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
>>>
>> --
>>
>>
>>
>>
>
>
--
