Is anyone USING any Ebay <----> Zencart Synchronizing software?

[carlwhat]

I hope so but I pm'd them about a month ago and never heard from them. Thank you for the help though.

i would argue that whoever approved this plugin on the ZC forum never really tested it. installing it does in fact create a log and an error.

i have tested the install, and i'm guessing that you have somehow mis-typed the changes that lat9 recommended.

that said, i do not agree with her changes. there is no reason to remove the ENGINE declaration.

as lat9 stated, there is a missing comma and an added comma. the code should look like:

$constants = get_defined_constants();

      $sql = <<<CREATE_TABLE_EBAY_CACHE
 CREATE TABLE IF NOT EXISTS `{$constants['TABLE_EBAY_CACHE']}` (
 `ebay_cache_id` int(20) NOT NULL,
  `cache_key` varchar(256) NOT NULL,
  `cache_value` mediumtext NOT NULL,
  `cache_date` date NOT NULL DEFAULT '2000-01-01',
  `keep` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`ebay_cache_id`),
  UNIQUE KEY `cache_key` (`cache_key`),
  KEY `keep` (`keep`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE_TABLE_EBAY_CACHE;
      $db->execute($sql); 

there is a misplaced comma, but other than that, it seemed to install fine for me.

i would ensure you are not using an editor (like MS-Word... the horror) that adds additional characters.

i tested with v200 and v158 running php8; 8.1 and 7.4.

whether it works after that is anyone's guess.

good luck!

best.

[WyrdGifts]

i would argue that whoever approved this plugin on the ZC forum never really tested it. installing it does in fact create a log and an error.

i have tested the install, and i'm guessing that you have somehow mis-typed the changes that lat9 recommended.

that said, i do not agree with her changes. there is no reason to remove the ENGINE declaration.

as lat9 stated, there is a missing comma and an added comma. the code should look like:

$constants = get_defined_constants();

      $sql = <<<CREATE_TABLE_EBAY_CACHE
 CREATE TABLE IF NOT EXISTS `{$constants['TABLE_EBAY_CACHE']}` (
 `ebay_cache_id` int(20) NOT NULL,
  `cache_key` varchar(256) NOT NULL,
  `cache_value` mediumtext NOT NULL,
  `cache_date` date NOT NULL DEFAULT '2000-01-01',
  `keep` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`ebay_cache_id`),
  UNIQUE KEY `cache_key` (`cache_key`),
  KEY `keep` (`keep`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE_TABLE_EBAY_CACHE;
      $db->execute($sql); 

there is a misplaced comma, but other than that, it seemed to install fine for me.

i would ensure you are not using an editor (like MS-Word... the horror) that adds additional characters.

i tested with v200 and v158 running php8; 8.1 and 7.4.

whether it works after that is anyone's guess.

good luck!

best.

Thank you! I copied and pasted what you had, and it worked. I don't know what was wrong before but thank you very much. Now, to configure all the rest that has to be done to use this plug-in... I'm just not very tech-savvy is the problem.