Installation - SQL syntax error

spanishcatAdvanced

3 posts

Hi,

If anyone could help me with this I'd be greatly appreciative.

I'm trying to install dolphin (6.1.4) and have done everything according to the instructions but when I try to install the database I'm getting this error.

Thanks for your time.

Tom.

Error while executing: SET NAMES 'utf8';
Unknown system variable 'NAMES'

Error while executing: ALTER DATABASE DEFAULT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci';
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 'DATABASE DEFAULT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci'

Error while executing: CREATE TABLE `AdminBanList` (`ProfID` int(11) NOT NULL default '0',`Time` int(20) NOT NULL default '0',`DateTime` datetime NOT NULL default '0000-00-00 00:00:00') ENGINE=MyISAM DEFAULT CHARSET=utf8;
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=utf8' at line 1

Quote · 4 Nov 2008

Stuart038Advanced

1274 posts

you should create the database before you install Dolphin.

There are none so blind as those that will not see.

Quote · 5 Nov 2008

spanishcatAdvanced

3 posts

Sorry, I should clarify. I did create the database before installing, as well as create a user and connect it to the database etc., but when I run the install file it obviously needs to populate the database with tables etc. (I think it's about the 4th or 5th stage of the installation) and this is where I'm getting the error messages. Thanks for your help.

Quote · 5 Nov 2008

MichelSwissAdvanced

1062 posts

Did you check if your MySQL version is compatible with Dolphin ?

Life is a fatal disease, sexually transmissible - Virginity is carcinogenic! Ask here for vaccine.

Quote · 5 Nov 2008

spanishcatAdvanced

3 posts

Hi, yes, I've checked, and it is compatible. Thanks anyway.

Quote · 5 Nov 2008

rpnightAdvanced

18 posts