Failure of user profile in some translations

[GoogleCodeExporter]

In http://opencaching.pl/viewprofile.php?userid=
and translations FR, DE, SV, CZ user profile (for all users) show strange data.
Signé up : 1970-01-01
Pays:   e-mail a l'utilisateur
 Voir la carte utilisateur  
descriptions-todo 
lastlogins-todo: user_not_active-todo

Even if user has created any caches, the list of user's caches is empty.

Original issue reported on code.google.com by etnam...@gmail.com on 14 Jan 2014 at 7:24

[GoogleCodeExporter]

this is two things in this error:

strange data (*-todo) is caused that we have no complete translation for 
specified language, this is no technical problem, we need translators to solve 
it.

sencond thing - missing user created caches section, need to be investigated. 
For me looks like still some language data is taken from database, not from 
language files. When there is no language in db, db returns nothing. Solution
If this diagnose is correct, solution should be refactoring of sql querries for 
this section.

Original comment by wloczynutka on 14 Jan 2014 at 10:52

• Changed state: Accepted

[GoogleCodeExporter]

Everybody "Signé up : 1970-01-01" is really quite strange, but has to do with 
refference from database, not translation itself.

Some of languages won't find any translators, as were not done since years. 
Maybe it will be better to remove flags?

Original comment by etnam...@gmail.com on 14 Jan 2014 at 9:48

[GoogleCodeExporter]

+1 for removing "exotic" translations (cs, es, fr, sv).

just take a look at the file size - all above are <25% of pl size, so the 
translations are very incomplete.

Original comment by marcin.w...@gmail.com on 15 Jan 2014 at 8:03

[GoogleCodeExporter]

When old caches are imported in database in the past there will be no count of 
finds, created, or notes. This is technical problem. If cache is made new all 
counts are made correct.

Please keep fr translation, this is neighbor country of oc.benelux. I try to 
find French translator 

Original comment by henricus...@gmail.com on 17 Jan 2014 at 7:51

[GoogleCodeExporter]

Fr should stay, especialy that south half of B use French.

etna&ars, 1970-01-01 is very well known date :-) this is equal to unix time 0. 
So if database return null as date, this is exactly converted to 1970-01-01 
human date.

I can give my head there is some db query trying to take lang translation from 
db.

Original comment by wloczynutka on 17 Jan 2014 at 3:30

[GoogleCodeExporter]

Original comment by wloczynutka on 17 Jan 2014 at 7:57

• Changed state: Started

[GoogleCodeExporter]

deployed to production.

Original comment by wloczynutka on 17 Jan 2014 at 8:20

• Changed state: Fixed