additional info...
Function argument list
(self=<gluon.dal.PostgreSQLAdapter object>, table=<Table {'ALL':
<gluon.dal.SQLALL object at 0x035...>, 'id': <gluon.dal.Field object at
0x0359A230>}>, migrate=True, fake_migrate=False, polymodel=None)
Code listing
628.
629.
630.
631.
632.
633.
634.
635.
636.
637.
foreign_key=referenced + ('(%s)' % id_fieldname),
on_delete_action=field.ondelete)
elif field.type.startswith('list:reference'):
ftype = self.types[field.type[:14]]
elif field.type.startswith('decimal'):
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' % \
On Monday, June 25, 2012 10:39:38 PM UTC-4, Horus wrote:
>
> I am currently getting this error working with DAL based on
>
>
> db.define_table('base_tags',
> Field('name', 'string', length=64, required=True,
> notnull=True),
> format='%(name)'
> )
>
>
>
> db.define_table('base_timezones',
> Field('name', 'string', length=64, required=True,
> notnull=True),
> Field('offset_time', 'integer', required=True,
> notnull=True),
> format='%(name)'
> )
>
>
> db.define_table('base_types',
> Field('name', 'string', length=64, required=True,
> notnull=True),
> format='%(name)'
> )
>
>
> db.define_table('base_sexes',
> Field('name', 'string', length=16, required=True,
> notnull=True),
> format='%(name)'
> )
>
>
> db.define_table('base_countries',
> Field('name', 'string', length=64, required=True,
> notnull=True),
> Field('latitude', 'decimal', required=True, notnull=True),
> Field('longitude', 'decimal', required=True, notnull=True),
> format='%(name)s'
> )
>
>
> db.define_table('base_states',
> Field('country_id', db.base_countries),
> Field('name', 'string', length=64, required=True,
> notnull=True),
> Field('latitude', 'decimal', required=True, notnull=True),
> Field('longitude', 'decimal', required=True, notnull=True),
> format='%(name)'
> )
>
>
> db.define_table('base_cities',
> Field('state_id', db.base_states),
> Field('name', 'string', length=64, required=True,
> notnull=True),
> Field('latitude', 'decimal', required=True, notnull=True),
> Field('longitude', 'decimal', required=True, notnull=True),
> format='%(name)'
> )
>
>
> <type 'exceptions.ValueError'> invalid literal for int() with base 10: ''
>
> VERSIONweb2py™(1, 99, 7, datetime.datetime(2012, 3, 4, 22, 12, 8),
> 'stable')PythonPython 2.7.2: C:\Python27\python.exeTRACEBACK
>
> 1.
> 2.
> 3.
> 4.
> 5.
> 6.
> 7.
> 8.
> 9.
> 10.
> 11.
>
> Traceback (most recent call last):
> File "C:\web2py\gluon\restricted.py", line 205, in restricted
> exec ccode in environment
> File "C:/web2py/applications/histreet/models/db.py"
> <http://127.0.0.1:8000/admin/default/edit/histreet/models/db.py>, line 79, in
> <module>
> format='%(name)s'
> File "C:\web2py\gluon\dal.py", line 6320, in define_table
> polymodel=polymodel)
> File "C:\web2py\gluon\dal.py", line 633, in create_table
> precision, scale = map(int,field.type[8:-1].split(','))
> ValueError: invalid literal for int() with base 10: ''
>
> ERROR SNAPSHOT [image: help]
>
> <type 'exceptions.ValueError'>(invalid literal for int() with base 10: '')
>
--
