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.

[Kirk Fitzgerald]

Okay Ted, no problem, will continue.

I just added a new product and used an external image link, then I ran the sync external images, at the end of sync I see this text:

photoid is: 5001fd68874b3
filename is: C:\xampp\htdocs\vb4dev\productphotos/5001fd68874b3
download is: http://i1049.photobucket.com/albums/...ndPipeRack.jpg
should now have: C:\xampp\htdocs\vb4dev\productphotos/5001fd68874b3_original.unknown
skipping the delete
exiting

The images are present in the productphotos folder YES

This is what I see on my localhost test site:

Manage Product in admin
Attachment 139818

Viewing forum
Attachment 139817

Viewing the Product itself
Attachment 139820

Viewing Product listings
Attachment 139819

[Ted S]

Originally Posted by Kirk Fitzgerald

I just added a new product and used an external image link, then I ran the sync external images, at the end of sync I see this text:

I think I see what's happening here...

Your test forum is hosted on a windows server which has backwards urls (productphotos\ instead of productphotos/)...

It's strange that nothing errors in creating the images but perhaps windows is smarter in processing than it is in rendering...

To this this run the mySQL query:

update pf_product set mainphoto = replace(mainphoto, '/', '\\');
update pf_product set mainphoto_thumb = replace(mainphoto_thumb, '/', '\\');
update pf_product set mainphoto_small = replace(mainphoto_small, '/', '\\');

Then check that C:\xampp\htdocs\vb4dev\productphotos\5001fd68874b3 .jpg [png|gif] opens properly.

Note: This will update all images, including those with external links.

[Kirk Fitzgerald]

Ran the query Ted, now there are no images anywhere, not in admin, forum, product view or product listing

[ywwz]

Originally Posted by Ted S

Care to be more specific? Have you followed the install guide? A

Read all 1 reviews

when I click this, I get error.:

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT pf.postid,pf.threadid,pf.headline,pf.rating,pf.loc ation,pf.mainphoto_thumb,DATE_FORMAT(pf.createddat e,'%a %b %D, %Y') as posted,u.userid,u.username,
pfp.title as productitle,pfp.mainphoto_thumb

FROM pf_review as pf
JOIN user as u ON u.userid = pf.userid
JOIN pf_product as pfp ON pfp.productid = pf.productid
WHERE pf.productid = '1' AND pf.approved = 1

ORDER BY pf.createddate DESC
LIMIT 0, 25;

MySQL Error : Unknown column 'pf.mainphoto_thumb' in 'field list'
Error Number : 1054
Request Date : Saturday, July 14th 2012 @ 07:04:44 PM
Error Date : Saturday, July 14th 2012 @ 07:04:44 PM
Script : http://xxx/forum/productforums.php?d...es&productid=1
Referrer : http://xxx/forum/threads/275
IP Address : xxx
Username : xx
Classname : vB_Database
MySQL Version : 5.5.23-55

[Ted S]

Originally Posted by ywwz

Read all 1 reviews

when I click this, I get error.:

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT pf.postid,pf.threadid,pf.headline,pf.rating,pf.loc ation,pf.mainphoto_thumb,DATE_FORMAT(pf.createddat e,'%a %b %D, %Y') as posted,u.userid,u.username,
pfp.title as productitle,pfp.mainphoto_thumb

FROM pf_review as pf
JOIN user as u ON u.userid = pf.userid
JOIN pf_product as pfp ON pfp.productid = pf.productid
WHERE pf.productid = '1' AND pf.approved = 1

ORDER BY pf.createddate DESC
LIMIT 0, 25;

MySQL Error : Unknown column 'pf.mainphoto_thumb' in 'field list'
Error Number : 1054
Request Date : Saturday, July 14th 2012 @ 07:04:44 PM
Error Date : Saturday, July 14th 2012 @ 07:04:44 PM
Script : http://xxx/forum/productforums.php?d...es&productid=1
Referrer : http://xxx/forum/threads/275
IP Address : xxx
Username : xx
Classname : vB_Database
MySQL Version : 5.5.23-55

Gotcha... That's a bug in beta 2, revised for beta 3 using the attached copy of /forums/productforums.php

[Ted S]

Originally Posted by Kirk Fitzgerald

Ran the query Ted, now there are no images anywhere, not in admin, forum, product view or product listing

Once you synced the images the first time wasn't this already the case? The same paths are used on the frontend and backend.

View a product [in the front or backend] and open the page source. Copy down the image src path and try loading it on your server... it should be \productforums\xxxxx.image which should correspond to where the image is saved.

I can't see your server configuration to know how your folders, slashes and file types are set so it's hard to tell what part of your links are broken but from everything you've posted there doesnt seem to be an issue in how the script works but rather in the configuration versus where images actually are.

[PattiOz]

This has got to be one of the most valuable and best mods ever. You guys have worked HARD on this. I will wait until the beta graduates before upgrading to the latest to go live with but I am watching this thread very closely! I think tens of thousands of my forum participants are going to use this once I turn it on.

[Kirk Fitzgerald]

Originally Posted by Ted S

Once you synced the images the first time wasn't this already the case? The same paths are used on the frontend and backend.

View a product [in the front or backend] and open the page source. Copy down the image src path and try loading it on your server... it should be \productforums\xxxxx.image which should correspond to where the image is saved.

I can't see your server configuration to know how your folders, slashes and file types are set so it's hard to tell what part of your links are broken but from everything you've posted there doesnt seem to be an issue in how the script works but rather in the configuration versus where images actually are.

Hey Ted,

sorry about delay, had to sleep.

Okay then, so when viewing a product ont he front end I obviously see no image, viewing source code I see this for the image call:

http:\\i1049.photobucket.com\albums\s386\KirkFitzgerald\PetersonCeramic3PipeStandPipeRack.jpg

but where it sends me when I put it in the broswer is this:

http://localhost/vb4dev/%5C%5Ci1049.photobucket.com%5Calbums%5Cs386%5CKirkFitzgerald%5CPetersonCeramic3PipeStandPipeRack.jpg

I can send you the main Apache config file httpd.conf is that helps to know how xampp is configured on my end, do you want me to do that?

[Ted S]

Originally Posted by Kirk Fitzgerald

Hey Ted,

sorry about delay, had to sleep.

Okay then, so when viewing a product ont he front end I obviously see no image, viewing source code I see this for the image call:

http:\\i1049.photobucket.com\albums\s386\KirkFitzgerald\PetersonCeramic3PipeStandPipeRack.jpg

but where it sends me when I put it in the broswer is this:

http://localhost/vb4dev/%5C%5Ci1049.photobucket.com%5Calbums%5Cs386%5CKirkFitzgerald%5CPetersonCeramic3PipeStandPipeRack.jpg

I can send you the main Apache config file httpd.conf is that helps to know how xampp is configured on my end, do you want me to do that?

I'm so confused here... didn't you process the images through the bulk sync script turning them into local links like /productforums/xxxxxx.img?

The reason external links won't work is the query I had you run which changes / to \ to work specifically for local links. If you want to use remote images instead that's no problem, we can fix the links to point back to those...

[Ted S]

Originally Posted by PattiOz

This has got to be one of the most valuable and best mods ever. You guys have worked HARD on this. I will wait until the beta graduates before upgrading to the latest to go live with but I am watching this thread very closely! I think tens of thousands of my forum participants are going to use this once I turn it on.

Thanks! :up: