Order History & Shopping Cart always full after order

[smartboyinuk]

Hi,

 

I had managed to customise the OSC a lot and removed lots of things. But it showed strange behaviour recently. I was planning to get the shop online - but the order history was not showing in the admin. After going through lots of posts here i enabled the show all errors option in aplication_top.php. I get lots of errors as below.

 

Can somebody help? The shop is at http://www.maisoncollection.com/catalog/default.php

 

Warning: Use of undefined constant STORE_DB_TRANSACTIONS - assumed 'STORE_DB_TRANSACTIONS' in (MyServerPath)/catalog/includes/functions/database.php on line 40

 

Warning: Use of undefined constant STORE_DB_TRANSACTIONS - assumed 'STORE_DB_TRANSACTIONS' in (MyServerPath)/catalog/includes/functions/database.php on line 46

 

Warning: Undefined index: osCsid in (MyServerPath)/catalog/includes/application_top.php on line 200

 

Warning: Cannot send session cache limiter - headers already sent (output started at (MyServerPath)/catalog/includes/functions/database.php:40) in (MyServerPath)/catalog/includes/functions/sessions.php on line 67

 

Warning: Undefined index: language in (MyServerPath)/catalog/includes/application_top.php on line 233

 

Warning: Undefined index: currency in (MyServerPath)/catalog/includes/application_top.php on line 256

 

Warning: Undefined index: HTTPS in (MyServerPath)/catalog/includes/classes/navigation_history.php on line 62

 

Warning: Undefined index: action in (MyServerPath)/catalog/includes/application_top.php on line 281

 

Warning: Undefined index: cPath in (MyServerPath)/catalog/includes/application_top.php on line 405

 

Warning: Undefined index: products_id in (MyServerPath)/catalog/includes/application_top.php on line 407

 

Warning: Undefined index: manufacturers_id in (MyServerPath)/catalog/includes/application_top.php on line 432

 

Warning: Undefined index: products_id in (MyServerPath)/catalog/includes/application_top.php on line 438

 

Warning: Undefined index: manufacturers_id in (MyServerPath)/catalog/includes/languages/english/default.php on line 18

[mattice]

In catalog/includes/configure.php you have an error where it says

define('STORE_DB_TRANSACTIONS' ....

 

should be:

 

define('STORE_DB_TRANSACTIONS', 'false');

 

 

At least, that is what is causing the first error. The rest might be a result of that.

 

HTH

Mattice

[smartboyinuk]

Thank you for your reply Mattice,

 

But I dont seem to have this line in configure.php file.

 

My shopping cart and secure trading payment provider is in demo mode.

The biggest problem I am facing is that the Order History is not updated once a successful transaction has taken place. The shopping cart still shows all the products even after the checkout has taken place. :(

[mattice]

duh. I should read posts better before answering them.

The rest of your errors are actual errors and not caused by the first one (well the cannot.. headersalready sent ARE, so don't look at them)

 

I turned on error reporting to fullblown on my catalog here and got similar results... but looking for the STORE_DB_TRANSACTIONS I could not locate the define anywhere at all? Turns out it is an Admin setting (under My Store -> Logging) It seems its value is not yet known when the functions in database.php are loaded.... Sloppy coding? ;)

[smartboyinuk]

Thanks again Mattice,

 

Would you know why the orders are not being entered into the database after successful completion ?

[mattice]

That can be due to a lot of things... I know the actual 'writing' to the db takes place in checkout_process.php so I'd start there.

Just see if you can simply 'echo' before the tep_db_query(INSERT stuff. That will tell you if the things that are going to be written to the db exist at that point for starters.

[smartboyinuk]

Mattice,

 

I discovered that the osCsid parameter is not being passed on to the securetrading servers. Hence I need to see where the Osc script is playing up and on which page - because on the form page -i can see the osCsid value to be null.

 

Will investigate and post here.

[smartboyinuk]

Problem sorted.

 

Refer: http://www.oscommerce.com/forums/viewtopic.php...9738&highlight=