this is the trigger i guess:
db.define_table('maps',
Field('name'),
Field('last_name'),
Field('long'),
Field('lat'),
format='%(name)s')
On Wednesday, August 1, 2012 3:30:40 PM UTC+3, Aurelijus Useckas wrote:
>
> 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
>
--
