auth.user_id or auth_user.id might be what you're looking for
On Dec 28, 7:42 am, "david.waldrop" <[email protected]> wrote: > I just upgraded to web2py 1.99 for an app that have been operational for > over a year and now get the following error. I have looked at all the code > and cannot find a reference to registration_id and am not ysing any custom > auth. Any help or ideas where to look next would be greatly appreciated??? > > TICKET ID > > 108.45.61.175.2011-12-27.17-29-47.014c5022-dacd-41c5-b997-d4a63c907e7e > <class 'psycopg2.ProgrammingError'> column auth_user.registration_id does > not exist LINE 1: ...r.registration_key, auth_user.reset_password_key, > auth_user.... ^VERSIONweb2py™(1, 99, 4, datetime.datetime(2011, 12, 14, 14, > 46, 14), 'stable')PythonPython 2.7.1: /usr/local/bin/pythonTRACEBACK > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > 15. > 16. > 17. > 18. > 19. > 20. > 21. > 22. > 23. > 24. > 25. > 26. > 27. > > Traceback (most recent call last): > File "/home/dlwatey/webapps/web2py/web2py/gluon/restricted.py", line 204, > in restricted > exec ccode in environment > File > "/home/dlwatey/webapps/web2py/web2py/applications/init/controllers/default. > py" > <https://www.meetingmonkey.net/admin/default/edit/init/controllers/def...>, > line 75, in <module> > File "/home/dlwatey/webapps/web2py/web2py/gluon/globals.py", line 172, in > <lambda> > self._caller = lambda f: f() > File > "/home/dlwatey/webapps/web2py/web2py/applications/init/controllers/default. > py" > <https://www.meetingmonkey.net/admin/default/edit/init/controllers/def...>, > line 52, in user > return dict(form=auth()) > File "/home/dlwatey/webapps/web2py/web2py/gluon/tools.py", line 1141, in > __call__ > return getattr(self,args[0])() > File "/home/dlwatey/webapps/web2py/web2py/gluon/tools.py", line 1703, in > login > user = self.db(table_user[username] == > form.vars[username]).select().first() > File "/home/dlwatey/webapps/web2py/web2py/gluon/dal.py", line 6333, in > select > return self.db._adapter.select(self.query,fields,attributes) > File "/home/dlwatey/webapps/web2py/web2py/gluon/dal.py", line 1282, in > select > rows = response(sql) > File "/home/dlwatey/webapps/web2py/web2py/gluon/dal.py", line 1272, in > response > self.execute(sql) > File "/home/dlwatey/webapps/web2py/web2py/gluon/dal.py", line 1359, in > execute > return self.log_execute(*a, **b) > File "/home/dlwatey/webapps/web2py/web2py/gluon/dal.py", line 1353, in > log_execute > ret = self.cursor.execute(*a, **b) > ProgrammingError: column auth_user.registration_id does not exist > LINE 1: ...r.registration_key, auth_user.reset_password_key, auth_user....

