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]
