Edit Orders v4.0 Support Thread

[southshorepizza]

What version of Zen Cart is installed? 1.5.1
What was the previously installed version of Edit Orders? V3.0
What version of Edit Orders are you trying to install (4.1.4 had not been approved yet)? 4.1.3
What messages did you receive during installation? Didn't see any messages However none of the links in the readme did anything so there really were no installation instructions. I just downloaded V4.0.3 and saw detailed instructions stating I should be logged into admin or I will miss it.
What is in the Zen Cart debug logs (and php / server error logs)? Zen Cart logs don't show anything from January 10th to current time. php/server logs in my cpanel not showing any errors
Can you enable TRACE debug in the Edit Orders configuration menu and attach the log? I did and it didn't generate any logs.

The only plug in I have that changes the core files is fast easy checkout. It changes my_admin/orders.php So that is the only one I have to merge.

I can say that after looking at the install for 4.0.3 I did upload that one overwriting the files for 4.1.3. I still get the same error message, no log files generated.

Perhaps I will check with hostgator and ask them if they have any error logs that are not shown in my cpanel error logs.

I am attaching my_admin/orders.php file that I attempted to merge with FEC. orders.php.zip

Thank you for taking the time to help me!

[DivaVocals]

However none of the links in the readme did anything so there really were no installation instructions.

The tabbed links in the readme WON'T work if you are attempting to view it from INSIDE the zip file.. You do need to UNZIP the file and extract the readme file to SEE it..

[southshorepizza]

I downloaded it on a mac. So it went into my download file as a folder and in my trash was a zip. So I assumed it was unzipped. Anyway I downloaded this morning on a pc unzipped and it looks completely different. Actually it looks very similar to V4.0.3 did on my mac last night. Perhaps the 4.1.3 didn't get zipped correctly or my mac didn't unzip it the same.

Anyway that still doesn't get me to the what didn't go right during the install. So I guess I will restore backup and try reinstalling again?

[lhungil]

... What messages did you receive during installation? Didn't see any messages ...
... However none of the links in the readme did anything so there really were no installation instructions. I just downloaded V4.0.3 and saw detailed instructions stating I should be logged into admin or I will miss it. ...

The instructions for 4.1.x are slightly different from 4.0.x. Please extract the Edit Orders 4.1.x distribution zip file to your hard drive and open /readme/index.html from the location you extracted the files. The readme is a webpage and links to other files / resources included in the distribution zip file.

I'd recommend after reading through the installation steps, performing each step - one at a time - to do a full re-install. During step 3 of the install, messages will be generated and displayed on the top of the admin interface.

... Zen Cart logs don't show anything from January 10th to current time. ... I (enabled TRACE debug) and it didn't generate any logs. ...

Please verify your configured Zen Cart "log" folder is writable.

If Edit Orders is completely installed (not just the files) and TRACE is enabled... Each and every access to "edit_orders" will create a log file. This includes just viewing the page. The log file will be found inside the Zen Cart log file location in a folder labeled "edit_orders" (/logs/edit_orders/).

Note: If Edit Orders 4.1.3+ is not fully installed or PHP (or the webserver) does not have access to write / create files and folders in the Zen Cart logs folder, enabling debug logging in Edit Orders will do nothing. Debug logging for Edit Orders should not be enabled unless one is actively troubleshooting an issue as it will cause a large number of log files to be created.

[southshorepizza]

So I reinstalled 4.1.3 following the instructions I see on my pc. Clicked on admin home as recommended.

Received the message:
Found previous version installed. Upgrading (or re-installing) Edit Orders (old 4.1.3 => new 4.1.3).
Edit Orders installation / upgrade completed!

Clicked on the last order. Choose edit. Tried to change from one shipping method to another in the drop down box. Clicked update and I get
WARNING: An Error occurred, please refresh the page and try again.
Clicking refresh gives me the same page.

Today I have success in generating three logs from the edit order folder:


============================================================
= Edit Orders (4.1.3) Action Log
============================================================
Order ID: 18908
Action Requested: edit
Enabled Order Totals: ot_subtotal;ot_shipping;ot_coupon;ot_group_pricing;ot_quantity_discount;ot_tax;o t_loworderfee;ot_gv;ot_reward_points;ot_cod_fee;ot_tip;ot_total;ot_reward_points _display


============================================================
= Edit Orders (4.1.3) Action Log
============================================================
Order ID: 18908
Action Requested: update_order
Enabled Order Totals: ot_subtotal;ot_shipping;ot_coupon;ot_group_pricing;ot_quantity_discount;ot_tax;o t_loworderfee;ot_gv;ot_reward_points;ot_cod_fee;ot_tip;ot_total;ot_reward_points _display

Requested Products:
array (
37930 =>
array (
'qty' => '1',
'name' => 'Hawaiian pizza',
'onetime_charges' => '0.0000',
'attr' =>
array (
37 =>
array (
'value' => '4698',
'type' => '0',
),
15 =>
array (
'value' => '1379',
'type' => '0',
),
14 =>
array (
'type' => '3',
),
22 =>
array (
'value' => '3454',
'type' => '0',
),
6 =>
array (
'type' => '3',
),
7 =>
array (
'type' => '3',
),
8 =>
array (
'type' => '3',
),
23 =>
array (
'value' => '',
'type' => '1',
),
),
'model' => '',
'tax' => '7',
'final_price' => '12.49',
),
)


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



============================================================
= Edit Orders (4.1.3) Action Log
============================================================
Order ID: 18908
Action Requested: update_order
Enabled Order Totals: ot_subtotal;ot_shipping;ot_coupon;ot_group_pricing;ot_quantity_discount;ot_tax;o t_loworderfee;ot_gv;ot_reward_points;ot_cod_fee;ot_tip;ot_total;ot_reward_points _display

Requested Products:
array (
37930 =>
array (
'qty' => '1',
'name' => 'Hawaiian pizza',
'onetime_charges' => '0.0000',
'attr' =>
array (
37 =>
array (
'value' => '4698',
'type' => '0',
),
15 =>
array (
'value' => '1379',
'type' => '0',
),
14 =>
array (
'type' => '3',
),
22 =>
array (
'value' => '3454',
'type' => '0',
),
6 =>
array (
'type' => '3',
),
7 =>
array (
'type' => '3',
),
8 =>
array (
'type' => '3',
),
23 =>
array (
'value' => '',
'type' => '1',
),
),
'model' => '',
'tax' => '7',
'final_price' => '12.49',
),
)


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

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


[29-Jan-2014 11:08:43] 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

It looks like the second was generated when I clicked refresh.
Product id=34 was the Hawaiian pizza. However the only thing I updated was the shipping module.

[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.