Welcome to WebmasterWorld Guest from 54.227.101.214

Forum Moderators: open

Message Too Old, No Replies

MySQL on Xampp on CentOS 6

     

joliett89

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
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

Trace:
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

eelixduppy

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

WebmasterWorld Senior Member eelixduppy is a WebmasterWorld Top Contributor of All Time 5+ Year Member



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

e.g.,

ENGINE = MyISAM

joliett89

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...

eelixduppy

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

WebmasterWorld Senior Member eelixduppy is a WebmasterWorld Top Contributor of All Time 5+ Year Member



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.
 

Featured Threads

Hot Threads This Week

Hot Threads This Month