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.
