[AN-net]

Originally Posted by TruthElixirX

I am isntalling this for a client. When I run the install script I get this on step two.

Database error in vBulletin 3.0.7:

Invalid SQL: CREATE TABLE IF NOT EXISTS journals (
		`journal_id` int(10) NOT NULL auto_increment,
		`journalname` varchar(50) NOT NULL default '',
		`journalist` varchar(50) NOT NULL default '',
		`journalist_id` int(10) NOT NULL default '0',
		`journaldate` int(10) NOT NULL default '0',
		`journaldesc` varchar(90) NOT NULL default '',
		`ipaddress` varchar(15) NOT NULL default '',
		`journalviews` int(10) NOT NULL default '0',
		`entrycount` int(7) NOT NULL default '0',
		`commentcount` int(12) NOT NULL default '0',
		`lastentry` varchar(80) NOT NULL default '',
		`lastentry_date` int(10) NOT NULL default '0',
		`lastentry_id` int(10) NOT NULL default '0',
		`journal_totalrating` int(15) NOT NULL default '0',
		`journal_totalvotes` int(10) NOT NULL default '0',
		`status` tinyint(4) NOT NULL default '0',
		`whovoted` mediumtext NOT NULL,
		`private` tinyint(4) NOT NULL default '0',
		`allowbuddies` tinyint(4) NOT NULL default '0',
		`whocanview` varchar(150) NOT NULL default '',
		`active` tinyint(4) NOT NULL default '0',
		`privatecount` int(10) NOT NULL default '0',
		`lastentry_misc` mediumtext NOT NULL,
		PRIMARY KEY  (`journal_id`),
		UNIQUE KEY `journalist` (`journalist`),
		UNIQUE KEY `journalist_id` (`journalist_id`),
		KEY `lastentry_date` (`lastentry_date`)
		) ENGINE=MyISAM DEFAULT CHARSET=latin1
	
mysql 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 'DEFAULT CHARSET=latin1' at line 29

mysql error number: 1064

Date: Monday 30th of January 2006 07:51:37 PM
Script: http://themediaforums.com/admincp/journalinstaller.php
Referer: http://themediaforums.com/admincp/journalinstaller.php
Username: tech
IP Address: 162.39.149.138

Please please please tell me you're still giving support.... Thanks a million.

go into the install file and remove DEFAULT CHARSET= latin1 where ever it exists. this probably solves the dilema.