even with the module from launchpad, I got the same error messages.
Really strange is the fact, that i received the products categories
perfectly.
In the Apache Logfiles are only successful requests. Maybe the error
message "Invalid api path" appears under several circumstances.
Mentioned below you will find the error messages in detail.
I have OpenERP (6.02) as well as Magento (1.5.1) up and running as test
installation in the internet. Any help is really welcome.
Best regards,
Arno Nebauer
Deleted Magento cache in /var/cache
Klick on "2 - Synchronize Referential Settings" results in Error <Fault
3: 'Invalid api path.'>:
+++++++++++++++++++++++++++++++++++++++
Environment Information :
System : Linux-2.6.32-5-686-i686-with-debian-6.0.2
OS Name : posix
Distributor ID: Debian
Description: Debian GNU/Linux 6.0.2 (squeeze)
Release: 6.0.2
Codename: squeeze
Operating System Release : 2.6.32-5-686
Operating System Version : #1 SMP Mon Jun 13 04:13:06 UTC 2011
Operating System Architecture : 32bit
Operating System Locale : de_DE.UTF8
Python Version : 2.6.6
OpenERP-Client Version : 6.0.2
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent
call last):
File "/usr/share/pyshared/openerp-server/netsvc.py", line 489, in
dispatch
result = ExportService.getService(service_name).dispatch(method,
auth, params)
File "/usr/share/pyshared/openerp-server/service/web_services.py",
line 599, in dispatch
res = fn(db, uid, *params)
File "/usr/share/pyshared/openerp-server/osv/osv.py", line 122, in
wrapper
return f(self, dbname, *args, **kwargs)
File "/usr/share/pyshared/openerp-server/osv/osv.py", line 176, in
execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/usr/share/pyshared/openerp-server/osv/osv.py", line 167, in
execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File
"/usr/share/pyshared/openerp-server/addons/magentoerpconnect.zip/magentoerpconnect/magerp_core.py",
line 64, in core_sync
self.pool.get('external.shop.group').mage_import_base(cr,
uid,core_imp_conn, inst.id, defaults={'referential_id':inst.id})
File
"/usr/share/pyshared/openerp-server/addons/magentoerpconnect.zip/magentoerpconnect/magerp_osv.py",
line 227, in mage_import_base
data = conn.call(list_method, context['ids_or_filter'])
File
"/usr/share/pyshared/openerp-server/addons/magentoerpconnect.zip/magentoerpconnect/magerp_osv.py",
line 53, in call
res = self.ser.call(self.session, method, arguments)
File "/usr/lib/python2.6/xmlrpclib.py", line 1199, in __call__
return self.__send(self.__name, args)
File "/usr/lib/python2.6/xmlrpclib.py", line 1489, in __request
verbose=self.__verbose
File "/usr/lib/python2.6/xmlrpclib.py", line 1253, in request
return self._parse_response(h.getfile(), sock)
File "/usr/lib/python2.6/xmlrpclib.py", line 1392, in _parse_response
return u.close()
File "/usr/lib/python2.6/xmlrpclib.py", line 838, in close
raise Fault(**self._stack[0])
Fault: <Fault 3: 'Invalid api path.'>
++++++++++++++++++++++++++++++++++++++++++++++++
Apaches logfile says:
46.4.216.219 - - [18/Aug/2011:16:22:18 +0200] "POST
/index.php/api/xmlrpc/ HTTP/1.0" 200 168 "-" "xmlrpclib.py/1.0.1 (by
www.pythonware.com)"
46.4.216.219 - - [18/Aug/2011:16:22:20 +0200] "POST
/index.php/api/xmlrpc/ HTTP/1.0" 200 275 "-" "xmlrpclib.py/1.0.1 (by
www.pythonware.com)"
++++++++++++++++++++++++++++++++++++++++++++++++
Optional - Initial import only says:
1. Import Customer Groups: <Fault 3: 'Invalid api path.'>
2. Import Product Categories: works, Categories are in OpenERP
3. - 5. : <Fault 3: 'Invalid api path.'>
6. Import Products :
+++++++++++++++++++++++++++++++++++++++++++++++
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent
call last):
File "/usr/share/pyshared/openerp-server/netsvc.py", line 489, in
dispatch
result = ExportService.getService(service_name).dispatch(method,
auth, params)
File "/usr/share/pyshared/openerp-server/service/web_services.py",
line 599, in dispatch
res = fn(db, uid, *params)
File "/usr/share/pyshared/openerp-server/osv/osv.py", line 122, in
wrapper
return f(self, dbname, *args, **kwargs)
File "/usr/share/pyshared/openerp-server/osv/osv.py", line 176, in
execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/usr/share/pyshared/openerp-server/osv/osv.py", line 167, in
execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File
"/usr/share/pyshared/openerp-server/addons/magentoerpconnect.zip/magentoerpconnect/magerp_core.py",
line 149, in sync_products
self.pool.get('product.product').ext_import(cr, uid, result,
inst.id, context={})
File
"/usr/share/pyshared/openerp-server/addons/base_external_referentials/external_osv.py",
line 254, in ext_import
crid = self.oe_create(cr, uid, vals, each_row,
external_referential_id, defaults, context)
File
"/usr/share/pyshared/openerp-server/addons/base_external_referentials/external_osv.py",
line 280, in oe_create
return self.create(cr, uid, vals, context)
File
"/usr/share/pyshared/openerp-server/addons/magentoerpconnect.zip/magentoerpconnect/product.py",
line 738, in create
File "/usr/share/pyshared/openerp-server/osv/orm.py", line 3683, in
create
result += self._columns[field].set(cr, self, id_new, field,
vals[field], user, rel_context) or []
File "/usr/share/pyshared/openerp-server/osv/fields.py", line 637, in set
cr.execute('insert into '+self._rel+' ('+self._id1+','+self._id2+')
values (%s, %s)', (id, act_nbr))
File "/usr/share/pyshared/openerp-server/sql_db.py", line 78, in wrapper
return f(self, *args, **kwargs)
File "/usr/share/pyshared/openerp-server/sql_db.py", line 131, in execute
res = self._obj.execute(query, params)
ProgrammingError: column "shop_group_id" is of type integer but
expression is of type boolean
ZEILE 1: ..._shop_group_rel (product_id,shop_group_id) values (6, false) ^
TIP: You will need to rewrite or cast the expression.
+++++++++++++++++++++++++++++++++++++++++++++++
7. Import Images says:
+++++++++++++++++++++++++++++++++++++++++++++++
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent
call last):
File "/usr/share/pyshared/openerp-server/netsvc.py", line 489, in
dispatch
result = ExportService.getService(service_name).dispatch(method,
auth, params)
File "/usr/share/pyshared/openerp-server/service/web_services.py",
line 599, in dispatch
res = fn(db, uid, *params)
File "/usr/share/pyshared/openerp-server/osv/osv.py", line 122, in
wrapper
return f(self, dbname, *args, **kwargs)
File "/usr/share/pyshared/openerp-server/osv/osv.py", line 176, in
execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/usr/share/pyshared/openerp-server/osv/osv.py", line 167, in
execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File
"/usr/share/pyshared/openerp-server/addons/magentoerpconnect.zip/magentoerpconnect/magerp_core.py",
line 153, in sync_images
logger = netsvc.Logger()
NameError: global name 'netsvc' is not defined
+++++++++++++++++++++++++++++++++++++++++++++++
In all cases the apache logfile gives similar entrys, only the output
size varies.
Am 18.08.2011 03:58, schrieb Kyle Waid - http://www.gcotech.com:
> Arno,
>
> you are talking about the magento connect repository but there is a repository here on launchpad.
> lp:magentoerpconnect/magento-module
>
> Try installing the module manually,
> clear the session data and cache
> go to system> advanced> advanced
> click save, it will reload your modules
>
> If you still have problems after trying the different versions you would
> need to have someone look at it for you. Let me know if this works for
> you and if it doesnt contact me via email and I will see if I can help
> you.
>
> Andreas,
> I would suggest following the same. the folder structure is somewhat like
> /etc/code/community/Openlabs/OpenERPConnector
>
> You can do the same if you cant figure it out. Thanks!
>
Hi Kyle,
even with the module from launchpad, I got the same error messages.
Really strange is the fact, that i received the products categories
perfectly.
In the Apache Logfiles are only successful requests. Maybe the error
message "Invalid api path" appears under several circumstances.
Mentioned below you will find the error messages in detail.
I have OpenERP (6.02) as well as Magento (1.5.1) up and running as test
installation in the internet. Any help is really welcome.
Best regards,
Arno Nebauer
Deleted Magento cache in /var/cache
Klick on "2 - Synchronize Referential Settings" results in Error <Fault +++++++ +++++++ +++++++ +++++++ ++++ 6.32-5- 686-i686- with-debian- 6.0.2 pyshared/ openerp- server/ netsvc. py", line 489, in getService( service_ name).dispatch( method, pyshared/ openerp- server/ service/ web_services. py", pyshared/ openerp- server/ osv/osv. py", line 122, in pyshared/ openerp- server/ osv/osv. py", line 176, in pyshared/ openerp- server/ osv/osv. py", line 167, in pyshared/ openerp- server/ addons/ magentoerpconne ct.zip/ magentoerpconne ct/magerp_ core.py" , pool.get( 'external. shop.group' ).mage_ import_ base(cr, {'referential_ id':inst. id}) pyshared/ openerp- server/ addons/ magentoerpconne ct.zip/ magentoerpconne ct/magerp_ osv.py" , list_method, context[ 'ids_or_ filter' ]) pyshared/ openerp- server/ addons/ magentoerpconne ct.zip/ magentoerpconne ct/magerp_ osv.py" , call(self. session, method, arguments) python2. 6/xmlrpclib. py", line 1199, in __call__ send(self. __name, args) python2. 6/xmlrpclib. py", line 1489, in __request self.__ verbose python2. 6/xmlrpclib. py", line 1253, in request response( h.getfile( ), sock) python2. 6/xmlrpclib. py", line 1392, in _parse_response python2. 6/xmlrpclib. py", line 838, in close *self._ stack[0] ) +++++++ +++++++ +++++++ +++++++ +++++++ ++++++ 2011:16: 22:18 +0200] "POST php/api/ xmlrpc/ HTTP/1.0" 200 168 "-" "xmlrpclib.py/1.0.1 (by com)" 2011:16: 22:20 +0200] "POST php/api/ xmlrpc/ HTTP/1.0" 200 275 "-" "xmlrpclib.py/1.0.1 (by com)" +++++++ +++++++ +++++++ +++++++ +++++++ ++++++
3: 'Invalid api path.'>:
+++++++
Environment Information :
System : Linux-2.
OS Name : posix
Distributor ID: Debian
Description: Debian GNU/Linux 6.0.2 (squeeze)
Release: 6.0.2
Codename: squeeze
Operating System Release : 2.6.32-5-686
Operating System Version : #1 SMP Mon Jun 13 04:13:06 UTC 2011
Operating System Architecture : 32bit
Operating System Locale : de_DE.UTF8
Python Version : 2.6.6
OpenERP-Client Version : 6.0.2
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent
call last):
File "/usr/share/
dispatch
result = ExportService.
auth, params)
File "/usr/share/
line 599, in dispatch
res = fn(db, uid, *params)
File "/usr/share/
wrapper
return f(self, dbname, *args, **kwargs)
File "/usr/share/
execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/usr/share/
execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File
"/usr/share/
line 64, in core_sync
self.
uid,core_imp_conn, inst.id, defaults=
File
"/usr/share/
line 227, in mage_import_base
data = conn.call(
File
"/usr/share/
line 53, in call
res = self.ser.
File "/usr/lib/
return self.__
File "/usr/lib/
verbose=
File "/usr/lib/
return self._parse_
File "/usr/lib/
return u.close()
File "/usr/lib/
raise Fault(*
Fault: <Fault 3: 'Invalid api path.'>
+++++++
Apaches logfile says:
46.4.216.219 - - [18/Aug/
/index.
www.pythonware.
46.4.216.219 - - [18/Aug/
/index.
www.pythonware.
+++++++
Optional - Initial import only says:
1. Import Customer Groups: <Fault 3: 'Invalid api path.'> +++++++ +++++++ +++++++ +++++++ +++++++ +++++ pyshared/ openerp- server/ netsvc. py", line 489, in getService( service_ name).dispatch( method, pyshared/ openerp- server/ service/ web_services. py", pyshared/ openerp- server/ osv/osv. py", line 122, in pyshared/ openerp- server/ osv/osv. py", line 176, in pyshared/ openerp- server/ osv/osv. py", line 167, in pyshared/ openerp- server/ addons/ magentoerpconne ct.zip/ magentoerpconne ct/magerp_ core.py" , pool.get( 'product. product' ).ext_import( cr, uid, result, pyshared/ openerp- server/ addons/ base_external_ referentials/ external_ osv.py" , referential_ id, defaults, context) pyshared/ openerp- server/ addons/ base_external_ referentials/ external_ osv.py" , pyshared/ openerp- server/ addons/ magentoerpconne ct.zip/ magentoerpconne ct/product. py", pyshared/ openerp- server/ osv/orm. py", line 3683, in field]. set(cr, self, id_new, field, pyshared/ openerp- server/ osv/fields. py", line 637, in set execute( 'insert into '+self._rel+' ('+self. _id1+', '+self. _id2+') pyshared/ openerp- server/ sql_db. py", line 78, in wrapper pyshared/ openerp- server/ sql_db. py", line 131, in execute execute( query, params) id,shop_ group_id) values (6, false)
^ +++++++ +++++++ +++++++ +++++++ +++++++ +++++
2. Import Product Categories: works, Categories are in OpenERP
3. - 5. : <Fault 3: 'Invalid api path.'>
6. Import Products :
+++++++
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent
call last):
File "/usr/share/
dispatch
result = ExportService.
auth, params)
File "/usr/share/
line 599, in dispatch
res = fn(db, uid, *params)
File "/usr/share/
wrapper
return f(self, dbname, *args, **kwargs)
File "/usr/share/
execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/usr/share/
execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File
"/usr/share/
line 149, in sync_products
self.
inst.id, context={})
File
"/usr/share/
line 254, in ext_import
crid = self.oe_create(cr, uid, vals, each_row,
external_
File
"/usr/share/
line 280, in oe_create
return self.create(cr, uid, vals, context)
File
"/usr/share/
line 738, in create
File "/usr/share/
create
result += self._columns[
vals[field], user, rel_context) or []
File "/usr/share/
cr.
values (%s, %s)', (id, act_nbr))
File "/usr/share/
return f(self, *args, **kwargs)
File "/usr/share/
res = self._obj.
ProgrammingError: column "shop_group_id" is of type integer but
expression is of type boolean
ZEILE 1: ..._shop_group_rel (product_
TIP: You will need to rewrite or cast the expression.
+++++++
7. Import Images says: +++++++ +++++++ +++++++ +++++++ +++++++ +++++ pyshared/ openerp- server/ netsvc. py", line 489, in getService( service_ name).dispatch( method, pyshared/ openerp- server/ service/ web_services. py", pyshared/ openerp- server/ osv/osv. py", line 122, in pyshared/ openerp- server/ osv/osv. py", line 176, in pyshared/ openerp- server/ osv/osv. py", line 167, in pyshared/ openerp- server/ addons/ magentoerpconne ct.zip/ magentoerpconne ct/magerp_ core.py" , +++++++ +++++++ +++++++ +++++++ +++++++ +++++
+++++++
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent
call last):
File "/usr/share/
dispatch
result = ExportService.
auth, params)
File "/usr/share/
line 599, in dispatch
res = fn(db, uid, *params)
File "/usr/share/
wrapper
return f(self, dbname, *args, **kwargs)
File "/usr/share/
execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/usr/share/
execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File
"/usr/share/
line 153, in sync_images
logger = netsvc.Logger()
NameError: global name 'netsvc' is not defined
+++++++
In all cases the apache logfile gives similar entrys, only the output
size varies.
Am 18.08.2011 03:58, schrieb Kyle Waid - http:// www.gcotech. com: community/ Openlabs/ OpenERPConnecto r
> Arno,
>
> you are talking about the magento connect repository but there is a repository here on launchpad.
> lp:magentoerpconnect/magento-module
>
> Try installing the module manually,
> clear the session data and cache
> go to system> advanced> advanced
> click save, it will reload your modules
>
> If you still have problems after trying the different versions you would
> need to have someone look at it for you. Let me know if this works for
> you and if it doesnt contact me via email and I will see if I can help
> you.
>
> Andreas,
> I would suggest following the same. the folder structure is somewhat like
> /etc/code/
>
> You can do the same if you cant figure it out. Thanks!
>