Home » Forums » Ubercart » Support

Checkout

Submitted by Dale Vogel on Sat, 03/29/2008 - 20:03
Dale Vogel
Posts: 37
 Joined: 09/30/2007

I need some help on this one. When I go to review my order, I get the below warning errors that prevents checkout. This is Ubercart Alpha 7. So first question: Will an upgrade to Beta 2 uncorrupt the database?

I'm not sure where to look to find this problem. Symptoms are: The credit card barber poll continues to animate on the checkout page, but no credit card entry form comes up, so you can not enter your credit card information if you wanted to.

Here's the error message: the "xxxxx's," I put in to take out my detailed buyer info. By the way, there is no line 172 in ..../database.mysql.inc
=====================================================================

* user warning: Column count doesn't match value count at row 1 query: INSERT INTO uc_orders VALUES (47, 2, 'in_checkout', 0, 'dale@refinedautomation.com', '', '', '', '', '', '', '', 0, '', 0, '', '', '', '', '', '', '', 0, 0, 0, '', 1206832961, 1206832961, '') in /home/refineda/public_html/includes/database.mysql.inc on line 172.

* You must select a shipping option before continuing.

* Enter the owner name as it appears on the card.

* You have entered an invalid CVV number.

* You have entered an invalid credit card number.

* user warning: Unknown column 'data' in 'field list' query: UPDATE uc_orders SET uid = 2, order_status = 'in_checkout', order_total = 3295, primary_email = 'xxxxx@xxxxxxx.xxx', delivery_first_name = 'Dale', delivery_last_name = 'Vogel', delivery_phone = 'xxx-xxx-xxxx', delivery_company = '', delivery_street1 = 'xxxxxxxxxx', delivery_street2 = '', delivery_city = 'xxxxxxxxx', delivery_zone = 31, delivery_postal_code = 'xxxxx', delivery_country = 840, billing_first_name = 'Dale', billing_last_name = 'Vogel', billing_phone = 'xxx-xxx-xxxx', billing_company = '', billing_street1 = 'xxxxxxxxxx', billing_street2 = '', billing_city = 'xxxxxxxxx', billing_zone = 31, billing_postal_code = 'xxxxx', billing_country = 840, payment_method = 'credit', data = 'N;', modified = 1206832961 WHERE order_id = 47 in /home/refineda/public_html/includes/database.mysql.inc on line 172.

===============================================================================
permalink #1 Sat, 03/29/2008 - 22:52
Ryan

Posts: 5245
 Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

I have a feeling the errors aren't related, but updating to the latest version is always the surest way to squash bugs. We've been quite busy since Alpha 6, so if you aren't relying on any contribs that might break with the update I'd encourage you to do so. We're actually on Beta 7 now, btw. Eye-wink

Anyways, the uc_orders thing was indeed a bug with one of the releases that you'll have to update to fix. That error may be what's causing the CC details to not pop up, but it may also just be a timeout. Puzzled

permalink #2 Sun, 03/30/2008 - 00:32
Dale Vogel
Posts: 37
 Joined: 09/30/2007

Thanks Ryan, let me update and see if that fixes the problem.