Zen Cart Logo
Forums / Addon Shipping Modules / GOB Package Tracker 1136 Error

GOB Package Tracker 1136 Error

Views: 763

Results 1 to 2 of 2
25 Jan 2012, 9:08 PM
#1
brooklynartist avatar

brooklynartist

New Zenner

Join Date:
Jan 2011
Location:
Brooklyn
Posts:
75
Plugin Contributions:
0

GOB Package Tracker 1136 Error

The GOB Package Tracker Support Thread is closed so I'm trying my problem here.

On the Order Page in the Admin, when I change the status and click Update I get a page with the error:


1136 Column count doesn't match value count at row 1
in:
[insert into zen_orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments, tracker_id, tracking_numbers) values ('400029', '2', now(), '1', '')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

So to the best of my knowledge the values are all matching up until it gets to 'tracker_id". 'tracker_id' and 'tracking_numbers' aren't in that values string.

An email DOES get sent to the costumer with the carrier and tracking number included. When I navigate back to the Order Page agin I do see that that status has changed. But there is no update to the Order History, only the original "pending" line (created at purchase) is present. The history isnt updated in the customer's order history on the store website either.

Can anyone help?

Thanks!

3 Feb 2012, 6:21 PM
#2
gob33 avatar

gob33

New Zenner

Join Date:
Jun 2008
Location:
Bordeaux, France
Posts:
69
Plugin Contributions:
3

Re: GOB Package Tracker 1136 Error

Column count doesn't match value count.

Its clear. Missing values "tracker_id", "tracking_numbers".
So you forget something in patching code.
Recheck step by step.