Jump to content
Sign in to follow this  
calmahomer

Order Total Modules selections not updating

Recommended Posts

I've been having a lot of trouble changing the Order Total Modules.

 

Although it appears that they are being installed in the admin section, the field in the configuration table is not automatically being updated, e.g.

 

On install, the following SQLstatement is run (install/oscommerce.sql - line 737):

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Installed Modules', 'MODULE_ORDER_TOTAL_INSTALLED', 'ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php', 'List of order_total module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php)', '6', '0', now());

- This installs Sub-Total, Tax, Shipping & Total

 

However, to get any additional order total modules to install and work correctly (e.g. Low Order Fee), I have to manually update this row, as below:

 

UPDATE `configuration` SET `configuration_value` = 'ot_loworderfee.php;ot_subtotal.php;ot_shipping.php;ot_tax.php;ot_total.php',
`use_function` = NULL ,
`set_function` = NULL WHERE `configuration_id` = '68' LIMIT 1;

 

The ordering of the modules on the checkout_confirmation.php page also appears to take the order of the filenames above (ot_loworderfee.php;ot_subtotal.php;ot_shipping.php;ot_tax.php;ot_total.php) rather than the order specified in the admin section.

 

Has anyone else come across this, is it a bug or alternatively what do you think I am doing wrong here?

 

Kind Regards

David

Share this post


Link to post
Share on other sites

After comparing your post to a few of our stores, it appears you are missing some tables (you have 7) here are the 11 we have:

 insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

 

Hope this helps

wazu :thumbsup:

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×