It goes without saying that you have backed up the production db so you can roll the application back, right?
Same for the old app, correct? What did you do about the applications/<whatever>/databases directory? Are the fields actually in the db on the production side? If not you should be able to manually add them and use fake_migrate on the auth tables. If that doesn't work you might consider moving the files in the databases directory off to the side and trying again. On Wednesday, April 3, 2013 9:51:14 AM UTC-4, software.ted wrote: > > 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] <javascript:>>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] <javascript:>. >> 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.
