Page 1 of 1

Google Checkout 1.4.8b error

Posted: Fri Aug 06, 2010 10:05 pm
by n19bmw
Brand New Install of 1.48b

I installed google checkout module from this site. When i enable it i get the following code on my store page"

Error: Table 'n19bmw_ocar149.oc_google_download' doesn't exist
Error No: 1146
DELETE FROM `oc_google_download` WHERE `expire` < '1281102919'

Re: Google Checkout 1.4.8b error

Posted: Sat Aug 07, 2010 12:17 am
by Qphoria
Moved to Extension support. Bugs are only related to the core. This is an external module issue

Re: Google Checkout 1.4.8b error

Posted: Tue Aug 10, 2010 2:39 am
by JNeuhoff
Have you created the 2 needed DB tables, e.g. run something like this in your PHPMyAdmin ?

Code: Select all

CREATE TABLE IF NOT EXISTS `oc_google_download` (
  `order_reference` varchar(32) character set utf8 NOT NULL,
  `product_id` int(11) NOT NULL,
  `download_id` int(11) NOT NULL default '0',
  `name` varchar(64) character set utf8 NOT NULL,
  `filename` varchar(128) character set utf8 NOT NULL,
  `mask` varchar(128) character set utf8 NOT NULL,
  `remaining` int(3) NOT NULL default '1',
  `expire` int(10) NOT NULL default '0',
  PRIMARY KEY  (`order_reference`,`product_id`,`download_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `oc_google_order` (
  `order_reference` varchar(32) NOT NULL,
  `expire` int(10) NOT NULL default '0',
  PRIMARY KEY  (`order_reference`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;