Two Database Error Messages

[Mikhal]

I've seen the following error messages while using Photopost:

Admin -> Order Images
If I choose a category that is set to not to contain thumbnails, I get the following:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT id,catname,thumbs,cattype,parent,thumbnail,sortorder FROM pp_categories WHERE id=notcat LIMIT 1

Result: Unknown column 'notcat' in 'where clause'

Database handle: Resource id #6

Perhaps it would be better just to display an error message saying there are no images in the category.

Also, if I have images in my upload queue and I click on the number in the upload page, I get this:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

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

Result: 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

Database handle: Resource id #20

[Chuck S]

Well lets see the second query in uploadphoto.php I dont see why it would happen since if your authenticating properly your userid should be defined however you can find the query noted here and replace with this one. Note I encapsulted the userid variable.

Content visible to verified customers only.

Lines 3559-3560 of adm-misc.php

Content visible to verified customers only.

replace with

Content visible to verified customers only.