db = DAL('mysql://....', check_reserved=['common','mysql'])
Anyway, I am not sure your problem is that you are using a reserved
keyword. Perhaps the table exists already. I am also surprised you are
getting a pymysql InternalError and not an OperationalError.
On Wednesday, 1 August 2012 07:45:01 UTC-5, Aurelijus Useckas wrote:
>
> I've changed the long into longitude and it seems to be solved but I still
> get errors:
>
> p2
> S'<class \'gluon.contrib.pymysql.err.InternalError\'> (1005, u"Can\'t
> create table \'./lpkdb/asoc.frm\' (errno: 150)")'
>
> Now it says it cannot create next table, which is:
>
> db.define_table('asoc',
> Field('name', label='Pavadinimas', unique=True),
> Field('City', db.city, 'list:reference city', label='Miestas'),
> Field('address', label='Adresas'),
> Field('www'),
> Field('tel'),
> Field('fax'),
> Field('email'),
> Field('President', label='Asociacijos prezidentas'),
> Field('CEO', label='Asociacijos generalinis'),
> Field('CEO_tel', label='Generalinio tel.'),
> Field('CEO_email', label='Generalinio email'),
> Field('CEO_mob', label='Generalinio mobilus'),
> Field('Pres_tel', label='Prezidento tel.'),
> Field('Pres_email', label='Prezidento email'),
> Field('Pres_mob', label='Prezidento mobilus'),
> Field('submited_at', 'datetime', default=request.now, writable=False,
> readable=False),
> Field('updated_at', 'datetime', default=request.now,
> update=request.now, writable=False, readable=False),
> Field('submited_by', db.auth_user, default=auth.user_id,
> writable=False, readable=False),
> Field('updated_by', db.auth_user, update=auth.user_id, writable=False,
> readable=False),
> format='%(name)s')
>
> Are there some guidlines on how to construct DAL field names in order to
> avoid any conflict while migrating to mysql?
>
>
> On Wednesday, August 1, 2012 3:36:51 PM UTC+3, tomasz bandura wrote:
>>
>> Is it 'long' a mysql's reserved word?
>>
>> Regards
>> Tomasz
>>
>> 2012/8/1 Aurelijus Useckas <[email protected]>
>>
>>> 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
>>>>
>>> --
>>>
>>>
>>>
>>>
>>
>>
--
