File "/data/domains/web2py/applications/kenneths/controllers/
stuff.py",
line 49, in payment_receiver_update has (onaccept=crud.archive)
this means you are storing history for the records in a archive table.
Perhaps you have migrations disabled and the f_address field is
missing in that table. If you do not need this, set onaccept=None.
On 12 tammi, 04:22, Kenneth Lundström <kenneth.t.lundst...@gmail.com>
wrote:
> I m working on a new application which I created with the online wizard.
> I just created a new record and then updated it via those crud forms
> which are created for all tables.
>
> This tabel was created by hand by editing the database models file and
> then I copied those crud forms too.
>
> But when I now tried to update that record I got this error ticket.
> There is a copy of the relevant part of the my database models file.
>
> Apache, mod_wsgi, MySQL
>
> Kenneth
>
> xxxxxxxx.2011-01-12.12-33-23.f900b81c-a5d5-45ac-8fcc-88b3bc0c3589
> Version
> web2py Version 1.91.6 (2011-01-03 17:55:14)
> Python Python 2.6.5: /usr/bin/python
> Traceback
>
> Traceback (most recent call last):
> File "/data/domains/web2py/gluon/restricted.py", line 188, in restricted
> exec ccode in environment
> File "/data/domains/web2py/applications/kenneths/controllers/stuff.py",
> line 162, in <module>
> File "/data/domains/web2py/gluon/globals.py", line 95, in <lambda>
> self._caller = lambda f: f()
> File "/data/domains/web2py/gluon/tools.py", line 2297, in f
> return action(*a, **b)
> File "/data/domains/web2py/applications/kenneths/controllers/stuff.py",
> line 49, in payment_receiver_update
> onaccept=crud.archive)
> File "/data/domains/web2py/gluon/tools.py", line 2860, in update
> callback(onaccept,form,table._tablename)
> File "/data/domains/web2py/gluon/tools.py", line 50, in callback
> [action(form) for action in actions]
> File "/data/domains/web2py/gluon/tools.py", line 2757, in archive
> id = archive_table.insert(**new_record)
> File "/data/domains/web2py/gluon/dal.py", line 3875, in insert
> return self._db._adapter.insert(self,self._listify(fields))
> File "/data/domains/web2py/gluon/dal.py", line 704, in insert
> raise e
> InternalError: (1054, u"Unknown column 'f_address' in 'field list'")
>
> Error snapshot help Detailed traceback description
>
> <class 'gluon.contrib.pymysql.err.InternalError'>((1054, u"Unknown
> column 'f_address' in 'field list'"))
>
> inspect attributes
> Exception instance attributes
> __module__ 'gluon.contrib.pymysql.err'
> __getslice__ <method-wrapper '__getslice__' of InternalError object>
> __str__ <method-wrapper '__str__' of InternalError object>
> __getattribute__ <method-wrapper '__getattribute__' of InternalError object>
> __dict__ {}
> __sizeof__ <built-in method __sizeof__ of InternalError object>
> __weakref__ None
> __init__ <method-wrapper '__init__' of InternalError object>
> __setattr__ <method-wrapper '__setattr__' of InternalError object>
> __reduce_ex__ <built-in method __reduce_ex__ of InternalError object>
> __new__ <built-in method __new__ of type object>
> __format__ <built-in method __format__ of InternalError object>
> __class__ <class 'gluon.contrib.pymysql.err.InternalError'>
> __doc__ 'Exception raised when the database encounters an...anymore, the
> transaction is\n out of sync, etc.'
> __getitem__ <method-wrapper '__getitem__' of InternalError object>
> __setstate__ <built-in method __setstate__ of InternalError object>
> __reduce__ <built-in method __reduce__ of InternalError object>
> args (1054, u"Unknown column 'f_address' in 'field list'")
> __subclasshook__ <built-in method __subclasshook__ of type object>
> __unicode__ <built-in method __unicode__ of InternalError object>
> __delattr__ <method-wrapper '__delattr__' of InternalError object>
> __repr__ <method-wrapper '__repr__' of InternalError object>
> __hash__ <method-wrapper '__hash__' of InternalError object>
>
> Function argument list
>
> (self=<gluon.dal.MySQLAdapter object>, table=<Table {'current_record':
> <gluon.dal.Field objec...te': <gluon.dal.Field object at
> 0x2aaab020bc90>}>, fields=[(<gluon.dal.Field object>, 'Suomi
> Communications Oy'), (<gluon.dal.Field object>, '157230-403873'),
> (<gluon.dal.Field object>, 'Upseerinkatu 3 A'), (<gluon.dal.Field
> object>, '02600'), (<gluon.dal.Field object>, 'Espoo'),
> (<gluon.dal.Field object>, 'lasku...@suomicom.fi'), (<gluon.dal.Field
> object>, 'www.suomicom.fi'), (<gluon.dal.Field object>, '1713769-5'),
> (<gluon.dal.Field object>, True), (<gluon.dal.Field object>,
> datetime.datetime(2011, 1, 12, 12, 28, 44)), (<gluon.dal.Field object>,
> datetime.datetime(2011, 1, 12, 12, 28, 44)), (<gluon.dal.Field object>,
> 1), (<gluon.dal.Field object>, 1), (<gluon.dal.Field object>, 3L)])
> Code listing
>
> try:
> self.execute(query)
> except Exception, e:
> if isinstance(e,self.integrity_error_class()):
> return None
> raise e
>
> if hasattr(table,'_primarykey'):
> return dict( [ (k,fields[k]) for k in table._primarykey ])
> id = self.lastrowid(table)
> if not isinstance(id,int):
>
> Variables
> e InternalError(1054, u"Unknown column 'f_address' in 'field list'")
>
> ########################################
> db.define_table('t_payment_receiver',
> Field('id','id',
> represent=lambda id:SPAN(id,'
> ',A('view',_href=URL('payment_receiver_read',args=id)))),
> Field('f_name', type='string',
> label=T('Name')),
> Field('f_bank_account', type='string',
> label=T('Bank account')),
> Field('f_address', type='string',
> label=T('Address')),
> Field('f_zip_code', type='string',
> label=T('Zip Code')),
> Field('f_city', type='string',
> label=T('City')),
> Field('f_email', type='string',
> label=T('Email')),
> Field('f_website', type='string',
> label=T('Website')),
> Field('f_business_id', type='string',
> label=T('Business ID')),
> Field('active','boolean',default=True,
> label=T('Active'),writable=False,readable=False),
> Field('created_on','datetime',default=request.now,
> label=T('Created On'),writable=False,readable=False),
> Field('modified_on','datetime',default=request.now,
> label=T('Modified On'),writable=False,readable=False,
> update=request.now),
> Field('created_by',db.auth_user,default=auth.user_id,
> label=T('Created By'),writable=False,readable=False),
> Field('modified_by',db.auth_user,default=auth.user_id,
> label=T('Modified By'),writable=False,readable=False,
> update=auth.user_id),
> format='%(f_name)s',
> migrate=settings.migrate)
