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?
I will definitely try this but how do I do it? I go to vb ACP, then what?
ALTER TABLE userfield ADD field2 VARCHAR(75) NULL;
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?
should be alright
|All times are GMT -5. The time now is 07:21 PM.|
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0