View Full Version : MySQL Error after new install
September 19th, 2007, 04:57 PM
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\Inetpub\vhosts\cougarvirtual.com\httpdocs\gallery\forums\vb3.php on line 177
New install of version 6
Error is displayed after upload of image or when clicking to view image in gallery. Forum does not have any cookie prefix set same as the forum tables.
Checked configs and they have all the correct settings.
Any idea's please?
September 19th, 2007, 05:28 PM
Also think its using photopost user system rather than the vb3 users, this was selected during install.
September 19th, 2007, 05:52 PM
Did you check the MySQL database and see if the tables where created during the install?
September 19th, 2007, 06:00 PM
? all the Photopost tables have been created inside its own DB yes! It would not display anything otherwise would it not!
September 19th, 2007, 06:35 PM
what page is that error on showphoto? If so your missing a vital vb3 field let me know so I can assist you further.
I think this might help but lets see
September 20th, 2007, 05:13 AM
The error happens when you;
Click on any image and after uploading new image when it displays.
The other issue (maybe) when clicking on members name next to image it is displaying what I guess is PP members details page and not the vb3 members details page? (can live with this as first problem is more of an issue)
September 20th, 2007, 10:00 AM
Your image is as I state in my thread link the profile data can not be grabbed for the users because your missing a profile field. More than likely field2 out of the userfield table of vbulletin. If you add the field back in your error will go away and users profile data will show.
September 20th, 2007, 02:54 PM
Thanks that did fix it... Question is how did it lose Field2, lol I did not remove it manually!
September 20th, 2007, 03:10 PM
You would have had to remove it from your vb profile admin setting up and deleting profile fields.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.