Author Topic: Language issue with minislider  (Read 5322 times)

Offline rumen

  • Posts: 452
  • Gender: Male
Language issue with minislider
« on: September 11, 2017, 12:44:09 PM »
With WB 2.10 I put minislider and the I want to use it in different laguages. With the English there is no issue, but with Cyrillic (Bulgarian) appeares only
Code: [Select]
???????????? ????? ??????????   instead of the text.

All other staff in Cyrillic is OK all over the website. Just in minislider I got that iproblem. How can I fix it?

Regards,

Offline Gast

  • Posts: 5920
Re: Language issue with minislider
« Reply #1 on: September 11, 2017, 12:55:09 PM »
looks like a wrong charset / table collation for this file or database table.
Where do you have this output? minslider description under or of the picture? or somewhere else?
is is possible to give a example line from the database (if its a stored text) ? important is here the tablestructure as sql-backup

if this text comes from a language file or somewhere from a hardcoded changes inside of a file (example: a echo in view.php), maybe the file is saved with the wrong encoding method - must be saved as UTF8 without BOM

Offline rumen

  • Posts: 452
  • Gender: Male
Re: Language issue with minislider
« Reply #2 on: September 11, 2017, 01:21:17 PM »
Look at the bottom of the picture here http://mktranslation.eu/pages/slider_test.php

Offline Gast

  • Posts: 5920
Re: Language issue with minislider
« Reply #3 on: September 11, 2017, 01:50:29 PM »
looks, that the module in my locale testdomain doesnt work correctly, it doesnt save any settings, the database table is empty  :-o :-o
i'll look at this

private hint: validate your template, maybe with W3C-Validator
a missing closing " at the end of this picture link can produce other errors in browsers with a stronger validation control (but has nothing to do with the char problem here)
Code: [Select]
<body background="http://mktranslation.eu/templates/mktranslation/images/l3.jpg>

Offline rumen

  • Posts: 452
  • Gender: Male
Re: Language issue with minislider
« Reply #4 on: September 11, 2017, 02:19:52 PM »
Thanks a lot for the advices buddy, will fix that. But the issue with the text of the pictures comes from other place. Maybe I have to add somewhere in view.php UTF-8?

Offline Gast

  • Posts: 5920
Re: Language issue with minislider
« Reply #5 on: September 11, 2017, 02:36:06 PM »
i work in locale test's with mysql-strict mode and in this mode, the add.php doesnt insert the entry for this section, because, there is no value for the field "texts" (our description)

if i work in non-strict-mode, everything works. the cyrillic letters are saved correctly in my database and the frontend display everything correctly in cyrillic letters,


so maybe something goes wrong at your server, please check the database table mod_minislider and here specially the structure like my picture (specially the collation - here the german word "Kollation" and the entry for this section (pic #2), specially the content of field "texts"





do you change anything in the module like new nivoslider-javascript-files?

the view.php use htmlentities to "translate" special chars - red marked in my quote

Quote
foreach($images as $img) {
      $text = isset($t[$i])? trim($t[$i]):'';
      echo '    <img src="'.$baseurl.$curdir.basename($img['file']).'" data-transition="'.$transition.'" title="'.htmlentities($text).'" alt="" />';
      $i++;
   }

you can try it without htmlentities like

foreach($images as $img) { 
	
	
$text = isset($t[$i])? trim($t[$i]):'';
	
	
echo 
'    <img src="'.$baseurl.$curdir.basename($img['file']).'" data-transition="'.$transition.'" title="'.$text.'" alt="" />'
	
	
$i++;
	
}


Quote
Maybe I have to add somewhere in view.php UTF-8?

we need to know first, what you use as table collation in this table. best way to found it out - export this table as sql-file, then we know, whats happend in the database. it looks for me like a different collation at the moment, maybe latin1_general

Offline rumen

  • Posts: 452
  • Gender: Male
Re: Language issue with minislider
« Reply #6 on: September 11, 2017, 02:47:30 PM »
In the site Code table is UTF-8, in the host callation is utf8_general_ci  and some modules have utf8_general_ci  other have utf8_unicode_ci. I don't know if there is difference between utf8_general_ci and utf8_unicode_ci

Offline rumen

  • Posts: 452
  • Gender: Male
Re: Language issue with minislider
« Reply #7 on: September 11, 2017, 02:55:32 PM »
The text field in module minislider in PHP admin is full with
Code: [Select]
?????????? ?????? ????????
Code: [Select]
????? ?? 1-???? ????????
????? ?? 2-???? ????????
????? ?? 3-???? ????????
????? ?? 4-???? ????????

I will try to cjange it there :)

Offline rumen

  • Posts: 452
  • Gender: Male
Re: Language issue with minislider
« Reply #8 on: September 11, 2017, 03:00:03 PM »
And guess what ..... on the host minislider has collation - latin1_swedish_ci

Offline Gast

  • Posts: 5920
Re: Language issue with minislider
« Reply #9 on: September 11, 2017, 03:07:18 PM »
Quote
The text field in module minislider in PHP admin is full with ........

its a translation problem, but dont use PHPmyAdmin to read the correct entry in sql-language. PHPmyAdmin is a browser and use the browser language settings to translate everything. if its not possible, to translate a char (maybe a unknow'n char are transmitted), the browser show's ???? for every char.

please use the sql-export, it show's the real entry in sql-language and without browser translation.

Quote
difference between utf8_general_ci and utf8_unicode_ci
i'm not expert for this. unicode is better in result sorting and general is a little bit faster. both collations are allowed, so it doesnt matter

Quote
And guess what ..... on the host minislider has collation - latin1_swedish_ci

you can change the collation to utf8_general_ci or utf8_unicode_ci  and add the description again

Offline rumen

  • Posts: 452
  • Gender: Male
Re: Language issue with minislider
« Reply #10 on: September 11, 2017, 03:40:12 PM »
Chaged collation, fixed and working!

Thanks a lot.

Offline Gast

  • Posts: 5920
Re: Language issue with minislider
« Reply #11 on: September 11, 2017, 06:50:44 PM »
 (Y) (Y) (Y)
thx for reply

P.S.:
i'm not sure, but i think, in the older wb-version's: if the module autor dont set the table collation and field collations in the module install, mysql use the default settings from this database. i have it on the german provider "strato" - there is latin1 the default collation for my database ( a old account)
newer modules or the wb-core since WB 2.8.3 SP6 use placeholders in sql-structure-files and utf8_unicode_ci as table collation then.