homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

MySQL on Xampp on CentOS 6

 9:21 pm on Nov 22, 2011 (gmt 0)

I am trying to install a program on Xampp (in Centos 6) and I get the error that I listed below. I am not sure whats wrong, because I just went to PHPMyAdmin, created a table called 001 and it was all that I needed to do. I looked at the info, but it is kind of hard to figure it out at this point. Does anybody have an idea what it is?
Thank you.

Fatal Error
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 49
CREATE TABLE IF NOT EXISTS tx_galleries ( `gallery_id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT, `gallery_url` TEXT, `description` TEXT, `keywords` TEXT, `thumbnails` INT, `email` CHAR(128), `nickname` CHAR(128), `weight` INT NOT NULL, `clicks` INT NOT NULL, `submit_ip` CHAR(16), `gallery_ip` CHAR(16), `sponsor_id` INT, `type` ENUM('submitted','permanent'), `format` ENUM('pictures','movies'), `status` ENUM('submitting','unconfirmed','pending','approved','used','holding','disabled'), `previous_status` ENUM('submitting','unconfirmed','pending','approved','used','holding','disabled'), `date_scanned` DATETIME, `date_added` DATETIME NOT NULL, `date_approved` DATETIME, `date_scheduled` DATETIME, `date_displayed` DATETIME, `date_deletion` DATETIME, `partner` CHAR(32), `administrator` CHAR(32), `admin_comments` TEXT, `page_hash` CHAR(32), `has_recip` TINYINT NOT NULL, `has_preview` TINYINT NOT NULL, `allow_scan` TINYINT NOT NULL, `allow_preview` TINYINT NOT NULL, `times_selected` INT NOT NULL, `used_counter` INT NOT NULL, `build_counter` INT NOT NULL, `tags` TEXT, `categories` TEXT, INDEX(`gallery_url`(100)), INDEX(`date_added`), INDEX(`date_approved`), INDEX(`date_displayed`), INDEX(`date_scheduled`), INDEX(`clicks`), INDEX(`page_hash`), INDEX(`email`), INDEX(`submit_ip`), INDEX(`sponsor_id`), FULLTEXT(`description`,`keywords`), FULLTEXT(`keywords`), FULLTEXT(`tags`), FULLTEXT(`categories`) ) TYPE=MyISAM

trigger_error in mysql.class.php on line 181
Update in install.php on line 174
CreateTables in install.php on line 59
Initialize in install.php on line 372



 10:51 pm on Nov 22, 2011 (gmt 0)

Depending on what version of MySQL you are running, the TYPE keyword is probably no longer supported, and should instead be ENGINE.




 12:12 am on Nov 23, 2011 (gmt 0)

Is there any way to do something about it? I installed the program on a regular server and it is working there...


 2:27 pm on Nov 23, 2011 (gmt 0)

They are probably two different versions of MySQL. Without changing the query or switching to a different version of MySQL, I do not know of anything else that you can do.

But just in case, you should first confirm that your version of MySQL is one that no longer supports the TYPE keyword first.

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved