mysql_fetch_row(): supplied argument is not a valid MySQL result resource in
 

We've just purchased PhotoPost and have done a fresh install of 5.61 Build 28 Nov. Everything looks all right except for http://gallery.istyles.com/member.php?uid=1 that's giving this error:

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

I've been checking everything and all seems well. The table prefixes seem fine. vb seems nicely integrated other than the above error. Does anyone have any idea as to what might have gone wrong?

You should get the same error viewing a photo also.

Looks to me like your missing a vbulletin vital field for profile data most likely field2 in the userfield table and you need to add that back into that vbulletin table

You can confirm this by setting debug setting to display errors in your admin global options and viewing the page logged in as admin you will be shown the exact error.

You're right. I'm not sure how field2 disappeared but as soon as it was manually added back to the userfield table, the error disappeared. Thanks!

How do I do those instructions?
 

Hello,

I will definitely try this but how do I do it? I go to vb ACP, then what?

Thanks Chuck,

Nuguru :)

ALTER TABLE userfield ADD field2 VARCHAR(75) NULL;

Oops...field settings
 

Hello Chuck,

When I created the new field (prior to your last message), I put MEDIUMTEXT apposed to VARCHAR for the type, because that's what all the other fields are using. Will there be a problem with that?


Thank You,

Nuguru :)

should be alright