upgraded to Mysql 5, now getting error

[Johnny Doomo]

How can I remove the error that is appearing at the top of my site: http://www.gamersgallery.com/gallery/

The error reads:

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

I am sort of in a hurry on if this can be fixed quickly or not. Basically my host is switching my server and they backed up my database then upgraded my mysql to 5 to see if we should put mysql 5 on the new server or not.

I need to know if this error can be fixed or if I need to stay with the previous version of mysql I had on the old server.

I am running PP 6.01

Please let me know ASAP.

Thank you.

[Chuck S]

Is that a test install or a new install?

I cant be sure of your error because your not using the latest code it would appear

[Johnny Doomo]

When I installed it, it was the latest code. It was a new install a few months ago or whenever 6.01 was considered new.

Should I be concerned about them putting mysql 5 on my new server and stick to what is working? If mysql 5 makes my sites run any faster I really would prefer to have mysql 5 on the server, but not if I'm stuck with this error on my gamers gallery site.

Can you tell me if there is a way to clear this error or is this error something I should be concerned about?

What do you recommend I do?

[Johnny Doomo]

they fixed it. nm.

[Chuck S]

Yeah I was gonna say mysql 5 is running on my site with no issues as well as others. I was just trying to figure out what query you where having issues with so we could assist.