XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. 2.5.x Support 
  4.  / Xoops Core Translation and german characters
Register
1
goffy
Xoops Core Translation and german characters

  • 2016/8/2 4:40

  • goffy

  • Just can't stay away

  • Posts: 543

  • Since: 2010/12/27


Hi

I made german translation of xoops core.
All files are translated, also modules/system/language/german/modinfo.php (utf-8 without BOM)
... 
// Names of blocks for this module (Not all module has blocks) 
define("_MI_SYSTEM_BNAME2",   "Mitgliedsmenü"); 
define("_MI_SYSTEM_BNAME3",   "Einloggen"); 
define("_MI_SYSTEM_BNAME4",   "Suche"); 
define("_MI_SYSTEM_BNAME5",   "Wartende Übermittlungen"); 
define("_MI_SYSTEM_BNAME6",   "Hauptmenü"); 
...

Now I installed new fresh Xoops 2.5.8 and now I see e.g.
Mitgliedsmenü
or
Hauptmenü


ü instead of ü

website is
<html lang="de">


anyone an idea?
2
Mamba
Re: Xoops Core Translation and german characters

  • 2016/8/2 8:09

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


Link to the Website? There might be something in the headers that is confusing the browser. Did you try a different browser? I would just go step by step: a) is the proper string delivered from the page to PHP ? b) Is PHP sending the correct value to the page? c) is the browser receiving the correct value from the page, consistent with the given language value? Recently we had the issue with changelog text in the modules's About tab - I was sending it as UTF-8, but it was showing the funny characters. When you went through a similar process as above, I discovered that the ModuleAdmin was assuming that it is ANSI and was converting it:
$ret .= utf8_encode(implode('
', file($file))) . "n";
Since our current standard is UTF-8 for all pages, in the next version of XOOPS the "utf8_encode" is removed...
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs
3
goffy
Re: Xoops Core Translation and german characters

  • 2016/8/2 8:25

  • goffy

  • Just can't stay away

  • Posts: 543

  • Since: 2010/12/27


Hi mamba

Quote:
Link to the Website? There might be something in the headers that is confusing the browser.

local site for testing; html header is fine


already in table 'newblocks' I find
Mitgliedsmenü

so the error happens when creating/filling the base tables during installing xoops

if I change name and title into
Mitgliedsmenü
in table new_blocks everthing is show proper

I tried the same with fresh xoops 2.5.7.1: there it works
4
Mamba
Re: Xoops Core Translation and german characters

  • 2016/8/2 8:46

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


Please email me the German files, and I'll test it here...
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs
5
goffy
Re: Xoops Core Translation and german characters

  • 2016/8/2 8:52

  • goffy

  • Just can't stay away

  • Posts: 543

  • Since: 2010/12/27


you can download from https://www.transifex.com/xoops/xoops-258/language/de_DE/

Edit: sent also by mail
6
Mamba
Re: Xoops Core Translation and german characters

  • 2016/8/2 9:53

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


Quote:
Edit: sent also by mail

Didn't receive it yet....
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs
7
goffy
Re: Xoops Core Translation and german characters

  • 2016/8/2 10:09

  • goffy

  • Just can't stay away

  • Posts: 543

  • Since: 2010/12/27


tried once more

maybe file will be delivered by ship
8
Mamba
Re: Xoops Core Translation and german characters

  • 2016/8/2 10:20

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


OK, everything works perfectly here on my local WAMP installation.

Resized Image


I've done it with the latest version of XOOPS from GitHub, and tested with both PHP 7 and PHP 5.4.

Check the German strings in the database - maybe you have a wrong collation and they were stored in a wrong format?
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs
9
goffy
Re: Xoops Core Translation and german characters

  • 2016/8/2 10:31

  • goffy

  • Just can't stay away

  • Posts: 543

  • Since: 2010/12/27


maybe a problem of database?

XOOPS Version XOOPS 2.5.8
PHP Version 7.0.6
mySQL Version 5.5.5-10.1.13-MariaDB
Server API apache2handler
OS WINNT


table collation: utf8_general_ci

Database server:
Server: 127.0.0.1 via TCP/IP
Server type: MariaDB
Server version: 10.1.13-MariaDB - mariadb.org binary distribution
Protocol version: 10
User: root@localhost
Server charset: UTF-8 Unicode (utf8)


Server connection collation: utf8mb4_general_ci


XAMPP 3.2.2
10
Mamba
Re: Xoops Core Translation and german characters

  • 2016/8/2 10:48

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


It seems like there are some issues with your "utf8mb4_general_ci".

See these articles:

http://stackoverflow.com/questions/20411440/incorrect-string-value-xf0-x9f-x8e-xb6-xf0-x9f-mysql

https://mathiasbynens.be/notes/mysql-utf8mb4#character-sets

In the below article, he shows a picture where there are differences between individual columns

Resized Image


Maybe something similar is in your case, since XOOPS normally installs with "utf8_general_ci"

http://stackoverflow.com/questions/28540772/using-utf8mb4-in-mysql?rq=1

Why are you using "utf8mb4_general_ci" at all? I always use just the " utf8_general_ci"

Yeah - it's always the same - wrong configuration, operator error, and then blame it on XOOPS! LOL
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs
(1) 2 3 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

488 user(s) are online (381 user(s) are browsing Support Forums)

Members: 0

Guests: 488

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits