Actually, I just tried on FluxFlex and it doesn't work neither! I have the same error if I use the MySQL database (provided by FluxFlex) but it works using SQLite.
The project is open source, available here: https://github.com/ThomasDalla/FansubCheck_web2py/tree/master/public_html/applications/fansubcheck The error occurs on a different table though: mysql.balises_archive. 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. Traceback (most recent call last): File "/home/fansubcheck/public_html/gluon/restricted.py", line 204, in restricted exec ccode in environment File "/home/fansubcheck/public_html/applications/fansubcheck/models/db_wizard.py" <https://fansubcheck.fluxflex.com/admin/default/edit/fansubcheck/models/db_wizard.py>, line 24, in <module> db.define_table('balise_archive',db.balise,Field('current_record','reference balise',readable=False,writable=False)) File "/home/fansubcheck/public_html/gluon/dal.py", line 5097, in define_table polymodel=polymodel) File "/home/fansubcheck/public_html/gluon/dal.py", line 705, in create_table self.create_sequence_and_triggers(query,table) File "/home/fansubcheck/public_html/gluon/dal.py", line 1348, in create_sequence_and_triggers self.execute(query) File "/home/fansubcheck/public_html/gluon/dal.py", line 1359, in execute return self.log_execute(*a, **b) File "/home/fansubcheck/public_html/gluon/dal.py", line 1353, in log_execute ret = self.cursor.execute(*a, **b) File "/home/fansubcheck/public_html/gluon/contrib/pymysql/cursors.py", line 108, in execute self.errorhandler(self, exc, value) File "/home/fansubcheck/public_html/gluon/contrib/pymysql/connections.py", line 184, in defaulterrorhandler raise errorclass, errorvalue InternalError: (1005, u"Can't create table 'fansubcheck.balise_archive' (errno: 150)") You can create a new web2py application and import my github project: [email protected]:ThomasDalla/FansubCheck_web2py.git You should have the same error... Any idea why this error occurs?
