Upload photo error

[bergmanb]

Using FusionBB 1.0
Using Photopost Pro 5.21
Using PHP 4.3.11
Using MySQL 4.0.16
----------------------------

I did extensive searches in the forums here looking for the same problem but i couldn't find one so I'm posting my problem now.

I do a new installation and integrate with FusionBB. On the first attempt I customized everything and tried to do a photo upload and got an error about permissions on the directory. After fixing that I am left with this error:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/tampains/public_html/gallery/uploadphoto.php on line 428

line 426, 427 and 428 shows this:

426: // And only do these if we are quick uploading...
427: $resulta = ppmysql_query("SELECT COUNT(*), SUM(filesize) AS fsize FROM {$Globals['pp_db_prefix']}photos WHERE userid=$upuserid AND storecat=0", $link);
428: list( $uploadchk, $diskuse ) = mysql_fetch_row($resulta);


After receiving that error I went and dropped all the Photopost tables from my database and re-started the install.php again. I use the out-of-the-box configuration and I still receive the same error.

Any ideas? Thanks for any help provided.

[Chuck S]

Well maybe some more info here like url to install?

maybe a test account for us to try an upload.

Please post the full error also. You can in admin global options set to display errors in debug setting. when logged in as admin you should get the true error.

I don't see anything that should be wrong here but the exact error here will help alot

How old is your download also?

[bergmanb]

Hey Chuck, sorry I forgot about the display errors info.

Here is what it shows.

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

Script: uploadphoto

Query: SELECT COUNT(*), 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 #7


I have created a test account: test/test
url: http://www.tampainsider.com/gallery/index.php

I do notice that the test account (normal user) doesn't have the same problem. I only get that error above when i'm logged in as admin trying to upload.

Thanks for the help. Need any more info?

[Chuck S]

Well are you using the latest download as have you tried downloading the code again and replacing all the files?