First time I've run in to this problem, and I've installed this module multiple times. Hoping somebody can point me in the right direction. When I click the install button I get the following:
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 'TYPE=MyISAM' at line 9
in:
[ CREATE TABLE IF NOT EXISTS subscribers ( `subscriber_id` int(11) NOT NULL auto_increment, `customers_id` int(11) default NULL, `email_address` varchar(96) NOT NULL default '' UNIQUE, `email_format` varchar(4) NOT NULL default 'TEXT', `confirmed` varchar(8) default NULL, `subscribed_date` date NOT NULL default '0000-00-00', PRIMARY KEY (`subscriber_id`) ) TYPE=MyISAM;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Module version is 2.2.2, Zen Cart Version is 1.39H, PHP Version 5.3.28, MySQL version 5.5.35. I have several sites with the same host using this module, so I'm stumped! Any ideas?
Bookmarks