Edit Orders v4.0 Support Thread

DML73:

Ok I removed Super Orders 4.0.4. I removed it instead of upgrading just to be sure everything is removed. Then I installed Super Orders 4.0.9 and it installed and works without errors or problems. ...
And what if anything did you do with Edit Orders? Did you leave everything as-is? Did you run the uninstall? Did you remove the files? Did you remove the database entries?

DML73:

... As far as I can see then init_eo_remove.php is not a part of the Edit Orders module...
It is part of the distribution zip related to uninstallation of Edit Orders.

DML73:

... What can I do to solve the problem ? :blink:
Is this on a production website (or a test website)?
Do you have a backup from before you started the upgrade (step 0)?
Are you leaving "extra" backup copies of PHP files on the web server?
Where do you store your backups?
How are you uploading files to the web server?
What version of Zen Cart and PHP are installed?
Was Zen Cart or PHP upgraded from a previous version (if so how were they upgraded)?
What web server software is the hosting provider running (Apache, IIS, Nginx, etc)?
Is the hosting provider using APC, eAccelerator, or Xcache?
Did you re-perform step #0, #1, and #2 of the Edit Orders installation (before step #3: Install)?

Hi All,

I want to know, if I want to install both Edit Order 4.x and Super Order 3.x, actually, install which one first? Or do they have the relationship which one must first, which one must after?

Since see the files both have some override ...

Thank you.

Best Regards,
Jimmy Chan
http://www.jimmychan.tk
http://explorerhome.no-ip.org/blog

explorer1979:

Hi All,

I want to know, if I want to install both Edit Order 4.x and Super Order 3.x, actually, install which one first? Or do they have the relationship which one must first, which one must after?

Since see the files both have some override ...

Thank you.

Best Regards,
Jimmy Chan
http://www.jimmychan.tk
http://explorerhome.no-ip.org/blog

It actually does not matter which you install first. As always, make a backup first, and install on a test site to see if it works accordingly. I seen far too many cases that have not done those 2 simple things. Just take care when merging the core files, especially when the same file affects both mods.

When I'm in the edit order screen I have this highlighted in red at the top of the screen:
WARNING_ORDER_TOTAL_SUBTOTAL

my admin debug file says:
[21-Jul-2014 21:53:45 UTC] PHP Warning: include_once(includes/modules/shipping/table.php): failed to open stream: No such file or directory in /home/mz/public_html/shop/includes/classes/shipping.php on line 58
[21-Jul-2014 21:53:45 UTC] PHP Warning: include_once(): Failed opening 'includes/modules/shipping/table.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mz/public_html/shop/includes/classes/shipping.php on line 58
[21-Jul-2014 21:53:45 UTC] PHP Fatal error: Class 'table' not found in /home/mz/public_html/shop/includes/classes/shipping.php on line 59

But these errors are only generated by edit orders. I don't recieve these errors when looking at the shipping modules in admin or as an error in regular debug files.

lhungil:

And what if anything did you do with Edit Orders? Did you leave everything as-is? Did you run the uninstall? Did you remove the files? Did you remove the database entries?

It is part of the distribution zip related to uninstallation of Edit Orders.

Is this on a production website (or a test website)?
Do you have a backup from before you started the upgrade (step 0)?
Are you leaving "extra" backup copies of PHP files on the web server?
Where do you store your backups?
How are you uploading files to the web server?
What version of Zen Cart and PHP are installed?
Was Zen Cart or PHP upgraded from a previous version (if so how were they upgraded)?
What web server software is the hosting provider running (Apache, IIS, Nginx, etc)?
Is the hosting provider using APC, eAccelerator, or Xcache?
Did you re-perform step #0, #1, and #2 of the Edit Orders installation (before step #3: Install)?

Thanks a lot, your reply made me start thinking :blush:

I kept getting errors no matter what I did, so I decided to revert back to zero and then uninstall both Edit Orders 404 and Super Orders 404. While I was uninstalling I found some old Super Orders files which I believe I forgot to uninstall earlier. I then first installed Edit Orders 414 and then Super Orders 409 and now its finally working :jump:

explorer1979:

Hi All,

I want to know, if I want to install both Edit Order 4.x and Super Order 3.x, actually, install which one first? Or do they have the relationship which one must first, which one must after?

Since see the files both have some override ...

Thank you.

Best Regards,
Jimmy Chan
http://www.jimmychan.tk
http://explorerhome.no-ip.org/blog

yaritai:

It actually does not matter which you install first. As always, make a backup first, and install on a test site to see if it works accordingly. I seen far too many cases that have not done those 2 simple things. Just take care when merging the core files, especially when the same file affects both mods.

It is suggested that if installing BOTH the order you install doesn't matter, but HOW you approach the installing does..

If you install Super Orders AFTER Edit Orders, you can simply replace the orders.php file with the one from Super Orders (no merging required unless you have other modifications to this file). Though is is suggested if Super Orders is installed after Edit Orders that the Edit Orders "install" step should be run again, current versions of Super Orders makes that step unnecessary.

If you already have Super Orders installed you DO NOT need to upload the orders.php file from Edit Orders. Though the Edit Orders "install" step could be run again, current versions of Super Orders probably makes that step unnecessary.

**DivaVocals**, and yaritai,

Thank you very much of this detail inform. Very useful for me :-)

Best Regards,
Jimmy Chan
http://www.jimmychan.tk
http://explorerhome.no-ip.org/blog

BGundlach:

When I'm in the edit order screen I have this highlighted in red at the top of the screen:
WARNING_ORDER_TOTAL_SUBTOTAL
...
This indicates you either have the Zen Cart "order total modules" system disabled or do not have the subtotal (ot_subtotal) order total module enabled. The order total system needs to be enabled (and both ot_subtotal and ot_total enabled at the minimum) for Edit Orders 4.1+ to operate.

