openerp-connector-community team mailing list archive

[Landis Arnold <larnold@xxxxxxxxxxx>]

Solved I think: I seems w e are back in Business. (it is slow, but I am majorly upgraded it seems) :) 

A restart or two were involved. Then to get past the 5.4 PHP issue 

apt-get install bzrtools 
then load the patches into the folders they actually work on 
bzr patch patchname.patch 

Somehow one had "self installed" - not sure how, but I epect this is how I was getting "some data in". 

I did learn something. 

best to all. Sorry for all the emails. 

Landis Arnold 
larnold@xxxxxxxxxxx 

----- Original Message -----

From: "Landis Arnold" <larnold@xxxxxxxxxxx> 
To: "Landis Arnold" <larnold@xxxxxxxxxxx> 
Cc: "openerp-connector-community" <openerp-connector-community@xxxxxxxxxxxxxxxxxxx> 
Sent: Thursday, April 10, 2014 3:00:33 PM 
Subject: Re: [Openerp-connector-community] Question about upgrades and possible reconfigurations 

Workers don't seem to be starting (I only have one). Last Alive Check (2 days ago prior to upgrade) 

UUID 	fc3c8773-7d71-4db6-b077-b149548987c0 
PID 	1448 Start Date 	04/08/2014 12:25:06 
Last Alive Check 	04/08/2014 16:18:08 

So, I can go backwards to pre-upgrade but I would rather not. 
How to get these workers moving? 

Should I move this to 'help.openerp.com" and get lost in the ether but clean up some inboxes? 
best to all. 

Landis 

----- Original Message -----

From: "Landis Arnold" <larnold@xxxxxxxxxxx> 
To: "Landis Arnold" <larnold@xxxxxxxxxxx> 
Cc: "openerp-connector-community" <openerp-connector-community@xxxxxxxxxxxxxxxxxxx> 
Sent: Thursday, April 10, 2014 2:50:08 PM 
Subject: Re: [Openerp-connector-community] Question about upgrades and possible reconfigurations 

Most errors gone on try 2 and after Grafting a few inputs together. 

./openerp-server -c /etc/openerp-server.conf -u all -d YOURDATABASENAME (random web instructions) 
-u all sale_payment_method,connector ( Guewen's instructions on this list from Feb 10 2014 ) 

what is working for database upgrade right now is: (very long upgrade seems to have completed - and no running errors that I can see as last time) 
su - openerp 
/bin/bash start -u all 

can test again: (had an error on first try - seem to have installed the modules below automatically 7.0.0.2.1 .) 
su - openerp 
/bin/bash start -u all sale_payment_method,connector 

Still expecting the Magento PHP 5.4 errors now. The Job I went to recue (first of about 12) from 04/03/14 at 14:00 just shows as pending. Does not seem to go beyond that. 
Not seeing anything in my Server Console either. Not triggering. 

I now have called an import of new orders. It looks like new Jobs toggle to Pending and stop there. 
I expect I need to work on the Magento side but I am suprised there are no Errors or Fails coming back to me. Just everything seems to be "Pending". 

Thoughts on this? 
thanks in advance, 

Landis Arnold 











----- Original Message -----

From: "Landis Arnold" <larnold@xxxxxxxxxxx> 
To: "Landis Arnold" <larnold@xxxxxxxxxxx> 
Cc: "openerp-connector-community" <openerp-connector-community@xxxxxxxxxxxxxxxxxxx> 
Sent: Thursday, April 10, 2014 1:41:01 PM 
Subject: Re: [Openerp-connector-community] Question about upgrades and possible reconfigurations 

It seems there may need to be a Database Update command for one. 

The xml-rpc connection also did fail (assume related to Magento and PHP 5.4). But because there were so many errors related (see error below) it was hard to capture the console output on that. Thomas just gave some guidance on that (he says to downgrade to PHP 5.3 in Magento) on the bug report: https://bugs.launchpad.net/openerp-connector-magento/+bug/1210775 

I will try to get the patch working, but I would sure like it if I can get the Auto Workflows working. They were working before I did all my pulls. 

Fun fun. I apologize about sending messages to a group like this. Is there a better method/forum for seeking help on this front. 

best to all, 
Landis Arnold 




----- Original Message -----

From: "Landis Arnold" <larnold@xxxxxxxxxxx> 
To: "Landis Arnold" <larnold@xxxxxxxxxxx> 
Cc: "openerp-connector-community" <openerp-connector-community@xxxxxxxxxxxxxxxxxxx> 
Sent: Thursday, April 10, 2014 1:26:40 PM 
Subject: Re: [Openerp-connector-community] Question about upgrades and possible reconfigurations 

So I did bring everything forward. Running OpenERP I am getting a running recursion of the following error in my Shell - of OpenERP. 
I can basically navigate inside OpenERP. I see the Connector Checkpoints I had. Still the Error keeps showing itself in my OpenERP window. 

I do have a Snapshot I will revert to which is immediately before my START command. I am going to go there and look a bit for the two files which seem to be conflicing. 

I also need to install the "partner.py" patch which I read should be able to help deal w/ my Magento having PHP 5.4 on it. I ran the Magento Patch but didn't fix my previous Job Failures on syncronization. 

Any thoughts on this? See Error below. 
Thanks for any and all help, 

Landis Arnold 




File "/opt/openerp/server/openerp/sql_db.py", line 226, in execute 
res = self._obj.execute(query, params) 
ProgrammingError: relation "accountmovelinesaleorderrel" does not exist 
LINE 1: ...e order rel.sale order id FROM account mo... 
2014-04-10 19:20:50,045 1793 ERROR active openerp.addons.saleautomaticworkflow.automaticworkflow 
job: Error during an automatic workflow action. 
Traceback (most recent call last): 
File "/opt/openerp/source/e-commerce-addons/sale_automatic_workflow/automatic_workflow_job.py", I 
ine 65, in commit 
yield 
File "/opt/openerp/source/e-commerce-addons/sale_automatic_workflow/automatic_workflow_job.py", I 
ine 103, in reconcileinvoices 
context=context) 
File "/opt/openerp/source/e-commerce-addons/sale_automatic_workflow/invoice.py", line 152, in rec 
oncileinvoice 
self._reconcile_invoice(cr, uid, invoice, context=context) 
File "/opt/openerp/source/e-commerce-addons/sale_automatic_workflow/invoice.py", line 120, in re 
concileinvoice 
if self._can_be_reconciled(cr, uid, invoice, context=context): 
File "/opt/openerp/source/e-commerce-addons/sale_automatic_workflow/invoice.py", line 45, in can 
bereconciled 
payments = self.getpayment(cr, uid, invoice, context=context) 
File "/opt/openerp/source/e-commerce-addons/sale_automatic_workflow/invoice.py", line 41, in get 
payment 
return invoice.saleids[0].paymentids 
File "/opt/openerp/server/openerp/osv/orm.py", line 502, in getattr____ 
return self[name] 
File "/opt/openerp/server/openerp/osv/orm.py", line 405, in getitem____ 
fieldvalues = self.table.read(self._cr, self.uid, ids, fieldnames, context=self.context, I 
pad="_classic_write") 
File "/opt/openerp/server/openerp/osv/orm.py", line 3679, in read 
result = self.readflat(cr, user, select, fields, context, load) 
File "/opt/openerp/server/openerp/osv/orm.py", line 3800, in readflat 
res2 = self.columns[f].get(cr, self, ids, f, user, context=context, values=res) 
File "/opt/openerp/server/openerp/osv/fields.py", line 748, in get 
cr.execute(query, [tuple(ids),] + whereparams) 
File "/opt/openerp/server/openerp/sqldb.py", line 161, in wrapper 
return f(self, *args, **kwargs) 
File "/opt/openerp/server/openerp/sqldb.py", line 226, in execute 
res = self._obj.execute(query, params) 
ProgrammingError: relation "accountmovelinesaleorderrel" does not exist 
LINE 1: ...e order rel.sale order id FROM account mo... 
I 

