as you are using mysql. try to delete everything you has in /databases folder (the .table files) backup it.
then try again with table definitions and migrate=True http://zerp.ly/rochacbruno Em 13/11/2011 21:33, "Jimmy Stewpot" <mail...@oranged.to> escreveu: > Hi, > > I have nothing set in my model at all for migrate so I assume that it's > True by being ommited. > > It has got me stumped.. I have not had problems like this in the past with > my previous testing. > > > ----- Original Message ----- > From: "Bruno Rocha" <rochacbr...@gmail.com> > To: web2py@googlegroups.com > Sent: Sunday, 13 November, 2011 5:53:52 PM > Subject: Re: [web2py] Re: web2py dal not creating database > > what is in your: define_table(..., migrate=? ) and db = DAL(...., > migrate_enabled=? ) > > > It needs to be setted to True or ommited to create the tables. > > > On Sun, Nov 13, 2011 at 4:14 AM, Jimmy Stewpot < mail...@oranged.to > > wrote: > > > Hi, > > Thanks for the quick response.. > > I have the DB created in mysql. The user has rights (using the root > user).. still no luck. > > I've turned on query logging in mysql, the app queries are all working as > expected but it won't create the model. > > Regards, > > Jimmy > > > > > > > > > ----- Original Message ----- > From: "Anthony" < abasta...@gmail.com > > To: web2py@googlegroups.com > Sent: Sunday, 13 November, 2011 3:54:58 PM > Subject: [web2py] Re: web2py dal not creating database > > web2py will only create the db for you if you're using SQLite -- otherwise > you have to create the db (once the db is created, though, web2py will > create tables for you). See > http://web2py.com/book/default/chapter/06#Connection-Strings . > > > Anthony > > On Saturday, November 12, 2011 11:10:18 PM UTC-5, Jimmy Stewpot wrote: > > Hello, > > I have been playing around with web2py for about a month.. I have > finally got to the point where I wanted to test the packing of my app > to test the install on another system. However when I load the app > into web2py on the new system the database is never created. I've even > gone so far as to use the root mysql database user to see where any > possible issues could arise.. I can't see any errors except a ticket > which says.. > > ProgrammingError: (1146, u"Table 'app03.auth_user' doesn't exist") > > I loaded the app via the administrative interface over the loopback.. > The sqllog has nothing interesting it.. I've restarted mysql, apache, > the management interface with no success. > > Any advice would be greatly appreciated. > > Regards, > > Jimmy. > > > > > -- > > > > > > > Bruno Rocha > [ http://rochacbruno.com.br ] >
