:-)
On Tuesday, 8 May 2012 21:37:52 UTC+1, Larry Wapnitsky wrote:
>
> 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
>>>>
>>>
>>
>>
