Not sure how you got into that state. Looks like your web2py table sturcture is not in sync with the db. Which db are you using? If you send me your models and your databases/*.table files I can fix them for you.
On Jan 8, 3:51 pm, "david.waldrop" <david.wald...@gmail.com> wrote: > I upgraded form 1.87 I think. The site has been running for about a year. > I have upgraded approximately every 2 months. I have tried to migrate, > but that yields an error message that auth_user already exists. > Thanks for the willingness to assist. Below is the traceback (I did not > know how to copy as a file with every option displayable). > > web2py™ administrative > interface<https://www.meetingmonkey.net/admin/default/index> > > - Site <https://www.meetingmonkey.net/admin/default/site> > - Edit <https://www.meetingmonkey.net/admin/default/design/init> > - About <https://www.meetingmonkey.net/admin/default/about/init> > - Errors <https://www.meetingmonkey.net/admin/default/errors/init> > - Versioning <https://www.meetingmonkey.net/admin/mercurial/commit/init> > - Logout <https://www.meetingmonkey.net/admin/default/logout> > - Help <https://www.meetingmonkey.net/examples/default/index> > > ERROR TICKET FOR "INIT"TICKET ID > > 66.110.180.66.2012-01-08.15-48-17.d0d251ed-0ea0-469c-afdb-52983470f052 > <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.... > ^ > > ERROR SNAPSHOT [image: help] > > <class 'psycopg2.ProgrammingError'>(column auth_user.registration_id does > not exist LINE 1: ...r.registration_key, auth_user.reset_password_key, > auth_user.... ^ ) > > inspect attributes > Frames > > - > > *File /home/dlwatey/webapps/web2py/web2py/gluon/restricted.py in > restricted at line 204* code arguments variables > - > > *File > > /home/dlwatey/webapps/web2py/web2py/applications/init/controllers/default.p y > in <module> at line 75* code arguments variables > - > > *File /home/dlwatey/webapps/web2py/web2py/gluon/globals.py in <lambda> > at line 172* code arguments variables > - > > *File > > /home/dlwatey/webapps/web2py/web2py/applications/init/controllers/default.p y > in user at line 52* code arguments variables > - > > *File /home/dlwatey/webapps/web2py/web2py/gluon/tools.py in __call__ at > line 1141* code arguments variables > - > > *File /home/dlwatey/webapps/web2py/web2py/gluon/tools.py in login at > line 1703* code arguments variables > - > > *File /home/dlwatey/webapps/web2py/web2py/gluon/dal.py in select at line > 6333* code arguments variables > - > > *File /home/dlwatey/webapps/web2py/web2py/gluon/dal.py in select at line > 1282* code arguments variables > - > > *File /home/dlwatey/webapps/web2py/web2py/gluon/dal.py in response at > line 1272* code arguments variables > - > > *File /home/dlwatey/webapps/web2py/web2py/gluon/dal.py in execute at > line 1359* code arguments variables > - > > *File /home/dlwatey/webapps/web2py/web2py/gluon/dal.py in log_execute at > line 1353* code arguments variables > Function argument list > > (self=<gluon.dal.PostgreSQLAdapter object>, *a=("SELECT auth_user.id, > auth_user.first_name, auth...RE (auth_user.email = > 'david.wald...@gmail.com');",), **b={}) > Code listing > > 1348. > 1349. > 1350. > 1351. > 1352. > 1353. > > 1354. > 1355. > 1356. > 1357. > > self.execute(query) > > def log_execute(self, *a, **b): > self.db._lastsql = a[0] > t0 = time.time() > ret = self.cursor.execute(*a, **b) > > self.db._timings.append((a[0],time.time()-t0)) > del self.db._timings[:-TIMINGSSIZE] > return ret > > Variablesa("SELECT auth_user.id, auth_user.first_name, auth...RE > (auth_user.email = > 'david.wald...@gmail.com');",)b{}self<gluon.dal.PostgreSQLAdapter > object>retundefinedself.cursor<cursor object at 0x9124f7c; closed: 0> > self.cursor.execute<built-in method execute of psycopg2._psycopg.cursor > object> > > Context > > locals request session response > IN FILE: > /HOME/DLWATEY/WEBAPPS/WEB2PY/WEB2PY/APPLICATIONS/INIT/CONTROLLERS/DEFAULT.P Y > > 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. > 28. > 29. > 30. > 31. > 32. > 33. > 34. > 35. > 36. > 37. > 38. > 39. > 40. > 41. > 42. > 43. > 44. > 45. > 46. > 47. > 48. > 49. > 50. > 51. > 52. > 53. > 54. > 55. > 56. > 57. > 58. > 59. > 60. > 61. > 62. > 63. > 64. > 65. > 66. > 67. > 68. > 69. > 70. > 71. > 72. > 73. > 74. > 75. > 76. > > # -*- coding: utf-8 -*- > > ######################################################################### > ## This is a samples controller > ## - index is the default action of any application > ## - user is required for authentication and authorization > ## - download is for downloading files uploaded in the db (does streaming) > ## - call exposes all registered services (none by default) > ######################################################################### > > def index(): > # if not auth.is_logged_in(): > # # if user clicked email link, redirect to login and set url to get > and check meeting password > # meetingparm = request.env.http_host.split('.')[1] > # meeting = db(db.meeting.link==meetingparm).select().first() > # #meeting = db(db.meeting.id==6).select().first() > # if meeting: # user clicked a link with a valid meeting, lets > get'em logged in and figure out who they are > # next = > URL(r=request,c='meetings',f='getmeetingpassword',args=meeting.id) > # session.next = next > # > redirect(URL(r=request,f='user',args='login',vars=dict(_next=next))) > return dict(message=T > <https://www.meetingmonkey.net/examples/global/vars/T>('')) > > def privacy(): > return dict(message=T > <https://www.meetingmonkey.net/examples/global/vars/T>('')) > > def security(): > return dict(message=T > <https://www.meetingmonkey.net/examples/global/vars/T>('')) > > def user(): > """ > exposes: > http://..../[app]/default/user/login > http://..../[app]/default/user/logout > http://..../[app]/default/user/register > http://..../[app]/default/user/profile > http://..../[app]/default/user/retrieve_password > http://..../[app]/default/user/change_password > use @auth.requires_login() > @auth.requires_membership('group name') > @auth.requires_permission('read','table name',record_id) > to decorate functions that need access control > """ > > db.auth_user.email.requires = IS_EMAIL > <https://www.meetingmonkey.net/examples/global/vars/IS_EMAIL>(),IS_LOWER > <https://www.meetingmonkey.net/examples/global/vars/IS_LOWER>() > > # if user clicked a link and registers, take them to the meeting after > the registration component logs them in > if request > <https://www.meetingmonkey.net/examples/global/vars/request>.args[0] == > 'register' and not session > <https://www.meetingmonkey.net/examples/global/vars/session>.next: > auth.settings.register_next = session > <https://www.meetingmonkey.net/examples/global/vars/session>.next > return dict(form=auth()) > > def download(): > """ > allows downloading of uploaded files > http://..../[app]/default/download/[filename] > """ > return response > <https://www.meetingmonkey.net/examples/global/vars/response>.download(request > <https://www.meetingmonkey.net/examples/global/vars/request>,db) > > #...@auth.requires(auth.user) > #...@auth.requires_login() > def call(): > """ > exposes services. for example: > http://..../[app]/default/call/jsonrpc > decorate with @services.jsonrpc the functions to expose > supports xml, json, xmlrpc, jsonrpc, amfrpc, rss, csv > """ > session > <https://www.meetingmonkey.net/examples/global/vars/session>.forget() > return service() > > response > <https://www.meetingmonkey.net/examples/global/vars/response>._vars=response > <https://www.meetingmonkey.net/examples/global/vars/response>._caller(user) > > Powered by web2py <http://www.web2py.com/>™ created by Massimo Di Pierro > ©2007-2011 - ... > > read more »
