if I recreate the database from scratch, then re-import my data, it works
fine.
On Tuesday, May 8, 2012 4:33:54 PM UTC-4, Larry Wapnitsky wrote:
>
> even tried it as root....no dice.
>
>
> On 5/8/2012 4:25 PM, villas wrote:
>
> Hi Larry, it sounds like your DB is not configured properly for your
> username. I don't use MySql but maybe this prob sounds familiar to those
> that do. Anyone?
> Sorry I can't think of anything more....
> D
>
> On Tuesday, 8 May 2012 21:16:50 UTC+1, 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
>>>
>>
>
>
