Error Message while trying to update Customer Order Record after installing Google Checkout

[GoogleCodeExporter]

Getting this error message while trying to update an Customer Order 
Record....It had been working prior to installing Google Checkout....Any 
help would be appreciated...thanks Karl

1146 - Table 'margarit_margaritas.google_orders' doesn't exist

select google_order_number from google_orders where orders_id= 150

Original issue reported on code.google.com by botanica...@yahoo.com on 24 Oct 2007 at 3:31

[GoogleCodeExporter]

I had the same problem. This may help, although I am no expert with osCommerce.

There was an error in one of the most recent versions where it was not creating 
the
tables in the database for google orders.

http://groups.google.com/group/google-checkout-for-osc-mod-support/browse_thread
/thread/efcad963b5c7a5d9/75baf5f9631456d6?lnk=gst&q=google_orders#75baf5f9631456
d6

I resolved this by manually creating the tables with the following SQL:

create table if not exists google_checkout (customers_id int(11), buyer_id 
bigint(20))

create table if not exists google_orders (orders_id int(11), google_order_number
bigint(20), order_amount decimal(15,4))

I copied these 2 SQL statements from includes/modules/payment/googlecheckout.php
lines 257 & 258.

Optionally, you can try to reinstall.

Tom

Original comment by t...@refreshweb.net on 30 Oct 2007 at 12:51

[GoogleCodeExporter]

Hi

that was a bug, the lines that create the DB tables where commented out, 
affecting
brand new installations.

latest version 1.4.5a should fix that issue

thx

ropu

Original comment by rovagn...@gmail.com on 12 Nov 2007 at 2:32

• Changed state: Fixed
• Added labels: Priority-High
• Removed labels: Priority-Medium