R. Ekin
R. Ekin
Offline
0
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:
Responses (6)
  • Accepted Answer

    R. Ekin
    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:
    The reply is currently minimized Show
  • Accepted Answer

    R. Ekin
    R. Ekin
    Offline
    Thursday, July 02 2015, 02:27 PM - #Permalink
    0
    And check this please.
    The reply is currently minimized Show
  • Accepted Answer

    R. Ekin
    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

    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
    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

    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
Your Reply