[#4116] - [#34056] indexer does not work properly in languages with different decimal notation
- Closed
- 10 Nov 2015
- Medium
- Build: staging
- # 4116
- Diff
- chrisdavenport:patch-5
- Foreign ID 34056
- Success The Travis CI build passed Details
User tests: Successful: Unsuccessful:
[#34056] indexer does not work properly in languages with different decimal notation
== Reproduce
Have a joomla site in a language that uses comma instead of a dot for decimal places (ex: Portuguese).
Turn on search indexer content plugin.
Edit a content item in the frontend and save.
It will appear an sql error like this
Column count doesn't match value count at row 1 SQL=INSERT INTO 29i8c_finder_tokens (term,stem,common,phrase,weight,context,language) VALUES ('a', 'a', 0, 0, 0,0667, 1, 'pt')
Note the "0,0667" it should be "0.0667" and the error is there.
jissues-bot
- | Status | Pending | ⇒ | New |
| Labels |
Added:
?
?
|
||
| Labels |
Added:
?
Removed: ? |
||
| Title |
|
||||||
I guess this change is needed in the other two database files as well?
nicksavov
- | Title |
|
||||||
| Labels |
Removed:
?
|
||||||
| Category | ⇒ | Multilanguage |
| Title |
|
||||||
| Status | New | ⇒ | Pending |
| Title |
|
||||||
| Title |
|
||||||
| Category | Multilanguage | ⇒ | MS SQL Multilanguage Postgresql Search |
| Title |
|
||||||
Copied steps to reproduce from joomlacode
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4116.
Hello @chrisdavenport
Thank you for your contribution.
The last comment here was on 4th January 2015. So the question is, Is this issue/pull request still valid?
If no reply is received within 4 weeks we will close this issue.
Thanks for understanding!
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4116.
| Status | Pending | ⇒ | Information Required |
Closing as this repo is removed. Here is a redo of the needed changes also for postgres and the mssql driver. Thanks @chrisdavenport
| Status | Information Required | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2015-11-10 21:30:57 |
| Closed_By | ⇒ | zero-24 |
| Title |
|
||||||
joomla-cms-bot
- | Title |
|
||||||
(updated title)