restarted web2py. no dice. died immediately when accessing any page
<class 'gluon.contrib.pymysql.err.InternalError'> (1005, u"Can't create
table 'rbl.plugin_wiki_page' (errno: 150)")
On Tuesday, May 8, 2012 4:16:50 PM UTC-4, Larry Wapnitsky wrote:
>
> A new, test app worked with no problems.
>
> Here is my DAL DB connection string: db = DAL('mysql://
> user:passw...@dbserer.company.com/dbname')
>
> I was getting "can't create table" errors until I added "grant" rights to
> the remote "user" account. Now, the page just spins...
>
> On Tuesday, May 8, 2012 4:06:05 PM UTC-4, villas wrote:
>>
>> I guess it still didn't work then. At this point [scratching head]:
>>
>> Consider upgrading your web2py.
>> Create a brand new app to test the most basic DB function is there.
>> Delete contents of the databases folder.
>> Change the DAL connection string in db.py
>> Put a simple table def in the db.py
>> Run your app, check whether there are *.table files in the databases
>> folder, and real tables in the DB.
>> If not, I suggest posting your DB connection string (needless to say
>> change the passwd), and define_table function here.
>>
>> Sorry if I'm missing something obvious, maybe someone else also has some
>> better advice to get this working.
>>
>> Regards, D
>>
>
