Edit Orders v4.0 Support Thread

@ Ilhungil In the post right above yours I stated that I had figured this out.

I have figured out my question after a few hours of studying this. I was given bad information by a programer that charges. Imagine that!

Thank you for taking the time to look at it. I am stuck on v 3.X because I keep getting errors when I install V 4.X I have posted here but haven't received any luck resolving my issue. Apparently Rewards Points and Edit Orders 4.X Don't play nice and I don't have the knowledge yet to fix it. My last post on the problem was #451. But I am finally taking some classes to learn it.

Thank you again for looking at this.

southshorepizza:

... I am stuck on v 3.X ... Rewards Points and Edit Orders 4.X Don't play nice and I don't have the knowledge yet to fix it. ...
See post #450 in the Edit Orders 4.x Support Thread and post #2315 in the Reward Points Support Thread.

Making the changes listed in those threads should take care of the immediate problems loading the Reward Points Order Total modules from within the Zen Cart admin interface (and Edit Orders 4.1+).

Okay so I have done all of these things. I also have gone back in and found post 441-451 in this thread about my last attempt at the upgrade. I have the same results! :(

Log says
[28-Mar-2014 14:24:44] PHP Fatal error: Call to undefined function getrewardpoints() in /home4/w57dsjmm/public_html/order/includes/modules/order_total/ot_reward_points_display.php on line 40

however line 40 of said file is $reward_points=GetRewardPoints($order->products);

I feel as if this is ground hog day all over again!

southshorepizza:

Okay so I have done all of these things. I also have gone back in and found post 441-451 in this thread about my last attempt at the upgrade. I have the same results! :(

Log says
[28-Mar-2014 14:24:44] PHP Fatal error: Call to undefined function getrewardpoints() in /home4/w57dsjmm/public_html/order/includes/modules/order_total/ot_reward_points_display.php on line 40

however line 40 of said file is $reward_points=GetRewardPoints($order->products);

I feel as if this is ground hog day all over again!
And do you have a GetRewardPoints function in \admin\includes\functions\extra_functions\reward_points_functions.php. (case sensitivity counts..) You would copy over the one from the store side function file.. Saying you did what was suggested and still got an error doesn't provide enough info to determine why.. POST the changes you made to the admin functions file.. The error says you DON'T have the function in admin functions file.. might be best if you not only post the part you added but a couple of lines above and below it to make sure you didn't add e character that isn't supposed to be there.. (on the Rewards Points support thread of course :smile:)

I posted to the rewards site. Is this what is preventing edit orders 4.1.3 from working or do I have another issue as well? I have several domains. A public domain and a not advertised domain for our store to use for taking orders. Do you think I could uninstall the rewards module from the nonpublic domain and install edit orders 4.1.X and have it work there while the public domain is running the files for the rewards module? I don't give any points for orders our store takes. Only orders on the public site.

Thanks for your help!

So I have completely reinstalled via filezilla ftp Rewards points full suite and edited orders. I tried to edit an order and received the following error log
[29-Mar-2014 11:17:21] PHP Fatal error: 1054:Unknown column 'p.products_quantity' in 'field list' :: SELECT p.products_quantity FROM zen_products WHERE p.products_id = '8' in /home4/w57dsjmm/public_html/order/includes/classes/db/mysql/query_factory.php on line 120

Please help

southshorepizza:

...
[29-Mar-2014 11:17:21] PHP Fatal error: 1054:Unknown column 'p.products_quantity' in 'field list' :: SELECT p.products_quantity FROM zen_products WHERE p.products_id = '8' in /home4/w57dsjmm/public_html/order/includes/classes/db/mysql/query_factory.php on line 120
...
Same answer as the #446 and #460 in this thread.

Zencart 1.5.1

Getting a 404 page when clicking edit button. I have tried reinstalling and I get a upgrade OK green I have superorders along with ty tracker.

Any ideas

Thanks

remops:

... Getting a 404 page when clicking edit button. I have tried reinstalling and I get a upgrade OK green I have superorders along with ty tracker. ...
Usual cause is something not installed correctly (or a misconfiguration in "configure.php"). If you can supply more information we may be able to help determine what went wrong and how to fix things. The posting tips (found directly above where you typed "Your Message") provide some valuable knowledge on what information to provide when asking for help. In addition, answers to the following would go a long ways towards helping us help you.

Version of Edit Orders?
This can be found by logging into the Zen Cart administrative interface and selecting "Configuration" --> "Edit Orders".

Link causing 404?
This will be listed in the "address bar" of your web browser. For example: "https://zencart.local/admin/edit_orders.php?page=1&oID=12&action=edit".

Installation order (TPT, SO, and EO)?
Which did you install first? Which did you install second? Which did you install third?

Were any upgrades?
Were any of the modules previously installed? If so, what modules and versions?

When did the 404 start appearing?
After installation on a "clean" version of Zen Cart? An upgraded copy of Zen Cart? After updating one of the modules? Etc?

lhungil:

Usual cause is something not installed correctly (or a misconfiguration in "configure.php"). If you can supply more information we may be able to help determine what went wrong and how to fix things. The posting tips (found directly above where you typed "Your Message") provide some valuable knowledge on what information to provide when asking for help. In addition, answers to the following would go a long ways towards helping us help you.

Version of Edit Orders?
This can be found by logging into the Zen Cart administrative interface and selecting "Configuration" --> "Edit Orders".

version 4.1.4

Link causing 404?
This will be listed in the "address bar" of your web browser. For example: "https://zencart.local/admin/edit_orders.php?page=1&oID=12&action=edit".

/admin/FILENAME_ORDER_EDIT.php?page=1&oID=955&action=edit[/url]

I edited my admin name in this post

Installation order (TPT, SO, and EO)?
Which did you install first? Which did you install second? Which did you install third?

Actually this was working untill I had to restore from a earlier date.

Were any upgrades?
Were any of the modules previously installed? If so, what modules and versions?

I had all working together. Superoder had been working for a year or so then I updated and then installed Ty tracker and edit order in that order.

When did the 404 start appearing?
After installation on a "clean" version of Zen Cart? An upgraded copy of Zen Cart? After updating one of the modules? Etc?

I reinstall edit order and it started the 404 page. Thanks again for your quick reply

remops:

... "/admin/FILENAME_ORDER_EDIT.php?page=1&oID=955&action=edit" ...
This usually indicates either Ty Package Tracker or Super Orders was updated AFTER Edit Orders was installed. Another possibility would be the user PHP is running as (on your webserver) does not have permissions to write to "/admin/orders.php".

Please re-run the installer for Edit Orders (this will make the necessary changes to order.php).

NOTE: As per the readme, Edit Orders will automatically update the relevant files including "/admin/orders.php" when the installer is run. Among other things it replaces FILENAME_ORDER_EDIT with FILENAME_EDIT_ORDERS.

I get the confirmation

Found previous version installed. Upgrading (or re-installing) Edit Orders (old 4.1.4 => new 4.1.4).
Success Edit Orders installation / upgrade completed!

All looks good untill I click the edit button, then I still get the 404 page.

Thanks again

I tried to edit the address field in the customer address, billing address, and shipping address columns. I received a blank page after clicking update and the following log

PHP Fatal error:  Call to undefined function  validate_for_category() in 
admin/includes/functions/extra_functions/edit_orders_functions.php on line 331

I searched this thread for validate_for_category() but didn't get any results.

remops:

... I had all working together. Superoder had been working for a year or so then I updated and then installed Ty tracker and edit order in that order. ...
For some reason I missed this comment...

I'm guessing you overwrote the Super Orders version of "/admin/orders.php" with a copy from Ty Package Tracker. This means portions of the Super Orders plugin are probably broken. I would recommend re-installing / upgrading Super Orders.

Once everything with Ty Package Tracker and Super Orders is installed (and fully working), running the Edit Orders installer again should get you back up and running.

**NOTE 1: **Reading the README for Edit Orders, it states Ty Package Tracker and Super Orders should be installed PRIOR to Edit Orders... Reading the README for Super Orders, it states Ty Package Tracker should be installed PRIOR to installing Super Orders to avoid potential problems... So the correct order of installation to avoid issues would be Ty Package Tracker, Super Orders, Edit Order.

**NOTE 2: **As per the Edit Orders README, when using only Ty Package Tracker and Edit Orders (no Super Orders), one needs to manually merge the "/admin/orders.php" file from both (not automated by the installer). If using Super Orders and Ty Package Tracker, follow the installation instructions in Super Orders to install Super Orders before Edit Orders.

**NOTE 3: ** At the minimum, you need to replace "/admin/orders.php" with the copy from Super Orders. However, there may be other files from Super Orders (or Edit Orders) accidentally overwritten when Ty Package Tracker was installed AFTER Super Orders and Edit Orders... If issues persist, I'd recommend starting over and following the installation order listed in NOTE 1 (and of course consulting the README files).

Affected Users:
Those running Edit Orders 4.1 and using coupons with category or product restrictions.

Observed Behavior:
When an order contains a "coupon" with a restriction based on category or product the order cannot be edited (and generates a PHP error).

The Fix:
Add the following (in red) to "/admin/includes/functions/extra_functions/edit_orders_functions.php":

		return false; //should never get here
	}
}
if(!function_exists('validate_for_category')) {
	function validate_for_category($product_id, $coupon_id) {
		global $db;
		$retVal = 'none';
		$productCatPath = zen_get_product_path($product_id);
		$catPathArray = array_reverse(explode('_', $productCatPath));
		$sql = "SELECT count(*) AS total
            FROM " . TABLE_COUPON_RESTRICT . "
            WHERE category_id = -1
            AND coupon_restrict = 'Y'
            AND coupon_id = " . (int)$coupon_id . " LIMIT 1";
		$checkQuery = $db->execute($sql);
		foreach ($catPathArray as $catPath) {
			$sql = "SELECT * FROM " . TABLE_COUPON_RESTRICT . "
              WHERE category_id = " . (int)$catPath . "
              AND coupon_id = " . (int)$coupon_id;
			$result = $db->execute($sql);
			if ($result->recordCount() > 0 && $result->fields['coupon_restrict'] == 'N') return true;
			if ($result->recordCount() > 0 && $result->fields['coupon_restrict'] == 'Y') return false;
		}
		if ($checkQuery->fields['total'] > 0) {
			return false;
		} else {
			return 'none';
		}
	}
}
if(!function_exists('validate_for_product')) {
	function validate_for_product($product_id, $coupon_id) {
		global $db;
		$sql = "SELECT * FROM " . TABLE_COUPON_RESTRICT . "
            WHERE product_id = " . (int)$product_id . "
            AND coupon_id = " . (int)$coupon_id . " LIMIT 1";
		$result = $db->execute($sql);
		if ($result->recordCount() > 0) {
			if ($result->fields['coupon_restrict'] == 'N') return true;
			if ($result->fields['coupon_restrict'] == 'Y') return false;
		} else {
			return 'none';
		}
	}
}

