eCart Confirm page - Unknown column error
Using eCart 4.5.2 with php and MySQL. When reaching my confirm.php the following error is reported on screen:
Unknown column 'TBB' in 'field list'
I have followed the comments in previous posts about this and belive this has to do with the code trying to post the information into the orderdetail table for a product SKU. All of my sku's start with TBB ("TBB-232305-2030"). The orders table is being updated but not the order details table and the error is displayed on the confirm page. I have CORRECTED the following mistakes that I had made:
1. orderdetail table - the column was set for a int(3) instead of varchar(50)
2. confirm server behavior to update corrected the SKU to TEXT (was numeric)
3. cleared browser values, exited session, closed and reopened browser
4. checked eCart Object - it was correct as it had selected the column from the products table, which was correctly set.
Where else can I check to correct this error??? Is there another place that the incorrect setting my be still set? Please help. Thank you.
Should the order data be posted to the tables before the customer accepts? The shipping values are being collected and intered into the orders table. When the customer clicks accept are they then directed to Authorize.Net to process the remote payment part?