mind that auth.define_tables() takes "migrate" parameter(s) on its own, not "respecting" some of the DAL(...) ones.
On Wednesday, April 3, 2013 2:53:02 PM UTC+2, software.ted wrote: > > I have this error: > > Database db <https://192.168.0.251/init/appadmin/index> select Traceback > > Traceback (most recent call last): > File "/home/www-data/web2py/applications/init/controllers/appadmin.py", > line 232, in select > limitby=(start, stop)) > File "/home/www-data/web2py/gluon/dal.py", line 9769, in select > return adapter.select(self.query,fields,attributes) > File "/home/www-data/web2py/gluon/dal.py", line 1680, in select > return self._select_aux(sql,fields,attributes) > File "/home/www-data/web2py/gluon/dal.py", line 1645, in _select_aux > self.execute(sql) > File "/home/www-data/web2py/gluon/dal.py", line 1758, in execute > return self.log_execute(*a, **b) > File "/home/www-data/web2py/gluon/dal.py", line 1752, in log_execute > ret = self.cursor.execute(*a, **b) > File "/home/www-data/web2py/gluon/contrib/pymysql/cursors.py", line 117, in > execute > self.errorhandler(self, exc, value) > File "/home/www-data/web2py/gluon/contrib/pymysql/connections.py", line > 202, in defaulterrorhandler > raise errorclass, errorvalue > InternalError: (1054, u"Unknown column 'auth_user.title' in 'field list'") > > > > > I have tried: > > db = DAL(..., fake_migrate_all=True) > > I have two copies of web2py running one production the other development. > I have added a "title, photo" fields to the auth_user table using: > > auth.settings.extra_fields['auth_user']= [ > Field('title', requires = IS_IN_SET(['Mr.', 'Dr.', 'Mrs.', 'Ms.', > 'Prof.', 'Maj.', 'Rev.', 'Lt.', 'Capt.', 'Col.','Lt. Col.', 'Brig-General', > 'Lt-Gen.'])), > Field('photo', 'upload')] > > The development side its working all well but after uninstalling the > production application and installing a new application using the > production database it gives the error above. > > Any ideas. > -- > > ....................................................................................... > Teddy Lubasi Nyambe > Opensource Zambia > Lusaka, ZAMBIA > > Cell: +260 97 7760473 > website: http://www.opensource.org.zm > > ~/ > Human Knowledge belongs to the world! - AntiTrust > > Man is a tool-using animal. Without tools he is nothing, with tools he is > all - Thomas Carlyle 1795-1881 > > /~ > -- --- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
