[web2py] invalid literal for int() with base 10: ''

[Horus]

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: '')

--