Edit Orders v4.0 Support Thread

[mendo1]

Hello. I'm having a problem installing edit orders. I downloaded the latest version 4.1.4. and my store is zc 1.5.0. I did a clean install last June and updated the database from 1.3.9 at that time. No issues with the store since then.
Server OS: LINUX .12.35 14186451
PHP version: 5.2.17 (ZEND: 2.20)
MySQL 5.5.40-36
HTTP Server: Apache
Add-ons: Image Handler 4_v4_0, ckeditor, backup_MySQL_plugin_v5

I followed the instructions in the read me and uploaded all the files under "modified core files" and "new files" and checked to see they were all there with the proper structure. I logged into the admin and then uploaded the install files. When I then go to the admin page and click on a link (admin home) I get a page that says "Warning An error occurred. Please refresh the page and try again". After that, I am stuck with that page and cannot get back into the admin. The only thing I can do at that point is delete files via ftp to access the admin again.

This is the debug code I am getting:
[CODE][28-Feb-2015 16:43:44] PHP Fatal error: 1146:Table 'mendo11d_organic1. configuration' doesn't exist :: SELECT `configuration_value` FROM ` configuration` WHERE `configuration_key` = 'EO_VERSION' in /home4/mendo11d/public_html/includes/classes/db/mysql/query_factory.php on line 101 [\COD]

Seems like it might be something with the database.
I can post more details if needed. Any help would be greatly appreciated.

[lhungil]

Check your "/admin/includes/configure.php" file. In particular check DB_PREFIX to see if it contains a space (should not contain any spaces).

[mendo1]

Check your "/admin/includes/configure.php" file. In particular check DB_PREFIX to see if it contains a space (should not contain any spaces).

Hi. Thank you for the quick response. Here is what I have in admin/includes/configure.php :
define('DB_PREFIX', ' ');

[mc12345678]

Hi. Thank you for the quick response. Here is what I have in admin/includes/configure.php :
define('DB_PREFIX', ' ');

And so when the space (space only) is removed to have:

define('DB_PREFIX', '');

Is the problem resolved?

[mendo1]

That absolutely did the trick! Edit orders seems to be working fine now. What one little space in the wrong place can do. Thanks very much everyone!

[abcisme]

When I click to update the order after editing, I get a blank page.

Logs say:

[09-Mar-2015 12:26:48] [09-Mar-2015 12:37:45] PHP Fatal error:  Call to undefined function  validate_for_category() in /home/sjenkins/public_html/shop/saffire_admin/includes/functions/extra_functions/edit_orders_functions.php on line 331

Here's what is in that section:

		$allow_for_category = validate_for_category($product_id, $coupon_id);
		$allow_for_product = validate_for_product($product_id, $coupon_id);
		//    echo '#'.$product_id . '#' . $allow_for_category;
		//    echo '#'.$product_id . '#' . $allow_for_product;
		if ($allow_for_category == 'none') {
			if ($allow_for_product === 'none') return true;
			if ($allow_for_product === true) return true;
			if ($allow_for_product === false) return false;
		}
		if ($allow_for_category === true) {
			if ($allow_for_product === 'none') return true;
			if ($allow_for_product === true) return true;
			if ($allow_for_product === false) return false;
		}
		if ($allow_for_category === false) {
			if ($allow_for_product === 'none') return false;
			if ($allow_for_product === true) return true;
			if ($allow_for_product === false) return false;
		}
		return false; //should never get here
	}
}

Any ideas?

[abcisme]

Sorry, found my answer: http://www.zen-cart.com/showthread.p...79#post1242779

When I click to update the order after editing, I get a blank page.

Logs say:

[09-Mar-2015 12:26:48] [09-Mar-2015 12:37:45] PHP Fatal error:  Call to undefined function  validate_for_category() in /home/sjenkins/public_html/shop/saffire_admin/includes/functions/extra_functions/edit_orders_functions.php on line 331

Here's what is in that section:

		$allow_for_category = validate_for_category($product_id, $coupon_id);
		$allow_for_product = validate_for_product($product_id, $coupon_id);
		//    echo '#'.$product_id . '#' . $allow_for_category;
		//    echo '#'.$product_id . '#' . $allow_for_product;
		if ($allow_for_category == 'none') {
			if ($allow_for_product === 'none') return true;
			if ($allow_for_product === true) return true;
			if ($allow_for_product === false) return false;
		}
		if ($allow_for_category === true) {
			if ($allow_for_product === 'none') return true;
			if ($allow_for_product === true) return true;
			if ($allow_for_product === false) return false;
		}
		if ($allow_for_category === false) {
			if ($allow_for_product === 'none') return false;
			if ($allow_for_product === true) return true;
			if ($allow_for_product === false) return false;
		}
		return false; //should never get here
	}
}

Any ideas?

[abcisme]

ZC 1.5.3
EO 4.1.4
SO 4.0.5

Tax doesn't seem to be recalculating at all. I've tried clicking update.. I've tried just hitting enter. Tax never adjusts.

100 ## Sub-Total ot_subtotal
102 ## Discount Coupon ot_coupon
103 ## Group Discount ot_group_pricing
200 ## Shipping ot_shipping
291 ## Combination Discounts ot_combination_discounts
292 ## Combination Discount ot_better_together
299 ## Signature Upon Delivery ot_insurance
300 ## Tax ot_tax
312 ## Gift Certificates ot_gv
999 ## Total ot_total

[abcisme]

We are experiencing this same situation as carlwhat.

Tax is being deleted from some orders and the tax is not being recalculated on others.. Would love to know if we have something installed in common.

first off, i want to say that this module is shareware... i never paid for it, so the idea that we can make demands on the developer seems a bit lame to me...

i stand by my previous comment about deleting and re-adding items in the orders products table. no developer can for-see everything going on in other users implementations. but as i said previously i do not agree with that decision.

with the comments above, i am experiencing the same situation. i have ot_tax records from the orders_total table getting deleted; and adding products after a coupon has already been established does not re-calculate the coupon value nor does it accurately recalculate the tax.

i have yet to really dig into these issues, but i no doubt will. i'm sure there were reasons why this module was designed the way that it is, but unfortunately for me, there are SO many problems that i have a difficult time with recommending it. perhaps i will find an easy fix, but TAX not getting calculated correctly? discount coupons that do not update when you add new products?

i know editing an order affects a number of different tables, but frankly i'm really at a loss on this code. and i do not remember this level of problems with the super-orders module; but hey that was a long time ago when i implemented that.

[abcisme]

So far what I've come up with is that is has to do with the settings of ot_coupon and ot_group_pricing. Is there some specific setting that these should use?

Here's what I have for settings:

Discount Coupon

This module is installed
true

Sort Order
102

Include Shipping
false

Include Tax
false

Re-calculate Tax
Standard

Tax Class
--none--

Group Discount

This module is installed
true

Sort Order
103

Include Shipping
false

Include Tax
false

Re-calculate Tax
Standard

Tax Class
--none--



My order totals are incorrect when trying to edit the order:

Sub-Total: CDN $64.91
$10 Coupon: -CDN $10.00
3% Discount - 3%: -CDN $1.69 (Should be $1.65 [$64.91 - $10 coupon = $54.91 * .03 = $1.65])
Shipping: $12.11
13% Tax (ON): CDN $8.50 (includes tax on shipping)
Total: CDN $74.88 (Should be $73.87.. no idea where it is getting $74.88, since the numbers it's giving me add up to $73.83??)

Any help would be greatly appreciated.