I am setting up my website on my computer offline so that I can upgrade to version 1.5 with all the customizations and added mods before replacing my live site. One of the wonderful modifications I have on my live site is Testimonial Manager - a fabulous program!

I have a new install of Zen Cart 1.5 on my computer, with phpmyadmin version 3.4.5. I downloaded testimonial manager 1.5.3a and installed the files, and installed the new_install.sql patch through Admin>tools>install sql patches (without copying the top info part).

I received the following 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 'TYPE=MyISAM' at line 1
in:
[CREATE TABLE PVtestimonials_manager ( testimonials_id int(11) NOT NULL auto_increment, language_id int(11) NOT NULL default '1', testimonials_title varchar(64) NOT NULL default '', testimonials_url VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_name text NOT NULL, testimonials_image varchar(254) NOT NULL default '', testimonials_html_text text, testimonials_mail text NOT NULL, testimonials_company VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_city VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_country VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_show_email char(1) default '0', status int(1) NOT NULL default '0', date_added datetime NOT NULL default '0000-00-00 00:00:00', last_update datetime NULL default NULL, PRIMARY KEY (testimonials_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.


Admin>configuration>testimonials manager has appeared and is editable.

Testimonials_manager has not appeared in the list under Admin>tools>layout boxes controller.

I have tried uninstalling and reinstalling, with the exact same results. I have no idea what this error message means.

Is there a more knowledgeable person available who can give me some idea of what to do to fix this?

Wendy