mysql error with comments

creekdawg · June 17th, 2005, 08:06 PM

It seems i have this error everytime a user adds a comment, so if there is 3 comments then i'll have 3 errors just like this? Any ideas?

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

Another issue when someone post a comment it just shows there IP not a username? Is this related?

creekdawg · June 17th, 2005, 08:19 PM

this is the code from vb3 file that it is complainging about

Code:

Content visible to verified customers only.

creekdawg · June 17th, 2005, 09:42 PM

Do i need to use a different inc_photopost.php then what orginaaly came with pp for use with vb3 and pp

Chuck S · June 18th, 2005, 07:40 AM

Line 146 is this

list( $cuser, $chomepage, $ctitle, $cposts, $regdate, $clocation, $conline, $csig, $avpath, $hasav, $avrev ) = mysql_fetch_row($results);

More than likely you have deleted the field2 column in the userfield table of vb. You need to modify our integration file to point to the proper table and field that now holds the location field for the user profile since your VB has been changed from the default.

creekdawg · June 18th, 2005, 02:51 PM

How might that have happened? I just installed it and havent deleted anything that i am aware of. How would I go about doing what you suggested? thanks

creekdawg · June 18th, 2005, 02:59 PM

I think i might know but need some expert advice.

I made a few cutoms feilds in the user profile section and deleted the location option, since it ask's for location in that code could this be breaking it?

creekdawg · June 18th, 2005, 03:03 PM

well I tried that and that wasnt it

Chuck S · June 18th, 2005, 03:22 PM

Exactly!! You hit the nail on the head on what I said above.

We code our integration to the default VB code meaning yep we look for location. If you delete it or love it to another profile field you would need to update our forum integration file vb3.php accordingly

creekdawg · June 18th, 2005, 08:45 PM

Anyone know what the mysql statemeant would be to insert the default vaules for the userfeild to match the default vb3.php file in the pp/forums dir?

Chuck S · June 18th, 2005, 09:27 PM

You would alter your profile query but I dont know what you changed your location field to so I cant help without that info