close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

eCart Confirm page - Unknown column error

Thread began 11/17/2009 5:12 pm by Kevin373660 | Last modified 11/18/2009 8:22 pm by Kevin373660 | 1477 views | 6 replies |

Kevin373660

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?

Sign in to reply to this post

Jason ByrnesWebAssist

Send a copy of your confirm page please so I can take a look at the code.

Sign in to reply to this post

Kevin373660

Attached is a copy of the confirm page. I removed sensitive account data with the note: [REMOVED FOR SECURITY IN THIS FILE COPY]. I have been correcting erorrs since 10:30pm last night and got this far. I am sure glad that you are willing to help.

Sign in to reply to this post

Jason ByrnesWebAssist

What is the value you are storeing in the cart ID column?





at line 211, change:

php:
$WA_editCmd = mysql_query($WA_sql, $WA_connection) or die(mysql_error());




to:

php:
$WA_editCmd = mysql_query($WA_sql, $WA_connection) or die(mysql_error()."<br />".$WA_sql);





this will show the sql that is being generated along with the error for trouble shooting.

Sign in to reply to this post

Kevin373660

The debug codes showed that I was trying to enter the SKU value in to the DetailProductID column. The Details page Add to Cart button had the table ID Column and binding for the ID set incorrectly. I have corrected and it adds to cart ok and is able to also reach the Confirm page. Your assistance is GREATLY APPRECIATED! Thank you.

Before I move onto: inserting the access codes in to their table, the remote payment processing, and email confirmation, there are two areas that I need to clean up.

1. The text at the bottom of the confirm page. Is there a thread with the English version of the text? I saw a comment on this before but could not find it.


*** ENTERED THIS NOTE IN ANOTHER THREAD RELATED TO THIS ISSUE ***
(It looks like others are having the same problem)
2. Most important Jimmy and I ran into a bug with the add to cart tool for the Resaults page (Ticket # 110136) if using remote payment processing with Authorize.Net. He had to remote in and came up with a workaround. It works adding all the information to the cart for a product when testing Local, however, now it does not work with Remote testing. He has closed the ticket and I can no longer open tickets or reopen them. Attached is the file and I can be reached by phone anytime if needed. It seams funny that it works Local but not Remote? Maybe their is another reason.

*******************************************************************

Sign in to reply to this post

Jason ByrnesWebAssist

1) Are you referring to the Latin place holder text? if so, that text should be replaced with your own text, if not, can you post the text5 you are referring to.



2) I reopened your ticket so jimmy can look into the problem further.

Sign in to reply to this post

Kevin373660

Thank you Jason.

1. Latin - I opted out of Latin classes to take computer science and typing. So I will just add my own good stuff.

2. Thank you for reopening the ticket. I have reuploaded the file to this post so that Jimmy does not have to wait for it. My phone number is in the ticket and I will be ready any time.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...