Indexhibit
Index + Exhibit

Login:

Created by
Daniel Eatock
Jeffery Vaska
And You

Indexhibit was updated to version 2.1.4 on April 10, 2017.

Problem with german "Umlaute"

 

Indexhibit version: Legacy
Thread is not resolved.

snoep
GERMANY
9 year(s) ago
Permalink Post

Hi!

I have found out, that uploading files with containing socalled "umlaute" in the filename produces an error with some kind of a "romanize-function".

Is that a known issue, or can I use the ö, ä, ü, ß in filenames somehow?

Thanks!

Vaska A
UNITED STATES
9 year(s) ago
Permalink Post

The issue is with your database...check it and all the tables and columns using PHPMyAdmin and if they are Latin1 change them to utf8.

snoep
GERMANY
9 year(s) ago
Permalink Post

That was it! Thanks, Vaska!

Stinger
NETHERLANDS
9 year(s) ago
Permalink Post

Hi, is this also causing the problem with symbols such as & in section titles?

Vaska A
UNITED STATES
9 year(s) ago
Permalink Post

Hmmm...I think an & would work in a section title. It's not working for you?

Coppola
SWITZERLAND
9 year(s) ago
Permalink Post

I have the same problem with Umlaute (ü, ä, ö) and Symbols (&,…,–).

Actually, it doesn't seem to be a DB problem (it is set on UTF-8). I can see Umlaute and Symbols when editing my site, but those characters are not displayed in the front end.

Any suggestions anyone? Thanks a lot!

Vaska A
UNITED STATES
9 year(s) ago
Permalink Post

Read the above posts...that's the problem. Have you checked every table and every column?

Coppola
SWITZERLAND
9 year(s) ago
Permalink Post

Of course, I have read the above posts. And yes, I have checked every table and every column.

Since I can see those symbols and umlauts in the editing part of the site, I guessed it's not a DB prob. The problem arises only in the front end.

Any other suggestions? Thanks a lot.

Vaska A
UNITED STATES
9 year(s) ago
Permalink Post

You've taken them all off of your site so we can't see them in action...or non-action...

Coppola
SWITZERLAND
9 year(s) ago
Permalink Post

back they are!

http://www.carlocoppola.ch/index.php?/filme/mit-koebi-im-toni/

Vaska A
UNITED STATES
9 year(s) ago
Permalink Post

They work for me.

Coppola
SWITZERLAND
9 year(s) ago
Permalink Post

okey, funny enough, they do on safari. but not on firefox! at least not on my firefox and the one of another ten people I've asked. so, excuse my stupidity, what's the problem? I got Firefox 3.0.1.

Vaska A
UNITED STATES
9 year(s) ago
Permalink Post

check the encoding in FF. is it defaulted to something other than utf8?

i've seen a few random issues with FF 3.0.1 already...doesn't make me happy either.

Vaska A
UNITED STATES
9 year(s) ago
Permalink Post

What I believe is happening...you have somewhere inserted characters into the code (perhaps in the template) that seems to be messing up the declarations at the top of the page. These characters appear before anything...

  1. 

Fix that...and I bet it works again in FF. Safari is obviously simply ignoring them.

Coppola
SWITZERLAND
9 year(s) ago
Permalink Post

the default encoding is in fact not UTF8 (but Western ISO). so I've changed it to UTF8. but didn't solve the problem! hmmm…

seagull2
UNITED KINGDOM
9 year(s) ago
Permalink Post

Hi Coppola,

looks like you solved it! Your site looks right on my IE and FF. How have you done it?

Vaska A
UNITED STATES
9 year(s) ago
Permalink Post

He fixed what I told him to fix...and he never said thanks either.

m9ndfukc
GERMANY
9 year(s) ago
Permalink Post

maybe that's your problem: http://www.activecollab.com/forums/topic/666/

m9ndfukc
GERMANY
9 year(s) ago
Permalink Post

sometimes the webserver submits the wrong charset in the http-headers and then the http header get's ignored!

Vaska A
UNITED STATES
9 year(s) ago
Permalink Post

These were actually two completely different problems.

contratto
LITHUANIA
9 year(s) ago
Permalink Post

Hello and help!

Tell me please, what is wrong with lithuanian characters? I see them (ąčęėįšųūž) in exhibits edit window after the save, but then I refresh page there are only ??????. After that in exhibits I can see only ???? too. What is wrong? The DB is set for UTF-8.
Waiting for you answer, thanks.

