Bug with encoding filenames to UTF-8 in jD3.2.16 [Fixed in 3.2.18]

[Makulia]

What for a language have you activated in Joomla?

Russian Frontend and Backend.
I have tried to switch to English. The same result!

[Arno]

The only different seems for me to be how is the filename stored in the db.
I have checked again the settings in my phpmyadmin and i have seen this setting (see pic)

I have for my tests only use english language in backend and frontend.
I will test it again with russian language. But it works for me without any special transliteration for cyrillic characters. So it does exactly what it shall do.


[gelöscht durch Administrator]

[Makulia]

With your settings file itself is uploading incorrectly.
So I believe problem is with php settings, not Mysql.
I can manually via PHPMA change file name in the DB, and it saves correctly.

[gelöscht durch Administrator]

[Arno]

Have you read my last posting above?

[Makulia]

Yes I have!
1) My DB settings are identical, pls look at SH
2) I have tried CP UI  in the English lang, it makes no difference.

[gelöscht durch Administrator]

[Arno]

What mean you with SH, and CP UI ?  
Control panel user interface?
but SH?

[Makulia]

Sorry, SH = Screenshot, CP UI - Control Panel User Interface.

[Makulia]

Update on this case! I have tested Jdownloads on another web-server with php running from php5-fpm and it worked like a sharm! My current web-server running with Apache2+mod_php
First, I sought that there is a problem in my php.ini config. I copy php.ini from php5-fpm and..problem is still exist.
My conclusions:
1) The problem is with mod_php.
2) The problem is with on of php modules.

[Arno]

Very good message! 
Can you describe a little bit more what exactly seems to be the problem on your first server?
The most users here are nor really server experts. 

[Makulia]

Sorry for the delay.
I was busy re-configuring my web server to the stuck Apache2.4+PHP5-FPM.
And guess what? Problem with encoding still in the place! Unbelievable! Investigation continues.

My first stuck was Apache 2.4 + mod_php. You know that we can execute php script in a number of ways. Apache, as web server, only receives requests and redirects it to the php interpreter. And in this step we have a several ways to redirect requests to the PHP interpreter.
First and most easy to config - through libapache2-mod-php5. But this approach has a number of disadvantages. You are unable to configure php environment individually for each of your php applications. Also you can only run all of your applications from a single user (Apache user, like www-data.www-data.). Apache2.4+ libapache2-mod-fastcgi +php5-fpm allows you to set php environment independently for each web-app and also runs them from a different users.

[Arno]

Very strange

Maybe should you look more at the database. You had described that in your case is the filename not correctly stored in cyrillic chars?

[Makulia]

No, it is not the DB itself, because:
1) I have attached you screenshots of my db. You can see that settings are correct.
2) All other Cyrillic names are stored in the DB without problem (User names, Article Titles, Jdownloads category titles). Problem is only with Jdowloads filenames. And that is really wired. As I have already told, if you replace filename in the DB manually, Jdownloads works correctly.
Problem rises only when file name of Jdownload file is saving to DB. Could you, please, point me in the exact place in the code, where storing to the DB takes place, just in case.

[Arno]

Go to /administrator/components/com_jdownloads/tables/download.php function checkData()
Here is the files handling.

[Makulia]

Thank you, I will check it out.

[Makulia]

I have a new clue. I have created VM with Ubuntu 14.10 , php 5.5, mysql 5.6.
And stuck with the same bug. I have changed mysql to 5.5, no result. I have also unloaded almost every modules from php setup, replace php.ini config and mysql config with one from working server.
No effect! It seems to me, that probelm is with php 5.5. My second config has Ubuntu 13.04 and php 5.4.9 and your config has even 5.3.28.
May be it is the bug inside the php or in a newer php version something changes related to encodings, so old approach is not working correctly!
Pleas confirm, which version of the php do you use in your dev environment? Do you use ubuntu packs or build php from sources (phpbrew maybe)? It would be great, if you can test Jdownloads with php 5.5!
Could it be some issues with php5.5 according to this: http://php.net/manual/ru/migration54.incompatible.php?