Major Additions - Product Review Forums ? Research, Review & Compare Items

Version 1.4.0 has been released to remove the giftery / list it integration of the addon now that service has been discontinued. No upgrade is needed though there have been a few other bug changes since 1.3.5.

Finding Feedback Can be Like a Needle in a Haystack

The more your forum grows, the more of a challenge it becomes to sort through the history and get the full story.

Product Review Forums Brings Structure to the Chaos

As a full-featured product management addon, PRF sits on top of your forum allowing you to create defined products which, unlike individual posts, stay relevant over time. Each comment, review and even product updates filter back into this one spot allowing for a quick and comprehensive overview while the individual discussions rage on as always.

Here's just a few of the many features you'll find in PRF:

• Bring structure to products with established pages & reviews
• Reduce the number of repetitive posts from members looking up the same info
• Increase your traffic with content-rich, seo friendly, product listings
• Drive revenue by adding your own affiliate links to product listings
• Increase the activity stream's value with review integration
  
• Engage visitors with integrated wishlists from Giftery.me

===========================

Installation is not upload & go... individualized settings are required. Read the install file.

===========================
QUICK TIPS:
===========================

Enabling Product Forums: To show product details and ratings, each product-forum must be enabled in the forum manager.

Adding Products: You may upload products one at a time through the admin [includes an image uploader using GD] or you can bulk import through XML. You can also enable users to add moderated products through a global and usergroup option.

Product Review Index: To access your forum's product overview go to www.yoursite.com/productforums.php - You may want to add a link to this to your navbar or as a tab.

Customization: This addon is made to be customized. To change the color schema see clientscript/vbulletin_css or dive right on in to the templates and phrases.

Powered by Giftery.me: This mod is maintained includes two integrations you should know about. Both can be controlled through the mod options.

[addamroy]

Marked as installed but had to uninstall. As another poster said, it's destroying the activity stream.

When using this mod on the test site, I get the following error when trying to view activity.php (EVEN if I disable the activity stream option in the product review settings)

Fatal error: Declaration of vB_ActivityStream_View_Perm_Product_Review::fetchT emplate() must be compatible with that of vB_ActivityStream_View_Perm_Base::fetchTemplate() in /home/xxxx/public_html/testvb/vb/activitystream/view/perm/product/review.php on line 19

Edit** I disabled the add-on and I'm STILL getting that error when I try to view the activity stream... argh how do I fix it? Somehow I assume I have to remove the product review entries from the activity stream somehow or something. Help please

[Ted S]

Originally Posted by addamroy

How do I change the fields? Is it possible to add custom ones?

Additional fields can be setup in your admin control panel under the PRF options. Existing fields must be removed by editing the templates.

Originally Posted by addamroy

Also, after trying to submit a product to the product forums I set up on my test site, all my thread says is this,
"Product information... View for more details "

Did you follow up the setup guide to enable the mod in the forum you're posting products to?

[Ted S]

Originally Posted by addamroy

Marked as installed but had to uninstall. As another poster said, it's destroying the activity stream.

What version of vB are you using?

And yes, if the mod is causing conflicts, you should remove it and / or any associated postings it has made.

[addamroy]

Originally Posted by Ted S

What version of vB are you using?

And yes, if the mod is causing conflicts, you should remove it and / or any associated postings it has made.

I'm using 4.2.1 fresh install.

Any plans on fixing the activity stream bug?

Also how do I remove the entry from the activity stream so its not broken? I've disabled the mod but the stream is still broken.

[Toorak Times]

Ted, deadset mate, it has caused me all sorts of grief and still trying to delete, but won't go away, it is a brilliant idea, but I couldn't get it working 4.2.1

[sadiq6210]

Originally Posted by sadiq6210

I try to uninstall the mod but I got this error

Database error in vBulletin 4.1.12:

Invalid SQL:
DELETE FROM activitystreamtype WHERE section = 'product' AND type = 'review';

MySQL Error : Table 'dbname_testforum2.activitystreamtype' doesn't exist
Error Number : 1146
Request Date : Tuesday, March 12th 2013 @ 02:25:48 PM
Error Date : Tuesday, March 12th 2013 @ 02:25:48 PM
Script : http://www.domain.com/vbtest/admincp...do=productkill
Referrer : http://www.domain.com/vbtest/admincp...duct_forums&s=
IP Address :
Username : sadiq6210
Classname : vB_Database
MySQL Version : 5.1.68-cll

_________________________________________

In 4.1.12 there is no activity stream

I will use it soon but I want to test it first and have all information about it.
Thank you for the great mod

Originally Posted by Ted S

The perils of using a significantly outdated version of vB with mods...

We'll be sure to code in db error suppression to avoid this bug but in the meantime you can comment out the lines in the .xml file, update and then uninstall.

I updated my forum to 4.2.1 and I tried to uninstall this mod
I uninstalled it and I didn't face any error during the un-installation process.

But after If I uninstalled it, the forum is not working at all (Database Error)! I receive many database errors in my email like this:

Database error in vBulletin 4.2.1:

Invalid SQL:

SELECT 
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_activitystream AS phrasegroup_activitystream,
language.phrasegroup_holiday AS phrasegroup_holiday,
language.phrasegroup_adv_gallery_int AS phrasegroup_adv_gallery_int,
language.phrasegroup_bop5iframer AS phrasegroup_bop5iframer,
language.phrasegroupinfo AS lang_phrasegroupinfo,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
, ppgal_user.ppicount, ppgal_user.pppcount, ppgal_user.lastimageid, ppgal_user.lastimagetitle, ppgal_user.lastimagedate, ppgal_user.lastpostid, ppgal_user.lastposttitle, ppgal_user.lastpostdate, ppgal_user.profile_active, ppgal_user.profile_exclude, ppgal_user.profile_include, ppgal_user.profile_orderby, ppgal_user.profile_cutoff, ppgal_user.profile_tabfirst, ppgal_user.profile_autosel, ppgal_user.profile_tabstats, ppgal_user.profile_tabhighlight, ppgal_user.profile_showtitle, ppgal_user.profile_showcat, ppgal_user.profile_showcontext, ppgal_user.profile_contextfirst, ppgal_user.profile_showhtitle, ppgal_user.profile_husername, ppgal_user.profile_showhcat, ppgal_user.profile_showhcontext, ppgal_user.ppfavcount, ppgal_user.upload_readpolicy, ppgal_user.profile_tabthumbs, ppgal_user.profile_limit 
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 5, user.languageid)) 

LEFT JOIN ppgal_user AS ppgal_user ON (ppgal_user.userid = user.userid) 
WHERE user.userid = 1 LIMIT 1;

MySQL Error : Unknown column 'language.phrasegroup_activitystream' in 'field list'
Error Number : 1054

I installed it again and the forum is working.
Again I tried to uninstall it >> the forum not working (database error)
Install it again >> the forum working.
...........

How can I uninstall it?

[Toorak Times]

seek the files in your forumroot mate and delete, still looking for it all. I hate bagging products and Teds seems to be around...speak to Christos Teriakis mate

[sadiq6210]

Fixed

I uninstalled the product then I run (forum/install/upgrade.php) and the forum is working now.

[Toorak Times]

I had it working in 4.1.2 but use it, thaks Sadiq, it is an important vB mod I reckon

[Ted S]

Originally Posted by sadiq6210

Fixed

I uninstalled the product then I run (forum/install/upgrade.php) and the forum is working now.

Nicely done....

After you remove a mod, bits of information lingers in the activity system and a cleanup (whether an upgrade or just clearing the system stuff) should help.