smart attach / fts error

[Ferdinand]

python
Python 2.5.2 (r252:60911, Dec 1 2008, 18:10:01)
[GCC 4.3.1 20080507 (prerelease) [gcc-4_3-branch revision 135036]] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import psycopg2.extensions
>>> import psycopg2
>>>
seems to work

+--- This exception occured remotely (Pyro) - Remote traceback:
 | Traceback (most recent call last):
 | File "/usr/lib64/python2.5/site-packages/Pyro/protocol.py", line 669, in _handleInvocation2
 | res = obj.Pyro_dyncall(req[1],flags,req[3]) # (method,flags,args)
 | File "/usr/lib64/python2.5/site-packages/Pyro/core.py", line 108, in Pyro_dyncall
 | return getattr(self.delegate or self,method) (*args,**keywords)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/addons/pyro.zip/pyro/pyro.py", line 48, in dispatch
 | result=method(*args)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/addons/base_module_record/base_module_record.py", line 38, in execute
 | res = super(recording_objects_proxy, self).execute(*args, **argv)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/addons/audittrail/audittrail.py", line 361, in execute
 | res = my_fct(db, uid, passwd, object, method, *args)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/addons/audittrail/audittrail.py", line 351, in my_fct
 | return fct_src(db, uid, passwd, object, method, *args)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/service/web_services.py", line 583, in execute
 | res = service.execute(db, uid, object, method, *args)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/osv/osv.py", line 59, in wrapper
 | return f(self, dbname, *args, **kwargs)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/osv/osv.py", line 119, in execute
 | res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/osv/osv.py", line 111, in execute_cr
 | return getattr(object, method)(cr, uid, *args, **kw)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/addons/document/document.py", line 701, in create
 | result = super(document_file,self).create(cr, uid, vals, context)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/addons/smart_attach.zip/smart_attach/smart_attach.py", line 60, in create
 | id = super(ir_attachment, self).create(cr, uid, vals, context)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/addons/base/ir/ir_attachment.py", line 82, in create
 | return super(ir_attachment, self).create(cr, uid, values, context)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/osv/orm.py", line 2619, in create
 | cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
 | File "/home/terp/OpenERP/branch/server/5.0/bin/sql_db.py", line 76, in wrapper
 | return f(self, *args, **kwargs)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/sql_db.py", line 120, in execute
 | res = self._obj.execute(query, params)
 | InternalError: plpython: function "fts_full_text_search_trigger" failed
 | DETAIL: <type 'exceptions.ImportError'>: No module named psycopg2.extensions
 |
 +--- End of remote traceback

[Ferdinand (office-chricar)]

btw i can not uninstall the module either
+--- This exception occured remotely (Pyro) - Remote traceback:
 | Traceback (most recent call last):
 | File "/usr/lib64/python2.5/site-packages/Pyro/protocol.py", line 669, in _handleInvocation2
 | res = obj.Pyro_dyncall(req[1],flags,req[3]) # (method,flags,args)
 | File "/usr/lib64/python2.5/site-packages/Pyro/core.py", line 108, in Pyro_dyncall
 | return getattr(self.delegate or self,method) (*args,**keywords)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/addons/pyro.zip/pyro/pyro.py", line 48, in dispatch
 | result=method(*args)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/service/web_services.py", line 639, in execute
 | return self._execute(db, uid, wiz_id, datas, action, context)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/service/web_services.py", line 619, in _execute
 | return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/wizard/__init__.py", line 178, in execute
 | res = self.execute_cr(cr, uid, data, state, context)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/wizard/__init__.py", line 74, in execute_cr
 | action_res = action(self, cr, uid, data, context)
 | File "/data/downloads/bzr/openobject-server/bin/addons/base/module/wizard/wizard_module_upgrade.py", line 92, in _upgrade_module
 | db, pool = pooler.restart_pool(cr.dbname, update_module=True)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/pooler.py", line 62, in restart_pool
 | return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/pooler.py", line 40, in get_db_and_pool
 | addons.load_modules(db, force_demo, status, update_module)
 | File "/home/terp/OpenERP/branch/server/5.0/bin/addons/__init__.py", line 755, in load_modules
 | pool.get(rmod).unlink(cr, uid, [rid])
 | AttributeError: 'NoneType' object has no attribute 'unlink'
 +--- End of remote traceback

