Contrary to the book, I seem to recall that both migrate and fake_migrate/fake_migrate_all need to be True for the .table files to get re-generated. I'm not sure if that's intended or a bug.
On Monday, June 11, 2012 8:04:55 AM UTC-7, vilas patil wrote: > > Hi Massimo, > I have done it but now I get error as : > web2py_session_myappname > > where myappname is the name of my application. > > I have tried both options migrate=False and fake_migrate=True but it didnt > work out. > > I have 2 applications which are accessing same database. When I seee > database table from first application, it shows tables. But when I try to > view tables of other application I get above error. > > Detailed stack trace is: > > Traceback (most recent call last): File "C:\src\web2py\gluon\main.py", > line 510, in wsgibase session._try_store_in_db(request, response) File > "C:\src\web2py\gluon\globals.py", line 561, in _try_store_in_db > record_id = table.insert(**dd) File "C:\src\web2py\gluon\dal.py", line > 6829, in insert return > self._db._adapter.insert(self,self._listify(fields)) File > "C:\src\web2py\gluon\dal.py", line 928, in insert raise > eOperationalError: no such table: web2py_session_myappname > > Please help. > > Regards, > Vilas Patil > > > On Wednesday, 8 April 2009 09:54:52 UTC+5:30, mdipierro wrote: > >> If the table already exists >> >> db.define_table(...., migrate=False) >> >> Massimo >> >> On Apr 7, 11:18 pm, TheDude <officed...@gmail.com> wrote: >> > OperationalError: (1050, "Table 'users' already exists") >> > >> > I know it already exists, but I want you to just know about it rather >> > than try to create it all the time. I tried clearing out my /databases >> > folder as well. Any other ideas? > > > On Wednesday, 8 April 2009 09:54:52 UTC+5:30, mdipierro wrote: >> >> If the table already exists >> >> db.define_table(...., migrate=False) >> >> Massimo >> >> On Apr 7, 11:18 pm, TheDude <officed...@gmail.com> wrote: >> > OperationalError: (1050, "Table 'users' already exists") >> > >> > I know it already exists, but I want you to just know about it rather >> > than try to create it all the time. I tried clearing out my /databases >> > folder as well. Any other ideas? > > > On Wednesday, 8 April 2009 09:54:52 UTC+5:30, mdipierro wrote: >> >> If the table already exists >> >> db.define_table(...., migrate=False) >> >> Massimo >> >> On Apr 7, 11:18 pm, TheDude <officed...@gmail.com> wrote: >> > OperationalError: (1050, "Table 'users' already exists") >> > >> > I know it already exists, but I want you to just know about it rather >> > than try to create it all the time. I tried clearing out my /databases >> > folder as well. Any other ideas? > > > On Wednesday, 8 April 2009 09:54:52 UTC+5:30, mdipierro wrote: >> >> If the table already exists >> >> db.define_table(...., migrate=False) >> >> Massimo >> >> On Apr 7, 11:18 pm, TheDude <officed...@gmail.com> wrote: >> > OperationalError: (1050, "Table 'users' already exists") >> > >> > I know it already exists, but I want you to just know about it rather >> > than try to create it all the time. I tried clearing out my /databases >> > folder as well. Any other ideas? > > On Monday, June 11, 2012 8:04:55 AM UTC-7, vilas patil wrote: > > Hi Massimo, > I have done it but now I get error as : > web2py_session_myappname > > where myappname is the name of my application. > > I have tried both options migrate=False and fake_migrate=True but it didnt > work out. > > I have 2 applications which are accessing same database. When I seee > database table from first application, it shows tables. But when I try to > view tables of other application I get above error. > > Detailed stack trace is: > > Traceback (most recent call last): File "C:\src\web2py\gluon\main.py", > line 510, in wsgibase session._try_store_in_db(request, response) File > "C:\src\web2py\gluon\globals.py", line 561, in _try_store_in_db > record_id = table.insert(**dd) File "C:\src\web2py\gluon\dal.py", line > 6829, in insert return > self._db._adapter.insert(self,self._listify(fields)) File > "C:\src\web2py\gluon\dal.py", line 928, in insert raise > eOperationalError: no such table: web2py_session_myappname > > Please help. > > Regards, > Vilas Patil > > > On Wednesday, 8 April 2009 09:54:52 UTC+5:30, mdipierro wrote: > >> If the table already exists >> >> db.define_table(...., migrate=False) >> >> Massimo >> >> On Apr 7, 11:18 pm, TheDude <officed...@gmail.com> wrote: >> > OperationalError: (1050, "Table 'users' already exists") >> > >> > I know it already exists, but I want you to just know about it rather >> > than try to create it all the time. I tried clearing out my /databases >> > folder as well. Any other ideas? > > > On Wednesday, 8 April 2009 09:54:52 UTC+5:30, mdipierro wrote: >> >> If the table already exists >> >> db.define_table(...., migrate=False) >> >> Massimo >> >> On Apr 7, 11:18 pm, TheDude <officed...@gmail.com> wrote: >> > OperationalError: (1050, "Table 'users' already exists") >> > >> > I know it already exists, but I want you to just know about it rather >> > than try to create it all the time. I tried clearing out my /databases >> > folder as well. Any other ideas? > > > On Wednesday, 8 April 2009 09:54:52 UTC+5:30, mdipierro wrote: >> >> If the table already exists >> >> db.define_table(...., migrate=False) >> >> Massimo >> >> On Apr 7, 11:18 pm, TheDude <officed...@gmail.com> wrote: >> > OperationalError: (1050, "Table 'users' already exists") >> > >> > I know it already exists, but I want you to just know about it rather >> > than try to create it all the time. I tried clearing out my /databases >> > folder as well. Any other ideas? > > > On Wednesday, 8 April 2009 09:54:52 UTC+5:30, mdipierro wrote: >> >> If the table already exists >> >> db.define_table(...., migrate=False) >> >> Massimo >> >> On Apr 7, 11:18 pm, TheDude <officed...@gmail.com> wrote: >> > OperationalError: (1050, "Table 'users' already exists") >> > >> > I know it already exists, but I want you to just know about it rather >> > than try to create it all the time. I tried clearing out my /databases >> > folder as well. Any other ideas? > > On Monday, June 11, 2012 8:04:55 AM UTC-7, vilas patil wrote: > > Hi Massimo, > I have done it but now I get error as : > web2py_session_myappname > > where myappname is the name of my application. > > I have tried both options migrate=False and fake_migrate=True but it didnt > work out. > > I have 2 applications which are accessing same database. When I seee > database table from first application, it shows tables. But when I try to > view tables of other application I get above error. > > Detailed stack trace is: > > Traceback (most recent call last): File "C:\src\web2py\gluon\main.py", > line 510, in wsgibase session._try_store_in_db(request, response) File > "C:\src\web2py\gluon\globals.py", line 561, in _try_store_in_db > record_id = table.insert(**dd) File "C:\src\web2py\gluon\dal.py", line > 6829, in insert return > self._db._adapter.insert(self,self._listify(fields)) File > "C:\src\web2py\gluon\dal.py", line 928, in insert raise > eOperationalError: no such table: web2py_session_myappname > > Please help. > > Regards, > Vilas Patil > > > On Wednesday, 8 April 2009 09:54:52 UTC+5:30, mdipierro wrote: > >> If the table already exists >> >> db.define_table(...., migrate=False) >> >> Massimo >> >> On Apr 7, 11:18 pm, TheDude <officed...@gmail.com> wrote: >> > OperationalError: (1050, "Table 'users' already exists") >> > >> > I know it already exists, but I want you to just know about it rather >> > than try to create it all the time. I tried clearing out my /databases >> > folder as well. Any other ideas? > > > On Wednesday, 8 April 2009 09:54:52 UTC+5:30, mdipierro wrote: >> >> If the table already exists >> >> db.define_table(...., migrate=False) >> >> Massimo >> >> On Apr 7, 11:18 pm, TheDude <officed...@gmail.com> wrote: >> > OperationalError: (1050, "Table 'users' already exists") >> > >> > I know it already exists, but I want you to just know about it rather >> > than try to create it all the time. I tried clearing out my /databases >> > folder as well. Any other ideas? > > > On Wednesday, 8 April 2009 09:54:52 UTC+5:30, mdipierro wrote: >> >> If the table already exists >> >> db.define_table(...., migrate=False) >> >> Massimo >> >> On Apr 7, 11:18 pm, TheDude <officed...@gmail.com> wrote: >> > OperationalError: (1050, "Table 'users' already exists") >> > >> > I know it already exists, but I want you to just know about it rather >> > than try to create it all the time. I tried clearing out my /databases >> > folder as well. Any other ideas? > > > On Wednesday, 8 April 2009 09:54:52 UTC+5:30, mdipierro wrote: >> >> If the table already exists >> >> db.define_table(...., migrate=False) >> >> Massimo >> >> On Apr 7, 11:18 pm, TheDude <officed...@gmail.com> wrote: >> > OperationalError: (1050, "Table 'users' already exists") >> > >> > I know it already exists, but I want you to just know about it rather >> > than try to create it all the time. I tried clearing out my /databases >> > folder as well. Any other ideas? > >