Author Topic: Database / script issue  (Read 1690 times)

0 Members and 1 Guest are viewing this topic.

Offline amebb

  • New Users
  • Newbie
  • *
  • Posts: 16
  • Karma: +0/-0
    • View Profile
Database / script issue
« on: March 07, 2015, 05:42:07 AM »
Hi there

I have uploaded the TGPx files to my site and then added the folders as stated and also changed the permissions etc.

When i goto my site to run the script and enter my database details etc i get the following error message:


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 188
Update in install.php on line 181
CreateTables in install.php on line 66
Initialize in install.php on line 379



Can anyone help me please.....

Thank you


Offline amebb

  • New Users
  • Newbie
  • *
  • Posts: 16
  • Karma: +0/-0
    • View Profile
Re: Database / script issue
« Reply #1 on: March 07, 2015, 05:53:12 AM »
HI

I am very sorry but i have sorted the issue out - thanks guys

Unofficial JMB Support Forums

Re: Database / script issue
« Reply #1 on: March 07, 2015, 05:53:12 AM »


Tags: error message 
 

Related Topics

  Subject / Started by Replies Last post
3 Replies
1167 Views
Last post October 28, 2012, 11:09:40 PM
by Chad
6 Replies
1578 Views
Last post May 06, 2013, 04:29:48 AM
by bbhrucy79
0 Replies
1147 Views
Last post August 05, 2013, 07:04:44 PM
by Chad
0 Replies
888 Views
Last post February 06, 2014, 07:17:17 AM
by gigasexo
0 Replies
1429 Views
Last post March 07, 2015, 06:17:45 AM
by amebb

anything