Installation error : Error while executing: --SET NAMES 'utf8';

zak2008 posted 11th of February 2008 in Community Voice. 10 comments.

I am installing Dolphin 6.0.0004 on Hostforweb, and have been stuck with the following error:

Error while executing: --SET NAMES '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 '--SET NAMES 'utf8'' at line 1

Hostforweb techs has advised me to contact Bootnex. Has anyone seen this error? I know I have to edit a php file or something to correct the entry.
I couldn't find this on any Dolphin forums.

Thanks,
zak

Comments

Newest

·Oldest

·Top

Please login to post a comment.

Interex•11th of February 2008

whats with the "--SET NAMES"

It should just be SET NAMES 'utf8';
WITHOUT the --

Shouldnt be editing the v60.sql file :)

Permalink•Reply•Plus•0 pluses

zak2008•11th of February 2008

But do you know how I can correct that entry? Any file that needs to be edited?

Permalink•Reply•Plus•0 pluses

Interex•11th of February 2008

Yes, open [dolphin directory] /install/sql/v60.sql with your favorite text editor and check the first few lines and make sure that there are no --'s in front of SET NAMES 'utf8';

You may have a corrupt download or files. If it still does not work or there are no --'s in front of SET NAMES 'utf8'; at the beginning of the v60.sql then repost and let me know.

Permalink•Reply•Plus•0 pluses

zak2008•11th of February 2008

Interex, you got it! I had to remove the long dotted line above SET NAMES 'utf8'. I am just curious how no one received my error yet. Thanks so much for you help.

Permalink•Reply•Plus•0 pluses

Interex•11th of February 2008

No problem. I've not seen anyone else with that error yet so not sure about wether anyone else has actually had a problem with it. :)

Permalink•Reply•Plus•0 pluses

praveenkv1988•12th of February 2008

Open install/install.sql
Find
SET NAMES 'utf8'
Replace it with SET NAMES 'utf-8'

This may fix your problem.

Permalink•Reply•Plus•0 pluses

mohysham•12th of February 2008

@parveen
"Replace it with SET NAMES 'utf-8"
does not work either.
If anybody can send "good" sql dump.
for phpmyadmin thing plz send 2 addwebd[at]yahoo[dot]com

Permalink•Reply•Plus•0 pluses

cherubini•31st of March 2008

I am getting the same error. I have tried all that you have but no luck.

Error while executing: SET NAMES 'utf-8';
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'

Permalink•Reply•Plus•0 pluses

eric0524•6th of August 2008

I have this problem now. Has anybody been able to resolve it?

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 see more

Permalink•Reply•Plus•0 pluses

eric0524•12th of August 2008

I may be mistaking but I think the problem is our version of MySQL, I think you have to have 5.x to use the utf8 stuff. I tried to re-write things got an actual install but there are to many places to change the SET NAMES and all the other utf8 stuff. Sent an email to tech support on it, but like they say you get what you pay for and it's free (I do plan on buying it when I can get it to work) but I think I will have to wait until zervex updates ServerCP with a PHP update. Please correct me if see more

Permalink•Reply•Plus•0 pluses

Installation error : Error while executing: --SET NAMES 'utf8';

Blogs

Help

Product

Company

Installation error : Error while executing: ﻿--SET NAMES 'utf8';

Blogs

Help

Product

Company

Installation error : Error while executing: --SET NAMES 'utf8';