PhotoPost Community - Bug! Shows error after removing profilefield in vbulletin

PhotoPost Community (http://www.photopost.com/forum/)

- Photopost Pro Installation & Upgrades (http://www.photopost.com/forum/photopost-pro-installation-upgrades/)

- - Bug! Shows error after removing profilefield in vbulletin (http://www.photopost.com/forum/photopost-pro-installation-upgrades/124457-bug-shows-error-after-removing-profilefield-vbulletin.html)

dutchbb

April 16th, 2006 08:04 PM

Bug! Shows error after removing profilefield in vbulletin

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

Quote:

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

April 16th, 2006 09:17 PM

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

June 16th, 2006 06:24 PM

comments problem

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

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.B=0

Anyway can you help with this please.

Chuck S

June 16th, 2006 06:47 PM

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

snoopy5

January 8th, 2008 03:37 PM

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.

Quote:

Originally Posted by Chuck S (Post 1156552)

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

January 8th, 2008 03:47 PM

1 Attachment(s)

here the screenshot...

Chuck S

January 8th, 2008 04:09 PM

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

http://www.photopost.com/forum/showt...ghlight=field2

snoopy5

January 8th, 2008 04:21 PM

Quote:

Originally Posted by Chuck S (Post 1214058)

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

http://www.photopost.com/forum/showt...ghlight=field2

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

Chuck S

January 8th, 2008 04:29 PM

Not a problem glad to help

All times are GMT -5. The time now is 01:46 PM.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97