I really have no clue.. Could it be?
On Wed, Aug 1, 2012 at 3:36 PM, tomasz bandura <tomasz.band...@gmail.com>wrote:
> 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
>>>
>> --
>>
>>
>>
>>
>
> --
>
>
>
>
--
