0
Hi,

When creating a menulink for a default artist layout I get the following error 1064:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 SQL=SELECT related FROM #__muscol_artists WHERE id =
Any idea what happens?

Regards
Dick Bronder
Responses (10)
  • Accepted Answer

    Tuesday, March 14 2017, 10:31 AM - #Permalink
    0
    did you select an artist?
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, March 14 2017, 10:36 AM - #Permalink
    0
    Yes, but it only happens with that artist not with others. Problem is that the site is centered around that artist.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, March 14 2017, 10:46 AM - #Permalink
    0
    can you send me access so I can check?
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, May 09 2017, 07:57 AM - #Permalink
    0
    Hi,
    Sorry but I still have an issue with this.
    The first link now works. But after clicking a letter in the search bar and then clicking on a artist I still go to an error page.
    When diving into the code I see the link gets an extra slash (see attached image). And I can't find where that happens.

    Regards
    Dick
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, May 09 2017, 11:50 AM - #Permalink
    0
    hello

    can you please make sure that the Music Collection SYSTEM plugin is placed on the LAST position of the plugin list?
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, May 09 2017, 11:56 AM - #Permalink
    0
    It is now. Nothing has changed though. Still has a double slash in front of the url in the code.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, May 09 2017, 11:58 AM - #Permalink
    0
    do you have cache enabled? if yes, please clear all cache and try again...
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, May 09 2017, 12:24 PM - #Permalink
    0
    Standard procedure to clean cache even when it's not enabled ;-) (including browser cache). Doesn't help :(.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, May 09 2017, 12:33 PM - #Permalink
    0
    By the way. I just checked. It not only happens when I click the artist but also when I do a search and click on the album or the number.
    For example if you go to: http://cvgoud.dbws-dev.nl/index.php?option=com_muscol&view=artist&id=1&Itemid=156&lang=nl and search for 'zomer' you get both an album and a number. Same thing happens.
    And if you delete one slash in the code you directly go to the right page. So I've searched for a file that used in all the views but then I don't have that much php knowledge.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, May 09 2017, 03:52 PM - #Permalink
    0
    ok thanks. Can you send me access to the backend?
    The reply is currently minimized Show
Your Reply