Store Cart Summary in Database Does Not

I seem to be having more than the usual issues with this eCart. I have just added the "Store Cart Summary in Database" SB to the confirm.php page but it simply will not add a record to the database. There are no errors displayed.

I have attached the confirm.php page in the hope that someone can point me in the right direction.

I don't see an obvious problem in the code. I'll need to look into the page on the server.

Jason, this is the same site I have had other issues with. It is not live as yet so it's a bit difficult to give you access to. If you could let me know which other pages you want to take a look at I will send them to you.

I dont see any issues in the code. Looking at the code will not help, I'll need to see the problem in order to troubleshoot.

Just out of curisority do you have your database connection include file above the store cart summary insertation? Reason why I ask is that I manually created an ecart using the invididual server behaviours rather then the wizards and found that if I add the server behaviours for "store cart summary in database" and "store cart details in database" it wont automatically add the database connection. After many tests I had to add the database connection manually.

Chris

Chris, the confirm page that Lee sent in he first message has the connection require once line at line 5. Good idea to check that though.

Jason, I have set up a test environment for you.

Details I will send privately.

Thanks.

I corrected the problem by editing the conform page at line 304:

i changed:
$_SESSION[$WA_sessionName] = mysql_insert_id();


to:
$_SESSION[$WA_sessionName] = mysql_insert_id($WA_connection);

I have a logged a bug for this issue, it seams on some servers, the connection used for the last insert is not assumed, so needs to be passed to the mysql_insert_id function.

Thanks Jason, WebAssist support at it's best.