Other people's images appearing in albums

[dpnow]

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

[Chuck S]

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

[dpnow]

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

[Chuck S]

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

[dpnow]

Originally Posted by Chuck S

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