migrate=False is on the db or on Auth define_table() call ?
Il giorno martedì 15 gennaio 2013 11:07:49 UTC+1, Paolo valleri ha scritto: > > Hi all, I tried something odd. > I pulled a fresh copy of my code from git and I connected the app to an > already 'working' database. 'working' in the meaning that both tables and > data are already in the database. In web2py this approach fails, because at > the first run it tries to create all the tables, and the db raises an > exception like 'table already exist'. > In order to fix that I thought that migrate=False would help, however it > fails again. due to Auth that tries to create the tables. Ticket: > > Traceback (most recent call last): > File "/home/pvalleri/src/web2py/gluon/restricted.py", line 212, in > restricted > exec ccode in environment > File > "/home/pvalleri/src/web2py/applications/vtraffic/controllers/default.py" > <http://127.0.0.1:8000/admin/default/edit/vtraffic/controllers/default.py>, > line 6, in <module> > start = db.record.with_alias('start_point') > File "/home/pvalleri/src/web2py/gluon/dal.py", line 7221, in __getattr__ > return self.lazy_define_table(tablename,*fields,**args) > File "/home/pvalleri/src/web2py/gluon/dal.py", line 7174, in > lazy_define_table > table = table_class(self, tablename, *fields, **args) > File "/home/pvalleri/src/web2py/gluon/dal.py", line 7594, in __init__ > field.requires = sqlhtml_validators(field) > File "/home/pvalleri/src/web2py/gluon/dal.py", line 6338, in > sqlhtml_validators > referenced = db[field_type[10:]] > File "/home/pvalleri/src/web2py/gluon/dal.py", line 7215, in __getitem__ > return self.__getattr__(str(key)) > File "/home/pvalleri/src/web2py/gluon/dal.py", line 7221, in __getattr__ > return self.lazy_define_table(tablename,*fields,**args) > File "/home/pvalleri/src/web2py/gluon/dal.py", line 7177, in > lazy_define_table > table._create_references() # must follow above line to handle self > references > File "/home/pvalleri/src/web2py/gluon/dal.py", line 7663, in > _create_references > rtable = db[rtablename] > File "/home/pvalleri/src/web2py/gluon/dal.py", line 7215, in __getitem__ > return self.__getattr__(str(key)) > File "/home/pvalleri/src/web2py/gluon/dal.py", line 7221, in __getattr__ > return self.lazy_define_table(tablename,*fields,**args) > File "/home/pvalleri/src/web2py/gluon/dal.py", line 7189, in > lazy_define_table > polymodel=polymodel) > File "/home/pvalleri/src/web2py/gluon/dal.py", line 935, in create_table > self.create_sequence_and_triggers(query,table) > File "/home/pvalleri/src/web2py/gluon/dal.py", line 2483, in > create_sequence_and_triggers > self.execute(query) > File "/home/pvalleri/src/web2py/gluon/dal.py", line 1709, in execute > return self.log_execute(*a, **b) > File "/home/pvalleri/src/web2py/gluon/dal.py", line 1703, in log_execute > ret = self.cursor.execute(*a, **b) > File "/home/pvalleri/src/web2py/gluon/contrib/pg8000/dbapi.py", line 246, > in _fn > return fn(self, *args, **kwargs) > File "/home/pvalleri/src/web2py/gluon/contrib/pg8000/dbapi.py", line 317, > in execute > self._execute(operation, args) > File "/home/pvalleri/src/web2py/gluon/contrib/pg8000/dbapi.py", line 322, > in _execute > self.cursor.execute(new_query, *new_args) > File "/home/pvalleri/src/web2py/gluon/contrib/pg8000/interface.py", line > 399, in execute > self._stmt.execute(*args, **kwargs) > File "/home/pvalleri/src/web2py/gluon/contrib/pg8000/interface.py", line > 169, in execute > self._row_desc, cmd = self.c.bind(self._portal_name, > self._statement_name, args, self._parse_row_desc, kwargs.get("stream")) > File "/home/pvalleri/src/web2py/gluon/contrib/pg8000/protocol.py", line > 943, in _fn > return fn(self, *args<span style="color: #660;" class="styled-by... > Mostra originale > <https://groups.google.com/group/web2py/msg/64de6b8ababbd2a3?dmode=source&output=gplain&noredirect> > > --
