I have image hosting script that shows mysql error every time new member signs up and do not have any image in his account.
Error looks like this:
Database error with function: Get Images
SQL: SELECT i.*, [login to view URL], [login to view URL], g.gallery_name, CONCAT('[login to view URL]',[login to view URL],'/', [login to view URL], '.', type) AS image_url, CONCAT('[login to view URL]',[login to view URL],'/', [login to view URL], '.jpg') AS thumb_url FROM images i LEFT OUTER JOIN galleries g ON i.gallery_id=g.gallery_id, users u WHERE i.user_id=u.user_id AND i.user_id=1 ORDER BY [login to view URL] desc LIMIT -5,5 mySQL Says: 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 '-5,5' at line 1
Need this to be fixed.
Escrow will be released when I test script on my server.
Regards
frula2005