Thank You for the reminder I still need to add some language for WARNING_ORDER_TOTAL_SUBTOTAL and WARNING_ORDER_TOTAL_TOTAL.

BGundlach:

...
my admin debug file says:
[21-Jul-2014 21:53:45 UTC] PHP Warning: include_once(includes/modules/shipping/table.php): failed to open stream: No such file or directory in /home/mz/public_html/shop/includes/classes/shipping.php on line 58
[21-Jul-2014 21:53:45 UTC] PHP Warning: include_once(): Failed opening 'includes/modules/shipping/table.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mz/public_html/shop/includes/classes/shipping.php on line 58
[21-Jul-2014 21:53:45 UTC] PHP Fatal error: Class 'table' not found in /home/mz/public_html/shop/includes/classes/shipping.php on line 59
... But these errors are only generated by edit orders. I don't recieve these errors when looking at the shipping modules in admin or as an error in regular debug files. ...
This can happen if "/includes/classes/shipping.php" has not been correctly merged to load the module from the correct location (I'm not seeing any value for DIR_FS_CATALOG prepended to the filename). The usual fix is to redo the installation of Edit Orders, paying especially close attention when merging changes to core Zen Cart files.

DML73:

... now its finally working :jump:
:clap: Glad you are back in business!

Thank You for letting us know a removal and re-installation of Super Orders and Edit Orders solved the issues your store was experiencing.

DivaVocals:

... If you install Super Orders AFTER Edit Orders, you can simply replace the orders.php file with the one from Super Orders (no merging required unless you have other modifications to this file). Though is is suggested if Super Orders is installed after Edit Orders that the Edit Orders "install" step should be run again, current versions of Super Orders makes that step unnecessary.

If you already have Super Orders installed you DO NOT need to upload the orders.php file from Edit Orders. Though the Edit Orders "install" step could be run again, current versions of Super Orders probably makes that step unnecessary.
...
Correct (and nicely summarized). Just to clarify: You do need to run the Edit Orders installer after installing / upgrading Edit Orders. Does not matter if Super Orders is or is not installed.

If Edit Orders 4.1+ is installed first:

• Overwrite "/admin/orders.php" with the version from Super Orders.
• Finish the installation of Super Orders.
• If Super Orders <= 4.0.5 was installed, run the Edit Orders installer.

If Super Orders 4.0+ is installed first:

• Do not overwrite (or merge) "/admin/orders.php" with the version from Edit Orders.
• Run the Edit Orders installer (when that step of the installation is reached).

Note: Running the Edit Orders installer after installing Super Orders >= 4.0.6 will not cause any issues. So no need to fret too much one way or the other.

**lhungil**,

Thank you of this additional inform with version number. This very helpful too.

FYI, I had to manually create folders and move the readme files around to get the installation instructions to work. The /readme/ folder and subfolders didn't exist in other words. It was just the files with the path enclosed in the file name, if that makes any sense. :) I've unzipped a bunch of plugins this evening and this one was the only one that I had to do this with. Someone might want to give the ZIP file a look to make sure all is hunky-dory. :)

laurelsstitchery:

FYI, I had to manually create folders and move the readme files around to get the installation instructions to work. The /readme/ folder and subfolders didn't exist in other words. It was just the files with the path enclosed in the file name, if that makes any sense. :) I've unzipped a bunch of plugins this evening and this one was the only one that I had to do this with. Someone might want to give the ZIP file a look to make sure all is hunky-dory. :)
I have no issues with unzipping the files to access the readme..

OK, I need some help, and I am not sure if this is the correct spot.
I have upgraded to v1.5.3

when i install your module to complete.
then go to order => edit => update

i get "WARNING: An error occurred, please refresh the page and try again." when I try to look at the order in the admin.

Help what am I doing wrong or missing.

I use zen 1.5.3

Thanks

When you receive the message "Warning an error occurred ...", there's a debug log in your store's /logs directory that identifies the source of the issue. You can post that here (make sure to XXXX-out your admin directory's name first!) to get some further help.

I've got Edit Orders v4.1.4 happily installed on Zen Cart v1.5.3, so it's got to be something in your setup.

lat9:

When you receive the message "Warning an error occurred ...", there's a debug log in your store's /logs directory that identifies the source of the issue. You can post that here (make sure to XXXX-out your admin directory's name first!) to get some further help.

I've got Edit Orders v4.1.4 happily installed on Zen Cart v1.5.3, so it's got to be something in your setup.

this is the message :

PHP Fatal error: 1054:Unknown column 'p.products_quantity' in 'field list' :: SELECT p.products_quantity FROM zen_products WHERE p.products_id = '1069' ==> (as called by) /home/store/public_html/admin/includes/functions/extra_functions/edit_orders_functions.php on line 1028 <== in /home/store/public_html/includes/classes/db/mysql/query_factory.php on line 155

lhungil:

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.

iqbal007:

this is the message :

PHP Fatal error: 1054:Unknown column 'p.products_quantity' in 'field list' :: SELECT p.products_quantity FROM zen_products WHERE p.products_id = '1069' ==> (as called by) /home/store/public_html/admin/includes/functions/extra_functions/edit_orders_functions.php on line 1028 <== in /home/store/public_html/includes/classes/db/mysql/query_factory.php on line 155
That's a known issue. See the quoted correction.

lat9:

That's a known issue. See the quoted correction.

wow this works bro. thanks for your help :D

iqbal007:

wow this works bro. thanks for your help :D
That "bro" is a LADY.. a "sheila" as the Aussies would say.. :smile:

DivaVocals:

That "bro" is a LADY.. a "sheila" as the Aussies would say.. :smile:

uupss :P