Newsletter Subscribe install problem

[RescoCCC]

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?

[DrByte]

That's because the plugin was written for an old version of MySQL.

Change the "TYPE=MyISAM" to "ENGINE=MyISAM" and that'll fix that SQL error.

[RescoCCC]

That's because the plugin was written for an old version of MySQL.

Change the "TYPE=MyISAM" to "ENGINE=MyISAM" and that'll fix that SQL error.

Thanks Doc. I read another thread before posting where you had provided that answer. However, I could not find where the install was using TYPE=MyISAM. It doesn't come with a user installed SQL patch, and I couldn't find that in any of the files provided. Any ideas where to look?

[DrByte]

If you've put its files onto your server, use the Developers Toolkit and have it search "all php files" (last option in the list)

http://www.zen-cart.com/content.php?...lopers-toolkit
http://www.zen-cart.com/content.php?...-files-to-edit

[RescoCCC]

Did that before posting. It comes up with nothing.

[DrByte]

What exactly did you search for?

[RescoCCC]

I searched for TYPE=MyISAM, MyISAM, and ISAM.

[DrByte]

I just downloaded the plugin myself and inspected it. You probably were searching "catalog" and not "admin" files. It's in one of the admin files:
/admin/includes/functions/extra_functions/subscription_manager.php

[RescoCCC]

I just downloaded the plugin myself and inspected it. You probably were searching "catalog" and not "admin" files. It's in one of the admin files:
/admin/includes/functions/extra_functions/subscription_manager.php

I searched both catalog and admin. I also searched that specific file since it's the one called when clicking install from the admin.

[RescoCCC]

My bad! There's more than one subscription_manager.php file. Editing the correct one right now.