Author Topic: Database Error on Install  (Read 1171 times)

0 Members and 1 Guest are viewing this topic.

Offline Chad

  • Administrator
  • Full Member
  • ***
  • Posts: 215
  • Karma: +27/-0
    • View Profile
Database Error on Install
« on: August 05, 2013, 07:04:44 PM »
If you get the following error on a new install:

Code: [Select]
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

Open admin/install.php and find around line 174:

Code: [Select]
$DB->Update("CREATE TABLE IF NOT EXISTS $name ( $create ) TYPE=MyISAM");

Change to:

Code: [Select]
$DB->Update("CREATE TABLE IF NOT EXISTS $name ( $create ) ENGINE=MyISAM");
« Last Edit: October 09, 2013, 05:43:06 PM by Chad »

Unofficial JMB Support Forums

Database Error on Install
« on: August 05, 2013, 07:04:44 PM »


Tags:
 

Related Topics

  Subject / Started by Replies Last post
6 Replies
1603 Views
Last post May 06, 2013, 04:29:48 AM
by bbhrucy79
21 Replies
7458 Views
Last post July 07, 2017, 10:40:10 AM
by The Dawg
0 Replies
900 Views
Last post February 06, 2014, 07:17:17 AM
by gigasexo
0 Replies
1126 Views
Last post October 16, 2014, 05:28:09 PM
by swingermoney
1 Replies
1706 Views
Last post March 07, 2015, 05:53:12 AM
by amebb

anything