I changed the signature =True in my "auth.define_tables" which created extra fields in the auth_user table and after that I am getting this error. Yes Web2py is installed in /opt directory. This is a production machine.
On Monday, January 22, 2018 at 6:31:44 PM UTC-6, Jim S wrote: > > Seems like you might have a permissions error. Are you running web2py as > root? > > Looks like web2py is install in the /opt directory. Is this a production > or development machine? > > -Jim > > On Monday, January 22, 2018 at 5:49:30 PM UTC-6, SR wrote: >> >> When I try to open my Database Administration window I am getting this >> error ticket: >> Error ticket for "cryoem"Ticket ID >> >> 10.51.133.94.2018-01-22.17-44-57.ddaeb556-9bc8-46b4-8dde-99a3c6eee6e7 >> <class '_mysql_exceptions.OperationalError'> (1025, "Error on rename of >> './db_cryoem/#sql-6313_9e' to './db_cryoem/auth_user' (errno: 150)") >> Version >> web2py™ Version 2.14.6-stable+timestamp.2016.05.10.00.21.47Traceback >> >> 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. >> >> Traceback (most recent call last): >> File "/opt/web2py_apps/web2py/gluon/restricted.py", line 227, in restricted >> exec ccode in environment >> File "/opt/web2py_apps/web2py/applications/cryoem/models/db.py" >> <https://10.10.10.101/admin/default/edit/cryoem/models/db.py>, line 109, in >> <module> >> auth.define_tables(username=False, signature=False) >> File "/opt/web2py_apps/web2py/gluon/tools.py", line 2376, in define_tables >> format='%(first_name)s %(last_name)s (%(id)s)')) >> File "/opt/web2py_apps/web2py/gluon/packages/dal/pydal/base.py", line 834, >> in define_table >> table = self.lazy_define_table(tablename,*fields,**args) >> File "/opt/web2py_apps/web2py/gluon/packages/dal/pydal/base.py", line 873, >> in lazy_define_table >> polymodel=polymodel) >> File "/opt/web2py_apps/web2py/gluon/packages/dal/pydal/adapters/base.py", >> line 510, in create_table >> fake_migrate=fake_migrate >> File "/opt/web2py_apps/web2py/gluon/packages/dal/pydal/adapters/base.py", >> line 623, in migrate_table >> self.execute(sub_query) >> File "/opt/web2py_apps/web2py/gluon/packages/dal/pydal/adapters/base.py", >> line 1388, in execute >> return self.log_execute(*a, **b) >> File "/opt/web2py_apps/web2py/gluon/packages/dal/pydal/adapters/base.py", >> line 1382, in log_execute >> ret = self.get_cursor().execute(command, *a[1:], **b) >> File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 205, in >> execute >> self.errorhandler(self, exc, value) >> File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, >> in defaulterrorhandler >> raise errorclass, errorvalue >> OperationalError: (1025, "Error on rename of './db_cryoem/#sql-6313_9e' to >> './db_cryoem/auth_user' (errno: 150)") >> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.
