Product Orders Not Showing in Admin Section

[captgary]

I'm using 2.3.1 and have installed QTPro and Attribute add-ons. Just recently discovered that customer orders are showing on admin->customers->orders but only the price not the actual product that was sold. This occurs also on the customers history page. They can't see what product has been ordered.

Further investigation indicates the orders_products table is not being updated.

 

Anyone have any idea what I did wrong with the two add-ons?

 

Thanks,

Capt Gary

[web-project]

1) you need to check if the order is recorded into mysql table

2) check the error logs

[Guest]

Gary,

 

Check the code edits made to the /admin/orders.php and admin/includes/classes/order.php

 

 

 

 

Chris

[captgary]

Thanks all....I'll take a look and report back. IN UK thru the end of the week and will check upon my return.

 

Really appreciate all the clues.

 

Gary

[captgary]

OK...found the error. It was occurring in checkout_process.php file.

 

Here's what the piece of code looked like and was causing the error.

 

//++++ QT Pro: End Changed Code tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);

$order_products_id = tep_db_insert_id();

 

Changed to........................

 

//++++ QT Pro: End Changed Code

tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);

$order_products_id = tep_db_insert_id();

 

Don't know what the one line got to the above commented out like, but it works fine now.

 

Thanks for everyone's suggestions and help

 

Capt Gary