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:
PHP Code:
$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.
Bookmarks