----- Original Message -----

From: "Landis Arnold" <larnold@xxxxxxxxxxx> 
To: "openerp-connector-community" <openerp-connector-community@xxxxxxxxxxxxxxxxxxx> 
Sent: Thursday, April 10, 2014 11:59:36 AM 
Subject: [Openerp-connector-community] Question about upgrades and possible reconfigurations 

Hi, 
I am restructuring my server now trying to get past the PHP 5.4 issue that hit Magento. Bringing my BZR folders and everything in line to current spec. 

I am, of course, nervous that it won't work as planned. The question I have is this. If I "remove" (ie disconnect) the connector from the OpenERP App list in my server then reinstall/attach it will the new setup process go and duplicate all of the items and customers I already have in my system. 

I am hoping I don't have to go this way, that my reconfigure - pre OpenERP now, will simply go smoothly. It seems, however, that it should be possible to disconnect and reconnect the connector without creating a bunch of dups. 

Thanks for any thoughts on this. 

Landis 

-- 
Landis Arnold 

larnold@xxxxxxxxxxx 

office: 303-444-2336 ext 11 
cell : 303-601-0622 

-- 
Mailing list: https://launchpad.net/~openerp-connector-community 
Post to : openerp-connector-community@xxxxxxxxxxxxxxxxxxx 
Unsubscribe : https://launchpad.net/~openerp-connector-community 
More help : https://help.launchpad.net/ListHelp 


-- 
Mailing list: https://launchpad.net/~openerp-connector-community 
Post to : openerp-connector-community@xxxxxxxxxxxxxxxxxxx 
Unsubscribe : https://launchpad.net/~openerp-connector-community 
More help : https://help.launchpad.net/ListHelp 


-- 
Mailing list: https://launchpad.net/~openerp-connector-community 
Post to : openerp-connector-community@xxxxxxxxxxxxxxxxxxx 
Unsubscribe : https://launchpad.net/~openerp-connector-community 
More help : https://help.launchpad.net/ListHelp 


-- 
Mailing list: https://launchpad.net/~openerp-connector-community 
Post to : openerp-connector-community@xxxxxxxxxxxxxxxxxxx 
Unsubscribe : https://launchpad.net/~openerp-connector-community 
More help : https://help.launchpad.net/ListHelp 


-- 
Mailing list: https://launchpad.net/~openerp-connector-community 
Post to : openerp-connector-community@xxxxxxxxxxxxxxxxxxx 
Unsubscribe : https://launchpad.net/~openerp-connector-community 
More help : https://help.launchpad.net/ListHelp