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 ]