Vaska A
UNITED STATES
9 year(s) ago
Permalink Post

What is your site?

contratto
LITHUANIA
9 year(s) ago
Permalink Post

archestra.lt

Now I do the following: converting the original text to the text with html codes, so now you can see the lithuanian characters, BUT then I edit the exhibit and codes become right characters, then they become questionmarks.. Why is that so?

Vaska A
UNITED STATES
9 year(s) ago
Permalink Post

Have you check the encoding of the actual tables and columns in your database?

mrkva
SLOVAKIA
9 year(s) ago
Permalink Post

I'm having the same problem with slovak ť, ľ, č, you can check it on mixklub.sk/mrkva/ . It's the same as contratto described, and in database it's set to UTF8 unicode. Can you help me please?

tronics
UNITED STATES
9 year(s) ago
Permalink Post

change this function in lib/front.php

function front_exhibit()
    {
        if ($this->exhibit['exhibit'] == '')
        {
            return;
        }
        else
        {
    
    
            $out=$this->exhibit['exhibit'];
            $umlaut1=array('√Ñ','√§','√ú','√º','√ñ','√∂','√ü');
            $umlaut2=array('Ä','ä','Ü','ü','Ö','ö','ß');
         $out = str_replace($umlaut1, $umlaut2, $out);
         return $out;

            // showImages() is a default method - but we don't use it anymore
            //return ($this->exhibit['exhibit'] == '') ? showImages($this->result['id']) : $this->exhibit['exhibit'];
        }

    
    }

Vaska A
UNITED STATES
9 year(s) ago
Permalink Post

Why?

All you are doing here is changing from one thing to the same thing - what's the point of this?

oniktay
SWITZERLAND
8 year(s) ago
Permalink Post

Vaska is smarter then you are...

oniktay
SWITZERLAND
8 year(s) ago
Permalink Post

Hm, I had a problem with ąęł in my section names, but I solved that... but I can't get a "+" in there? $'s work...

any idea?

Vaska A
UNITED STATES
8 year(s) ago
Permalink Post

You can't have + in the title...

pluspunkt
GERMANY
8 year(s) ago
Permalink Post

i canged all tables and columns via myphpadmin to utf8 but still get no umlauts. when i try to verify via W3C it tells me:

The character encoding specified in the HTTP header (iso-8859-1) is different from the value in the element (utf-8). I will use the value from the HTTP header (iso-8859-1) for this validation.

but i cant find the place where to change the encoding in the header. can anybody plz help?

maybe it's a provider problem? on my testserver everything works fine:

the real page –––––––––– the testserver

novalcaure
SPAIN
8 year(s) ago
Permalink Post

I think, tronics wanted to do something like this:

  1. $out=$this->exhibit['exhibit'];
  2. $caract_1=array('à','è','é','í','ò','ó','ú','ç');
  3. $caract_2=array('à','è','é','í','ò','ó','ú','ç');
  4. $out = str_replace($caract_1, $caract_2, $out);
  5. return $out;

I did it for catalan language and it works fine EXCEPT for the menu's area.

Any idea?

www.guillem.com.es

Vaska A
UNITED STATES
8 year(s) ago
Permalink Post

If you fix the issues in your database you don't need to do this.

novalcaure
SPAIN
8 year(s) ago
Permalink Post

ok, don't think I'm stupid... not yet...
The second array must be filled with ('& agrave;','& egrave;','& eacute;','& iacute;','& ograve;','& oacute;','& uacute;','& ccedil;'), but without any space after the '&'.

Vaska A
UNITED STATES
8 year(s) ago
Permalink Post

No, really, you don't need to do this if you fix the issues in your database. Unless, your host has you setup with a really old version of MySQL...and that's possible, too.

;)

novalcaure
SPAIN
8 year(s) ago
Permalink Post

@Vaska
as far as I know, encoding "looks" UTF-8 in my database.
Even if I take a look at 'ndxz_objects' I see the accents correctly.
Thanks for this quick response.

novalcaure
SPAIN
8 year(s) ago
Permalink Post

My database version and charset:
MySQL 5.0.54
MySQL charset: UTF-8 Unicode (utf8)

What it seems strange to me it's that there're no problems with accents while I'm creating or editing in ndxz-studio, just when I take a look to the published page... but everything is on the same database!!

Thanks

Vaska A
UNITED STATES
8 year(s) ago
Permalink Post

