Music Collection Error 1064 Issue

geckonet
geckonet
Offline
1
Hi,

On some, but not all links to songs I'm getting this error:

1064
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 5 SQL=SELECT s.name, al.name as album_name, ar.letter, ar.artist_name FROM #__muscol_songs as s LEFT JOIN #__muscol_albums as al ON al.id = s.album_id LEFT JOIN #__muscol_artists as ar ON ar.id = al.artist_id WHERE s.id =

Here is an example link.

http://surfrockradio.com/music/i/the-incredible-catheads/the-incredible-catheads/home/geckon5/public_html/surfrockradio.com/songs/incredible-catheads/02.-on-a-razor-s-edge.mp3

Regards,

Mike
Responses (10)
  • Accepted Answer

    Monday, March 20 2017, 10:55 AM - #Permalink
    0
    hello

    well, there's some wrong URL here.

    have you changed Music Collection's songs server path?

    this part should not be showing: home/geckon5/public_html/surfrockradio.com/songs
    The reply is currently minimized Show
  • Accepted Answer

    geckonet
    geckonet
    Offline
    Monday, March 20 2017, 04:37 PM - #Permalink
    0
    No, in configuration it is set to /songs and under plugins it is blank.

    Please visit this page and see what is happening when and individual song is selected.

    http://surfrockradio.com/music/i/the-incredible-catheads/the-incredible-catheads
    The reply is currently minimized Show
  • Accepted Answer

    Monday, March 20 2017, 05:07 PM - #Permalink
    0
    please, can you send me joomla admin access so I can take a look at the configuration?
    The reply is currently minimized Show
  • Accepted Answer

    geckonet
    geckonet
    Offline
    Tuesday, March 21 2017, 04:31 AM - #Permalink
    0
    Sent as a PM
    The reply is currently minimized Show
  • Accepted Answer

    geckonet
    geckonet
    Offline
    Monday, March 27 2017, 01:51 PM - #Permalink
    0
    Hi

    Any update on this? If you were not able to login before I have deactivated the other admin account for you.
    The reply is currently minimized Show
  • Accepted Answer

    geckonet
    geckonet
    Offline
    Monday, March 27 2017, 01:52 PM - #Permalink
    0
    Typo. That should be reactivated.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, March 28 2017, 09:26 AM - #Permalink
    0
    well the problem seems to be in sh404sef extension. the links are not correctly generated.

    try to remove all URLs generated for Music Collection and let the system re-generate them again.
    The reply is currently minimized Show
  • Accepted Answer

    geckonet
    geckonet
    Offline
    Tuesday, March 28 2017, 04:04 PM - #Permalink
    0
    I don't know how to do this. Can you give more specific instructions?
    Which URLs?
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, March 29 2017, 09:45 AM - #Permalink
    0
    sh404sef is creating the URLs in your site.

    go to this extension, and select it to NOT process the URLs from Music Collection...
    The reply is currently minimized Show
  • Accepted Answer

    geckonet
    geckonet
    Offline
    Wednesday, March 29 2017, 04:38 PM - #Permalink
    0
    I think I have deactivated that specific function, but that also deactivates search engine friendly URLS on everything. That's not the solution I need.

    Please login and find a way to make this work - it's not all tracks that display incorrectly, just a few. However i can not say what the pattern is.
    I am reactivating Sh40SEF for musicollection in the interim.
    The reply is currently minimized Show
Your Reply