Database Errors

[Toxiedog]

This post should be here.

I have my vBulletin and ReviewPost in seperate databases. I have a the featured reviews box displaying on my homepage, but I also get 2 error messages at the top:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/bidsness/public_html/reviews/inc_reviews.php on line 56

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/bidsness/public_html/reviews/inc_reviews.php on line 107

I have set everything correctly in the inc_reviews.php file, and my prefix is set correctly in config_intr (rp_). My inc_reviews settings are as follows. I can't see what the problem is, as there is no 'could not connect to reviewpost database'.

//$link = mysql_connect ("localhost", "bidsness_reviews", "reviews1234") or die('I cannot connect to the database.');
//mysql_select_db ("bidsness_reviews")or die("Could not select reviewpost database");

At the bottom of inc_reviews.php:

// If you use reviewpost in a seperate database from vB, you'll need to reselect the vB database!
//mysql_select_db ("bidsness_forums");

I am running the latest version of vBulletin (3.5.4) with no hacks or mods

[Chuck S]

As the instructions state you need to uncomment those lines and fill out the variables when things when running in separate databases.

Uncomment means remove // from in front of the meantioned lines .

EXAMPLE

mysql_select_db ("bidsness_forums");

[Toxiedog]

Thank you Chuck. Genuinely didn't know what 'uncomment' meant. Just thought you had to replace the variables.

Doh