ÅÄÖ (solved)

Worker Joined: Jun 16, 2004 Posts: 159 Location: Sweden

hi i have problem with å ä ö any that can help me?
but its show just wierd in forum
looks like this
Yttre Gï¿½llarebï¿½ke Forum Index

Site Admin Joined: Aug 22, 2007 Posts: 1774

Sounds like a collation mismatch in your database. That's happend if you have a database created maybe with a UTF-8 collation and in there entries with a another collation. Search the entry in your database and check if the specialchars are also not readable.

Posted: Fri Sep 12, 2014 5:21 am

Hi
It's seems to be ok in database and its a clean install no changes
the main page handle Å Ä Ö perfect its just the darn forum
can fault be on the hostserver?

Posted: Fri Sep 12, 2014 6:13 am

Where you are getting this issue? In forum titles or topic titles or topic text?

Posted: Fri Sep 12, 2014 7:01 am

all the places you told titles, topic titles ,topic tex

Posted: Fri Sep 12, 2014 10:32 am

I tested on my local installations and can't reproduce this issue - all fine! Which colation have your database and which collation have the database-table with the entries?

Posted: Fri Sep 12, 2014 10:45 am

database is utf8mb4_general_ci and database table is latin1_swedish_ci and i have test shift around to diffrent but no luck

Posted: Fri Sep 12, 2014 11:15 am

Anders wrote:

database is utf8mb4_general_ci and database table is latin1_swedish_ci

That is the cause! You should have the same collation.

Create a new database with latin1_swedish_ci and then start the db-install of RN again.

Posted: Fri Sep 12, 2014 11:24 am

ok thx i give that a try

Posted: Fri Sep 12, 2014 12:28 pm

Nope its same i have latin1_swedish_ci on every place still no go

Posted: Fri Sep 12, 2014 1:07 pm

Create a new database and try to use: utf8_general_ci

After that run the db-installer. It works for me in more than 15 installations.

Please don't change an existend db!!

Add this database+pw in your config.php

Posted: Sat Sep 13, 2014 6:13 am

Now it works did talk to host and he did do something what i dont know but will ask him...and i have utf8mb4_general_ci as i not can change that and tables at utf8_general_ci dam...thx for all help

Posted: Sat Sep 13, 2014 6:19 am

too fast grrr topic title dont show

preview dont work even

Posted: Sat Sep 13, 2014 8:03 am

Hi Anders

What FTP software are you using? Do not forget to clean your cache from the browser. Try to run your installation with FF(firefox). What is your default language on the website? can you please show us the link from your website?

Posted: Sat Sep 13, 2014 9:44 am

i use smartftp and it have work b4 so that should not be the problem ihope...and i will give FF a test just weird if that should help...
default lang is english

Posted: Sat Sep 13, 2014 10:58 am

My experience with SmartFTP was not good. Lots of permission problems in the past. I don't know if they improve it.

Check it out.
[ Only registered users can see links on this board! Get registered or login! ]

Where is the link for your website. I would like to check it.

Can you do yourself a favor. Try this FTP and upload all RavenNuke files again. If you don't like the program. I can advice you FlashFXP which is my favorite. I never had any single problem with it.
[ Only registered users can see links on this board! Get registered or login! ]

If you do these steps we suggest you it would be more easy to find out where your issues are coming from.

When you enter to your your MySQL Databases on your phpMyadmin you need to see this collation neralex mentioned before. Please follow steps so you can find your problem asap.

Posted: Sat Sep 13, 2014 11:24 am

i have done all what neralex have told me and i have exactly data base as your images now....

I think I am an experimental rabbit to the new webhost
they have called in expert help later

Posted: Sun Sep 14, 2014 11:33 am

@hicux, please don't turn him in a wrong direction. He is on the right way. This issue is based on the used database collation or better on the a collation mismatch and can't be a part of FTP permissions. If should have the files wrong permissions so he wouldn't see the website >(!)< because then the files aren't executable or readable. Its a pain to read your false-instruction postings again and again that helps anybody.

Posted: Sun Sep 14, 2014 4:33 pm

Yupp little confusing....but i did get from my host Confused

raven isn't going to work on our servers Try this [ Only registered users can see links on this board! Get registered or login! ]
and they did say some more that i wont take up here....
i hope raven realse ravencms sooooooon
or raven maybe can give them webhost setup lol b4 å ä ö work here

Posted: Sun Sep 14, 2014 6:05 pm

They have moved me to a new server now lol...so i must wait and see to dns point work.... Sad

Posted: Sun Sep 14, 2014 9:04 pm

WTF, if the current RN will not work on their servers and they are recommend old stuff like evo, then RavenCMS will also not work. Its a simple database issue and have nothing to do with the CMS. Anyway.

Posted: Tue Sep 16, 2014 12:04 am

Hello Anders can I see online your problem? I think you have my Skype account "MisterStereus"

Posted: Tue Sep 16, 2014 7:11 am

Hi misterstereus!
I do not have skype anymore ... And even webhost could not fix it, it seems that only xtreme nuke works on their server lol but you can say what the problem is and I will try to upload ravens distro again and install

Posted: Tue Sep 16, 2014 7:17 am

Personally, I think it's something with the forum Å Ä Ö works in ravens distro but the Forum looks F-UP and i have test atleast 5 diffrent Character Sets and Collations setups

Posted: Tue Sep 16, 2014 10:26 am

You can see it here in this thread. It works! This installation is a RN251 and i have it tested on my WAMP with a fresh install and don't get this issue.

What is happen if you are using the specialchars in article titles of the News module?