I'm assuming other migrations work just fine - is that correct? If that is the case then I'm thinking it is a problem with foreign keys. If not that, then I'm stumped.
If it were me, I'd do the following: 1. Make a backup of the database 2. Delete the database 3. Recreate the database with the same name 4. Go to your web2py/applications/cryoem/databases directory and delete everything 5. Start up web2py and run your app - this should recreate all the tables in your database 6. Copy all your data back into your tables from your backup (without recreating the tables) Are you familiar with the tool SQLyog? I use it for all my MySQL database manipulations. It has simple utilities to do all the things in my list there. Hope this is a little helpful. -Jim On Tuesday, January 23, 2018 at 8:26:33 AM UTC-6, SR wrote: > > 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
