Got a little problem just curious if anyone can help me out

[stelthius]

ok ive just installed a image uploading script, and it gives me this error

 

i know this isnt much to go from if anyone can help and does need any more information SQL wise of PHP wise let me know as i need to get this problem fixed A.S.A.P

 

 

Database error with function: Get Images

SQL: SELECT i.*, u.username, u.email, g.gallery_name, CONCAT('http://82.42.212.25/Image-hosting/images/',u.username,'/', i.name, '.', type) AS image_url, CONCAT('http://82.42.212.25/Image-hosting/thumbs/',u.username,'/', i.name, '.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 i.uploaded desc LIMIT -5,5

 

 

Kindest Regards Stelth

[sasa]

1st i see LIMIT -5, 5

[stelthius]

exactly why im so confused, first time ive ever seen it too

[sasa]

can we see this function

[stelthius]

Do you just want to view the site so you can see it your self an maybe get a better idea of what the problem is, if so its... {Link Removed}

 

 

 

thank you also

[revraz]

No, post the Get Images function.

[stelthius]

Here is the actual page script that is causing the problem, this is the page that does all the work when you want to view photos and galleries, {Link Removed}

 

 

Thanks rick

[stelthius]

ok i have done some fiddling around today and decided to make my self a premium user on my site, Then i noticed the error had changed to :-

 

 

 

Database error with function: Get Images

SQL: SELECT i.*, u.username, u.email, g.gallery_name, CONCAT('http://82.42.212.25/Image-hosting/images/',u.username,'/', i.name, '.', type) AS image_url, CONCAT('http://82.42.212.25/Image-hosting/thumbs/',u.username,'/', i.name, '.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 i.uploaded desc LIMIT '-30,30' at line 1

 

 

 

'-30,30' at line 1 used to be '-5,5' at line 1, So i decided to do some googling and i searched :-

 

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 ( i just removed this > '-30,30' at line 1 < )

and it braught up a few pages and one of them mention that the :::: 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 :::: is a bug in Mysql so im just wondering if any pro's or gur's in here have ever seen this before ?

[stelthius]

should i try going back to an older version of Mysql ?

[stelthius]

Ok im switching servers this Thursday/Friday so im going to install Mysql 4.0 and see if anything changes if not i guess im gonna try 6.0 as im running on 5.0 now ill post my results if no one has come up with a soloution before i change servers! Thanks Guys!

 

 

Thanks stelth