Error Code when Users Post Comments(NOT A BUG)

[rcwild]

Gallery seems to be working fine, except ...

When users add a comment or rate a photo, error code appears at the top of the page. Most recent:

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

[Michael P]

We'll need some info on your setup...

[rcwild]

What info?

[Chuck S]

Hello looks to me like you have altered your vb3 default profile structure in your vb3 admin

We look for the user location field in the userfield table field2. If you have changed/deleted profile options you may need to update our vb3.php file and correctly alter the query to the user field location is stored at. We code queries based on default installations.

[rcwild]

Uh ... I have no idea what you just said. I'm not a programmer.

I haven't altered anything. Our website uses a CMS program called Subdreamer that integrates with vB. Any chance Subdreamer changed something?

What should I look for to fix?

[Chuck S]

I stated above what to look for Let's see if this is easier to understand.

The most likely culprit is you have deleted the field2 field from the database table userfield

Use phpmyadmin to view that table and see that there is a field called field2

[rcwild]

There is a table called vb3_userfield. It does not have a field called field2. It has temp, field4, field5, etc.

[Chuck S]

Okay and thats your issue as in a normal VB3 there is a field called field2 which holds the user location.

You need to do one of two things. Either add a field2 back into that database table so you will not get an error anymore or alter the query in our file to point to a database field that has the user location. I think just adding a field2 back into the table would be easiest for ya through phpmyadmin

[rcwild]

Thank you for all your help.

I added the field to the table, then posted a couple test comments. I don't see any error code now, so it seems to have worked. I'll ask a few users to test it, too.