0
I found a new bug involving keywords with non-latin UTF8 characters. I looked at the database structure and it seems to me that there should be two different keyword fields for these two tables:
1. jos_muscol_albums
2. jos_muscol_artists
MC by default fill out these fields using the following rules:
1. album name + artist name
2. artist name
As far as I understand, this is to facilitate the search function. However if either the album name or the artist name has non-latin UTF8 characters, the keyword is not inserted into the tables. This create trouble when searching for these non-latin albums/artists. I haven't found a way to solve this yet. Do you have any idea Germi?
1. jos_muscol_albums
2. jos_muscol_artists
MC by default fill out these fields using the following rules:
1. album name + artist name
2. artist name
As far as I understand, this is to facilitate the search function. However if either the album name or the artist name has non-latin UTF8 characters, the keyword is not inserted into the tables. This create trouble when searching for these non-latin albums/artists. I haven't found a way to solve this yet. Do you have any idea Germi?
Responses (17)
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
0OK I found the problem. It has to do with the get_keywords function in the files you mentioned. The call to JFilterOutput::stringURLSafe seems to mess up the encoding of the characters and they're therefore not added into the database. It looks to me that the strtolower function of JFilterOutput::stringURLSafe causes the problem.
If I take out the cal to JFilterOutput, the keywords are generated correctly. However would there be any security concern when doing so?
Thanks again Germi
-
Accepted Answer
0well, that JFilterOutput::stringURLSafe was precisely putted there to avoid strange characters: I didnt think in Chinese when I wrote it (never though that Music Collection would be used in Chinese! )
but nothing you have to worry about security (I mean, HTML entities, for example, or MySQL injections, are striped before that) -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
0I know that my subscription expired long time ago but just a few days ago I asked you how come I had a lot of errors installing the component.
As "marcap" it appeared "this is a verified customer".
Anyway it is not important.
Important is that you took off the "&" from the code (who knows why) and for sure you are not going to say what to do. -
Accepted Answer
0hello
I'm sorry to say but you're confused when you asked me a few days ago the user appeared as "not verified". actually I told you this!
please read the conversation: http://www.joomlathat.com/support/music-collection/joomla-2-5/problem-installing-in-localhost
you're probably confused, you saw MY status which is "verified" and you though it was yours
but yours did not show as verified at all that's why I told you. the subscription expired more than 1 year ago, it's simply not possible
I never took "&" from the code, it has ALWAYS been removed, from version 1.0.0
my friend, please try to be reasonable here, you're mistaken in 2 things! -
Accepted Answer
0here is a screenshot of our conversation, I think you saw my status "verified" (green) and you thought it was yours (red)Attachments:
-
-
Accepted Answer
0I did not made a mistake with you "green", I just, probably, thought that using "marcap" it was going to be "verified" even if my subscription was over.
About the "&": I didn't realize about it before because I was not using names of groups or album or whatever with that letter in it.
Very strange that it was never there. -
Accepted Answer
-
Accepted Answer
0Hello,
basically there's a function (well, a set of functions) on the file administrator/components/com_muscol/tables/album.php that "removes" all the special characters from the keywords field (like "&" and others), you need to get ride of that basically.
there you go.. free support..! please from now on consider renewing
best,
Germi -
Accepted Answer
0Thank you for your answer, anyway the solution was here and it helped me a lot.
http://www.joomlathat.com/support/music-collection/pre-buy-questions/greek-and-english-in-the-alphabet-search#reply-11836
Your Reply
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »