SMF Support > Install and Upgrade Help

massive errors on installing

(1/1)

ukr:
Hi

Whats wrong with my install.  Its just too many errors for me to see whats happening.

Its long so worry in advance

Executing package #1... unsuccessful!
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 '_attachments ( ID_ATTACH int(11) unsigned NOT NULL auto_incre
In CREATE TABLE rally_forum _attachments ( ID_ATTACH int(11) unsigned NOT NULL auto_increment, ID_MSG int(10) unsigned NOT NULL default '0', ID_MEMBER int(10) unsigned NOT NULL default '0', filename tinytext NOT NULL default '', size mediumint(8) unsigned NOT NULL default '0', downloads mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (ID_ATTACH), KEY ID_MSG (ID_MSG), KEY ID_MEMBER (ID_MEMBER) ) TYPE=MyISAM;
Executing package #2... unsuccessful!
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 '_banned ( ID_BAN mediumint(8) unsigned NOT NULL auto_incremen
In CREATE TABLE rally_forum _banned ( ID_BAN mediumint(8) unsigned NOT NULL auto_increment, ban_type varchar(30) NOT NULL default '', ip_low1 tinyint(3) unsigned NOT NULL default '0', ip_high1 tinyint(3) unsigned NOT NULL default '0', ip_low2 tinyint(3) unsigned NOT NULL default '0', ip_high2 tinyint(3) unsigned NOT NULL default '0', ip_low3 tinyint(3) unsigned NOT NULL default '0', ip_high3 tinyint(3) unsigned NOT NULL default '0', ip_low4 tinyint(3) unsigned NOT NULL default '0', ip_high4 tinyint(3) unsigned NOT NULL default '0', hostname tinytext NOT NULL default '', email_address tinytext NOT NULL default '', ID_MEMBER mediumint(8) unsigned NOT NULL default '0', ban_time int(10) unsigned NOT NULL default '0', expire_time int(10) unsigned, restriction_type varchar(30) NOT NULL default '', reason tinytext NOT NULL default '', notes text NOT NULL default '', PRIMARY KEY (ID_BAN) ) TYPE=MyISAM;
Executing package #3... unsuccessful!
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 '_board_permissions ( ID_GROUP smallint(5) NOT NULL default '0
In CREATE TABLE rally_forum _board_permissions ( ID_GROUP smallint(5) NOT NULL default '0', ID_BOARD smallint(5) unsigned NOT NULL default '0', permission varchar(24) NOT NULL default '', addDeny tinyint(4) NOT NULL default '1', PRIMARY KEY (ID_GROUP, ID_BOARD, permission) ) TYPE=MyISAM;
Executing package #4... unsuccessful!
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 '_board_permissions (ID_GROUP, ID_BOARD, permission) VALUES (-1
.... Loads cut.............
Warning: Some of the queries failed!!
Your installation may not work correctly!

[Unknown]:
You're using an invalid database prefix.  In 99% of cases, smf_ should be fine.

-[Unknown]

Oldiesmann:
You've got an extra space at the end of your db prefix. Remove that and try again.

ukr:

--- Quote from: Oldiesmann on April 22, 2004, 04:19:55 PM ---You've got an extra space at the end of your db prefix. Remove that and try again.

--- End quote ---

I guess you are both right :)

I used smf_ and it worked but I still could not get it working using smf as the data base name as I had called mine forum  :)

I guess rally_forum without the extra space might have worked but dont have time to try it just now but will do when I get time!

thanks for the solution.!

Oldiesmann:
Glad you got it working :)

Navigation

[0] Message Index