Hi, I've built the app on SQLite and now want to migrate to the server based mysql. BUT web2py hangs in the middle of creating, basicaly just after the auth tables. When I restart the apache I can see auth tables as well as a few from my app.
this is the err ticket that I get: (dp1 S'output' p2 S'<class \'gluon.contrib.pymysql.err.ProgrammingError\'> (1064, u"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'long VARCHAR(255),\\n lat VARCHAR(255),\\n PRIMARY KEY(id)\\n) ENGINE=InnoDB CHA\' at line 5")' p3 sS'layer' p4 S'/opt/web-apps/web2py/applications/init/models/db_comp.py' p5 sS'code' p6 thnx --