Ohhh...its great!!!... you fixed my problem!!! El domingo, 13 de noviembre de 2011, 20:41:53 (UTC-3), rochacbruno escribió: > > 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" <mai...@oranged.to <javascript:>> > 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" <rocha...@gmail.com <javascript:>> >> To: web...@googlegroups.com <javascript:> >> 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 < mai...@oranged.to >> <javascript:> > 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" < abas...@gmail.com <javascript:> > >> To: web...@googlegroups.com <javascript:> >> 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 ] >> >
-- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.