Edit Orders v4.0 Support Thread

So i loaded that and then did the same test.
Again a blank page with
[29-Jan-2014 14:00:27] PHP Fatal error: Call to undefined function getrewardpoints() in /home4/w57dsjmm/public_html/d132s/includes/modules/order_total/ot_reward_points_display.php on line 40

as my log. :(

Hi - I just upgraded to EO 4.1.4 (from 4.1.2 I believe) and since then, when tracking # is present, comment text doesn't get included in the email sent to the customer. The comment gets sent fine when there is no tracking # attached. Seems like a TPT problem, except it began after the EO upgrade, that's why I'm posting it here. Sadly, no error logs... (EO trace logs just list the products and OT values, but don't report any problem, either.)

I did make a huge mistake while upgrading and somehow TPT code flew out of the admin/orders.php file, however putting it back in didn't fix the problem. I checked and all of the other TPT and EO files are where they should be and have all the code they're supposed to have (unless I missed something, running on 2-3 hrs of sleep per day for the past week or so...).

Should I check all of my code again or is there a simpler answer to this issue? Any help will be much appreciated.
Thank you!
Magz :frusty:

Quote:

---

Originally Posted by magz

Hi - I just upgraded to EO 4.1.4 (from 4.1.2 I believe) and since then, when tracking # is present, comment text doesn't get included in the email sent to the customer. The comment gets sent fine when there is no tracking # attached. Seems like a TPT problem, except it began after the EO upgrade, that's why I'm posting it here. Sadly, no error logs... (EO trace logs just list the products and OT values, but don't report any problem, either.)

I did make a huge mistake while upgrading and somehow TPT code flew out of the admin/orders.php file, however putting it back in didn't fix the problem. I checked and all of the other TPT and EO files are where they should be and have all the code they're supposed to have (unless I missed something, running on 2-3 hrs of sleep per day for the past week or so...).

Should I check all of my code again or is there a simpler answer to this issue? Any help will be much appreciated.
Thank you!
Magz :frusty:

---

You already posted the answer.. check your code.. You have borked the Ty Package Tracker code and that has NOTHING to do with Edit Orders..

Hi,

I've come across an error with the Edit Orders 4.1.4 module in that when clicking 'update' button an error message of:

WARNING: An Error occurred, please refresh the page and try again.

comes up and nothing is saved into the database. Edit orders module was installed with Admin New Order and Super Orders, which I understand are designed to work together and while the other 2 mods work okay, this one is throwing the error upon save.

I'm running ZC 1.5.1. Any ideas?

Regards,
dp

There will be an error log in your /logs directory. See what it says.

Hi,

The log comes out with the following:

============================================================
= Edit Orders (4.1.4) Action Log
============================================================
Order ID: 7616
Action Requested: update_order
Enabled Order Totals: ot_subtotal;ot_shipping;ot_coupon;ot_group_pricing;ot_tax;ot_gv;ot_total

Requested Products:
array (
8 =>
array (
'qty' => '1',
'name' => 'Bathroom Vanity Unit',
'onetime_charges' => '0.0000',
'attr' =>
array (
1 =>
array (
'value' => '46',
'type' => '0',
),
2 =>
array (
'value' => '51',
'type' => '0',
),
3 =>
array (
'value' => '55',
'type' => '0',
),
4 =>
array (
'value' => '60',
'type' => '0',
),
),
'model' => 'S502',
'tax' => '0',
'final_price' => '379.99',
),
)


============================================================
= Processing Requested Updates to Products
============================================================

Not sure what/where the error is within that output - I can only see that 'attr' doesn't have a value after it (I'm guessing here). I've tried using/not using the 'Mock Shopping Cart' and 'Strip Tags from Shipping' options within the EO 4 options to no avail either.

Regards,
dp

Quote:

---

Originally Posted by dp-web

Hi,

The log comes out with the following:

============================================================
= Edit Orders (4.1.4) Action Log
============================================================
Order ID: 7616
Action Requested: update_order
Enabled Order Totals: ot_subtotal;ot_shipping;ot_coupon;ot_group_pricing;ot_tax;ot_gv;ot_total

Requested Products:
array (
8 =>
array (
'qty' => '1',
'name' => 'Bathroom Vanity Unit',
'onetime_charges' => '0.0000',
'attr' =>
array (
1 =>
array (
'value' => '46',
'type' => '0',
),
2 =>
array (
'value' => '51',
'type' => '0',
),
3 =>
array (
'value' => '55',
'type' => '0',
),
4 =>
array (
'value' => '60',
'type' => '0',
),
),
'model' => 'S502',
'tax' => '0',
'final_price' => '379.99',
),
)


============================================================
= Processing Requested Updates to Products
============================================================

Not sure what/where the error is within that output - I can only see that 'attr' doesn't have a value after it (I'm guessing here).

Regards,
dp

---

That's not the log that was asked for. There should be/expected to be a debug log in your /logs folder off of the root of your store.

Quote:

---

Originally Posted by dp-web

Hi,

The log comes out with the following:

============================================================
= Edit Orders (4.1.4) Action Log
============================================================
Order ID: 7616
Action Requested: update_order
Enabled Order Totals: ot_subtotal;ot_shipping;ot_coupon;ot_group_pricing;ot_tax;ot_gv;ot_total

Requested Products:
array (
8 =>
array (
'qty' => '1',
'name' => 'Bathroom Vanity Unit',
'onetime_charges' => '0.0000',
'attr' =>
array (
1 =>
array (
'value' => '46',
'type' => '0',
),
2 =>
array (
'value' => '51',
'type' => '0',
),
3 =>
array (
'value' => '55',
'type' => '0',
),
4 =>
array (
'value' => '60',
'type' => '0',
),
),
'model' => 'S502',
'tax' => '0',
'final_price' => '379.99',
),
)


============================================================
= Processing Requested Updates to Products
============================================================

Not sure what/where the error is within that output - I can only see that 'attr' doesn't have a value after it (I'm guessing here).

Regards,
dp

---

That's not the log that was asked for. There should be/expected to be a debug log in your /logs folder off of the root of your store.

Sorry, I read the one from the /logs/edit_orders/ folder not the /logs/ folder.

This is the correct log:

[07-Mar-2014 13:27:30 UTC] PHP Fatal error: 1054:Unknown column 'p.products_quantity' in 'field list' :: SELECT `p`.`products_quantity` FROM `products` WHERE `p`.`products_id` = '531' in /home/mysite/public_html/includes/classes/db/mysql/query_factory.php on line 120

dp

Quote:

---

Originally Posted by dp-web

Hi,

The log comes out with the following:

============================================================
= Edit Orders (4.1.4) Action Log
============================================================
...

---

Just a reminder to turn off the Edit Orders "action debug log" for performance reasons.

Quote:

---

Originally Posted by dp-web

...
[07-Mar-2014 13:27:30 UTC] PHP Fatal error: 1054:Unknown column 'p.products_quantity' in 'field list' :: SELECT `p`.`products_quantity` FROM `products` WHERE `p`.`products_id` = '531' in /home/mysite/public_html/includes/classes/db/mysql/query_factory.php on line 120
..

---

This is a known bug in Edit Orders 4.1.4 when product downloads are disabled. The fix will be included in the next release of Edit Orders.