No valid database connection...

0
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 '' at line 1 SQL=SELECT tag_name,icon FROM jos_muscol_tags WHERE id =

This is the error that I got when I choose album by artist. You can see error on this URL [url]http://beta.thesonofman.org/index.php?option=com_muscol&view=album&id=3&Itemid=29&lang=en[/url]
Can you help? Please :)
Responses (12)
  • Accepted Answer

    Sunday, April 05 2009, 07:24 PM - #Permalink
    0
    mm... did you add any "tag" to this album? it seems like this error is trying to get some tag data on the database, but as you can see, the "id" property is missing.
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, April 05 2009, 07:31 PM - #Permalink
    0
    also tell me if you know it your PHP version and your MySQL version
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, April 05 2009, 07:37 PM - #Permalink
    0
    No I did not add any tag, I will. Regarding server software PHP version is 5.2.9 and MySQL version is 5.0.75-community-log.
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, April 05 2009, 07:41 PM - #Permalink
    0
    mmm.. I'm checking the code and this error should not appear... I think this must be something related to PHP version.
    anyway, tell you what: I'll send you two PHP files (to your mail), and you replace those you have now with the ones I send you. I just added a sligh modification, to see if we can avoid this issue.

    ok?
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, April 05 2009, 07:48 PM - #Permalink
    0
    Ok, by the way I'm working on XMAP plugin for MC right now :)
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, April 05 2009, 08:21 PM - #Permalink
    0
    for anyone reading this thread:

    if you have this error discussed here, just leave a post here saying it. it's very easy to solve, it is related to PHP version
    The reply is currently minimized Show
  • Accepted Answer

    Friday, September 18 2009, 04:24 PM - #Permalink
    0
    the same problem form me:
    No valid database connection...


    please can you send me those 2 php files?

    my system is:

    Database Version: 4.1.22-standard-log
    Database Collation: utf8_general_ci
    PHP Version: 5.2.2
    Web Server to PHP interface: apache
    Joomla! Version: Joomla! 1.5.10 Production/Stable [ Wohmamni ]



    thank you!
    The reply is currently minimized Show
  • Accepted Answer

    Friday, September 18 2009, 04:27 PM - #Permalink
    0
    hello,

    Where do you get the error? when you try to create a new album or artist?

    Germi
    The reply is currently minimized Show
  • Accepted Answer

    Friday, September 18 2009, 04:43 PM - #Permalink
    0
    when displaying Standard Album Layout
    but this error is present just when i don't select any album from backend, jist like in picture http://www.joomlamusicsolutions.com/images/fbfiles/images/music_player2.jpg
    Attachments:
    The reply is currently minimized Show
  • Accepted Answer

    Friday, September 18 2009, 04:46 PM - #Permalink
    0
    of course... you should select an album!! if you dont, the system does not know what album to display

    but what I really recomend you is NOT to acces MC this way, but creating a menu item of typ "Artists", not "Album".

    believe me, this is the best way! :) try it and tell me something
    The reply is currently minimized Show
  • Accepted Answer

    Friday, September 18 2009, 04:54 PM - #Permalink
    0
    it is perfect, thank you!
    The reply is currently minimized Show
  • Accepted Answer

    Friday, September 18 2009, 04:55 PM - #Permalink
    0
    glad to help :)
    The reply is currently minimized Show
Your Reply