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 >>> >> > >