After Upgrading from 5.2 to 5.31

[mackers8923]

I'm currently getting this error when browsing the gallery:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/mackers8/public_html/gallery/forums/vb3.php on line 173

Now I'm running Vb 3.6 RC1 and like I have said I just completed an upgrade of photopost. Is the vb3 file causing the issue?

[Chuck S]

Check to ensure you have not deleted one of your profile fields specifically the field2 field from the userfield table.

[mackers8923]

Field 2 still exists anything else I should check?

[Chuck S]

well you have a url for me to see? You can also as admin set in global option your debug setting to display errors. That way you will know what it is not finding when its looking for the profile info from a user when your viewing a photo. Given your error this is what I am assuming is happening since that line deals with grabbing a users profile data

[mackers8923]

http://www.sccportal.org.uk/gallery

You might need to look at a few pics to get it to work chuck, I have tested today and the error had gone. That is until I had clicked through about 4 or 5 images.

[Chuck S]

You need to find out specifically what is not being found in your vb tables.

Are you when logged in as admin shown the error? You have set display errors to on yes?

The error is only going to happen on photos with comments

[mackers8923]

Thanks Chuck

[Chuck S]

Once you see the sql printed on screen you can see whats missing on the vb tables.

You can try changing this code below from pp-inc.php to print out the error if your not seeing in when logged in as admin

Content visible to verified customers only.

change to this

Content visible to verified customers only.

[mackers8923]

Thats a great help will try shortly. Thank you

[mackers8923]

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/mackers8/public_html/gallery/forums/vb3.php on line 173


Ummmm Same error no further on!!

[Chuck S]

If you have display errrors set to on and have removed the code meantioned your script should die and give you the exact error. You might need to PM me your ftp info

[mackers8923]

Details Sent Chuck

[Chuck S]

You forgot to turn on display errors in global options like I said Your error is plain as day now and is exactly what I said it is. Your userfield table in vbulletin is missing the column in that table called field2 which is a default vbulletin field. You need to add that field to the mysql table noted.

http://www.sccportal.org.uk/gallery/...php?photo=2237

[mackers8923]

1st class instructions Chuck, thank you for your help today. Very much appreciated.