[2.4.3 vb 3.7.1] mysql error - Unknown column 'places' - Bug in profile view

info5538 · June 15th, 2008, 07:32 AM

Running photopost vbgallery 2.4.3, vbulletin 3.7.1 patch 1, vbseo (latest)

Apparently if you try to view certain members profiles, the following mysql error is generated

Code:

Content visible to verified customers only.

Zachariah · June 16th, 2008, 11:14 AM

The error points to:
/forums/includes/vbgallery/member_complete.php

Code:

Content visible to verified customers only.

This allows the user to not show images in a category if there is a value added. "Do not show images in category XXXX"

In your error:

Code:

Content visible to verified customers only.

$notcat is replaced with "places, other"
- there should only be category ID numbers. EX: 1,3,5,6

Something within the profile page also has $notcat defined.
- Do you have any other add-ons / hacks install into your profile area other than VBSEO ?
- What users does it happen to ? (new members, all users in a group, or only a select few)

info5538 · June 16th, 2008, 11:06 PM

I do have the vbulletin blog installed, could that be the cause? I have a few other mods, but none that I see affecting the profile (other than vbulletin's blog product).

Zachariah · June 16th, 2008, 11:54 PM

As a test remove that line and see if all is ok.
If so we will explore further on what is mixed up.

I have the VB Blog, VBSEO, VBGallery, on my site also, but no errors.

Have you tested if this error happens on different usergroups.

What users does it happen to ?
- new members
- all users in a group
- only a select few