eBay Integration for Zen Cart Plugin

[jeking]

Thank you for writing and submitting this plugin. I have a client who wants to use this so I installed it on a 1.5.8a test store.

I'm getting this error when trying to install it. I can provide the full log, if you need the additional details.

--> PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''ebay_cache' (
'ebay_cache_id' int(20) NOT NULL,
'cache_key' varchar(256) NO' at line 1 :: CREATE TABLE IF NOT EXISTS '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'),

[WyrdGifts]

Hello,

I tried to use the integration, but it won't install. I get this message when I try to install it on zc:

WARNING: An Error occurred, please let us know! If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you entered valid data.

I don't know if I did something wrong when I added the 3 files to my folders or if it's something else. Do you have directions for dummies or do you help non-tech people?

Thank you

[simon1066]

Hello,

I tried to use the integration, but it won't install. I get this message when I try to install it on zc:

WARNING: An Error occurred, please let us know! If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you entered valid data.

I don't know if I did something wrong when I added the 3 files to my folders or if it's something else. Do you have directions for dummies or do you help non-tech people?

Thank you

https://docs.zen-cart.com/user/troub...rror_occurred/

This should help you. The first place to look for such a WARNING is a myDEBUG-xxxxxx.log in your logs folder.

[dreadscott]

I'm running v1.5.8a and get the same exact "WARNING: An Error occurred, please let us know!" output. Applying the SQL patch also locked me out of my back end access (with a 500 HTML error result). The debug log demonstrates the same sort of PHP response, too:

--> PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(`ebay_cache_id`),
UNIQUE KEY `cache_key` (`cache_key`),
KEY `keep` (`keep`)' at line 7 :: CREATE TABLE IF NOT EXISTS `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; ==> (as called by) /zc_plugins/ebayintegration/v1.0.0/Installer/ScriptedInstaller.php on line 30 <== in /includes/classes/db/mysql/query_factory.php on line 667.


Is there a fix to this?

[lat9]

I think that'll be corrected by removing the trailing comma (highlighted) from this portion of the SQL query

KEY `keep` (`keep`),
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[TamyA]

Has it been tested with zen cart 210? Or do you think it might work? Thanks.