You have set migrate=False or you have a custom auth.user table. But web2py 1.75.6 requires a new field in auth_user
Field('reset_password_key', length=512, writable=False, readable=False, default='', label=auth,.messages.label_reset_password_key), You either create it or let web2py create it for you. On 27 Mar, 15:15, drayco <antrod...@gmail.com> wrote: > Hi everyone. > > I have a application in a server production with web2py 1.72.3 and > MySQL, and in this moment, I try to do some modifications in my > localhost, but when I try to use with web2py 1.76.5 I got this error > when I try to enter, Only in auth. > I see that you did some changes in auth tables, well especifically in > auth.user. > My question is, What can I do to avoid this problem? > I want to use that database in my tests. > If I will put that changes in MySQL, Will I have problems? > > Traceback (most recent call last): > File "/media/RESPALDO/web2py/gluon/restricted.py", line 173, in > restricted > exec ccode in environment > File "/media/RESPALDO/web2py/applications/seccion36/controllers/ > default.py", line 91, in <module> > File "/media/RESPALDO/web2py/gluon/globals.py", line 96, in <lambda> > self._caller = lambda f: f() > File "/media/RESPALDO/web2py/applications/seccion36/controllers/ > default.py", line 32, in user > return dict(form=auth()) > File "/media/RESPALDO/web2py/gluon/tools.py", line 723, in __call__ > return self.login() > File "/media/RESPALDO/web2py/gluon/tools.py", line 1045, in login > user = self.db(table_user[username] == > form.vars[username]).select().first() > File "/media/RESPALDO/web2py/gluon/sql.py", line 3056, in select > rows = response(query) > File "/media/RESPALDO/web2py/gluon/sql.py", line 3051, in response > db._execute(query) > File "/media/RESPALDO/web2py/gluon/sql.py", line 928, in <lambda> > self._execute = lambda *a, **b: self._cursor.execute(*a, **b) > File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in > execute > self.errorhandler(self, exc, value) > File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, > in defaulterrorhandler > raise errorclass, errorvalue > OperationalError: (1054, "Unknown column > 'auth_user.reset_password_key' in 'field list'") -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.