// Start Edit Orders configuration functions
function eo_debug_action_level_list($level) {
```

**Reported By:**
Thank You to southshorepizza for finding this one!

lhungil:

For some reason I missed this comment...

I'm guessing you overwrote the Super Orders version of "/admin/orders.php" with a copy from Ty Package Tracker. This means portions of the Super Orders plugin are probably broken. I would recommend re-installing / upgrading Super Orders.

Once everything with Ty Package Tracker and Super Orders is installed (and fully working), running the Edit Orders installer again should get you back up and running.

**NOTE 1: **Reading the README for Edit Orders, it states Ty Package Tracker and Super Orders should be installed PRIOR to Edit Orders... Reading the README for Super Orders, it states Ty Package Tracker should be installed PRIOR to installing Super Orders to avoid potential problems... So the correct order of installation to avoid issues would be Ty Package Tracker, Super Orders, Edit Order.

**NOTE 2: **As per the Edit Orders README, when using only Ty Package Tracker and Edit Orders (no Super Orders), one needs to manually merge the "/admin/orders.php" file from both (not automated by the installer). If using Super Orders and Ty Package Tracker, follow the installation instructions in Super Orders to install Super Orders before Edit Orders.

**NOTE 3: ** At the minimum, you need to replace "/admin/orders.php" with the copy from Super Orders. However, there may be other files from Super Orders (or Edit Orders) accidentally overwritten when Ty Package Tracker was installed AFTER Super Orders and Edit Orders... If issues persist, I'd recommend starting over and following the installation order listed in NOTE 1 (and of course consulting the README files).

Installed the files and all is good! :laugh:

Thanks

remops:

Installed the files and all is good! :laugh:
Glad you were able to get everything sorted.

Thank you for fixing that bug!!

Unable to remove a quantity discount when editing an order. I have this http://www.zen-cart.com/downloads.php?do=file&id=135 module installed. When you edit an order the quantity discount down in the total doesn't have a text box for the amount. It does have a text box for the title "quantity discount". But without the text box I can't adjust the amount. The discount also doesn't change if you remove any products. But that would be okay if I could adjust the amount of the discount or remove it. Thanks for your help.

If I give something to a customer for free I cannot zero out the tax on an order.