MySQL Error- lost images and comments

[rstarke]

I got this MySQL Error when a new user uploaded some new photos (I think)

An error was encountered during execution of the query:

SELECT bigimage,approved,cat,storecat,title,userid,width,height,date,filesize,rating,views,user FROM pp_photos WHERE id= LIMIT 1

The query returned with an errorcode of:

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 'LIMIT 1' at line 1

there are now missing images and comments on my PP board
not quite sure how this happened
Any sugestions?

[Chuck S]

Url to install? Is this a new install an old one?

[rstarke]

Yes this is a new install
http://www.paint-sculpt.com/gallery/index.php

[Chuck S]

Where are your categories?

I see you have modified your code and as such you might want to place unmodified files back on your server so that we may provide you product support.

[rstarke]

ok done
I have been looking into this problem further and it scemes that whenever new images are added I am losing old ones by order of date (IE. a new image is added and the oldest image is droped)
what the heck?
could this just be a setting in admin that I have set incorrectly?
http://www.paint-sculpt.com/gallery/index.php

[rstarke]

I think I found the problem
my members category had a limit of 30 images
so that is why images (and comments) were being dropped
I just don't understand where the My SQL error came from

[Chuck S]

Okay so your error is not there