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 <[email protected]> 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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
