Multiple Genre ID on mod_muscol_albums

Thursday, July 02 2015, 01:00 PM

Offline

Hello,
I need to show on my home page this module but showing spesitic Genre ID.
When I write only 1 Genre ID number everything is ok. But if I would like to write for example ID numbers (4,5) it is not working I saw this error on home page:

1241

Operand should contain 1 column(s) SQL=SELECT al.*,al.points as points_to_display, ar.artist_name, f.format_name FROM aydm1_muscol_albums as al LEFT JOIN aydm1_muscol_format as f ON f.id = al.format_id LEFT JOIN aydm1_muscol_artists as ar ON ar.id = al.artist_id WHERE ( al.genre_id = 4,5 ) ORDER BY al.added DESC LIMIT 15

Check the screenshot.

How can I do it?

Thank you

Attachments:

GENRE ID.PNG

Responses (6)

Accepted Answer

R. Ekin

Offline
Thursday, July 02 2015, 02:27 PM - #Permalink
0

I saw every modules have a lot of problem...
For example check attached file.

I am explaining with ID;

For example, ID 6 is sub category's ID 1, right?

Why on this module when I add parameter "1" to Genre ID field and it is not include to showing sub category?

I see same stranges with all modules.
Now I am thinking what should I do?

Attachments:

Genres.PNG
The reply is currently minimized Show
Accepted Answer

R. Ekin

Offline
Thursday, July 02 2015, 02:27 PM - #Permalink
0

And check this please.

Attachments:

Recently Added Songs.PNG
The reply is currently minimized Show
Accepted Answer

R. Ekin

Offline
Friday, July 03 2015, 01:12 PM - #Permalink
0

When somebody will give an answer for my questions?
The reply is currently minimized Show
Accepted Answer

Germinal Camps

Offline
Thursday, July 09 2015, 11:57 AM - #Permalink
0

hello!!
sorry looks like I missed this post! my apologies. if you get a question unanswered, please feel free to email me directly. sometimes I miss posts on the forum..!

about your question: you would need to change a little bit the MySQL query of that module to allow multiple genre ID.

in this case it should be:

WHERE genre_id IN (4,5,6)

you have to use the "IN" clause.
The reply is currently minimized Show
Accepted Answer

R. Ekin

Offline
Friday, July 10 2015, 01:21 PM - #Permalink
0

Thank you your answer where should I change that parameter?
The reply is currently minimized Show
Accepted Answer

Germinal Camps

Offline
Friday, July 10 2015, 06:04 PM - #Permalink
0

it's not a parameter, this needs to be changed on the CODE.
I asumed you are a coder... aren't you?

this is in the file /modules/mod_muscol_albums/helpers.php
The reply is currently minimized Show