Edit Orders v4.0 Support Thread

[lhungil]

...
From my regular log file:
[29-Jan-2014 11:07:44] PHP Fatal error: 1054:Unknown column 'p.products_quantity' in 'field list' :: SELECT `p`.`products_quantity` FROM `zen_products` WHERE `p`.`products_id` = '34' in /home4/w57dsjmm/public_html/d132s/includes/classes/db/mysql/query_factory.php on line 120
...

Verified Bug.

Edit "/admin/includes/functions/extra_functions/edit_orders_functions.php". Around line 1025 change:

				$check = $db->Execute(
					'SELECT `p`.`products_quantity` FROM `' . TABLE_PRODUCTS . '` ' .
				 	'WHERE `p`.`products_id` = \'' . (int)$query->fields['products_id'] . '\''
				);

to read:

				$check = $db->Execute(
					'SELECT `p`.`products_quantity` FROM `' . TABLE_PRODUCTS . '` AS `p` ' .
				 	'WHERE `p`.`products_id` = \'' . (int)$query->fields['products_id'] . '\''
				);

Please let me know if this solves the problem.

[southshorepizza]

In /public_html/d132s/admin_folder/includes/functions/extra_functions/edit_orders_functions.php

I searched for your text. There was one result found. I changed it to read

$check = $db->Execute(
					'SELECT `p`.`products_quantity` FROM `' . TABLE_PRODUCTS . '` AS `P` ' .
				 	'WHERE `p`.`products_id` = \'' . (int)$query->fields['products_id'] . '\''
				);

Saved then tried to edit order. I clicked update and just got a completely blank page.


I now have this in my log file:
[29-Jan-2014 12:16:20] PHP Fatal error: 1054:Unknown column 'p.products_quantity' in 'field list' :: SELECT `p`.`products_quantity` FROM `zen_products` AS `P` WHERE `p`.`products_id` = '164' in /home4/w57dsjmm/public_html/d132s/includes/classes/db/mysql/query_factory.php on line 120

[lhungil]

...
[29-Jan-2014 12:16:20] PHP Fatal error: 1054:Unknown column 'p.products_quantity' in 'field list' :: SELECT `p`.`products_quantity` FROM `zen_products` AS `P` WHERE `p`.`products_id` = '164' in /home4/w57dsjmm/public_html/d132s/includes/classes/db/mysql/query_factory.php on line 120

Case sensitivity matters. The `P` needs to be `p` (lowercase).

[southshorepizza]

Code now looks like

			else {
				$check = $db->Execute(
					'SELECT `p`.`products_quantity` FROM `' . TABLE_PRODUCTS . '` AS `p` ' .
				 	'WHERE `p`.`products_id` = \'' . (int)$query->fields['products_id'] . '\''
				);
			}

I still get a blank page and log states.
[29-Jan-2014 12:59:41] 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

[lhungil]

I ... get a blank page and log states.
[29-Jan-2014 12:59:41] 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

This is caused by another "add-on" you have installed. A quick search of the "Edit Orders" thread and the Zen Cart forums reveals: Bugfix for "Reward Points Module" to allow the reward points order total modules to be loaded from the admin side of Zen Cart.

[southshorepizza]

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.