Is it 'long' a mysql's reserved word?
Regards
Tomasz
2012/8/1 Aurelijus Useckas <aurelijus.usec...@gmail.com>
> 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
>>
> --
>
>
>
>
--
