error while installing dolphin

totallyfreak posted 2nd of March 2008 in Community Voice. 10 comments.
i got this error message when i try to install dolphin



Error while executing: SET NAMES ''utf8'';
Unknown character set: ''
Error while executing: ALTER DATABASE DEFAULT CHARACTER SET ''utf8'' COLLATE ''utf8_unicode_ci'';
Unknown character set: ''
Error while executing: CREATE TABLE `AccountCompose` (`ID` int(8) unsigned NOT NULL auto_increment,`Title` varchar(255) NOT NULL default '''',`Div` varchar(255) NOT NULL default '''',`Caption` varchar(255) NOT NULL default '''',`Desc` varchar(255) NOT NULL default '''',`Func` varchar(40) NOT NULL default '''',`Content` text NOT NULL,`Visible` set(''non'',''memb'') NOT NULL default '''',`Column` int(11) NOT NULL default ''0'',`Order` int(11) NOT NULL default ''0'',PRIMARY KEY (`ID`)) 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 'non'',''memb'') NOT NULL default '''',`Column` int(11) NOT NULL default ''0'',`O' at line 1




what i need to change on my vps setting server....


thx
 
Comments
·Oldest
·Top
Please login to post a comment.
nuccca
Hey TotallyFreak,


What encoding method did you use when setting up your MySQL database?

Try logging into PHPMYADMIN and changing the collation to UTF-8.

Hope this helps.
totallyfreak
ok and how i do that in my phpadmin??

thx
totallyfreak
i think i make an bad change when i try to add some extra feature to my apache vps server... maybe i made a change in the mysql server version or option... so what can i do for got it back... i dont see utf8 only... its all with another extension... utf8-bin, utf8-unicode, utf8-czech... etc...
nuccca
utf8-unicode would be the one.

try it and let me know the results.
totallyfreak
but how i can modify that..
djgenesis
I found that if you add " -- " in front of those things that won't execute it works...but i'm checking now to see if this is just a mysql 4.0 error or is it across the 4.0 and 5.0 mysql thing
djgenesis
yeah I just found that it happens even if you are running 5.0 on certain servers. Boonex wants everyone to use the server that they are speaking of but unfortunately to get a package similar to the ones 1and1 and other companies are providing you have to pay much more...Unfortunately you will have to do some tweaking with the sql file to make it work with your server that is what I have found...once I get the solution and my site is up and running I will hit yall with the file. I emailed them with see more the same problem and they gave me the response to use their hosting company, unfortunately I found a better deal with 1and1 who says they support Dolphin. like I said I found that by putting in the two lines in front of those values that aren't working it makes the sql file readable.
djgenesis
to modify the file go to the "install" directory and open up the sql directory then open the v60.sql file in a text editor. I'm on a mac so I simly use "text editor" once in there you will find that certain items have the double lines -- in front of them...these are the items that are having the issue...
Dude.. Nucca is right.. your error clearly tells you that your MySQL entries are not encoded correctly. PHPMYADMIN is the way to go. Login you hostng account (example CPanel).. Go to MySQL.. onces in MySQL look towards the bottom and find PHPMYADMIN.. this will take you to all your database and tables.. find the relevant database.. open the tables.. in each field (row) you will find a encoding column (character set).. these will have drop downs with a range of sets... select the UTF-8 unicode for see more all of them. That should fix it.
lehmio
but... there is just the database, no tables can be created!!!
i have the same problem as mentioned above...
why is there noone from BoonEx to feel responsible to fix this problem???
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.
PET:0.074383974075317