Warning: mysql_fetch_row() pp-inc.php on line 2836
 

After upgrade Im getting these errrors while uploading

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/domain/public_html/photopost/pp-inc.php on line 2836

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/domain/public_html/photopost/pp-inc.php on line 2845


line 2836 is

list( $lastphoid, $lastphoby, $lastphobyid, $lastphotime ) = mysql_fetch_row($lastp);


line 2845 is

list( $lastpostby, $lastpostbyid, $lastposttime, $lastpostlink ) = mysql_fetch_row($lastc);

Have you ran all upgrades you needed to?

What did you upgrade from what version?

I think so - I didnt check the version first ...

I reran from 5.2 up ....

well what site is this?

You have 4 licenses and i have viewed every last one of those sites and none of them have that error

Okay someone elses site not yours

Your link is wrong above I think you mean this photopost but you have it closed so I cant see anything

http://www.nloc.net/photopost/

I closed it to prevent potential DB damage
Its open now

I am not seeing any mysql errors on that site

While uploading or deleting a file I get the above errors

Doug

I would suggest you reupload all core files and rerun upgrades 5.0 thru the last one no reason I would see that those queries would be wrong

I went ahead and deleted everything BUT the data folder and then uploaded 5.6x files and ran the upgrade.pho from 5.0 on and only saw one error that wasnt a result of the changes already existing

it was

it appears the table prefix was left off this command

Still getting same error on upload and on delete

Interesting try turning on display errors in the debug setting in global options and tell me the exact error

uploading error

What cat are you trying to upload to?

You can post a test user login here as well

Trying to understand what your doing would help because I see no forseeable reason why you would get that error.

Why is category 500 in that query thats what I want to know obviously your trying to upload somewhere else besides the members gallery because there is a separate set of queries if its the members gallery.

Looks to me somewhere in your categories the children variable is not right.

Try editing your cats and saving them to update the children fields

I wasn't doing anything special
I simply clicked upload and then picked a picture and clicked upload

- the good news is that after taking your recommendation of adding a test cat and saving and for good measure updating the user groups from the forum the issue seems to be gone

THANKS !!!

Yep your child field seemed to be fubared