Bug! Shows error after removing profilefield in vbulletin

[dutchbb]

Just discovered a bug with the vbulletin integration: when I remove a profilefield in vbulletin, photopost showphoto.php shows this error:

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

Script:

Query: SELECT u.username,u.homepage,u.usertitle,u.posts,u.joindate,uf.field2,s.host,t.signature,avatar.avatarpath, NOT ISNULL(customavatar.filedata) AS hascustomavatar,u.avatarrevision FROM user u LEFT JOIN userfield uf ON uf.userid=u.userid LEFT JOIN session s ON s.userid=u.userid LEFT JOIN usertextfield t ON t.userid=u.userid LEFT JOIN avatar AS avatar ON (avatar.avatarid = u.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = u.userid) WHERE u.userid=6885 LIMIT 1

Result: Unknown column 'uf.field2' in 'field list'

Database handle: Resource id #26

How can I solve this, as my gallery doesn't work now.

[Chuck S]

We code to a default vb and the location field is in field2 column in the vbulletin userfield table

Therefore if you delete this field you will get that error

The correct course of action and easiest would be to add field2 back in the vb userfield table.

You can do the harder thing and modify your get_profiledata function in vb3.php if you choose.

[simonc101]

Hi there thanks for the advise I tried it and it worked

But now there is a new issue with the comments.

When someones rates a photo it does not show the comments of that person but if someone does not rate the photo then the comments show for that person. if that makes sense.

Anyway can you help with this please.

[Chuck S]

Easy in your admin showphoto options you are electing not to show empty comments. turn this to off

[snoopy5]

Hi

I have the exact same problem as dutchbb. I deleted 4 profile fields within vb and get now this error when clicking on a photo within photopost.

Originally Posted by Chuck S

The correct course of action and easiest would be to add field2 back in the vb userfield table.

How do I do this within phpmyadmin?

Thanks in advance

[snoopy5]

here the screenshot...

[Chuck S]

This will help you make sure to add in any vb table prefix you use.

forums/vb3.php on line 173

[snoopy5]

Originally Posted by Chuck S

This will help you make sure to add in any vb table prefix you use.

forums/vb3.php on line 173

GREAT! Thank you very much! It is working again...

[Chuck S]

Not a problem glad to help