In order:
Yes
Yes
No existing tables
Files don't exist
migration settings removed
Only error message from running web2py that way: WARNING:web2py:import
IPython error; use default python shell
On Tuesday, May 8, 2012 10:50:38 AM UTC-4, villas wrote:
>
> 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
>>>>>
>>>>
