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

-- 



Reply via email to