Hi there,
I've created 7 tables from my app and 2 of them cause error when to be
listed from Appadmin (/appadmin/select/db?query=db.t_leads.id>0). Don't see
anything particular in the table definition that may cause the problem. Any
help would be apprecicated.
Traceback
Traceback (most recent call last):
File "D:\web2py\applications\myapp\controllers/appadmin.py", line 232, in
select
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 9810, in select
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 2218, in select
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1676, in select
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1657, in
_select_aux
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 2028, in parse
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1876, in
parse_value
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1916, in
parse_datetime
ValueError: need more than 1 value to unpack
Traceback
Traceback (most recent call last):
File "D:\web2py\applications\myapp\controllers/appadmin.py", line 232, in
select
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 9810, in select
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 2218, in select
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1676, in select
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1657, in
_select_aux
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 2028, in parse
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1876, in
parse_value
File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1920, in
parse_datetime
ValueError: invalid literal for int() with base 10: 'Dull white'
The definition is as follows:
db.define_table('t_leads',
Field('f_lead_designation', type='string',
label=T('Lead')),
Field('f_owner', type='string',
label=T('Owner')),
Field('f_location', type='string',
label=T('Location')),
Field('f_status', type='string',
label=T('Status')),
Field('f_description', type='string',
label=T('Description')),
Field('f_links', type='list:string',
label=T('Links')),
Field('f_participants', type='list:string',
label=T('Participants')),
Field('f_schedule', type='list:string',
label=T('Schedule')),
Field('f_last_update', type='datetime',
label=T('Last Update')),
Field('f_remarks', type='list:string',
label=T('Remarks')),
auth.signature,
format='%(f_lead_designation)s',
migrate=settings.migrate)
db.define_table('t_accounts',
Field('f_account_name', type='string',
label=T('Account Name')),
Field('f_account_number', type='string',
label=T('Account Number')),
Field('f_address', type='string',
label=T('Address')),
Field('f_website', type='string',
label=T('Website')),
Field('f_last_update', type='datetime',
label=T('Last Update')),
Field('f_remarks', type='list:string',
label=T('Remarks')),
auth.signature,
format='%(f_account_name)s',
migrate=settings.migrate)
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
