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. Attachment #13720

Thank you for taking the time to help me!

southshorepizza:

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

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?

southshorepizza:

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

southshorepizza:

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

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;ot_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;ot_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;ot_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.

southshorepizza:

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

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

southshorepizza:

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

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

southshorepizza:

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.

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:

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

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.

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

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.

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.