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

[Silver_2000]

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);

[Chuck S]

Have you ran all upgrades you needed to?

What did you upgrade from what version?

[Silver_2000]

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

I reran from 5.2 up ....

[Chuck S]

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

[Silver_2000]

Originally Posted by Chuck S

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

www.Nloc.net/gallery

[Chuck S]

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/

[Silver_2000]

Originally Posted by Chuck S

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

[Chuck S]

I am not seeing any mysql errors on that site

[Silver_2000]

Originally Posted by Silver_2000

After upgrade I'm getting these errors 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

While uploading or deleting a file I get the above errors

Doug

[Chuck S]

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

[Silver_2000]

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

Error performing MySQL command: UPDATE settings SET setting = 'Powered by: PhotoPost --replaceme--
Copyright 2007 All Enthusiast, Inc.' WHERE id=37
Error: Table 'usernameXX_vbulletin.settings' doesn't exist

it appears the table prefix was left off this command

Still getting same error on upload and on delete

[Chuck S]

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

[Silver_2000]

uploading error

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

Script:

Query: SELECT id,user,userid,date FROM pp_photos WHERE cat IN (1,500,) ORDER BY date DESC LIMIT 1

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 ') ORDER BY date DESC LIMIT 1' at line 1

Database handle: Resource id #22

[Chuck S]

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

[Silver_2000]

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 !!!

[Chuck S]

Yep your child field seemed to be fubared