I have this error:
Database db <https://192.168.0.251/init/appadmin/index> selectTraceback
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
