from the error looks like you have
Field('Client', 'db.Client'),
instead of
Field('Client', db.Client),
is that possible?
On Jan 18, 6:25 pm, Simon Ashley <gregs...@gmail.com> wrote:
> Moving from SQLite to Postgres and when running Database
> Administration we're getting unknown field type errors when using a db
> reference i.e. Field('Client', db.Client)
> Any advice or work arounds?
>
> TIA,
>
> Traceback (most recent call last):
> File "C:\web2py\gluon\restricted.py", line 204, in restricted
> exec ccode in environment
> File "C:/web2py/applications/OAS/models/oa.py", line 358, in
> <module>
> Field('Interpretation_Type', db.Interpretation_Type))
> File "C:\web2py\gluon\dal.py", line 5114, in define_table
> polymodel=polymodel)
> File "C:\web2py\gluon\dal.py", line 624, in create_table
> (field.type, field.name)
> SyntaxError: Field: unknown field type: db.Client for Client
>
> Code listing:
> precision, scale = map(int,field.type[8:-1].split(','))
> ftype = self.types[field.type[:7]] % \
> dict(precision=precision,scale=scale)
> elif not field.type in self.types:
> raise SyntaxError, 'Field: unknown field type: %s for
> %s' % \
> (field.type, field.name)
>
> Model:
> db.define_table('Client',
> Field('Company', 'string'),
> Field('Address', 'string'),
> Field('Town', 'string'),
> Field('State', 'string'),
> Field('Zip', 'string'),
> Field('Activity', 'integer'),
> Field('Account', 'integer'),
> format='%(Company)s')
>
> db.define_table('Contact',
> Field('Client', db.Client),
> Field('Surname', 'string'),
> Field('First_Name', 'string'),
> Field('Position', 'string'),
> Field('Department', 'string'),
> Field('eMail', 'string'),
> Field('Mobile', 'string'),
> Field('Phone', 'string'),
> Field('Fax', 'string'),
> format='%(Surname)s - %(First_Name)s')
>
> Environment:
> Windows 7 64bit
> Current Postgresql (64bit) with psycopy2
> web2py source from trunk: (1, 99, 4, datetime.datetime(2011, 12, 31,
> 4, 51, 15), 'stable')
> Python 2.7.2: C:\Python27\python.exe
