View Full Version : Error Code when Users Post Comments(NOT A BUG)
September 4th, 2005, 07:19 PM
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
September 4th, 2005, 07:23 PM
We'll need some info on your setup...
September 4th, 2005, 07:38 PM
September 4th, 2005, 08:32 PM
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.
September 4th, 2005, 09:43 PM
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?
September 4th, 2005, 10:13 PM
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
September 4th, 2005, 11:31 PM
There is a table called vb3_userfield. It does not have a field called field2. It has temp, field4, field5, etc.
September 5th, 2005, 10:46 AM
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
September 5th, 2005, 12:13 PM
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.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.