rp3 integration into forumhome problem

ncg · August 28th, 2005, 12:27 PM

i keep getting these type errors:

Quote:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/hsphere/local/home/xx/reviews/inc_reviews.php on line 49

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/hsphere/local/home/xx/reviews/inc_reviews.php on line 63

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/hsphere/local/home/xx/reviews/inc_reviews.php on line 101

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/hsphere/local/home/xx/reviews/inc_reviewpost.php on line 99

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/hsphere/local/home/xx/reviews/inc_reviewpost.php on line 110

this error appears at the top of the page above the vb index content.

Chuck S · August 29th, 2005, 09:01 AM

Hello as noted in the instructions to set this up if you have the forum and reviewpost in separate databases you need to uncomment the mysql_select_db lines

Also download the build and replace files as there is a fix already posted for inc_reviewpost.php where $pp_db_prefix was used not $rp_db_prefix

ncg · August 29th, 2005, 11:07 AM

ok, im still having problems. i replaced the inc_* files with the build ones.

but im still getting errors.

Quote:

Warning: getimagesize(/reviews/data/431/676Diamond.jpg): failed to open stream: No such file or directory in /var/hsphere/local/home/xx/reviews/inc_reviews.php on line 112

Warning: getimagesize(/reviews/data/429/9Bomb_Purple_Erkle.JPG): failed to open stream: No such file or directory in /var/hsphere/local/home/xx/reviews/inc_reviews.php on line 112

Warning: getimagesize(/reviews/data/450/169grapefruit-upclose.jpg): failed to open stream: No such file or directory in /var/hsphere/local/home/xx/reviews/inc_reviews.php on line 112

Warning: getimagesize(/reviews/data/454/169ogkush-upclose.jpg): failed to open stream: No such file or directory in /var/hsphere/local/home/xx/reviews/inc_reviews.php on line 112
Could not select ReviewPost database

i also had to change this (inc_reviewpost):

Code:

Content visible to verified customers only.

to this:

Code:

Content visible to verified customers only.

it would just die with the cant select database error before i made the change. now i get the above errors that i posted first.

Chuck S · August 29th, 2005, 11:33 AM

Is your database named rp_products

These are the databases of the reviewpost and forum you put in there.The instructions clearly state if they are in separate databases you must uncomment those lines and place the proper database names in there

ncg · August 29th, 2005, 11:56 AM

inc_reviews:

Quote:

// If you have placed ReviewPost into a seperate database, you will need to
// uncomment these lines to connect to the ReviewPost database. It is suggested
// that you install PP into the same database as vB for better performance.

yes, review post is in a separate database.

Quote:

// If you use the same userid/password to access both databases, you don't need to
// uncomment the mysql_connect - this is only if you require different ids to access
// the ReviewPost database.

same userid and password to access both reviewpost and vb3.

Quote:

//$link = mysql_connect ("localhost", "$dbuserid", "$dbuserpassword") or die('I cannot connect to the database.');

leave this commented because i use same username and password. right?

Quote:

