GoDaddy install - MySQL error 1115

Permalink
I'm trying to install C5 on GoDaddy. I did the 'patch' necessary to get it to run on GoDaddy. Now I can't get past the C5 install screen. Type in all DB info and click "Install Concrete"... the following error returns:

mysql error: [1115: Unknown character set: 'DB_CHARSET'] in EXECUTE("SET NAMES 'DB_CHARSET' COLLATE 'DB_COLLATE'")

Does anyone have an answer/fix? Thanks much!

 
tecnolord replied on at Permalink Reply
tecnolord
Hi,
i opened a godaddy account just to fiddle with this problem.

i changed the .htaccess to the htaccess that is shown on this site and i could install.http://c5cms.net

http://osignite.com/blog/29-perfect-htaccess-for-joomla-with-godadd...

after that i had a new problem. the site only shows empty pages. So i guess there is a php.ini and/or .htaccess page that makes it all possible. If you search for GoDaddy on this site you also see similar problems and solutions. I even read one response that had the site working on godaddy.
so its possible i just need to figure out how to do it properly.
I'll let you know as soon as i find it out.

about godaddy as host:
Currently i don't like godaddy very much. way to complex in handling their menu. takes me ages to find everything in their menus and popup windows.. and 1 hour before you have a database?
they probably run it on a c64. ;)

i just found out that it possibly also can be due to caching the files that it won't work right away.
andyharwood replied on at Permalink Reply
Thanks for all of your help!! Yes, GoDaddy is a nightmare. My client has the account there so I'm stuck with it...hopefully I can figure this out.
tecnolord replied on at Permalink Reply
tecnolord
Hi Andy,
I managed to get the site up and running on godaddy. However, i am not 100% sure why it worked this time. check out thehttp://c5cms.net/info.php

after reading here and there i found out that i had to create a php.ini and/or a php5.ini with only cgi.fix_pathinfo = 1 in it.

i also used the .htaccess as i mentioned before.

To get it running (it worked for me)
(unpack the added zip)
i created a new database on godaddy
i deleted all the files on godaddy (after a backup)
i uploaded concrete5 files
i uploaded the php.ini and php5.ini and the .htaccess
did a test to see if all items would work (i got no errors on the install test)
and fileld in the new database name (stupid long godaddy fantasy name) and the database user etc. and the result was... a working cms.

since i only believe that this will work repeatedly: i'll try the procedure again. just to be sure.
I hope this will work out for you.
There is also a chance there is a difference in hosting plans... i dunno. (i guess not if its a payed plan, but the free plans can be different.)

an alternative would be to use godaddy dns function and host the site somewhere else. (god knows how difficult that would be with nodaddy. err. godaddy) Godaddy is also way behind with updates. (compare thehttp://c5cms.net/info.php withhttp://pbpgamer.com/info.php ) Also usefull to see what is missing. I had sites up and running at namecheap and bluehost in no time.

i hope this will help. If not, let me know. Then i'll try a different approach
tecnolord replied on at Permalink Reply 1 Attachment
tecnolord
i tried to add the file (with the good htacces... but it would not save.)

I also have some trouble to get the Enable Pretty URLs to work.
i'll hope to find out how to get that working. testing with godaddy takes ages :-S
andyharwood replied on at Permalink Reply
Thank you for all of your help! I have it working. It's possible that my original upload of the Concrete files had a corruption somewhere. Because I tried your fixes and they didn't work. Then I started over from scratch and it worked. Thanks again!!!
tecnolord replied on at Permalink Reply
tecnolord
the fix sets the environment right (you can check that with phpinfo) probably the only thing needed is the php.ini file to set that var. After that is set you can run a clean install without any problems.

but i am glad it worked. i found out that godaddy is real slow so maybe your client isn't going to be real happy.
from my installations is the one running onhttp://www.namecheap.com the faster one.