Unofficial JMB Support Forums

UnofficialJMBSupport.Com => TgpX(SE) Discussion => Topic started by: calaber24p on September 24, 2012, 10:31:15 PM

Title: Problems with installing tpgx after using tubex
Post by: calaber24p on September 24, 2012, 10:31:15 PM
So here goes the problem. At first I thought using Tubex was a better direction for my but now I think tpgx is. That being said I had tubex fully installed and just deleted all the files to make room for tpgx. Same url and everything. I am able to get to the point where I need to install it, but when I put in my MYSQL database it gives me the fatal error below. It is a completely new database btw i deleted the tubex one. Any input would be appreciated. Thanks in advance!

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
Title: Re: Problems with installing tpgx after using tubex
Post by: Chad on September 24, 2012, 10:35:46 PM
Open up install.php and find around line 174:
Code: [Select]
$DB->Update("CREATE TABLE IF NOT EXISTS $name ( $create ) TYPE=MyISAM");

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

There are some other edits to make also.  I will make a sticky post about them in just a few minutes. This should get you going till then.

Thanks,
Chad