Author Topic: Problems with installing tpgx after using tubex  (Read 1014 times)

0 Members and 1 Guest are viewing this topic.

Offline calaber24p

  • Newbie
  • *
  • Posts: 16
  • Karma: +0/-0
    • View Profile
Problems with installing tpgx after using tubex
« 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

Offline Chad

  • Administrator
  • Full Member
  • ***
  • Posts: 215
  • Karma: +27/-0
    • View Profile
Re: Problems with installing tpgx after using tubex
« Reply #1 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

Unofficial JMB Support Forums

Re: Problems with installing tpgx after using tubex
« Reply #1 on: September 24, 2012, 10:35:46 PM »


Tags:
 

Related Topics

  Subject / Started by Replies Last post
10 Replies
3941 Views
Last post April 14, 2015, 05:22:12 AM
by Zug
3 Replies
1545 Views
Last post September 26, 2013, 03:40:52 AM
by nick_bmc
2 Replies
1030 Views
Last post June 27, 2013, 02:41:07 AM
by that_guy
0 Replies
1159 Views
Last post July 22, 2015, 04:55:34 PM
by seojedi32
1 Replies
1023 Views
Last post August 23, 2016, 02:28:12 PM
by Robert9

anything