1 reply to this topic

[calmahomer]

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

[wazu]

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