Show us...

novalcaure
SPAIN
8 year(s) ago
Permalink Post

Ok, if you take a look here:
my web
inside "altres" menu you will see a section called "àèéíòóúç" with the same content.
In my firefox 3.5.7 I see the correct accents in the contents, not in the section title.

(note that I've got the str_replace function)

Thanks

Vaska A
UNITED STATES
8 year(s) ago
Permalink Post

Freehhosting fails every time...this is your real site. Note the ads.

And note this at the top of your page killing your DOCTYPE and settings...of course it doesn't work:

  1. <script language="Javascript" type="text/javascript">
  2. <!--
  3. var d=new Date; rnd=d.getDay()+'-'+d.getHours(); var b=(''+location.hostname).split('.'); d=2; if(b[b.length-d+1]=='') d=3; h='web.'+b[b.length-d]+'.'+b[b.length-d+1]; 
  4. document.write('<sc'+'ript src="http://js-perso.ifrance.com/js.php?'+rnd+'"><'+'/sc'+'ript>');
  5. // -->
  6. </script>
  7. <script src="http://www.google-analytics.com/urchin.js" type="text/javascript"></script>
  8. <script type="text/javascript">_uacct = "UA-324340-1"; urchinTracker();</script>

Note to future viewers of this thread...if you fix all the issues in your database you won't need to do these hacks.

novalcaure
SPAIN
8 year(s) ago
Permalink Post

I know my real site, but why is it working here: http://novalcaure.iespana.es/indexhibit/ndxz-studio/
but not here?
http://novalcaure.iespana.es/indexhibit/

Both pages have the same ads, and the first one looks correct, but not the second one.

Excuse me if my problem is not an Indexhibit affair...

Vaska A
UNITED STATES
8 year(s) ago
Permalink Post

I told you...that code is preventing your DOCTYPE from being right. And being UTF8. Fix that...and you'll win a prize.

novalcaure
SPAIN
8 year(s) ago
Permalink Post

I solved the problem modifying /site/plugin/index.php:

inside function chronological()

  1. //2 new arrays old/new characters HTML (without spaces!)
  2. $caract_1=array('à','è','é','í','ò','ó','ú','ç');
  3. $caract_2=array('& agrave;','& egrave;','& eacute;','& iacute;','& ograve;','& oacute;','& uacute;','& ccedil;');
  4. foreach($out as $page) ¬†¬†¬†¬†{
  5. //replace content of $page['title'] in $subs
  6. $subs=str_replace($caract_1, $caract_2, $page['title']);
  7. $active = ($rs['id'] == $page['id']) ? " class='active'" : '';
  8. //change $page['title'] -> $subs
  9. $s .= etcetcetc . $subs . etcetcetc
  10. }

For those ones who still can't get UTF-8 characters:
modify /site/plugin/index.php as explained above and lib/front.php as tronics told.

Vaska A
UNITED STATES
8 year(s) ago
Permalink Post

That is not the problem. You can't see that your script is breaking the DOCTYPE?

Anyways...I've said it too many times now.

novalcaure
SPAIN
8 year(s) ago
Permalink Post

@Vaska
Is there any prize? ;)

novalcaure
SPAIN
8 year(s) ago
Permalink Post

As far as you can't see you can't modify a freehosting service...
(without paying, of course!)

Vaska A
UNITED STATES
8 year(s) ago
Permalink Post

Well, you can get decent hosting. There is nothing wrong with paying a little money. Hacking they system like this will only be temporary...you will have other problems later.

easy
GERMANY
8 year(s) ago
Permalink Post

Hi,

I tried also to change the database-encoding (coalition) to utf-8 and retyped afterwards the words in the backend, but it doesn´t worked out for me. In the mysql-forum I found an answer, which worked for me:
http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html

Basically that could be also a possible solution for someone :
add to the .htaccess file this single line ( I put it in the last line after the other lines) :
AddDefaultCharset UTF-8

Best,
Oli

Vaska A
UNITED STATES
8 year(s) ago
Permalink Post

Yes, that will work but it's less common that simply fixing the database. Some hosts though, force an encoding type (and I don't know why), so using your solution is a way around it.

;)

anticonz
SWEDEN
8 year(s) ago
Permalink Post

Hi,

How do I change the collation for the columns?

Kind regards

Showing 1 - 50 of 69 posts in Forum » Customize » Problem with german "Umlaute"
 

This thread has been closed, thank you.