Other people's images appearing in albums
 

Some of my users are reporting that they are seeing other people's pictures showing in their albums (PhotoPost 5.5/vBulletin 3.6.2).

Could this be related to an SQL error report I received the other day?:

An error was encountered during execution of the query:

SELECT SUM(filesize) AS fsize FROM pp_photos WHERE userid= AND storecat=0

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 'AND storecat=0' at line 1

Ian

You have examples? The query above is from spiders viewing your site and I have posted in other threads how to surpress the error by encapsulating the $userid variable

http://dpnow.com/galleries/showphoto.php?photo=164

Andy only has three images in his gallery but there are more show in the thumbnails above.

Ian

those are thumbnail strips next and prev and are not designed to show just a users photos.

OK, I admit I'm still learning, but this is confusing me a little. Can I set that thumbnail strip to show just images from a user's gallery or album?


Ian