Author Topic: Fatal Error after installation of ToplistX  (Read 1478 times)

0 Members and 1 Guest are viewing this topic.

Offline apollouk

  • Newbie
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Fatal Error after installation of ToplistX
« 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

Offline Robert9

  • New Users
  • Newbie
  • *
  • Posts: 8
  • Karma: +0/-0
    • View Profile
Re: Fatal Error after installation of ToplistX
« Reply #1 on: August 23, 2016, 01:02:36 PM »
You have to find the word TYPE in install.php and substitute it with ENGINE.

Unofficial JMB Support Forums

Re: Fatal Error after installation of ToplistX
« Reply #1 on: August 23, 2016, 01:02:36 PM »


Tags:
 

Related Topics

  Subject / Started by Replies Last post
0 Replies
1314 Views
Last post August 05, 2013, 07:07:54 PM
by Chad
4 Replies
1692 Views
Last post May 23, 2014, 09:27:32 AM
by morf
0 Replies
1124 Views
Last post October 04, 2014, 06:39:06 PM
by oman
4 Replies
2800 Views
Last post July 13, 2016, 06:40:17 AM
by amebb
0 Replies
1108 Views
Last post October 17, 2016, 09:30:33 PM
by j3ss3jam3s

anything