Unofficial JMB Support Forums

UnofficialJMBSupport.Com => ToplistX Discussion => Topic started by: apollouk on February 18, 2015, 10:50:39 AM

Title: Fatal Error after installation of ToplistX
Post by: apollouk on February 18, 2015, 10:50:39 AM
Shared  server:

Script Version: toplistX 1.0.0-SS
PHP Version: 5.4.31
MySQL Version: 4.0.4+ with all database privileges enabled

Have you tried the server test script: Yes
If yes, results (all passed, some issues (if so what?)): Only JPG support is not installed; will not be able to read/write JPEG images

Have you modified any code yourself: No
If yes, briefly describe changes:

Link to site:

Description of issue: I've just installed and I get the following error after I have submitted the MySQL database information

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 30
CREATE TABLE IF NOT EXISTS tlx_accounts ( `username` CHAR(32) NOT NULL PRIMARY KEY, `email` TEXT, `site_url` TEXT, `domain` TEXT, `banner_url` TEXT, `banner_url_local` TEXT, `banner_height` INT, `banner_width` INT, `title` TEXT, `description` TEXT, `keywords` TEXT, `date_added` DATETIME NOT NULL, `date_activated` DATETIME, `date_scanned` DATETIME, `password` CHAR(40), `return_percent` DECIMAL(4,2), `status` ENUM('unconfirmed','pending','active'), `locked` TINYINT NOT NULL, `disabled` TINYINT NOT NULL, `edited` TINYINT NOT NULL, `category_id` INT, `last_rank` INT, `last_category_rank` INT, `ratings` INT, `ratings_total` INT, `inactive` INT, `edit_data` BLOB, `admin_comments` TEXT, FULLTEXT(`title`,`description`,`keywords`), INDEX(`domain`(200)) ) TYPE=MyISAM

Trace:
trigger_error in mysql.class.php on line 190
Update in install.php on line 193
CreateTables in install.php on line 51
Initialize in install.php on line 373
Title: Re: Fatal Error after installation of ToplistX
Post by: Robert9 on August 23, 2016, 01:02:36 PM
You have to find the word TYPE in install.php and substitute it with ENGINE.