Author Topic: New Install? Here are some REQUIRED edits...  (Read 3963 times)

0 Members and 1 Guest are viewing this topic.

Offline Chad

  • Administrator
  • Full Member
  • ***
  • Posts: 215
  • Karma: +27/-0
    • View Profile
New Install? Here are some REQUIRED edits...
« on: September 24, 2012, 11:00:12 PM »
Database error on install
If you get the following error on a new install:
Code: [Select]
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

Make the following changes:
Open admin/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");

Fatal Error on Build
Code: [Select]
Fatal Error
 Error:
 Parameter 1 to txBuildCallback() expected to be a reference, value given
 
 Trace:
 call_user_func in common.php on line 473
 BuildPages in common.php on line 312
 BuildNewAll in index.php on line 471
 call_user_func in index.php on line 50
Make the following change:
In admin/index.php
find around line 306:
Code: [Select]
function txBuildCallback(&$page)
Change it to:
Code: [Select]
function txBuildCallback($page)

In includes/htmlparser.class.php find:

Code: [Select]
=& new

Replace with:

Code: [Select]
= new


Various Errors
In includes/htmlparser.class.php find (15 times in this file...):

Code: [Select]
=& new

Replace with:

Code: [Select]
= new
« Last Edit: November 25, 2012, 05:26:59 PM by Chad »

Unofficial JMB Support Forums

New Install? Here are some REQUIRED edits...
« on: September 24, 2012, 11:00:12 PM »


Tags:
 

Related Topics

  Subject / Started by Replies Last post
4 Replies
1724 Views
Last post January 15, 2013, 02:42:16 PM
by panther555
3 Replies
2056 Views
Last post May 29, 2014, 01:59:45 AM
by GFED
1 Replies
994 Views
Last post April 06, 2013, 04:02:40 PM
by Chad
0 Replies
903 Views
Last post August 09, 2013, 06:58:52 PM
by Chad
0 Replies
1088 Views
Last post April 13, 2014, 03:56:32 PM
by thorshammer

anything