WebsiteBaker Logo
  • *
  • Templates
  • Help
  • Add-ons
  • Download
  • Home
*
Welcome, Guest. Please login or register.

Login with username, password and session length
 

News

WebsiteBaker 2.13.6 is now available!

Will it continue with WB? It goes on! | Geht es mit WB weiter? Es geht weiter!
https://forum.websitebaker.org/index.php/topic,32340.msg226702.html#msg226702

The forum email address board@websitebaker.org is working again
https://forum.websitebaker.org/index.php/topic,32358.0.html

R.I.P Dietmar (luisehahne) and thank you for all your valuable work for WB
https://forum.websitebaker.org/index.php/topic,32355.0.html

* Support WebsiteBaker


  • Home
  • Help
  • Search
  • Login
  • Register

  • WebsiteBaker Community Forum »
  • WebsiteBaker Support (2.10.x) »
  • General Help & Support »
  • Language issue with minislider
  • Print
Pages: [1]   Go Down

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

Offline rumen

  • Posts: 480
  • 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,
Logged

Offline jacobi22

  • Betatester
  • **
  • 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
Logged

Offline rumen

  • Posts: 480
  • 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
Logged

Offline jacobi22

  • Betatester
  • **
  • 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>
Logged

Offline rumen

  • Posts: 480
  • 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?
Logged

Offline jacobi22

  • Betatester
  • **
  • 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
Logged

Offline rumen

  • Posts: 480
  • 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
Logged

Offline rumen

  • Posts: 480
  • 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 :)
Logged

Offline rumen

  • Posts: 480
  • 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
Logged

Offline jacobi22

  • Betatester
  • **
  • 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
Logged

Offline rumen

  • Posts: 480
  • 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.
Logged

Offline jacobi22

  • Betatester
  • **
  • 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.
Logged
  • Print
Pages: [1]   Go Up
  • WebsiteBaker Community Forum »
  • WebsiteBaker Support (2.10.x) »
  • General Help & Support »
  • Language issue with minislider
 

  • SMF 2.0.19 | SMF © 2017, Simple Machines
  • XHTML
  • RSS
  • WAP2