[2011-06-19 14:16:01,056][test] ERROR:db.cursor:Programming error: column crm_lead.last_name does not exist
LINE 1: SELECT crm_lead.date_closed,crm_lead.last_name,date_trunc('s... ^
, in query SELECT crm_lead.date_closed,crm_lead.last_name,date_trunc('second', crm_lead.create_date) as create_date,crm_lead.probability,crm_lead.type_id,crm_lead.partner_address_id,crm_lead.date_action_last,crm_lead.day_close,crm_lead.street,crm_lead.day_open,crm_lead.contact_name,crm_lead.partner_id,crm_lead.date_action_next,crm_lead.city,crm_lead.first_name,crm_lead.user_id,crm_lead.zip,crm_lead.title,crm_lead.partner_name,crm_lead.planned_revenue,crm_lead.country_id,crm_lead.company_id,crm_lead.id,crm_lead.priority,crm_lead.state,crm_lead.email_cc,crm_lead.type,crm_lead.email,crm_lead.function,crm_lead.fax,crm_lead.optin,crm_lead.description,crm_lead.street2,crm_lead.ref2,crm_lead.section_id,crm_lead.title_action,crm_lead.phone,date_trunc('second', crm_lead.write_date) as write_date,crm_lead.active,crm_lead.date_action,crm_lead.categ_id,crm_lead.name,crm_lead.stage_id,crm_lead.date_open,crm_lead.date_deadline,crm_lead.optout,crm_lead.mobile,crm_lead.ref,crm_lead.birthdate,crm_lead.channel_id,crm_lead.state_id,crm_lead.email_from,crm_lead.referred,crm_lead.id FROM "crm_lead" WHERE crm_lead.id IN %s ORDER BY priority,date_action,id desc
[2011-06-19 14:16:01,057][test] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
File "/home/elbati/workspace/openerp/openerp6/server/bin/osv/osv.py", line 122, in wrapper
return f(self, dbname, *args, **kwargs)
File "/home/elbati/workspace/openerp/openerp6/server/bin/osv/osv.py", line 176, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/home/elbati/workspace/openerp/openerp6/server/bin/osv/osv.py", line 167, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/home/elbati/workspace/openerp/openerp6/server/bin/osv/orm.py", line 3694, in create
self.pool.get(object)._store_set_values(cr, user, ids, fields2, context)
File "/home/elbati/workspace/openerp/openerp6/server/bin/osv/orm.py", line 3788, in _store_set_values
result = self._columns[val[0]].get(cr, self, ids, val, 1, context=context)
File "/home/elbati/workspace/openerp/openerp6/server/bin/osv/fields.py", line 800, in get
res = self._fnct(obj, cr, user, ids, name, self._arg, context)
File "/home/elbati/workspace/openerp/openerp6/server/bin/addons/crm/crm_lead.py", line 69, in _compute_day
if lead.date_closed:
File "/home/elbati/workspace/openerp/openerp6/server/bin/osv/orm.py", line 292, in __getattr__
return self[name]
File "/home/elbati/workspace/openerp/openerp6/server/bin/osv/orm.py", line 194, in __getitem__
fields_to_fetch = filter(lambda x: x[1]._classic_write, self._table._columns.items())
File "/home/elbati/workspace/openerp/openerp6/server/bin/osv/orm.py", line 2942, in read
result = self._read_flat(cr, user, select, fields, context, load)
File "/home/elbati/workspace/openerp/openerp6/server/bin/osv/orm.py", line 3001, in _read_flat
cr.execute(query, (tuple(sub_ids),))
File "/home/elbati/workspace/openerp/openerp6/server/bin/sql_db.py", line 78, in wrapper
return f(self, *args, **kwargs)
File "/home/elbati/workspace/openerp/openerp6/server/bin/sql_db.py", line 131, in execute
res = self._obj.execute(query, params)
ProgrammingError: column crm_lead.last_name does not exist
LINE 1: SELECT crm_lead.date_closed,crm_lead.last_name,date_trunc('s... ^
This is because 'crm.lead' inherits 'res.partner.address' by prototyping, but the new module (base_partner_surname) has been installed after 'crm', so, when 'crm' was installed, 'last_name' didn't exist.
openobject- server/ 6.0 revno 3445
Steps:
1 - Install 'crm' module address' (for instance, you can use 'base_partner_ surname' http:// apps.openerp. com/addon/ 1526 or 'l10n_it_base' http:// apps.openerp. com/addon/ 4528) and install it
2 - Make a module that adds a field to 'res.partner.
3 - Try to create a new lead
you get:
[2011-06-19 14:16:01,056][test] ERROR:db. cursor: Programming error: column crm_lead.last_name does not exist date_closed, crm_lead. last_name, date_trunc( 's...
^ date_closed, crm_lead. last_name, date_trunc( 'second' , crm_lead. create_ date) as create_ date,crm_ lead.probabilit y,crm_lead. type_id, crm_lead. partner_ address_ id,crm_ lead.date_ action_ last,crm_ lead.day_ close,crm_ lead.street, crm_lead. day_open, crm_lead. contact_ name,crm_ lead.partner_ id,crm_ lead.date_ action_ next,crm_ lead.city, crm_lead. first_name, crm_lead. user_id, crm_lead. zip,crm_ lead.title, crm_lead. partner_ name,crm_ lead.planned_ revenue, crm_lead. country_ id,crm_ lead.company_ id,crm_ lead.id, crm_lead. priority, crm_lead. state,crm_ lead.email_ cc,crm_ lead.type, crm_lead. email,crm_ lead.function, crm_lead. fax,crm_ lead.optin, crm_lead. description, crm_lead. street2, crm_lead. ref2,crm_ lead.section_ id,crm_ lead.title_ action, crm_lead. phone,date_ trunc(' second' , crm_lead. write_date) as write_date, crm_lead. active, crm_lead. date_action, crm_lead. categ_id, crm_lead. name,crm_ lead.stage_ id,crm_ lead.date_ open,crm_ lead.date_ deadline, crm_lead. optout, crm_lead. mobile, crm_lead. ref,crm_ lead.birthdate, crm_lead. channel_ id,crm_ lead.state_ id,crm_ lead.email_ from,crm_ lead.referred, crm_lead. id FROM "crm_lead" WHERE crm_lead.id IN %s ORDER BY priority, date_action, id desc services: Uncaught exception elbati/ workspace/ openerp/ openerp6/ server/ bin/osv/ osv.py" , line 122, in wrapper elbati/ workspace/ openerp/ openerp6/ server/ bin/osv/ osv.py" , line 176, in execute elbati/ workspace/ openerp/ openerp6/ server/ bin/osv/ osv.py" , line 167, in execute_cr elbati/ workspace/ openerp/ openerp6/ server/ bin/osv/ orm.py" , line 3694, in create pool.get( object) ._store_ set_values( cr, user, ids, fields2, context) elbati/ workspace/ openerp/ openerp6/ server/ bin/osv/ orm.py" , line 3788, in _store_set_values val[0]] .get(cr, self, ids, val, 1, context=context) elbati/ workspace/ openerp/ openerp6/ server/ bin/osv/ fields. py", line 800, in get elbati/ workspace/ openerp/ openerp6/ server/ bin/addons/ crm/crm_ lead.py" , line 69, in _compute_day elbati/ workspace/ openerp/ openerp6/ server/ bin/osv/ orm.py" , line 292, in __getattr__ elbati/ workspace/ openerp/ openerp6/ server/ bin/osv/ orm.py" , line 194, in __getitem__ write, self._table. _columns. items() ) elbati/ workspace/ openerp/ openerp6/ server/ bin/osv/ orm.py" , line 2942, in read elbati/ workspace/ openerp/ openerp6/ server/ bin/osv/ orm.py" , line 3001, in _read_flat execute( query, (tuple(sub_ids),)) elbati/ workspace/ openerp/ openerp6/ server/ bin/sql_ db.py", line 78, in wrapper elbati/ workspace/ openerp/ openerp6/ server/ bin/sql_ db.py", line 131, in execute execute( query, params) date_closed, crm_lead. last_name, date_trunc( 's...
^
LINE 1: SELECT crm_lead.
, in query SELECT crm_lead.
[2011-06-19 14:16:01,057][test] ERROR:web-
Traceback (most recent call last):
File "/home/
return f(self, dbname, *args, **kwargs)
File "/home/
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/home/
return getattr(object, method)(cr, uid, *args, **kw)
File "/home/
self.
File "/home/
result = self._columns[
File "/home/
res = self._fnct(obj, cr, user, ids, name, self._arg, context)
File "/home/
if lead.date_closed:
File "/home/
return self[name]
File "/home/
fields_to_fetch = filter(lambda x: x[1]._classic_
File "/home/
result = self._read_flat(cr, user, select, fields, context, load)
File "/home/
cr.
File "/home/
return f(self, *args, **kwargs)
File "/home/
res = self._obj.
ProgrammingError: column crm_lead.last_name does not exist
LINE 1: SELECT crm_lead.
This is because 'crm.lead' inherits 'res.partner. address' by prototyping, but the new module (base_partner_ surname) has been installed after 'crm', so, when 'crm' was installed, 'last_name' didn't exist.
Investigating, I noticed that at line 194 bazaar. launchpad. net/~openerp/ openobject- server/ 6.0/view/ 3445/bin/ osv/orm. py#L190 table._ columns' contains 'last_name' while that column, as mentioned above, is not present within the database.
http://
'self._