Re: [web2py] Re: web2py dal not creating database
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" 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.
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 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" > 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]
Re: [web2py] Re: web2py dal not creating database
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" 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 ]
Re: [web2py] Re: web2py dal not creating database
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" 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" > 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 ] >
Re: [web2py] Re: web2py dal not creating database
Hi Bruno, Thanks so much, deleting the files in the database folder fixed this problem. Is it normal that those files would have been copied over between systems or was it a botch somewhere? - Original Message - From: "Bruno Rocha" To: web2py@googlegroups.com Sent: Monday, 14 November, 2011 10:41:53 AM Subject: Re: [web2py] Re: web2py dal not creating database 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 ]
Re: [web2py] Re: web2py dal not creating database
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" > > 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" > >> To: web...@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 < mai...@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" < abas...@gmail.com > >> To: web...@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 ] >> > -- 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.
