vb 3.07 integration error

[ncg]

hey all, need a little help.. this error comes up sometimes when i try and view the reviews index.

Warning: main(./languages/english/pp-inc.php): failed to open stream: No such file or directory in varhspherelocalhomeslothdogweedtracker.comreviewspp-inc.php on line 60

Warning: main(./languages/english/pp-inc.php): failed to open stream: No such file or directory in varhspherelocalhomeslothdogweedtracker.comreviewspp-inc.php on line 60

....

ive tripple checked all the settings and everything has the proper "/'s"

[Michael P]

Is this a ReviewPost error?

[ncg]

yeah, i just realized i posted it in the wrong section. sorry.

[ncg]

can i please get some help here? your support really sucks. you never reply to forum post and you reply to emails even less.

it only does this when the vb3 is set to the "open" position. when its "closed" it works fine.

[ncg]

i know it has something to do with the integraton, ive deleted and installed reviewpost 20 times now and i get the same error everytime when i turn on the integration. would somebody please help me? this is getting really annoying. it works fine if i turn the vb integration off.

[Chuck S]

Hello You just opened this thread 11PM last night and have recieved one response. Our support sucks?

Check in your config-inc.php file and make sure you input the proper server path to the reviewpost installation in the $RP_PATH line variable. You have a . in there now. To use VB3 integration your server paths must be filled out.

[ncg]

Originally Posted by omegatron

Hello You just opened this thread 11PM last night and have recieved one response. Our support sucks?

Check in your config-inc.php file and make sure you input the proper server path to the reviewpost installation in the $RP_PATH line variable. You have a . in there now. To use VB3 integration your server paths must be filled out.

its not just this thread, its every thread. it takes at least 2 to 3 days to get an anwser if you even get an anwser, its the same with email.

[Chuck S]

This very thread speaks differently here as you where responded to in within 15mins and another reply within 14 hours. When one puts in a support request do realise the time of day you do it and whether it is a weekend of weekday. We are in the US and people posting in off hours will experience some time to get a response. I dont know where your from so that may be a factor here.

Posting at 11PM at night getting a response the next afternoon after an initial response is not a long period of time.

You have not let me know whether correcting your $RP_PATH solved your issue.

[ncg]

im not going to aruge with you about the quality or quanity of your support abilities. i just want to fix this damn thing so i dont have to ask for help. its been nothing but a pain in the ass and im tired of working on it.

the $rp_path solved one issuse but created another.

i cant admin the review post, now when i try to login to to review post i get this pleasnt message:

You are not a valid administrator or moderator!

argh!

[Chuck S]

When you installed did you specify the proper Vblicense and cookie settings? I would think cookies are not set properly and you are not logged in when you indeed think you are.

Make sure Photopost cookie settings in the settings table settings 171-173 are set exactly as VB. Note the default VB cookie prefix is bb and I can tell ya tons of people forget this.

[ncg]

there is no setting 171-173 in reviewpost

ill bet your right about the cookie though, i remember forgetting to set that before and having problems. where is that setting in the reviewspost db?

[Chuck S]

UGH!!

yeah reviewpost is the one product they are still set in config-inc.php. forget we have not moved those into the database yet for that one

[ncg]

ok checked cookie prefix in config-inc.php and its already set to the same as in vb.

[Chuck S]

okay vb license entered correctly? ( not vb customer number )

cookie domains match?

Basically if you login in vb and go to photopost and they are on the same domain and your not logged in it has to be cookies.

You can post a link to your install and I can see which it is.

[ncg]

ok, it works now. i had the customer number insted of the vb licence number.

now my question is, how can i reload all my old reviews data (did a clean install) without breaking it ?

[Chuck S]

You would need to restore the categories reviews and products tables at a minimum and run the upgrade script from the last version you where running or now you know your mistake restore the entire old database and upgrade it.

[ncg]

so i can just drop the tables and load the backup tables into mysql then run upgrade script and it will be good to go ?

[ncg]

this is what i did:

1) put the catagories from the old db into the new db -- ok
2) put the products from the old db into the new db -- ok
3) put the reviews form the old db into the new db -- ok
4) run upgrade.php -- error

error:

Performing MySQL command: INSERT INTO rp_settings VALUES (165,'Your SMF Cookie Name', 'smfcookie', 'Only needed for users of SMF forums', '', 5, 12) ... Error: Duplicate entry '165' for key 1
Performing MySQL command: INSERT INTO rp_settings VALUES (198,'Use 24 hour time format?','timeformat', 'You can elect to have time displayed as HH:MMam or using the 24 hour clock', 'no', 32, 1) ... Error: Duplicate entry '198' for key 1
Performing MySQL command: INSERT INTO rp_settings VALUES (205,'Show Last Reviews column on Index?','showrevs','','yes',16,3) ... Error: Duplicate entry '205' for key 1
Performing MySQL command: INSERT INTO rp_settings VALUES (206,'Show Last Product column on Index','showlast','','yes',17,3) ... Error: Duplicate entry '206' for key 1
Performing MySQL command: REPLACE INTO rp_admingroups VALUES (12,'Forum Settings') ... Successful!
Performing MySQL command: ALTER TABLE rp_products ADD numreviews INT(12) DEFAULT '0' NOT NULL AFTER lastpost ... Error: Duplicate column name 'numreviews'
Performing MySQL command: REPLACE INTO rp_settings VALUES (84,'ReviewPost Version','pversion','','2.91',53,0) ... Successful!

Warning: unlink(/hsphere/local/home/xxx/reviews//showgallery.php): No such file or directory in varhspherelocalxxxreviewsupgrade.php on line 566

Warning: unlink(/hsphere/local/home/xxx/reviews//login-inc.php): No such file or directory in varhspherelocalhomexxxreviewsupgrade.php on line 567

Warning: unlink(/hsphere/local/home/xxx/reviews//email-inc.php): No such file or directory in varhspherelocalhomexxxreviewsupgrade.php on line 568

Warning: unlink(/hsphere/local/home/xxx/reviews//adm-backup.php): No such file or directory in varhspherelocalxxxreviewsupgrade.php on line 569


Finished upgrade! You may now remove this script.

then my other issue is that hte review count dont show up, but when you click on a product to see a review they are all there that were there before.

[Chuck S]

Those are just duplicate errors no problem means it was ran before. One of the upgrades added a new review field and calculated the reviews and must be run for the reviews to show right in the new version

[ncg]

do you know how to refresh the post count? it says xxx reviews and xxx products, but in the products and reviews section it shows all 0's.