PP trouble finding VB user info? (But classifieds pulling it just fine)

[RobertBasil]

Running VBuletin 3.5.1 - Photopost 5.21 - Photopost Classifieds 2.4.2

The calssifieds is running great, no problems at all.....

The Photopost is having some kind of trouble pulling the user data from the VB database when viewing a photo.

Here is the error I am getting:

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

Here is line 142:

Content visible to verified customers only.

Depending on the image sometimes I will get the error once and sometimes I will get it 5-8 times in a row at the top of the page.

What's weird is that the Classifieds program has the same exact code in it's vb3.php file and it has no problem.

I noticed that the only thing displayed in the profile area of each comment is the users IP address. So it does look like PP is having problems pulling the VB user data from the VB database.

I've checked and rechecked everything. I have the correct VB license number in the settings (same number I have in the classifieds settings which is working).

I even tried using the vb3.php from the classifieds for the photopost setup but still no luck. I know the VB database is ok as the forum is fine and also the classifieds script is pulling the data with no errors and PhotoPost is pulling the correct user info when viewing the thumbnails. It's only having problems when viewing the photos.

Any ideas Chuck?

Thanks in advance for any help you can provide.

[Chuck S]

Hello looks to me like your vb3 is hacked

Your ufield2 field is missing from userfield database table so the query above is failing right

I would think your going to have the same problem in classifieds, basically your viewing a photo with comments right

[RobertBasil]

Originally Posted by Chuck S

Hello looks to me like your vb3 is hacked

Your ufield2 field is missing from userfield database table so the query above is failing right

I would think your going to have the same problem in classifieds, basically your viewing a photo with comments right

Yes, I am viewing a photo with comments.

The classified work 100%. I can also view the gallery comment posters username while viewing the index of the gallery and also while viewing the thumbnails. The only time I get the error is after clicking on one of the thumbnails and viewing in medium and full size image mode.

I looked in my VB database in the userfield table and see the following fields:

userid
temp
field1
field3
field4
field5
field6
field7
field8

So the field2 is missing. But what I don't understand is I just checked my backup database that was working perfectly with the gallery before the upgrade from 4.83 and it also does not contain a field2 in the userfield table.

[Chuck S]

Well it should not work with classifieds either

Try placing a comment on an ad and see what happens

Basically field2 on that database table is the user's location field and exists in a stock Vbulletin and we code our program for a stock install.

You need to either code our query to look at the proper field that contains user location or add back in that field so the query can complete

[RobertBasil]

The location has been changed in VB. I now have a city, state and country. Weird that the 4.8e version had no problems with it.

How can I had the field2 back to the vb database? I'll add it back and just leave it blank for all users.

[RobertBasil]

Nevermind, I just changed VB3.php to look in field6 (users state) instead of field2.

For anyone else having this problem this is what I changed in vb3.php

line 122

Change this:

Content visible to verified customers only.

to this:

Content visible to verified customers only.

Thanks for your help Chuck!

[Chuck S]

Yep was just gonna post you can change the field2 to another one

[CavySpirit]

Thank you, thank you, thank you!! I'm having the same problem in Classifieds.

This would be a rather typical change for Classifieds especially, as it's almost a given you have to get more granular on location, and you sure as heck don't want to burn up those very precious 6 user fields on address junk, especially as address stuff is by user, not by ad. I think this little tidbit should be documented in the installation manual somewhere.

I've just spent some time tracking it down.

[rcull]

I have this error and tried to follow the correction, but it would not work for me.

I found the field2 in the vb3.php on line 173 instead of 122. There was a query on 122, but didn't mention field2. I changed the query on 173, but it just changed the error to field 6.

I had been running a spam field for a long time, deleted it and then replaced it because it was needed. This may have been the source for this problem.

Thanks!

[Chuck S]

There is most definitely depending on your product a field2 column in the query to get user info as thats the location field

My suggestion if you get an error is view your vb database under the userfield table and make sure field2 exists.

[rcull]

The field does not exist.

I find:
userid, temp, field1, field3, field4, field13, field67, field68, field43, field70

I suppose I have to create a field2 somehow. I know the admin cp will allow me to create a field, but it won't allow me to designate a number. So once it is created, I would have to rename it.
or I have to learn what these high numbered fields are and rename it?

Thanks

[Chuck S]

The field exists in a default vb. You need to either alter or coding to remove it or more importantly add it back

http://www.photopost.com/forum/1179129-post5.html