https://bugzilla.wikimedia.org/show_bug.cgi?id=32661
Francis Hunger <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|WORKSFORME | --- Comment #12 from Francis Hunger <[email protected]> 2012-02-19 22:02:59 UTC --- First of all thanks to everybody for replying. Thanks a lot to Edward for the provisional fix. Markus, I think, with "bilingual" Edward in comment #9 meant simply, that we have an english install of MW at en.wiki-products.org and a German install of MW at de.wiki-products.org. But both run SMW. The latter (the German) has the problem with the comma values. Edward is however mistaken, when he assumes that these both version use the same database. They are two completely separated MW installs – one running with an English localisation and one with a German localisation. Regarding Markus' comment #7 I have again run SMW database update and repair via the Mediawiki SMW Admin Panel and in table "swm_atts2", row "value_xsd" there are still values containing a comma. So it unfortunately seems, that outdated values didn't get fixed (as suggested by Markus). In addition I have entered a new value containing a comma, which got written directly into the database. So if users enter a value containing a a comma as decimal seperator, the decimal seperator is not changed to whatever the database expects. In my database install, the "value_xsd" row is of a varbinary (255) type. For the record: the server runs with PHP 5.2.17 and MySQL 5.0.77 Also I have created a new value of the datatype "Quantity" and created a new wikipage and entered "23,23" for that value. Again the comma appears in the database in the smw_atts2 table, value_xsd row. So we can assume, that the problem doesn't lie in a changed datatype at some point in the past, as also suggested in comment #7. Of course I could replace all appearances of comma with a point directly in mysql, but mediawiki users are able to enter decimal comma values at any time. So we are still at the state of Ewards Comment #6. I hope that you understand, that under these circumstances I'm reopening this as a bug in the hope that a general solution and much better solution than "works for me" can be found. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
