orders_total table not updating - no error messages

[petercbk]

I have studied the many contributions relating to this problem and have made the recommended changes. These are:

 

- Changed to max($offset, 0) in both split_page_results.php files,

- included in configure.php the following:

define('DIR_FS_CATALOG', '/usr/home/emgeea/public_html/catalog');

define('DIR_FS_DOCUMENT_ROOT', '/usr/home/emgeea/public_html/catalog');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');

define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');

- updated the files in includes/modules/order_total

 

But the problem persists.

 

The osCommerce site has been running well for 2 years. Recently MySql was upgraded to 4.1.12 and since then when an order is placed the tables:

orders

orders_products

orders_status_history

are updated correctly, but there is no record in orders_total.

 

As a result, in Admin, the order does not appear in the orders list or for the client's orders. If I manually add the required records to orders_total, the orders show correctly in Admin.

 

There are NO error messages for the user or Admin.

 

I can add records to the table using sql queries in a simple php page.

 

Can anyone point me to where a solution might be.

 

With thanks

[petercbk]

Solved the problem, see http://www.oscommerce.com/forums/index.php?showtopic=125432

 

Thanks to warrenthewindmill