c2c-oerpscenario team mailing list archive

[Arno Nebauer <610450@xxxxxxxxxxxxxxxxxx>]

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 
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!
>

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/610450

Title:
  Magento Connection Access denied in Synchronize Referential

Status in Magento OpenERP Connector:
  Invalid

Bug description:
  From my openerp Gtk client, to create a new instance in Magento Connection > Core Settings > Magento Instances
  When I click the button ; Synchronize Referential Setting , it get this Error :

  Magento Connection:Attempting connection with
  Settings:http://localhost/magento/index.php/api/xmlrpc/,u1,magento

  ERROR:Magento Connection:[16]: Error in connecting:<Fault 2: 'Access
  denied.'>

  WARNING:Magento Call:Webservice Failure,

  I use Openerp-5.0.10
  Xampp 1.6.4
  Magento 1.6.4
  Ubuntu 9.04

To manage notifications about this bug go to:
https://bugs.launchpad.net/magentoerpconnect/+bug/610450/+subscriptions