THE UNKNOWN COLUMN IS THE ItemName column which is the NAME column in the eCart and it appears to be an error in the OrderDetails DB since it is not added to the OrderSummary, AFAIK...
Okay, I switched the DetailsID in the DB from integer to varchar... but that did not solve it. Same error... In the server behavior, it was set to int, BUT the binding was to a varchar... so i switched both the DetailsId in the DB and in the cart Details to text/varchar... It did not fix the problem though...
Now, it appears to me that many of my problems are stemming from the add to cart button where I set the bindings for the eCart objects like ID and Name to specific fields in the DB, and if they don't match type, I get these errors.
So, the bindings in the Add to Cart button are for:
Cart's ID to <?php echo $row_Rings['ItemName']; ?> which is a varchar in my DB
I would think that normally the DetailsID would be an auto assigned incremental integer in the db, but is must be dynamically assigned in the Cart Details Database. So If I assign it to <?php echo $LhunterCart->DisplayInfo("ID"); ?> it is picking up the ID from the Cart which is the ItemName varchar, so I changed the DB to match.
I assigned the DetailOrderID to the session ID
That means the Order ID is the unique key and not the detailsID ? Yes? And the DetailsID would be duplicated every time someone orders the same item...
To what value would you normally assign the Details ID and how is to properly linked to the order summary? My next step will be to set up the admin to review orders and I want to make sure they can see both the ordersummary and the details..
However, I cannot get the details to store. I'm on the confirm page with this column error.
ALSO>>>> IT APPEARS THAT IT MAY BE PROCESSING THE ORDER 2 times!!!! Because I'm getting 2 receipts for every single press of the submit cart button! Could it possibly be processing it 2 times?