I'm having a similar problem installing the SQL for a brand-new use of Testimonial Manager 1.5.3a. I've got a fresh 1.5.0 install on my local machine (PHP 5.3.8, mySQL 5.5.16) and ran the new_install.sql (without the lead-in comments) in my admin. Here's what's in my debug log:
[15-Mar-2012 13:44:58] 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 'TYPE=MyISAM' at line 1 :: CREATE TABLE testimonials_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 ; in C:\xampp\htdocs\v1.5.0\includes\classes\db\mysql\query_factory.php on line 101
Any ideas?


Reply With Quote