[Albert Cervera i Areny - http://www.NaN-tic.com (albert-nan)]

A Dijous, 20 d'agost de 2009, Ferdinand @ ChriCar va escriure:
> >>> import psycopg2.extensions
> >>> import psycopg2
> >>>
>
> seems to work

Are you trying this in the server where PostgreSQL is running?

--
Albert Cervera i Areny
http://www.NaN-tic.com
Mòbil: [phone]

[Ferdinand (office-chricar)]

thanks - installing psycopg2 on the postgres server system solved the problem

a bit surprising though.

suggestion fts should check and warn during install

[Albert Cervera i Areny - http://www.NaN-tic.com (albert-nan)]

A Dijous, 20 d'agost de 2009, Ferdinand @ ChriCar va escriure:
> thanks - installing psycopg2 on the postgres server system solved the
> problem
>
> a bit surprising though.

Not surprising, given that the trigger is implemented in Python...
>
> suggestion fts should check and warn during install

More things in the todo list ;-)

>
> >>> import psycopg2.extensions
> >>> import psycopg2
>
> seems to work
>
> +--- This exception occured remotely (Pyro) - Remote traceback:
> | Traceback (most recent call last):
> | File "/usr/lib64/python2.5/site-packages/Pyro/protocol.py", line 669,
> | in _handleInvocation2 res = obj.Pyro_dyncall(req[1],flags,req[3]) #
> | (method,flags,args) File
> | "/usr/lib64/python2.5/site-packages/Pyro/core.py", line 108, in
> | Pyro_dyncall return getattr(self.delegate or self,method)
> | (*args,**keywords) File
> | "/home/terp/OpenERP/branch/server/5.0/bin/addons/pyro.zip/pyro/pyro.py",
> | line 48, in dispatch result=method(*args)
> | File
> | "/home/terp/OpenERP/branch/server/5.0/bin/addons/base_module_record/base
> |_module_record.py", line 38, in execute res =
> | super(recording_objects_proxy, self).execute(*args, **argv) File
> | "/home/terp/OpenERP/branch/server/5.0/bin/addons/audittrail/audittrail.p
> |y", line 361, in execute res = my_fct(db, uid, passwd, object, method,
> | *args)
> | File
> | "/home/terp/OpenERP/branch/server/5.0/bin/addons/audittrail/audittrail.p
> |y", line 351, in my_fct return fct_src(db, uid, passwd, object, method,
> | *args)
> | File
> | "/home/terp/OpenERP/branch/server/5.0/bin/service/web_services.py", line
> | 583, in execute res = service.execute(db, uid, object, method, *args)
> | File "/home/terp/OpenERP/branch/server/5.0/bin/osv/osv.py", line 59,
> | in wrapper return f(self, dbname, *args, **kwargs)
> | File "/home/terp/OpenERP/branch/server/5.0/bin/osv/osv.py", line 119,
> | in execute res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
> | File "/home/terp/OpenERP/branch/server/5.0/bin/osv/osv.py", line 111,
> | in execute_cr return getattr(object, method)(cr, uid, *args, **kw)
> | File
> | "/home/terp/OpenERP/branch/server/5.0/bin/addons/document/document.py",
> | line 701, in create result = super(document_file,self).create(cr, uid,
> | vals, context) File
> | "/home/terp/OpenERP/branch/server/5.0/bin/addons/smart_attach.zip/smart_
> |attach/smart_attach.py", line 60, in create id = super(ir_attachment,
> | self).create(cr, uid, vals, context) File
> | "/home/terp/OpenERP/branch/server/5.0/bin/addons/base/ir/ir_attachment.p
> |y", line 82, in create return super(ir_attachment, self).create(cr, uid,
> | values, context) File
> | "/home/terp/OpenERP/branch/server/5.0/bin/osv/orm.py", line 2619, in
> | create cr.execute('insert into "'+self._table+'" (id'+upd0+") values
> | ("+str(id_new)+upd1+')', tuple(upd2)) File
> | "/home/terp/OpenERP/branch/server/5.0/bin/sql_db.py", line 76, in
> | wrapper return f(self, *args, **kwargs)
> | File "/home/terp/OpenERP/branch/server/5.0/bin/sql_db.py", line 120,
> | in execute res = self._obj.execute(query, params)
> | InternalError: plpython: function "fts_full_text_s...