mysql_select_db ("review
_post_database")or die("Could not select photopost database");

then i uncomment this line because i want it to select the diffrent database that has reviewpost in it. right?

Quote:

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

then i would uncomment this line to select the vb3 database because the reviews abd forums are in separate db's right?

----

inc_reviewpost:

Quote:

// If you have placed ReviewPost into a seperate database, you will need to
// uncomment these lines to connect to the ReviewPost database. It is suggested
// that you install PP into the same database as vB for better performance.

same thing as above.

Quote:

// If you use the same userid/password to access both databases, you don't need to
// uncomment the mysql_connect - this is only if you require different ids to access
// the ReviewPost database.

same as above, dont need to uncomment because they use the same user/pass. right?

Quote:

// $link = mysql_connect ("localhost", "dbuserid", "dbuserpassword") or die('I cannot connect to the database.');

dont need to uncomment, user/pass the samew for both.

Quote:

mysql_select_db ("products")or die("Could not select ReviewPost database");

select the products database from reviewpost. but this is where i get an error because "products" isnt the name of any tables in my database. they all have a table prefix (which this refrence is lacking) of rp_.

---

did i follow the directions correctly?

then this takes us back to the above post of the errors im getting.

Chuck S · August 29th, 2005, 12:37 PM

yes both database things would be uncommented. I run it on my site with no issues.

ncg · August 29th, 2005, 01:10 PM

ok, i fixed the database issues. no more problems with that. now i get these image related errors:

Quote:

Warning: getimagesize(/reviews/data/454/169rainbow-upclose.jpg): failed to open stream: No such file or directory in /var/hsphere/local/home/xx/reviews/inc_reviews.php on line 112

Warning: getimagesize(/reviews/data/433/9GR1.JPG): failed to open stream: No such file or directory in /var/hsphere/local/home/xx/reviews/inc_reviews.php on line 112

Warning: getimagesize(/reviews/data/433/539a-mist.JPG): failed to open stream: No such file or directory in /var/hsphere/local/home/xx/reviews/inc_reviews.php on line 112

Warning: getimagesize(/reviews/data/407/676KnockOut.jpg): failed to open stream: No such file or directory in /var/hsphere/local/home/xx/reviews/inc_reviews.php on line 112

looks to me that the path to reviews is bad from the forums directory. where do i change that at? it should be ../reviews not /reviews

note, the featured products box does show up in the forum home and shows pics and seems to work. however, it gives those above errors at the very top of the page.

Chuck S · August 29th, 2005, 02:20 PM

In your config-intr.php file is the path you need to change

$thumbtag = "{$rpdata_dir}/{$pcat}/{$puserid}{$product}";
$image_stats = getimagesize( $thumbtag );

ncg · August 29th, 2005, 04:07 PM

ok. so i just added ../ before the {}. and now the errors are gone, but it doesnt show the pics. the box is there, the titile and who uploaded it shows, but no pics.

Chuck S · August 29th, 2005, 04:33 PM

I was giving an example

$rpdata_dir definately exists in the config-intr.php file and you need to set it to this

/var/hsphere/local/home/xx/reviews/data

ncg · August 29th, 2005, 08:13 PM

same problem still. i changed that path in the config-intr file.

in firefox on a mac the pics dont show up in the top featured reviews. in safari they show up as black squares with question marks in them. i havent tested it on my pc yet with ie or firefox.

Chuck S · August 29th, 2005, 08:21 PM

Warning: getimagesize(/reviews/data/454/169rainbow-upclose.jpg): failed to open stream: No such file or directory in /var/hsphere/local/home/xx/reviews/inc_reviews.php on line 112

Warning: getimagesize(/reviews/data/433/9GR1.JPG): failed to open stream: No such file or directory in /var/hsphere/local/home/xx/reviews/inc_reviews.php on line 112

Warning: getimagesize(/reviews/data/433/539a-mist.JPG): failed to open stream: No such file or directory in /var/hsphere/local/home/xx/reviews/inc_reviews.php on line 112

Warning: getimagesize(/reviews/data/407/676KnockOut.jpg): failed to open stream: No such file or directory in /var/hsphere/local/home/xx/reviews/inc_reviews.php on line 112

you get that still then your path as I noted is not correct as I noted in the config.intr.php

Have you uploaded all the required files as in the overlay files which are in the images directory?

I have this on my forums and they are in separate databases so it does work if the proper files and paths are correct

http://www.reeftalk.com/forums/index.php?

ncg · August 29th, 2005, 08:30 PM

the path is fine. i dont get any errors anymore, i just dont get any images.

before i had images but i also had errors.

i know it works too, i saw it work on my site, it just had the image errors at the top.

what are the overlay images? i copied all the files over the old ones when i upgraded to rp 3.0. so i must have it ??

Chuck S · August 29th, 2005, 09:02 PM

the images folder has new images

overlay_round.gif as an example

Those would need to exist or you will get nothing

ncg · August 29th, 2005, 09:05 PM

yeah i checked that ive got all the required files.

in windows all i get is boxes with x's in them. no pics.

Chuck S · August 29th, 2005, 09:11 PM

well we are going back and forth here

post the url to your install please

ncg · August 29th, 2005, 10:19 PM

http://weedtracker.com/forums/

Chuck S · August 29th, 2005, 11:21 PM

in inc_reviews.php find $url_path and replace with $rpurl_path

ncg · August 30th, 2005, 09:28 AM

ok, made 2 changes of $url_path to $rpurl_path in inc_reviews. now were getting closer, it gives me black squares now, but not pics yet

Chuck S · August 30th, 2005, 09:40 AM

Look at your path statement in your integration settings it is definately wrong

<td style="background-repeat: no-repeat; background-position: center;" bgcolor="#000000" background="/hsphere/local/home/slothdog/weedtracker.com/reviews/data//434/9gods_gift-thumb.JPG"

It should be if I am readin this right this

/var/hsphere/local/home/slothdog/weedtracker.com/reviews/data