HomeUnityBlogs
 
 
totallyfreak

error while installing dolphin

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
bad
1
good
 
 

Comments

nuccca
nuccca 277 days agocomment permalink
 
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.
 
bad
0
good
 
 
totallyfreak
totallyfreak 276 days agocomment permalink
 
ok and how i do that in my phpadmin??

thx
 
bad
0
good
 
 
totallyfreak
totallyfreak 276 days agocomment permalink
 
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...
 
bad
0
good
 
 
nuccca
nuccca 276 days agocomment permalink
 
utf8-unicode would be the one.

try it and let me know the results.
 
bad
0
good
 
 
totallyfreak
totallyfreak 276 days agocomment permalink
 
but how i can modify that..
 
bad
0
good
 
 
djgenesis
djgenesis 275 days agocomment permalink
 
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
 
bad
0
good
 
 
djgenesis
djgenesis 275 days agocomment permalink
 
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 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.
 
bad
0
good
 
 
djgenesis
djgenesis 275 days agocomment permalink
 
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...
 
bad
0
good
 
 
Cloodo
Cloodo 274 days agocomment permalink
 
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 all of them. That should fix it.
 
bad
0
good
 
 
lehmio
lehmio 192 days agocomment permalink
 
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???
 
bad
0
good
 
 


Post a Comment

Please login to post a comment.

This Post
 
 
totallyfreak Blog
All Blogs
Found a bug? Have a suggestion? We really value your feedback!
 
© 2008 BoonEx Ltd
ABN 27 127 966 581
 
PET:0.777791023254