Subscribe via rss
Guest
or Ask a Question
Discussions
Add a reply View Replies (6)

Help plz plz plz!!

General
Tuesday, January 12 2010, 10:21 PM
JF
JF
Offline
0
Dear Germi,

I have the component installed on my website but I get the following error messages:


No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (display_group = '' OR format_id = '' OR format_id = '') ORDER BY yea' at line 4 SQL=SELECT jos_muscol_albums.id FROM jos_muscol_albums LEFT JOIN jos_muscol_format ON jos_muscol_format.id = jos_muscol_albums.format_id WHERE artist_id = AND (display_group = '' OR format_id = '' OR format_id = '') ORDER BY year,month

No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (display_group = '' OR format_id = '' OR format_id = '') ORDER BY yea' at line 4 SQL=SELECT jos_muscol_albums.id FROM jos_muscol_albums LEFT JOIN jos_muscol_format ON jos_muscol_format.id = jos_muscol_albums.format_id WHERE artist_id = AND (display_group = '' OR format_id = '' OR format_id = '') ORDER BY year,month



I've searched a lot on the forum but I could not find anyone with the same problem. maybe you can help me please?

the site with error messages: http://www.al-mawaddah.tv/index.php?option=com_muscol&view=album&Itemid=3&lang=ar
Responses (6)

  • Accepted Answer

    Germinal Camps
    Germinal Camps
    Offline
    Tuesday, January 12 2010, 10:31 PM - #Permalink
    0
    I need your music collection purchase transaction id to tell you how to solve this, I cant find it in our system. Can you give it to me? Thanks
    The reply is currently minimized Show

  • Accepted Answer

    Ali Shareef
    Ali Shareef
    Offline
    Tuesday, January 12 2010, 10:48 PM - #Permalink
    0
    germi wrote:
    I need your music collection purchase transaction id to tell you how to solve this, I cant find it in our system. Can you give it to me? Thanks


    hi, i am JF85 but this is my second username. so you can chek the id now.
    The reply is currently minimized Show

  • Accepted Answer

    Germinal Camps
    Germinal Camps
    Offline
    Tuesday, January 12 2010, 10:58 PM - #Permalink
    0
    ok

    you are trying to show an album without choosing any album. go to the menu item and choose an album in the parameters (on the right)

    I mean.. what album is suposed to show up if you dont select one¿? ;) ;)

    best,
    Germi
    The reply is currently minimized Show

  • Accepted Answer

    Ali Shareef
    Ali Shareef
    Offline
    Tuesday, January 12 2010, 11:05 PM - #Permalink
    0
    germi wrote:
    ok

    you are trying to show an album without choosing any album. go to the menu item and choose an album in the parameters (on the right)

    I mean.. what album is suposed to show up if you dont select one¿? ;) ;)

    best,
    Germi


    Yes but that is not the intention that I choose an album. I want this page show a list of all albums.
    The reply is currently minimized Show

  • Accepted Answer

    Germinal Camps
    Germinal Camps
    Offline
    Tuesday, January 12 2010, 11:09 PM - #Permalink
    0
    Theres no such view. Choose artists view for main MC page instead
    The reply is currently minimized Show

  • Accepted Answer

    Ali Shareef
    Ali Shareef
    Offline
    Tuesday, January 12 2010, 11:25 PM - #Permalink
    0
    germi wrote:
    Theres no such view. Choose artists view for main MC page instead


    thnx you're right and it works. Please check here: http://www.al-mawaddah.tv/index.php?option=com_muscol&view=artist&Itemid=3&lang=ar

    but how can I change the layout of the list of artists change. For example, a picture or more details of each artist artist in the artist list?
    The reply is currently minimized Show
Your Reply