Hmm.... keep trying...
Check you have appropriate read/write permissions from your host.
Connect with your DB management tool and create a test table to make sure
your DB server etc is running.
Take one single table definition, let's call it 'yourexample'.
Make sure there is no yourexample.table file in the yourapp/databases
folder.
Delete (or comment out) any migrate or fake_migrate settings on your
define_table function (migrate has a default of True).
Make sure there are no countering migration settings on the DAL connection.
Make sure there are no fake_migration settings anywhere.
Run python web2py.py -N -M -S yourapp to start web2py
Are there any error messages?
On Tuesday, 8 May 2012 14:51:45 UTC+1, Larry Wapnitsky wrote:
>
> David-
>
> No dice. Still getting the same errors. It does not want to create the
> tables in my MySQL database. I've made sure the settings are as you
> stated. These are things I've already done, but just got into the office
> today and retried them.
>
> On Friday, May 4, 2012 5:49:46 PM UTC-4, villas wrote:
>>
>> Hi Larry
>>
>> Generating tables is a general thing, not just for the plugin_wiki. As
>> you obviously do not have any data in your plugin_wiki yet, I suggest:
>>
>> 1. Get yourself a DB management tool for your DB.
>> 2. Using the tool, have a look in the DB. If you are using Sqlite,
>> you should find it here: yourapp/databases/storage.sqlite, are there
>> any
>> plugin_wiki tables in there? If so, drop them.
>> 3. Look in the yourapp/databases folder. Do you see .table files
>> with plugin_wiki in the filename? If so, delete them.
>> 4. Make sure that there are NO settings for migrate=False in your
>> db.py. For example,
>> db = DAL('sqlite://storage.sqlite', migrate=False)
>> db = DAL(...,migrate_enabled=False)
>> 5. Access any page in your app. This should now generate the tables.
>>
>> I appreciate that step one is a bit of a hassle, but it is so useful to
>> be able to look inside your DB that I think it is well worth the effort.
>> You should be able to find something easily on google, especially if you
>> are using Sqlite.
>>
>> Regards, David
>>
>>
>> On Friday, 4 May 2012 20:12:25 UTC+1, Larry Wapnitsky wrote:
>>>
>>> It looks as though the database table generation does not automatically
>>> take place unless you use the wizard.
>>>
>>> How can I initiate this and get the plugin active? The "book" doesn't
>>> really give great details on that.
>>>
>>> Thanks
>>>
>>> On Friday, May 4, 2012 2:38:51 PM UTC-4, villas wrote:
>>>>
>>>>
>>>>> 1. *<class 'gluon.contrib.pymysql.err.ProgrammingError'> (1146,
>>>>> u"Table 'rbl.plugin_wiki_page' doesn't exist"*
>>>>>
>>>>>
>>>>> Sounds like a migration error. Do you have the tables in your DB? If
>>>> not, make sure you delete plugin_wiki table defs from the databases
>>>> folder
>>>> so that they can be created
>>>>
>>>>
>>>>> 2. when loading the plugin in a brand-new app, I don't see any
>>>>> additional menu called "pages".
>>>>>
>>>>
>>>> I think you have to be logged in with either user.id == 1 or role ==
>>>> 'editor'.
>>>>
>>>> Hope that helps, David
>>>>
>>>
