I have tried both: auth.define_tables(username=True, signature=False, fake_migrate=True)
and auth.define_tables(username=True, signature=False, migrate=True) But the error still persists maybe i delete the table from the db? Any more ideas? On Wed, Apr 3, 2013 at 3:29 PM, Niphlod <[email protected]> wrote: > 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. > > > -- ....................................................................................... 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.
