Google Checkout Still Reports Config Shipping Error

[Bruce - PhosphorMedia]

Still getting the following error when trying to setup Google Checkout:

Runtime error in /miva/5.00/modules/payment/google_checkout5.mvc @ [00000018:00000028]: modules/payment/google_checkout5.mv: Line 1190: MvQUERY: mysql_stmt_prepare: Unknown column 'dship_name' in 'field list'
Fatal Error

Miva Merchant has encountered a fatal error and is unable to continue. The following information may assist you in determining the cause of the error:

Error Code: MER-GOOGLE-00016
Description: mysql_stmt_prepare: Unknown column 'dship_name' in 'field list'


API Status is set to Sandbox.

[burch]

Re: Google Checkout Still Reports Config Shipping Error

Wow. We made those database changes back in September of last year and completely missed them throughout the Wombat beta.

A manual upgrade of the module will not create the columns either. In RC2, the only way to get the columns created properly is to remove and reinstall the module.

I've filed a bug and this will be fixed.
http://bugzilla.mivamerchant.com/show_bug.cgi?id=5368

[burch]

Re: Google Checkout Still Reports Config Shipping Error

If you want to create the columns manually, in table sNN_GOOGLE_settings

dship_name DB_Type_CHAR( 100 )
dship_cost DB_Type_NUMBER( 10, 2 )

We'll make sure the patch that fixes this bug properly accounts for stores where the columns have been manually created.