Intermittent database error

After entering their name and shipping information (most fields are required), the data is posted to mysql. about 33% of the time it will post blank fields to the order table even those marked not null.

I have tried pconnect and connect with no change.

Thanks

please send a copy of the page that does the insert

Originally Said By: Jason Byrnes

  please send a copy of the page that does the insert  

how do I submit the page?

the link is checkout.php

compress the php file into a zip archive and attach the zip file to your reply.

thanks here is the file

when the checkout page posts the info to the confirm page, the info is stored in session variables, then the session variables are used in the store order summary behavior.


the only way I can see it inserting blank data is if the session is not being set properly.


try adding the following code at line 1:

<?php @session_start(); ?>

is this a problem that you can reproduce? to be able to troubleshoot what is wrong, we will need to know what steps are happening to cause the problem. intermittent issues that cannot be faithfully reproduced are about impossible to fix