This morning the connections between Magento is broken to ebay. It also doesn’t work with anything sold on amazon which doesn’t update on ebay but updates on magento. I’ve also sent in a e-mail to support 3 days ago with my login details and access to my ftp and nothing has happened. Looks like this is not going to work as it is riddled with problems that cannot be sorted. And still getting persistent error messages in the synchronisation problems with,
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘pc.initiators’ in ‘field list’
I’ve tried to investigate this error but the problem gets sorted (if you are lucky) but no reason why it has happened and what it affects.
Widgetchimp doesn’t work either properly, must be something to do with the above reason. Put a ticket in to there support and they said they could not do anything as the problem was in the m2e pro side of things, so going round in circles.
All I know is that my head hurts from banging my head against a brick wall.
Between my developer and m2epro support are both scratching there heads as to where the problem is. One solution is that it is something to do with a firewall but we don’t know who’s server it is attached to. We have checked our’s and m2epro’s server name is not there so it looks like it is at the m2epro’s end but at the moment this is not a definite. I have done a manual synchronization and all is well with orders but it does come up with the error for inventory. We are moving to a new server tomorrow for a different reason not associated with this so fingers crossed that may throw up a few answer’s, hopefully.
Just got up and running with the contacting server, my server firewall was blocking it, so getting orders coming in from ebay and amazon. Just got the last problem SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘pc.initiators’ in ‘field list’
which is stopping the inventory side of things which for us is the most important.
My developer things that it is in a table with the m2epro program but found 120 tables in there so could not find it.
I have sent a support ticket to m2epro with log in details so waiting for a reaction, fingers crossed they can sort it.
They recently changed the servers July 20th 2015, I have checked my firewall setting and my ports are open as stated for 80 and 443.
Not properly checked it as it is late in the day but had a e-mail from support saying that “It was a problem related to a failed upgrade. Now it is fixed so all should work correctly. Please check it.”
Done a re-index and done a re-sync and at least no waning logs so fingers crossed I think we may have cracked it.
Why Should You Join UnderstandingE?
- Access to over 500 step-by-step video tutorials
- +20 video courses available
- Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
- Everything is in 100% Plain English
- Learn how to build your own multi-channel software for eBay & Amazon
- Access to the community forums, meet fellow business owners like yourself
Join Now with 2 Clicks
Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.
Most Users Ever Online: 1012
Currently Browsing this Page:
Jim @ Moogento: 688
Steve Froggatt: 514
Badeth - UE: 513
Paul Cartwright: 414
Administrators: Matthew Ogborne: 4565, Dave Furness: 4606