Product Review Forums ? Research, Review & Compare Items

[imported_dfmafia]

haha, think i found it...i had must require prefixes to post on that forum topic.

fixed and working now

[imported_dfmafia]

"Quotes" - print out in review title as "Quotes"

[Ted S]

haha, think i found it...i had must require prefixes to post on that forum topic.

fixed and working now

Fantastic. We'll work on that for beta 2... obviously it should not present an error.

[Ted S]

"Quotes" - print out in review title as "Quotes"

The review title is made up from the product title... Where are you seeing the quotes show up like this? In the body of the review or in the headline elsewhere?

[imported_dfmafia]

I like to require prefixes since I set them up to be clickable, thus sorted. easily find posts or items in a certain prefix. i find im using it more and more on my boards, just a pain to set up

[Ricsca]

It's the big link on the edit product page... you must have an item created first.

In our beta 2 release we spell this out on the add product page as well.

Alternatively you can keep using image links and then run the bulk importer [also in beta 2] which will move them over for you.

Found .... But if I click on

Upload a new product photo?

are this error:

Not Found

The requested URL /admincp/productforums was not found on this server.

but in the Image Upload Path and Image View Url the cart are images/productforums and not

admincp/productforums...

why?

Thanks

[Ted S]

I like to require prefixes since I set them up to be clickable, thus sorted. easily find posts or items in a certain prefix. i find im using it more and more on my boards, just a pain to set up

Well then you'll like our solve... Rather than skipping the setting and overriding it we've added prefixes in. So you can create something like positive / negative / great / bad, etc for your review thread forum. If you want it...

[Ted S]

admincp/productforums...

why?

Thanks

It's a link bug we posted about earlier today... When beta 2 comes in a few minutes out just upgrade and you'll be good to go.

[Ted S]

1.3.0 beta 2 is out with a few changes...

1. Added a bulk image importer. Now you can convert your existing image urls into local photos w/ thumbnails... No local saving or old product updating needed!

2. Added support for forum prefixes to label reviews. If enabled these will be considered required.

3. Fixed a bug with a link to the image uploader script.

Plus a larger note about images when you add a product, making that harder to miss :D

Changed files: /forum/productforums.php, /admincp/productforums.php /includes/xml and the template prodforums_review_create

[imported_dfmafia]

Well then you'll like our solve... Rather than skipping the setting and overriding it we've added prefixes in. So you can create something like positive / negative / great / bad, etc for your review thread forum. If you want it...

nice, if I already have prefixes, will I be able to use these that are already in the system?

[imported_dfmafia]

prefixes work and to answer my own question from above. yes it uses current prefixes asigned to forum topic :up:

[imported_dfmafia]

1 0 char .

[Kirk Fitzgerald]

Hi Ted,
B2 is a fantastic update, I have a question, probably just me being stupid!

With existing Products, suppose they have external images for the main image such as:
http://photobucket.com/blah/blah/DrPlumbQuintexBentAppleSmoothLondonMadeMagicInchBr iarPipe.jpg

What do we do to ensure they have the thumbnail and tiny image, currently nothing has changed on localhost for existing Products, those images are still missing.

[Ricsca]

It's a link bug we posted about earlier today... When beta 2 comes in a few minutes out just upgrade and you'll be good to go.


Upgrade and now

Warning: getimagesize(): Filename cannot be empty in [path]/includes/prodforums_uploader.php on line 32
couldnt understand the image

[Ted S]

1 0 char .

Not sure I follow?

[Ted S]

Upgrade and now

Warning: getimagesize(): Filename cannot be empty in [path]/includes/prodforums_uploader.php on line 32
couldnt understand the image

The script debugs for valid images a bit but it looks like something is sneaking through or perhaps just not playing nicely... What version of php / gd are you using?

Debugging this will require a few changes. Please try this version of admincp/productforums.php and includes/prodforums_uploader.php

This will print out some debug information and exit the script before trying to process any images.

[Ted S]

Hi Ted,
B2 is a fantastic update, I have a question, probably just me being stupid!

With existing Products, suppose they have external images for the main image such as:


What do we do to ensure they have the thumbnail and tiny image, currently nothing has changed on localhost for existing Products, those images are still missing.

Just run the bulk script. It will try to load the remote image, reprocess it into the 3 image sizes and update the database if successful.

The nice thing is that you can use this moving forward so rather than uploading files individually you just include the url, hit sync and it grabs them for you.

[Ted S]

prefixes work and to answer my own question from above. yes it uses current prefixes asigned to forum topic :up:

Yup, uses whatever is set for the forum... just like you were making a regular thread. Glad it's working how you expected :D

[Ricsca]

The script debugs for valid images a bit but it looks like something is sneaking through or perhaps just not playing nicely... What version of php / gd are you using?

Debugging this will require a few changes. Please try this version of admincp/productforums.php and includes/prodforums_uploader.php

This will print out some debug information and exit the script before trying to process any images.

Dont work... my php info

http://www.tartaportal.it/admincp/index.php?do=phpinfo

[Ted S]

Dont work... my php info

http://www.tartaportal.it/admincp/index.php?do=phpinfo

Don't work doesn't give me much to go off of... Let's dive deeper...

Did it error on you? If so, which script? If not, Did it output messages?

It's not suppose to convert anything... in fact it will stop before trying. It's a debug script and should produce something like:


photoid is: 500126c9ad6d2
filename is: /var/www/forum/prodphotos/500126c9ad6d2
download is: http://www.xxx.com/Image/Product/Full/APLFPCO.jpg
should now have: /var/www/forum/prodphotos/500126c9ad6d2_original.unknown
file name is: /var/www/forum/prodphotos/500126c9ad6d2_original.unknown
skipping the delete
exiting


And since I'm not an admin for your forum I can't see your php info. You'll need to find the versions for PHP and GD and report them back [phpinfo should never be openly shared]

[Ricsca]

I clik in Sync External Images link and now

http://www.tartaportal.it/productforums.php

[Ted S]

I clik in Sync External Images link and now

http://www.tartaportal.it/productforums.php

As noted in the script I posted is a version of admincp/productforums.php

You've uploaded the admin script to your forum folder... thus the error. :D

[nukinfuts29]

I'm confused, it is all set up but when i click "add product" i get:

"This feature is currently not in use"

How do i put it in use?

http://www.theglockboard.com/productforums.php

Nice mod

[Ricsca]

And how do I fix?

[Ted S]

I'm confused, it is all set up but when i click "add product" i get:

"This feature is currently not in use"

How do i put it in use?

http://www.theglockboard.com/productforums.php

Nice mod

As noted in the documents, this is not upload and go, you must configure certain options to use all the features of this mod.

Please review the install guide and your product forum settings in your Admin Control Panel -- in this case the new product forum is what's missing but there are likely others you will need to adjust.

http://www.giftery.me/productforums/howto

p.s. Thank you!

[Ted S]

And how do I fix?

How do you fix what?

[Ricsca]

To run your mod on my site ...

[Ted S]

To run your mod on my site ...


That depends. What's the problem?

From your last post you had uploaded files to the wrong folder and from your previous one it's not clear if you have a setting issue, a software issue or a script issue. You'll need to run the debugger script provided for us to sort that out.

[nukinfuts29]

As noted in the documents, this is not upload and go, you must configure certain options to use all the features of this mod.

Please review t1e install guide and your product forum settings in your Admin Control Panel -- in this case the new product forum is what's missing but there are likely others you will need to adjust.

http://www.giftery.me/productforums/howto

p.s. Thank you!

Those settings are all complete, i followed your instructions from the get go

[Ted S]

Those settings are all complete, i followed your instructions from the get go

Great... well then let's dig deeper...

That error comes up when Members Can Post Products and New Product Forum ID are not set. What values do you have for each [should be Yes and a Forum ID].

[nukinfuts29]

OK I got it. The value for the forum ID was set in the CP, but didn't translate to the backend. Adjusted it manually and it is working.

[Ted S]

OK I got it. The value for the forum ID was set in the CP, but didn't translate to the backend. Adjusted it manually and it is working.

Great! Anything we should look at in the mod / docs to help with this for others?

Everything else working ok?

[nukinfuts29]

New issue. Went to click on stars to rate something, got this

Unknown column 'pf.mainphoto_thumb' in 'field list'

[Ted S]

New issue. Went to click on stars to rate something, got this

Unknown column 'pf.mainphoto_thumb' in 'field list'

Nice find... Looks like we had a double call to the field, one on the wrong table.

This version of /forums/productforums.php fixes it...

[nukinfuts29]

You're on top of it!

No more error, just redirects to a new screen and the rating doesn't change. Here is a screenshot

[Kirk Fitzgerald]

Just run the bulk script. It will try to load the remote image, reprocess it into the 3 image sizes and update the database if successful.

The nice thing is that you can use this moving forward so rather than uploading files individually you just include the url, hit sync and it grabs them for you.

Do you mean the Sync External Images?

If so I get this error when running that!

Fatal error: Call to undefined function curl_init() in C:\xampp\htdocs\vb4dev\admincp\productforums.php on line 671

[Ted S]

You're on top of it!

No more error, just redirects to a new screen and the rating doesn't change. Here is a screenshot

You caught us at a good time :D

The error you were getting was in the search function... Clicking the stars won't rate anything if that's what you intended [for that you have to click "Write a Review" and fill out the form].

Unless I'm misunderstanding you?

Of course we will add an error for when no reviews are found.

[nukinfuts29]

ooooh i thought you could click the stars to rate it. Like ebay and a lot of websites. My guess is this will be a common mistake ;)

[Ted S]

Do you mean the Sync External Images?

If so I get this error when running that!

Fatal error: Call to undefined function curl_init() in C:\xampp\htdocs\vb4dev\admincp\productforums.php on line 671

Your server needs curl to run this function [curl lets us fetch the images from their remote source quickly and without worrying about limited php settings].

[Ted S]

ooooh i thought you could click the stars to rate it. Like ebay and a lot of websites. My guess is this will be a common mistake ;)

It's a good point... No one has brought it up to date but that doesn't mean users get it...

You can of course remove the link by editing the template. Since reviews generally need detail a click alone doesn't seam to be enough but we're open to thoughts.

[Kirk Fitzgerald]

Your server needs curl to run this function [curl lets us fetch the images from their remote source quickly and without worrying about limited php settings].

I enable curl in localhost xampp and ran that script, now there are NO images for the Products already listed, the add image from an url is gone too, all I have open to me now is to upload a new image!

This is no good at all for when upgrading my live site, why are the external linked images deleted?

[Ted S]

I enable curl in localhost xampp and ran that script, now there are NO images for the Products already listed, the add image from an url is gone too, all I have open to me now is to upload a new image!

This is no good at all for when upgrading my live site, why are the external linked images deleted?

When a local image is made, the old link is replaced... One product, one image path.

Essentially the script just sees an image field. Whether it's internal or external is irrelevant to a browser or the script and thus calling one field avoids having to check two places for images. Speed is good.

That said, in the syncing process there's a number of sanity checks in place so if an image doesn't load, isn't a valid type, etc it gets skipped over and the external link remains in place. The process runs one image through at a time to avoid any issues with something breaking mid-way and reloads after 25 images to avoid browser timeouts.

But critical errors can always throw curve balls so for beta 3 we're adding a field to store the old link. Just in case.

When you re-ran the script did it say there was nothing to process? Are all of the products now showing local paths?

You can query: SELECT productid,mainphoto,uploadimg FROM pf_products

[Ted S]

The add image from an url is gone too, all I have open to me now is to upload a new image!

Once you use the uploader on a product we assume you're uploading images [for that product] and hide the fields from view to keep the edit field less cluttered.

I'm not sure why you'd want to go from an uploaded image to an external url rather than another upload but you can reset it by changing the uploadimg flag to 0.

[Kirk Fitzgerald]

The err is mine Ted, I have made an error in the image view url in the core settings, just trying to figure out what I should have in there now. :)

[ywwz]

Doesnt' work for me. 4.2.0

[Kirk Fitzgerald]

Hiya Ted,
doesn't matter what I change the "Image View Url" to in the core settings, when I check the view in Products listing page all I see is this text where the thumbnail should be:
product photo for Peterson System Smooth 317 Small Briar
139808
When I use firebug to check the image location I see this:
/productphotos/50014e732fa54_thumb.jpg
and a message saying "failed to load the given url"

In the core settings I have set the Image View Url to '/productphotos' but still cannot see any images anywhere.

I have the images in "C:\xampp\htdocs\vb4dev\productphotos"

Any ideas what I am doing wrong here TEd, it's all getting to be a bit of a headache now!

[Ted S]

Doesnt' work for me. 4.2.0

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

[Ted S]

Hiya Ted,
doesn't matter what I change the "Image View Url" to in the core settings, when I check the view in Products listing page all I see is this text where the thumbnail should be:

139808
When I use firebug to check the image location I see this:
/productphotos/50014e732fa54_thumb.jpgand a message saying "failed to load the given url"

In the core settings I have set the Image View Url to '/productphotos' but still cannot see any images anywhere.

I have the images in "C:\xampp\htdocs\vb4dev\productphotos"

Any ideas what I am doing wrong here TEd, it's all getting to be a bit of a headache now!

So /productphotos/ is the folder images are set to go to... but when you open it are the images there? If so, do they load properly?

If not, try changing one or two products to an external url [via your database or adding a new item], run the sync script again and see how those look.

You can run this version of admincp/productforums.php which will print debug code if you're not sure on the paths

[Kirk Fitzgerald]

Hi Ted, the images are present in the /productphotos/ folder but are not loading, I tried adding two new products on my test environment, nothing changed.

I uploaded the new admincp/productforums.php you posted but don't know how to get the debug stuff to show, I turn on debugging but have no idea how make it show!

I think it is going to be simpler for me to delete my existing install on my live site and re-install with 1.3 when it's stable and start afresh. I don't want my site to be running a patched up version of your brilliant mod, I should like it to be functioning fully and properly. :)

[Ted S]

Hi Ted, the images are present in the /productphotos/ folder but are not loading, I tried adding two new products on my test environment, nothing changed.

I uploaded the new admincp/productforums.php you posted but don't know how to get the debug stuff to show, I turn on debugging but have no idea how make it show!

I think it is going to be simpler for me to delete my existing install on my live site and re-install with 1.3 when it's stable and start afresh. I don't want my site to be running a patched up version of your brilliant mod, I should like it to be functioning fully and properly. :)

In a controlled environment beta means "this mostly works, we're testing to fix the rest" but in mass software beta is more akin to "this works every way we've tested, now we need to see what happens when you try it under other settings". Simply put there is no way for us to account for all of the possible variations, setting, servers that exist out there so while it's painful to watch "issues" come in, it's how mods work.

And, given how vBulletin runs mods, upgraded or new, you get the exact same build structure.

..........

At this point there are no known issues with 1.3.0 beta including the image sync routine -- so obviously we'd like to understand what's happening to your site and if there is indeed an issue in the script before we roll this code to "stable".

So, if you're up for it, let's think through this...

Correct me if I'm wrong but images (3 versions per product) do exist in /productphotos/.
When you view one locally it loads and looks like, well, a product image
But when you load it from the page it does not.Does that sum up the issue you are experiencing?

The debug script I provided only runs when you run the image sync process on new images. It's completely unrelated to the admin setting.

[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/s386/KirkFitzgerald/PetersonCeramic3PipeStandPipeRack.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
139818

Viewing forum
139817

Viewing the Product itself
139820

Viewing Product listings
139819

[Ted S]

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]

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?do=matches&productid=1
Referrer : http://xxx/forum/threads/275
IP Address : xxx
Username : xx
Classname : vB_Database
MySQL Version : 5.5.23-55

[Ted S]

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?do=matches&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]

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]

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\KirkFitzg erald\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%5CKirk Fitzgerald%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]

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\KirkFitzg erald\PetersonCeramic3PipeStandPipeRack.jpgbut where it sends me when I put it in the broswer is this:
http://localhost/vb4dev/%5C%5Ci1049.photobucket.com%5Calbums%5Cs386%5CKirk Fitzgerald%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]

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:

[Kirk Fitzgerald]

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...

Hi Ted,
yes, I did sync the images and I did run the query, the result you are seeing in my last post is the result of adding a product from the front end where members would be submitting Products. I changed nothing after running the query other than submitting a new Product on the front end to see what happened, and the results I posted was what happened.

Perhaps this is a problem specifically with using Xampp on localhost, I don't know, windows is notorious for being riddled with bugs, we may be looking at a conflict that windows is to blame for. I don't know what else to tell you Ted, the process I went through has been laid out as acted upon, I have absolutely no idea why the results are as they are.

I could shut down my real site for an hour or so, back up everything and run the upgrade there for the Beta and see what happens!

[qpurser]

Ted,
I used your "old" mod which worked fine for me and love it.
I just updated to your newest version and a little confused/lost.

Now all the new reviews I post need approval/moderation. I can't figure out anymore how to turn this off as I don't want to approve them.

Also when adding a new review the image uploader doesn't show up on the page.
What could be the issue?

Thanks for any help or suggestions
Michael

[Ted S]

Now all the new reviews I post need approval/moderation. I can't figure out anymore how to turn this off as I don't want to approve them.

The moderation process didn't change but it is an admin option in the general settings [Screen New Reviews?]. Also be sure that your forum settings don't place posts into moderation either.

Also when adding a new review the image uploader doesn't show up on the page. What could be the issue?Reviews don't get images.... Products do and only as an admin.

[Ted S]

Hi Ted,
yes, I did sync the images and I did run the query, the result you are seeing in my last post is the result of adding a product from the front end where members would be submitting Products. I changed nothing after running the query other than submitting a new Product on the front end to see what happened, and the results I posted was what happened.

Perhaps this is a problem specifically with using Xampp on localhost, I don't know, windows is notorious for being riddled with bugs, we may be looking at a conflict that windows is to blame for. I don't know what else to tell you Ted, the process I went through has been laid out as acted upon, I have absolutely no idea why the results are as they are.

I could shut down my real site for an hour or so, back up everything and run the upgrade there for the Beta and see what happens!

Well if you added an external url image and then ran my query which was designed to handle internal urls of course it broke. Like I said when I posted it, it will impact every url.

Can you do the same source comparison on an image that was actually up and moved locally?

[Kirk Fitzgerald]

Well if you added an external url image and then ran my query which was designed to handle internal urls of course it broke. Like I said when I posted it, it will impact every url.

Can you do the same source comparison on an image that was actually up and moved locally?

Ah, okay, sure, here is one that was already there, the source shows this:
<img src="\productphotos\5001db3eda3fd_full.jpg" style="max-width:300px;max-height:300px;" />

[Ted S]

Ah, okay, sure, here is one that was already there, the source shows this:
<img src="\productphotos\5001db3eda3fd_full.jpg" style="max-width:300px;max-height:300px;" />

Now we're on the right track...

So \productphotos\5001db3eda3fd_full.jpg

1. If you type this path into windows [C:\server\...\productphotos\] does it work?

2. When you open the file 5001db3eda3fd_full.jpg from that folder in windows, does it show anything?

3. Looking at another image on your pages that does work, what's the path?

[Kirk Fitzgerald]

Now we're on the right track...

So \productphotos\5001db3eda3fd_full.jpg

1. If you type this path into windows [C:\server\...\productphotos\] does it work?

2. When you open the file 5001db3eda3fd_full.jpg from that folder in windows, does it show anything?

3. Looking at another image on your pages that does work, what's the path?

C:\xampp\htdocs\vb4dev\productphotos\
This opens the productphotos directory in windows successfully


C:\xampp\htdocs\vb4dev\productphotos\5001db3eda3fd _full.jpg
This opens the image with windows image viewer successfully

The no image icon shows on the Product listings page, it loks like this:
<img src="themes/pscubby/rating/pf/noimage-75.png" width="75" height="75" border="0" alt="missing photo" />

[nibb]

Hi Ted S, does the beta fix the issue I commented some replies back?

I still have this plugin installed but nobody can review anything. Should I install the beta or wait for a fix?

Regards

[Ted S]

Hi Ted S, does the beta fix the issue I commented some replies back?

I still have this plugin installed but nobody can review anything. Should I install the beta or wait for a fix?

Regards

What was the issue?

[Ted S]

C:\xampp\htdocs\vb4dev\productphotos\This opens the productphotos directory in windows successfully


C:\xampp\htdocs\vb4dev\productphotos\5001db3eda3fd _full.jpgThis opens the image with windows image viewer successfully

The no image icon shows on the Product listings page, it loks like this:
<img src="themes/pscubby/rating/pf/noimage-75.png" width="75" height="75" border="0" alt="missing photo" />

Ok, well I have no idea why the link didn't work then but it feels like we're close...

Try changing the source in your template from {vb:raw mainphoto} to productphotos/5001db3eda3fd_full.jpg

[Ted S]

PRF users... Thank you so much for trying out beta out and the feedback!

Just a quick heads up for you all that our team will be at an offsite much of this week with limited access. We will of course still try to provide the fastest support we can and, given that all signs for the beta point up, we hope to launch the stable version of 1.3.0 the following week!

[Kirk Fitzgerald]

PRF users... Thank you so much for trying out beta out and the feedback!

Just a quick heads up for you all that our team will be at an offsite much of this week with limited access. We will of course still try to provide the fastest support we can and, given that all signs for the beta point up, we hope to launch the stable version of 1.3.0 the following week!

Opened productforums_listed_bit
replaced this line:
<a href="{vb:raw vboptions.bburl}/showthread.php?t={vb:raw threadid}" class="title"><img src="{vb:raw mainphoto_thumb}" border="0" alt="product photo for {vb:var title}" /></a>
With this line:
<a href="{vb:raw vboptions.bburl}/showthread.php?t={vb:raw threadid}" class="title"><img src="productphotos/5001db3eda3fd_full.jpg" border="0" alt="product photo for {vb:var title}" /></a>


It did this:

[nibb]

Hi Ted S, does the beta fix the issue I commented some replies back?

I still have this plugin installed but nobody can review anything. Should I install the beta or wait for a fix?

Regards

I think I explained the issue some topics back and I was not the only one affected by this, just look some pages back. You said it would be fixed in a future release, not sure if this beta is the next release.

I always get the message that the description does not contain the minimum length to send the review.

[Phrost]

Hi Ted, you know we're fans of your work so you'll excuse me if I'm being repetitive, but does this new version allow for multiple ratings categories for an individual product?

The full change log mentioned customization, and this is the feature that's keeping us from implementing the product on our big board.

[Ted S]

I think I explained the issue some topics back and I was not the only one affected by this, just look some pages back. You said it would be fixed in a future release, not sure if this beta is the next release.

I always get the message that the description does not contain the minimum length to send the review.

Unfortunately this forum does not have a method for tracking issues thus once something is pages back remembering who specifically asked about it is about impossible. Thus it's much easier to include the topic than for us to go finding it..

That said, we have addressed this as explained in the change log. Of course we'll leave it to you to confirm if it works properly with your forum settings.

[Ted S]

Hi Ted, you know we're fans of your work so you'll excuse me if I'm being repetitive, but does this new version allow for multiple ratings categories for an individual product?

The full change log mentioned customization, and this is the feature that's keeping us from implementing the product on our big board.

Yes, you can add multiple rating attributes to products using a 5-star, yes/no or free-form attribute. The option is global [all ratings for all products] and will be for the time being.

Take a look at the screenshots or try the beta and let us know if this cuts it.

[Ted S]

Opened productforums_listed_bit
replaced this line:
<a href="{vb:raw vboptions.bburl}/showthread.php?t={vb:raw threadid}" class="title"><img src="{vb:raw mainphoto_thumb}" border="0" alt="product photo for {vb:var title}" /></a>With this line:
<a href="{vb:raw vboptions.bburl}/showthread.php?t={vb:raw threadid}" class="title"><img src="productphotos/5001db3eda3fd_full.jpg" border="0" alt="product photo for {vb:var title}" /></a>
It did this:

Looks like you just need to change the path set in your admin to productphotos/ and you'll be good to go.

[Kirk Fitzgerald]

Looks like you just need to change the path set in your admin to productphotos/ and you'll be good to go.

Changed img url to productphotos/
I am sorry to report that there is no improvement.

[Ted S]

Changed img url to productphotos/
I am sorry to report that there is no improvement.

Whats the resulting image path you see when you view a page?

[Kirk Fitzgerald]

Whats the resulting image path you see when you view a page?

In Product Listing page I see this in page source:
<img src="\productphotos\50014e732fa54_full.jpg">

[Ted S]

In Product Listing page I see this in page source:
<img src="\productphotos\50014e732fa54_full.jpg">

You'll need to add a new product or edit the photo on an existing one.

This version of admincp/productforums.php will let you edit images even if there was already an upload.

[Kirk Fitzgerald]

You'll need to add a new product or edit the photo on an existing one.

This version of admincp/productforums.php will let you edit images even if there was already an upload.

Adding a new product works perfectly, editing an existing product image is also working. :)

So I will need to edit the images of all existing products to make the images work properly, bit of a pain but I can live with that, thank you for some seriously excellent and first rate support Ted, you're a heck of a fine chap. :up:

[Ted S]

Adding a new product works perfectly, editing an existing product image is also working. :)

So I will need to edit the images of all existing products to make the images work properly, bit of a pain but I can live with that, thank you for some seriously excellent and first rate support Ted, you're a heck of a fine chap. :up:

We can fix this with a simple query...


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


Or something along those lines depending on your current image paths.

[Note: to replace \ you must escape it with another \ thus \\]

[Kirk Fitzgerald]

We can fix this with a simple query...


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


Or something along those lines depending on your current image paths.

[Note: to replace \ you must escape it with another \ thus \\]

What a star, I used this:

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

and everything is fine, just had to re-upload an image for the one I changed earlier and it's working properly now. :)

Thank you Ted. :)

[Ted S]

What a star, I used this:

update pf_product set mainphoto = replace(mainphoto, '\\productphotos\\', 'productphotos/');
update pf_product set mainphoto_thumb = replace(mainphoto_thumb, '\\productphotos\\', 'productphotos/');
update pf_product set mainphoto_small = replace(mainphoto_small, '\\productphotos\\', 'productphotos/');and everything is fine, just had to re-upload an image for the one I changed earlier and it's working properly now. :)

Thank you Ted. :)

Images aside, how's the rest of the addon working for you?

[Kirk Fitzgerald]

Images aside, how's the rest of the addon working for you?

Images aside, the addon works without flaw or error, the improvements in 1.3 are absolutely breath-taking, very very excited about the coming stable release. :)

[Ted S]

With the release of 1.3.1 stable we wanted to provide a quick recap on how to upgrade. While the process is straight forward and quick, the new image uploading and other features do make it important to go through a few extra steps so please read on and ask if you have any questions:

1. Start with a backup of your forum for this or any other mod you install.

2. Download the latest version of PRF and upload the contents of the upload folder to your forum directory

3. From your AdminCP update the Product Forums plugin package to the included file

4. Review the main addon settings paying special attention to the new upload and image paths if you wish to use the image uploading features

5. Run the image sync script to convert existing images from external links to local images [requires cURL and GD]

6. Post your comments / suggestions whether they're good, bad or indifferent back here for us, and everyone else in the community

This is a major update and as such you'll see changes throughout the templates and phrases. As always we encourage you to make the mod your starting place and customize beyond it with the options and your own adjustments.

For those who wish to use the image uploader & sync script you will need to have cURL and GD installed on your server and be able to create a writeable folder for images to be saved in. Images can be processed either one at a time by editing an existing product or in bulk by using the sync images link which will fetch all external images and resize, localize and update them [credit too Simon Jarvis (http://www.white-hat-web-design.co.uk/articles/php-image-resizing.php)].


The complete install & customization guide can be found @ http://www.giftery.me/productforums/howto/

[Ted S]

Wondering what's new? Here's the main changes [yes, there's a lot of them]
Customizable rating options... yes/no, 5-star and text freeform
Product images. You upload, we resize [gd required]
Bulk image importing from external links [curl & gd required]
Thumbnails all over... the product index, even forum display
Activity Stream updates when a review is posted
Support for user-selected thread prefixes
Automatic add product links for the user
Improvements to product management for speedier changes
Cleaned up product adding interfaces for admin use
Lots of small tweaks, bug fixes and other changesSee the full change log @ http://www.giftery.me/productforums/changelog

[RPSmedia]

Hi Ted, great product and you saved me lots of money with this. I've got the beta working good but the only thing is I can't find where users can upload the pictures.

Thanks.

[Ted S]

Hi Ted, great product and you saved me lots of money with this. I've got the beta working good but the only thing is I can't find where users can upload the pictures.

Thanks.

They don't. For a variety of reasons we opted not to build this into 1.3, or at least not uploads. Of course end users can specify a link for an image which, if you run the sync script, will get converted in.

[Kirk Fitzgerald]

Hey Ted,

importing bulk xml's isn't working on my site, is there something I am missing here, I import a bulk xml, the script runs and says done but there are no products showing at all!

[Ted S]

Hey Ted,

importing bulk xml's isn't working on my site, is there something I am missing here, I import a bulk xml, the script runs and says done but there are no products showing at all!

Is your product feed in the right format? If so you'll see an update on each product if finds and whether it's new, existing or incomplete.

[Kirk Fitzgerald]

Is your product feed in the right format? If so you'll see an update on each product if finds and whether it's new, existing or incomplete.

It was my error there Ted, I forgot to add the <productData> opening in each xml, but now I got a database error:
Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT threadid FROM thread WHERE title = 'Dr Plumb 9mm Absorbent Carbon smoking Pipe Filters 10's';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's'' at line 1
Error Number : 1064
Request Date : Sunday, July 22nd 2012 @ 01:35:11 AM
Error Date : Sunday, July 22nd 2012 @ 01:35:12 AM
Script : http://www.pipesmokerscubby.com/admincp/productforums.php?do=do_xml
Referrer : http://www.pipesmokerscubby.com/admincp/productforums.php?do=xml
IP Address : 86.130.60.119
Username : Kirk Fitzgerald
Classname : vB_Database
MySQL Version : 5.1.63-community-log

Any ideas on this Ted?

[Ted S]

It was my error there Ted, I forgot to add the <productData> opening in each xml, but now I got a database error:


Any ideas on this Ted?

It's the ' in the line which is not being escaped...

admincp/productforums.php attached

[Kirk Fitzgerald]

It's the ' in the line which is not being escaped...

admincp/productforums.php attached

Perfect, thanks Ted

[Kirk Fitzgerald]

Hey Ted,
what happened to the images on the forum/productforums.php page, the product listings no longer have images, has this feature been removed since the Beta?

[Ted S]

Hey Ted,
what happened to the images on the forum/productforums.php page, the product listings no longer have images, has this feature been removed since the Beta?

Nothing was changed in this between beta 2 and the final... In our test site images show up just fine.

Have you checked your template to be sure it's not using an older, customized version?

[Kirk Fitzgerald]

Nothing was changed in this between beta 2 and the final... In our test site images show up just fine.

Have you checked your template to be sure it's not using an older, customized version?

Okay, had to revert some templates, huge changes in some templates then, the files don't even compare in winmerge, they are too different now, will have to figure out my changes again, no biggie I guess, just annoying.

Thanks for your help Ted, much appreciated. ):

[Kirk Fitzgerald]

Little addition for anyone wanting it in the forumdisplay for your products, to add the +add new product button to be at the top of the thread listing as well as the bottom, do the following:

Open FORUMDISPLAY

FIND:
<div id="above_threadlist" class="above_threadlist">

BELOW ADD:
<vb:if condition="$show['newproduct']">
<a href="{vb:raw $vboptions.vbforum_url}{vb:if "$vboptions['vbforum_url']", '/', ''}productforums.php?do=addproduct" rel="nofollow" class="newcontent_textcontrol" id="newthreadlink_top"><span>+</span> {vb:rawphrase post_newproduct}</a>
</vb:if>

Perhaps something you could add in future release Ted, not essential as easy enough to hack. :)

[Ted S]

Little addition for anyone wanting it in the forumdisplay for your products, to add the +add new product button to be at the top of the thread listing as well as the bottom, do the following:

Open FORUMDISPLAY

FIND:
<div id="above_threadlist" class="above_threadlist">BELOW ADD:
<vb:if condition="$show['newproduct']">
<a href="{vb:raw $vboptions.vbforum_url}{vb:if "$vboptions['vbforum_url']", '/', ''}productforums.php?do=addproduct" rel="nofollow" class="newcontent_textcontrol" id="newthreadlink_top"><span>+</span> {vb:rawphrase post_newproduct}</a>
</vb:if>Perhaps something you could add in future release Ted, not essential as easy enough to hack. :)

There's no hook to add it there or we would have :(

[mickknutson]

Do the products become threads that are automatically Added to the SEO sitemap each night?

Will these threads also be included in the RSS feed for the site?

[Ted S]

Do the products become threads that are automatically Added to the SEO sitemap each night?

Will these threads also be included in the RSS feed for the site?

Products are regular threads and will show up in any regular syndication although since the details are saved separately aside from the title you may want to commit them from your RSS process.

[qpurser]

Ted,
just updated to the latest version and all seem to work great but I have an issue with the images.
I added the URL from an external image by using the option "add new product" on the site itself.
When I sync then the pics in my admin CP I get the following message:
couldnt understand the image for - skipping
All Done!

When I look in the created thread the pic is there however looking into the general overview page the thumbnail is not there. Just a question mark.
I looked into my server and the thumbnail was created in the correct folder. Also when I looked into the link where the question mark is it points to the correct image and folder on my server.

What could be wrong?
Thanks for any help
Michael

[RPSmedia]

Which version gives you image uploading then?

"Product images. You upload, we resize [gd required]"

Also, how do you add different fields (sorry if I missed how to, I searched)

[1320Nation]

Hey Ted, I downloaded and installed version 1.2.3 and have really not used it yet. Would it be better for me to uninstall that version, and then install the newest version? Or just upgrade the older version I mentioned?

[Ted S]

Which version gives you image uploading then?

"Product images. You upload, we resize [gd required]"

Also, how do you add different fields (sorry if I missed how to, I searched)

1.3+ gives admin photo uploading and resyncing user submitted images.

You add fields through your AdminCP. Expand the first PRF option group on the navbar.

[Ted S]

Hey Ted, I downloaded and installed version 1.2.3 and have really not used it yet. Would it be better for me to uninstall that version, and then install the newest version? Or just upgrade the older version I mentioned?

When you install a vBulletin mod it adds version 1, 2, 3, etc... to account for upgrades so it really makes no difference.

[Ted S]

Ted,
just updated to the latest version and all seem to work great but I have an issue with the images.
I added the URL from an external image by using the option "add new product" on the site itself.
When I sync then the pics in my admin CP I get the following message:
couldnt understand the image for - skipping
All Done!When I look in the created thread the pic is there however looking into the general overview page the thumbnail is not there. Just a question mark.
I looked into my server and the thumbnail was created in the correct folder. Also when I looked into the link where the question mark is it points to the correct image and folder on my server.

What could be wrong?
Thanks for any help
Michael

Michael -

I'm not sure I'm following... you get the error but see a local copy of the main image for the same product but not a thumbnail? When you view the thumbnail created directly does the image file work [render]?

[qpurser]

Michael -

I'm not sure I'm following... you get the error but see a local copy of the main image for the same product but not a thumbnail? When you view the thumbnail created directly does the image file work [render]?

Sorry if my explanation was a little complicated to follow.
I went through all the steps again and I found the issue. I had something wrong in my URL settings for the image folder.

Really sorry I have wasted your time to follow up on this while it was my mistake. Feel so stupid right now.

Michael

[Ricsca]

Now it works, really nice component ...

you can upload images to the users?

[Ricsca]

In my forum is on the box for quick response.
Is there a way to disable it in the forum to display the reviews?
The quick answers are not counted as votes.

[Kirk Fitzgerald]

In my forum is on the box for quick response.
Is there a way to disable it in the forum to display the reviews?
The quick answers are not counted as votes.

The quick reply box is removed in the latest version, which version are you using?

[Ricsca]

excuse is true;)

[RPSmedia]

1.3+ gives admin photo uploading and resyncing user submitted images.

You add fields through your AdminCP. Expand the first PRF option group on the navbar.

Sorry for being a pain. I'm running 1.3.0 beta 2.

I'm guessing you're talking about adding fields in the Custom Ratings Field? When I do that, nothing shows up.

** edit - I just upgraded to 1.3.1 but still can't get the extra options to show up. Thanks.

[Kirk Fitzgerald]

Hi Ted,
found a bug, when searching for products in the admincp, when I select a specific category (Pipes) I get a page saying 151 results and the first 10 results, when i click next page the search result returns 'all' 366 products not just the remainder of the 151 from Pipes that I searched for.

[Ted S]

Sorry if my explanation was a little complicated to follow.
I went through all the steps again and I found the issue. I had something wrong in my URL settings for the image folder.

Really sorry I have wasted your time to follow up on this while it was my mistake. Feel so stupid right now.

Michael

No problem!

[Ted S]

Now it works, really nice component ...

you can upload images to the users?

End users can not upload images. They can however add a url for an image which the admin can either upload or import via the image sync script.

[Ted S]

Sorry for being a pain. I'm running 1.3.0 beta 2.

I'm guessing you're talking about adding fields in the Custom Ratings Field? When I do that, nothing shows up.

** edit - I just upgraded to 1.3.1 but still can't get the extra options to show up. Thanks.

Have you upgraded from a past version? If so, check that your templates are all reverted.

If not, what are the settings on your custom groups?

[Ted S]

Hi Ted,
found a bug, when searching for products in the admincp, when I select a specific category (Pipes) I get a page saying 151 results and the first 10 results, when i click next page the search result returns 'all' 366 products not just the remainder of the 151 from Pipes that I searched for.

Thanks. We'll get this tackled in 1.3.2

[Kirk Fitzgerald]

Thanks. We'll get this tackled in 1.3.2

Excellent, look forward to it. :)

[RPSmedia]

Have you upgraded from a past version? If so, check that your templates are all reverted.

If not, what are the settings on your custom groups?

my first install was the 1.3.0 beta 2 and then I upgraded to the 1.3.1 and it all looks the same.

As for usergroup permissions, I only have it set for the administrators right now to be able to add products. If it's something different you're asking then I'm not sure.

thanks for the help

[Ted S]

my first install was the 1.3.0 beta 2 and then I upgraded to the 1.3.1 and it all looks the same.

As for usergroup permissions, I only have it set for the administrators right now to be able to add products. If it's something different you're asking then I'm not sure.

thanks for the help

Not usergroup settings, custom rating settings. What options did you add? Can you share a screenshot of one of the product rating pages?

[RPSmedia]

I put in three tests.

[Ted S]

I put in three tests.

Great. And how about a screenshot of your write a review page?

[RPSmedia]

OK I see now. I need to ask a better question then. How do I add more details for the person to enter when adding a new product to be reviewed.

My example is I'm going to put in a gun, I don't need SKU, etc. but I do need model, caliber, etc.

thanks for your patience

[Ted S]

OK I see now. I need to ask a better question then. How do I add more details for the person to enter when adding a new product to be reviewed.

My example is I'm going to put in a gun, I don't need SKU, etc. but I do need model, caliber, etc.

thanks for your patience

There's no built in support for that.

You could of course add a database field, query element and for field. [and I'm pretty sure all major gun brands use SKUs to identify products].

[RPSmedia]

There's no built in support for that.

You could of course add a database field, query element and for field. [and I'm pretty sure all major gun brands use SKUs to identify products].

Thanks for all of your help. This saved me over $100 and fits the need completely!

[Ted S]

Thanks for all of your help. This saved me over $100 and fits the need completely!

Awesome!!

[ludachris]

Anyone have any luck porting this modification to 3.8 or know a trusted developer that could do it?

[Ted S]

Anyone have any luck porting this modification to 3.8 or know a trusted developer that could do it?

Given the way this mod works it would be a pain, although certainly possible, to port it down to 3.8. For reasons that aren't worth diving too far into we've elected to move to 4.x only but would certainly support anyone's desire to build out a ported version.

[IGCEMA]

Ted,
Nice mod first off. I wanted to ask where you have the photos is it possible to embed a video in place of that image? The reason I ask is I want to use this mod as a way to review our communities live stream broadcasts. Each person has their own embed code which I think would work well if it were embeded in the photo area. Let me know what you think and if this is possible.

[Ted S]

Ted,
Nice mod first off. I wanted to ask where you have the photos is it possible to embed a video in place of that image? The reason I ask is I want to use this mod as a way to review our communities live stream broadcasts. Each person has their own embed code which I think would work well if it were embeded in the photo area. Let me know what you think and if this is possible.

Sure...

Basically you'd ignore the thumbnail image fields and rename the input for the main image to video url then change the detail template to call that as an embed link. The script checks that field for a valid url so you'd either have to change that to allow HTML or just use a youtube style link [or such].

Basically you're looking at template edits with the possibility of one or two small code changes depending on where videos are stored.

[imported_dfmafia]

Looks like I lost the prefixes. I'm getting the same error as last time. I tried to add a product today for review and it's not letting me as a user.

I do not have an option to select a prefix anymore.

[Ted S]

Looks like I lost the prefixes. I'm getting the same error as last time. I tried to add a product today for review and it's not letting me as a user.

I do not have an option to select a prefix anymore.

Did you upgrade your version or change any prefix settings?

[imported_dfmafia]

I updated it. Guess I'll revert to the one that was working.

[imported_dfmafia]

upgraded to latest. i just disabled require prefix to post and it works. though cant add a prefix to reivew or product. can select a category but I'd have to make new categories to match the prefixes already established. categories are useless to me as I am unable to use them to sort through a mass of products or reviews. whereas I can with the clickable prefixes mod

also i create product and it posts to forumid 88 as an inactive product. when i activate it via the admincp it disappears...now is in forumid 45
create a review and it posts to forumid 45

but when I activate the product it posts to the review forumid 45 and disappears from the forumid 88 for product displays.

I'd like to keep the products seperate from the reviews or reviews as reply posts under the product thread. at this time this is not happening. a review is made and creates a new thread.

my current settings are:

Review Thread Forum ID
Required only if "Create Thread On Review" is enabled. Specify which forum [by id] product reviews should be posted too. You may want to disable posting new threads to this forum. forumid 88

and
New Product Forum ID
The forum where user-created product threads are placed by default. forumid 45

88 is my product reviews forum topic
45 is my product display forum topic

the attached image may shed some light on what is happening. the prefixed threads are threads made before the mod. this was our old system and I haven't removed it...yet. Once this works I will remove these posts.

http://mrdeids.com/forums/forumdisplay.php/88-Product-Reviews

https://vborg.vbsupport.ru/attachment.php?attachmentid=140174&stc=1&d=1343527647

[Ted S]

Reviews will always make a post reply, there's no setting or function to disable this... the thread is the option which you can turn on or off.

Approving a product lets you change the forum [the first option] so be sure the area you want it to be in is the same as what's selected.

As far as prefixes, nothing should have changed but we'll figure it out.

[Phrost]

Yes, you can add multiple rating attributes to products using a 5-star, yes/no or free-form attribute. The option is global [all ratings for all products] and will be for the time being.

Take a look at the screenshots or try the beta and let us know if this cuts it.

Thanks Ted, going to give this a whirl.

[imported_dfmafia]

Reviews will always make a post reply, there's no setting or function to disable this... the thread is the option which you can turn on or off.

Approving a product lets you change the forum [the first option] so be sure the area you want it to be in is the same as what's selected.

As far as prefixes, nothing should have changed but we'll figure it out.

am I able to stick the products to top of thread display? I'd like to keep the thread display clean with products on top and reviews below if I am unable to have products in one forum and reviews in another.

currently I am only able to select one forum. the review forum. I tried to enter more than one forumid but that didnt take. ie. 45,88

[Ted S]

am I able to stick the products to top of thread display? I'd like to keep the thread display clean with products on top and reviews below if I am unable to have products in one forum and reviews in another.

Product threads can be created in multiple forums you want. Simply enable the option per forum and either create a product their in your ACP or move a user submitted product there also via your ACP.

Review threads can go in any one forum you want. If you chose to enable them at all.

Review replies always go into the product thread and are not an option.

You can do whatever you want with the threads themselves, just be sure product threads stay in a forum that's product review enabled.

An example structure can be found in the main post of this mod showing 4 different product areas and one review discussion area.

[imported_dfmafia]

makes sense now. working now. i didnt have my product display forum enabled for the review system. all good now.

thanks again ted!

[Ted S]

makes sense now. working now. i didnt have my product display forum enabled for the review system. all good now.

thanks again ted!

If you had just looked at the whiteboard in the conference room it's all mapped out and explained with flawless logic. Except I suppose you can't quite see that :D

Glad it's working out. Still digging into prefixes however...

[zakonline]

Excellent Mod, Installed and using it :) Thanks a lot. Just a small question how do i allow Registered users to Add the Product?

[imported_dfmafia]

Excellent Mod, Installed and using it :) Thanks a lot. Just a small question how do i allow Registered users to Add the Product?

Usergroup permissions. about 1/3 from the bottom of the option list

[Ted S]

Excellent Mod, Installed and using it :) Thanks a lot. Just a small question how do i allow Registered users to Add the Product?

Looks like I got beat to the answer but please be sure to review the install guide if you have not done so already. I know it's long but there's a few critical settings required to actually make this work.

[mickknutson]

Review item categories?

Is it possible to create separate categories such as:

Product Reviews
|--> Parachute gear
|--> Rock climbing gear
|--> Surfing gear

This way I can have some sort of organization...?

[Ted S]

Review item categories?

Is it possible to create separate categories such as:

Product Reviews
|--> Parachute gear
|--> Rock climbing gear
|--> Surfing gear

This way I can have some sort of organization...?

Sounds like I need to clean up the introduction a bit... Let's try this:

PRF has two elements: products and reviews. Products are the master to which reviews are made, thus there needs to be a product before there can be a review.

You can structure product forums literally however you want with 3 even levels
- Gear 1
- Gear 2
- Gear 3

Or you could nest levels to be even more specific

- Gear 1
--- Gear 1 subset a
--- Gear 1 subset b
- Gear 2
- Gear 3
--- Gear 3 subset a

Reviews will always be appended to product threads as posts plus you can optionally elect to have them create a new thread to just one forum.

Does that make sense? Does it accomplish your goal?

p.s. I'm an avid climber, diver, etc so if that's a real example shoot me over your forum url, I'd love to check it out. :D

[angeljs]

Please can you tell me where to look to change the product image size in the thread listing page in the forums?

[Ted S]

Please can you tell me where to look to change the product image size in the thread listing page in the forums?

Are you using image uploads or external urls?

[Kirk Fitzgerald]

Hey Ted,

can you tell me how to fix this problem please chap.

In the Products listings content that got imported through xml's all of the ' have been replaced with this ?€™.

See here: http://www.pipesmokerscubby.com/showthread.php?1014-Savinelli-Tortuga-Straight-Apple-207-6mm-Filter-Italian-Briar-Smoking-Pipe

[Ted S]

Hey Ted,

can you tell me how to fix this problem please chap.

In the Products listings content that got imported through xml's all of the ' have been replaced with this ’.

See here: http://www.pipesmokerscubby.com/showthread.php?1014-Savinelli-Tortuga-Straight-Apple-207-6mm-Filter-Italian-Briar-Smoking-Pipe

What happens when you look up that product's description in the database?

SELECT description FROM pf_product WHERE productid = XXXX

[Kirk Fitzgerald]

This is what is in the database for the content of this post: http://www.pipesmokerscubby.com/showthread.php?1014-Savinelli-Tortuga-Straight-Apple-207-6mm-Filter-Italian-Briar-Smoking-Pipe

Savinelli, the worlds No.1 selling pipe Ferrari have given the Italians a reasonable edge in the world of motoring but that?€™s not all they strive at. Since 1876 Savinelli have kept the Italians at the pinnacle of the pipe manufacturing game! Putting the Italian legacy behind us for a minute if you where to look at the Savinelli range you could be forgiven for thinking they are a classic high end British made pipe. We have received a number of comments over the years from our high end pipe customers who believe the quality of the briar and the finish of Savinelli pipes exceed what is strongly regarded as the epitome of the pipe world and they don?€™t demand the same price tag (No names mentioned as we are British through and through) Savinelli Tortuga 207 The Savinelli Tortuga 207 is a classic straight Apple 6mm smoking pipe with a stunning black, Sandblast finish on the bowl and contrasting tortoise shell effect, tapered, mouthpiece. The Apple shape is arguably the most comfortable bowl shape for most palms and the briar wall stays thickest where it is needed the most, which helps keep the pipe cool along with the smoke. Ash cap As soon as we saw the Savinelli Tortuga we had to have them. We?€™ve seen pipes with lids before but nothing this high end. Each Tortuga comes with a hand fitted lid, in a stunning tortoise shell effect to match the mouthpiece. The base of the lid is made from a fire proof rubber so you can plug the pipe mid smoke and bury your pipe in your pocket so the boss doesn?€™t catch you smoking. Balsa wood filter Unique to Savinelli is their Balsa wood filter system. The triangular shape does not form a seal in the bore of the pipe so allows an un-restricted full flavoured draw but the extremely porous and highly absorbent nature of the Balsa wood is very effective at removing moisture and impurities form the smoke. And for those who prefer a totally unfiltered smoke Savinelli provide a plug to block the system.

[Ted S]

And in your XML file are the single quotes actually ' or is it microsoft word's silly ` character?

[sgbmad]

Hi,

Installed and works perfectly on vBulletin 4.2.0.

Everything works but I have a issue. When someone write a review, the post created has the review comments duplicated.

Writing the review.

http://i.imgur.com/ccaWf.png

https://vborg.vbsupport.ru/external/2012/08/44.jpg

The post created with review comments duplicated.

http://i.imgur.com/OZ28M.png

https://vborg.vbsupport.ru/external/2012/08/45.jpg

How can I fix that? :(

Thanks!

[Kirk Fitzgerald]

And in your XML file are the single quotes actually ' or is it microsoft word's silly ` character?

In the xml the ' is an ?, so yeah, a silly Microsoft character!

[Ted S]

Hi,

Installed and works perfectly on vBulletin 4.2.0.

Everything works but I have a issue. When someone write a review, the post created has the review comments duplicated.

Writing the review.

http://i.imgur.com/ccaWf.png

The post created with review comments duplicated.

http://i.imgur.com/OZ28M.png

How can I fix that? :(

Thanks!

That's very, very strange.

Are you having any issues with the character count minimums not working?

What are your WYWIWYG settings?

Try this version of upload/productforums.php

[Ted S]

In the xml the ' is an ?, so yeah, a silly Microsoft character!

Haven't had a chance to test this but if the code is valid it should remove the special characters on any new / updated product.

upload/admincp/productforums.php

[sgbmad]

That's very, very strange.

Are you having any issues with the character count minimums not working?

What are your WYWIWYG settings?

Try this version of upload/productforums.php

No, I haven't issues with the minimum character count.

I set to "yes" the WYSIWYG editor.

With your productforums.php version works! No more duplicates :D

Thank you so much!

[Kirk Fitzgerald]

Is there anything I can do for the existing listings with a query perhaps Ted, there's 395 of them right now, updating each one at a time would take too long and I don't have so much free time.

Additionally Ted, is there any way for us to add more than just the one Affiliate shop link for each listing, our members of course are Worldwide and having shops just from one country is of no use to our members in Sweden or America or Africa etcetera. Is there also any way of adding additional affiliate shop links to existing Product listings?

[Ted S]

No, I haven't issues with the minimum character count.

I set to "yes" the WYSIWYG editor.

With your productforums.php version works! No more duplicates :D

Thank you so much!

Great!

[Ted S]

Is there anything I can do for the existing listings with a query perhaps Ted, there's 395 of them right now, updating each one at a time would take too long and I don't have so much free time.

Additionally Ted, is there any way for us to add more than just the one Affiliate shop link for each listing, our members of course are Worldwide and having shops just from one country is of no use to our members in Sweden or America or Africa etcetera. Is there also any way of adding additional affiliate shop links to existing Product listings?

The XML process should update every existing product that's included using the SKU / UPC and Title as a key.

There is only one link field supported by default but of course you could add more, or put them in the description.

[Kirk Fitzgerald]

Sorry Ted, not following, are you saying to re-upload the xml's, if so, will this put the product listings back into the fore of the site content as in the sideblocks for new posts and the activity page, I have just annoyed the hell out of my members by deleting all the listings and uploading the product xml's afresh, long story and rather a dull one. I shouldn't want all the Product listings to appear in the stats as new content again, I would have an uprising on my hands.

[sgbmad]

Great!

Ted, the new version of "productforums.php" works but it does not work totally because doesn't appear the custom fields. :(

[Ted S]

Sorry Ted, not following, are you saying to re-upload the xml's, if so, will this put the product listings back into the fore of the site content as in the sideblocks for new posts and the activity page, I have just annoyed the hell out of my members by deleting all the listings and uploading the product xml's afresh, long story and rather a dull one. I shouldn't want all the Product listings to appear in the stats as new content again, I would have an uprising on my hands.

If there's no new products there will be no new posts. The system updates what already exists... assuming it can find a match on the SKU or UPC that is.

[Ted S]

Ted, the new version of "productforums.php" works but it does not work totally because doesn't appear the custom fields. :(

Gotcha. Try this version...

/upload/productforums.php

[Kirk Fitzgerald]

If there's no new products there will be no new posts. The system updates what already exists... assuming it can find a match on the SKU or UPC that is.

Ah right, I didn't include the SKU's, I forgot to add them tot he xml's, and there are no UPC's to be used any way, so running the xml's again without the SKU's will cause problems!

[Ted S]

That's a problem indeed...

Do you have reviews on any / many of the products yet?

[Kirk Fitzgerald]

That's a problem indeed...

Do you have reviews on any / many of the products yet?

No there aren't any reviews just yet, I just re-uploaded the xml's recently and no-one has had chance to add reviews yet, but some are due in soon.

[Ted S]

No there aren't any reviews just yet, I just re-uploaded the xml's recently and no-one has had chance to add reviews yet, but some are due in soon.

Why not make a quick change to your XML to add in SKUs [they don't have to be real to anyone else, just a simple 001, 002, 003, ... works], delete the forum & existing products and reimport now?

This will save you a lot of headache making updates down the road.

[Kirk Fitzgerald]

Why not make a quick change to your XML to add in SKUs [they don't have to be real to anyone else, just a simple 001, 002, 003, ... works], delete the forum & existing products and reimport now?

This will save you a lot of headache making updates down the road.

Okay, so essentially I need to add sku's no matter what, it makes more sense to me to add the real ones, adding fake sku's would be a bit faster as I would not have to access the real ones from the source site but it feels wrong to me so I will add the real ones.

Ted, once I delete the existing Products and then import the xml's again, is there some way I can stop them from showing in the activity stream. Doing this is really going to annoy my members, it otherwise would add 395 new posts to the activity stream, I can't afford to anger my members with this again. I see I can exclude Product Reviews from the Activity Stream but I can't find any way of excluding the new threads created by the xml's in the forum specified in the core settings..

[Ted S]

Okay, so essentially I need to add sku's no matter what, it makes more sense to me to add the real ones, adding fake sku's would be a bit faster as I would not have to access the real ones from the source site but it feels wrong to me so I will add the real ones.

Ted, once I delete the existing Products and then import the xml's again, is there some way I can stop them from showing in the activity stream. Doing this is really going to annoy my members, it otherwise would add 395 new posts to the activity stream, I can't afford to anger my members with this again. I see I can exclude Product Reviews from the Activity Stream but I can't find any way of excluding the new threads created by the xml's in the forum specified in the core settings..

Can you exclude the forum from the stream? I've only worked with it enough to create our custom bit for reviews.

[Kirk Fitzgerald]

Can you exclude the forum from the stream? I've only worked with it enough to create our custom bit for reviews.

Oddly no, you would think vB would have included the option to include/exclude forums from the stream, bit stumped with this one!

[Ted S]

Oddly no, you would think vB would have included the option to include/exclude forums from the stream, bit stumped with this one!

Actually I'm not surprised. The activity stream is the most modular part of vB4 I've worked with and clearly just getting started... In searching for examples of mods with their own bits I found none so while I don't know that PRF is the first to get into it, it is possible.

There's no hooks for us to plug into, which is why we didn't make any exclusions in 1.3 but you can trick it manually... but it's not a solve I'd suggest.

How unique are your titles [i.e. how many overlap with other products]?

[Kirk Fitzgerald]

Actually I'm not surprised. The activity stream is the most modular part of vB4 I've worked with and clearly just getting started... In searching for examples of mods with their own bits I found none so while I don't know that PRF is the first to get into it, it is possible.

There's no hooks for us to plug into, which is why we didn't make any exclusions in 1.3 but you can trick it manually... but it's not a solve I'd suggest.

How unique are your titles [i.e. how many overlap with other products]?

A great many have similarities, there are multitudes fot Products from the same manufacturers, IE there are several listings starting with Falcon, or Peterson and so on. I am more than a little intrigued to learn where you are going with this. :)

[Ted S]

A great many have similarities, there are multitudes fot Products from the same manufacturers, IE there are several listings starting with Falcon, or Peterson and so on. I am more than a little intrigued to learn where you are going with this. :)

Well we don't have to match on SKU + Title, we could just do title but if there's products with identical titles that would cause all sorts of problems and essentially leave you with multiple items for one and no way to find what's missing.

[Kirk Fitzgerald]

Well we don't have to match on SKU + Title, we could just do title but if there's products with identical titles that would cause all sorts of problems and essentially leave you with multiple items for one and no way to find what's missing.

Every Product in the xml's have their own unique title, there are similar titles but none are identical!

[Ted S]

Every Product in the xml's have their own unique title, there are similar titles but none are identical!

admincp/productforums.php

checks on title alone [be sure to test this first before running it in production!]

[Kirk Fitzgerald]

Hiya Ted,

I placed that in my testbed localhost site, navigated to localhost site to products, the problem still exists, when I upload an xmls to the test site every letter 'd' now has a letter 'j' following it in product titles and descriptions!

[Ted S]

Hiya Ted,

I placed that in my testbed localhost site, navigated to localhost site to products, the problem still exists, when I upload an xmls to the test site every letter 'd' now has a letter 'j' following it in product titles and descriptions!

Ok but first let's see if the import update worked...

When you ran it what sort of output did you get [it should tell you if it updates or creates a product for each record].

Any duplication?

[appsfinder]

when submit a review i get an error how do i fix thanks,

Oh great, you had to go and press THAT button. There goes the whole site. Just kidding...

We had an issue posting your review because of
[ARG:2 UNDEFINED]. Try again or report this to our team and incldue code 164251-B.
:confused:

[Kirk Fitzgerald]

Ok but first let's see if the import update worked...

When you ran it what sort of output did you get [it should tell you if it updates or creates a product for each record].

Any duplication?

Working perfectly in the respect Ted, all Products on xml's show as Existing product... updating

[Ted S]

when submit a review i get an error how do i fix thanks,

Oh great, you had to go and press THAT button. There goes the whole site. Just kidding...

We had an issue posting your review because of
[ARG:2 UNDEFINED]. Try again or report this to our team and incldue code 164251-B.
:confused:

It means the script wasn't able to make a thread in the review forum. Have you set a forum to go along with enabling this option? Does that forum allow posts?

[Kirk Fitzgerald]

Working perfectly in that respect Ted, all Products on xml's show as Existing product... updating

Hey Ted,

by your not responding do I infer that it is safe to go ahead with the admincp/productforums.php file you provided me, what about the extra 'd' after all of the letter 'j'?

[Ted S]

Hey Ted,

by your not responding do I infer that it is safe to go ahead with the admincp/productforums.php file you provided me, what about the extra 'd' after all of the letter 'j'?

MS office does some nasty things with special characters, we'll have to work on the filtering a bit more using the version we posted for you. No reason to use it now unless you have other updates to make through XML importing.

[Kirk Fitzgerald]

MS office does some nasty things with special characters, we'll have to work on the filtering a bit more using the version we posted for you. No reason to use it now unless you have other updates to make through XML importing.

Nothing new to import, just keen to remove that bizarre formatting from the product descriptions, looks bad is all. ;)

[Kirk Fitzgerald]

Hiya Ted,

please do not continue with the weird character problem, I have just discovered the problem has absolutely nothing to do with your mod at all, the problem is coming from the source data itself, the weird characters are in the data entered into the xml's when I wrote them. I took the text from the website the products are sold on and they are right there in the text on that site.

So sorry for wasting your time with this, I will notify the site owner and let him know of the problem, thank you for your continued excellent first rate support Ted.

[Ted S]

Hiya Ted,

please do not continue with the weird character problem, I have just discovered the problem has absolutely nothing to do with your mod at all, the problem is coming from the source data itself, the weird characters are in the data entered into the xml's when I wrote them. I took the text from the website the products are sold on and they are right there in the text on that site.

So sorry for wasting your time with this, I will notify the site owner and let him know of the problem, thank you for your continued excellent first rate support Ted.

Good to hear but I'm glad we were also able to track down your XML matching so you can get those updates in a little easier...

[Phrost]

About to dive in on configuring this, but I had a stupid question:

You can use this with pre-existing threads, right?

Kind of a big deal for us, given that we're GARS refugees.

[Ted S]

About to dive in on configuring this, but I had a stupid question:

You can use this with pre-existing threads, right?

Kind of a big deal for us, given that we're GARS refugees.

Products have a whole extended set of data that is displayed back so you'd have to create that manually or import it off of other products. Basically yes, but not without some work.

[Phrost]

Thanks for the quick answer. Not being a developer, is there a guide to importing old GARS info, or even just old threads?

I have years worth of GARS reviews.

[Ted S]

Thanks for the quick answer. Not being a developer, is there a guide to importing old GARS info, or even just old threads?

I have years worth of GARS reviews.

It's never even been mentioned before so sorry but no info...

I'm not familiar with GARS in the least so if you can explain how it worked [were there items, clustered reviews, single reviews, etc] I can get more specific.

[Phrost]

GARS basically added extra fields and custom templates to a thread on a per-forum basis. It allowed you to have multiple numeric rating fields for a product (associated with a single thread). Each thread would be the "parent", and subsequent posts could either review the product by rating the various options, or just make an ordinary post.

For example, we had Martial Arts School reviews broken down with ratings such as:

*Class Size
*Equipment
*Facility
*Striking
*Grappling

All 1-10 ratings.

It was basically an overlay onto existing threads, and had options to customize the layouts of said threads. You could either use it as a Reviews, or an Article system, by customizing those meta-templates, and then assigning them to individual forums.

Here's the only screenshot of GARS that I have left; it's from a sidebar added to a forum thread displaying the ratings.

http://www.bullshido.net/images/ads/reviews.jpg

On a personal note, it boggles my mind why this hasn't been remade or even incorporated into VB itself. When we upgraded to 4.0, we essentially turned thousands of reviews into ordinary forum threads, because we lost GARS.

[deverill2010]

Ted are there any upgrade instructions? I am running the previous version or previous two version. Basically the version before you added images on the view forum bit lol

[Ted S]

Ted are there any upgrade instructions? I am running the previous version or previous two version. Basically the version before you added images on the view forum bit lol

Upload all the files. Import the new product file. And if desired run the image sync routine in the AdminCP options. That's it.

And oh, if you have modified templates prepare to merge them.

[deverill2010]

I can't find the image sync...?

[deverill2010]

Ok I managed to get the image sync thing to work, however I don't see any images on the view forum bit, it looks as if it did before.

http://www.midwiferyonline.co.uk/productforums.php

http://www.midwiferyonline.co.uk/forums/7-The-Library

I have now lost all my images as I deleted them from the folder then tried to resync, how ever it didnt recreate the images.

I am trying to upload new ones but jus get this error -

Product Review Forums

Warning: imagejpeg() [function.imagejpeg]: Unable to open '../productimages/502d2feb1f375_full.jpg' for writing: No such file or directory in [path]/includes/prodforums_uploader.php on line 54

Warning: imagejpeg() [function.imagejpeg]: Unable to open '../productimages/502d2feb1f375_thumb.jpg' for writing: No such file or directory in [path]/includes/prodforums_uploader.php on line 54

Warning: imagejpeg() [function.imagejpeg]: Unable to open '../productimages/502d2feb1f375_small.jpg' for writing: No such file or directory in [path]/includes/prodforums_uploader.php on line 54

[Ted S]

Ok I managed to get the image sync thing to work, however I don't see any images on the view forum bit, it looks as if it did before.

http://www.midwiferyonline.co.uk/productforums.php

http://www.midwiferyonline.co.uk/forums/7-The-Library

I have now lost all my images as I deleted them from the folder then tried to resync, how ever it didnt recreate the images.

I am trying to upload new ones but jus get this error -

Product Review Forums

Warning: imagejpeg() [function.imagejpeg]: Unable to open '../productimages/502d2feb1f375_full.jpg' for writing: No such file or directory in [path]/includes/prodforums_uploader.php on line 54

Warning: imagejpeg() [function.imagejpeg]: Unable to open '../productimages/502d2feb1f375_thumb.jpg' for writing: No such file or directory in [path]/includes/prodforums_uploader.php on line 54

Warning: imagejpeg() [function.imagejpeg]: Unable to open '../productimages/502d2feb1f375_small.jpg' for writing: No such file or directory in [path]/includes/prodforums_uploader.php on line 54

Your settings are incorrect and the script can not create images. Double check the path for where images should go [you need to work from root so /home/mysite/forum/products/ or such] and set the folder to 0755 writeable.

Once that's complete and you can upload one image re-run the importer which will try to salvage the old images [if not I can show you a query to get them back and then let you import then again].

[deverill2010]

Ok the directory route is right now and I have uplaoded one image which is showing on the product itself and and the productsforum.php. However the image hasn't replaced the forum icons.

I have ran the image sync and ma missing all previous images so if you could give me that query, that would be much appreciated.

[fechten]

Hey there. I've been reading through and couldn't find the answer to this question.

Right now, the product reviews are sorted by the date the thread/product was created. How do I set the forum to show by latest reply and how do we get productforums.php to show a list of categories and then latest reviews below that? (Or just latest reviews?)

[Ted S]

Hey there. I've been reading through and couldn't find the answer to this question.

Right now, the product reviews are sorted by the date the thread/product was created. How do I set the forum to show by latest reply and how do we get productforums.php to show a list of categories and then latest reviews below that? (Or just latest reviews?)

The first issue requires a hack as [currently] we're looking at the product table rather than the reviews one. You could either add a column for last reviewed or change the table query around to do a JOIN statement.

The second change also requires a quick hack to the code to add in the drop down list. You can basically copy how the manufacturer dropdown works or wait for the next release as this sounds like it's worth being added in.

[Ricsca]

Is possible can add reviews to only specific user groups?

[Ricsca]

I would like this product featured with the vbulletin friendly urls.

[Ricsca]

In my site (http://www.tartaportal.it/showthread.php?t=84650)whole description is inserted in a single line.
Why is that?

[Ted S]

In my site (http://www.tartaportal.it/showthread.php?t=84650)whole description is inserted in a single line.
Why is that?

Did you add line breaks with a br, p or other spacing element?

[Ted S]

I would like this product featured with the vbulletin friendly urls.

This mod does not change url structures. Use whatever you like.

[Ted S]

Is possible can add reviews to only specific user groups?

Nope.

[deverill2010]

Ok the directory route is right now and I have uplaoded one image which is showing on the product itself and and the productsforum.php. However the image hasn't replaced the forum icons.

I have ran the image sync and ma missing all previous images so if you could give me that query, that would be much appreciated.

Hi Ted can I get that query please?

[deverill2010]

I am also getting this message again when trying to leave a review -

'Your review comments must be at least 50 characters long. Yours was 4'

My review was longer than 4 characters. It was fine before I upgraded.

[Ted S]

I am also getting this message again when trying to leave a review -

'Your review comments must be at least 50 characters long. Yours was 4'

My review was longer than 4 characters. It was fine before I upgraded.

Is it always showing 4? Do you have the WYSIWYG editor enabled elsewhere?

[Ted S]

Hi Ted can I get that query please?

Can you look at the path for one of your images in the database [ie select mainphoto from pf_product where productid = XXX] and tell me if there's anything in that folder with a similar name?

[deverill2010]

Is it always showing 4? Do you have the WYSIWYG editor enabled elsewhere?

Yep it always showing 4, I don't have WYSIWYG enabledon the site nor in this mod.

My Message Posting Interface Options are all set to enable standard controls.

[deverill2010]

Can you look at the path for one of your images in the database [ie select mainphoto from pf_product where productid = XXX] and tell me if there's anything in that folder with a similar name?

Ok this is what it looks like -

140597

For the ones I am having trouble with i.e no images show up.

The image files it is calling are not in the folder.

The ones which are working the images it is calling are in the folder.

[Ted S]

Yep it always showing 4, I don't have WYSIWYG enabledon the site nor in this mod.

My Message Posting Interface Options are all set to enable standard controls.

That should make things easier but it also deviates from the typical options...

Upload this version of upload/productforums.php which will add debug code [remove it once you've copied the results if you're using it on a live forum].

[deverill2010]

I don't have a folder called upload?

[Ted S]

I don't have a folder called upload?

Whoops... Upload refers to your root folder in vB. :D

[deverill2010]

Um it gave me this -

start debug
used backup message
check review length
use mod option
failed entirely

[Ted S]

Um it gave me this -

start debug
used backup message
check review length
use mod option
failed entirely

Ok, now we know what's wrong. This version may help tell us what's right...

[deverill2010]

Ok uploaded the file and when trying to add a review I still get -

Your review comments must be at least 50 characters long. It was 4

[Ted S]

Ok uploaded the file and when trying to add a review I still get -

Your review comments must be at least 50 characters long. It was 4

Nothing was changed to stop the error... But more debug code was added which I need to see the output from.

[deverill2010]

start debug
used backup message:
check review length
use mod option
failed entirely

[deverill2010]

Also how do I get the images to show up here? -

140605

[Ted S]

start debug
used backup message:
check review length
use mod option
failed entirely

Ok... And one more time please.

[deverill2010]

Ok... And one more time please.

It didnt display any additional debug info for that one.

Still says - Your review comments must be at least 50 characters long. It was 4

though.

Thanks for your help by the way.

[Ted S]

It didnt display any additional debug info for that one.

Still says - Your review comments must be at least 50 characters long. It was 4

though.

Thanks for your help by the way.

Strange...

And this one?

[deverill2010]

start debug
used original messagecheck review length
use mod option

[Ted S]

And did it post?

[deverill2010]

No still got the same message sorry.

[Ted S]

No still got the same message sorry.

Wait... you get the error but not the line about the failure in the debug code?

[deverill2010]

Oh I just tried it again and it posted!

How do I remove the debug info?

[Ted S]

Oh I just tried it again and it posted!

How do I remove the debug info?

Here you go

[deverill2010]

Yeah hi sorry that isnt working.

I havejust downloaded and uploaded the above file but stillg et -

Your review comments must be at least 50 characters long. It was 4

[Ted S]

Yeah hi sorry that isnt working.

I havejust downloaded and uploaded the above file but stillg et -

Your review comments must be at least 50 characters long. It was 4

Strange. Well here's the version you had used minus the debug outputs.

[deverill2010]

Great that works fine, thank you!. However I have just noticed that if I delete a review from the admin, it doesn't delete it off the forum?

Also how do I get the images to show on the forum display -

140643

[Ted S]

Great that works fine, thank you!. However I have just noticed that if I delete a review from the admin, it doesn't delete it off the forum?

Does the thread still work or just show up in the list?

Also how do I get the images to show on the forum display

There's no special icons for reviews...?

[deverill2010]

I'm not quite sure what you mean?

The thread still shows up as a product?

Regarding the images, you have this photo attached here - https://vborg.vbsupport.ru/attachment.php?attachmentid=139761&d=1342151619

How do I do it? No there currently isn't any image showing like this for some reason as Ive shown in my picture.

[Ted S]

I'm not quite sure what you mean?

The thread still shows up as a product?

Regarding the images, you have this photo attached here - https://vborg.vbsupport.ru/attachment.php?attachmentid=139761&d=1342151619

How do I do it? No there currently isn't any image showing like this for some reason as Ive shown in my picture.

Open up the install guide and you'll find instructions to this which require a manual code hack. But note, this change impacts product listings... not review threads.

[deverill2010]

Last thing I cn think off then this is as perfect for me. On this page - http://www.midwiferyonline.co.uk/productforums.php the table columns are not aligned properly and I can't figure out how to fix it with CSS.

[Ted S]

Last thing I cn think off then this is as perfect for me. On this page - http://www.midwiferyonline.co.uk/productforums.php the table columns are not aligned properly and I can't figure out how to fix it with CSS.

You're missing a column header for category. Revert the template or add it back in.

[deverill2010]

Thanks ted I really appreciate all your help, it is looking great and deffo the best out the there by far!

With adding custom raiting fields, is there any way to make them required? As I need to do this.

[cooljeba]

Yeah hi sorry that isnt working.

I havejust downloaded and uploaded the above file but stillg et -

Your review comments must be at least 50 characters long. It was 4

I get the same error message too.. It is because it is only trying to insert
<br> which is 4 char long.

I set the min post length to 0 then it only seems to be posting <br> as the review . Disabled it for now

[deverill2010]

I get the same error message too.. It is because it is only trying to insert
<br> which is 4 char long.

I set the min post length to 0 then it only seems to be posting <br> as the review . Disabled it for now

The very last productforums/php that Ted uploaded is now working for me. Make a backup of your copy and upload it, see if it works.

Yeah I spotted that <br> thing once, but didn't post it as couldnt get it up again.

[deverill2010]

Thanks ted I really appreciate all your help, it is looking great and deffo the best out the there by far!

With adding custom raiting fields, is there any way to make them required? As I need to do this.

I also just noticed that when adding custom rating fields, how do I go about getting the star images to show instead of text like so -

Content: 3 stars
Readability: 4 stars
Graphics / Illustrations: 4 stars
Would Recommend: 5 stars

What is the template for posting this as I would like to edit the way the way the reviews display within posts.

[Ted S]

I also just noticed that when adding custom rating fields, how do I go about getting the star images to show instead of text like so -

Content: 3 stars
Readability: 4 stars
Graphics / Illustrations: 4 stars
Would Recommend: 5 stars

What is the template for posting this as I would like to edit the way the way the reviews display within posts.

You'd have to hack the php code to insert the images rather than text... Sub-elements are built as a review is created so there's no database storing of the individual selections.

There are however phrases you can work off of which will help a bit.

[deverill2010]

Ah I wouldn't know what to do with the PHP code. Just thought it would look more aesthetically pleasing.

[Ted S]

Ah I wouldn't know what to do with the PHP code. Just thought it would look more aesthetically pleasing.

Gotcha...

If you can comp [photoshop, sketch, powerpoint] what you want I'll try to get it done in our upcoming bug release.

[deverill2010]

I will do thank you.

[GCC LLC]

Having lots of problems with search. On any search for manufacturer for example, the URL as shown in the browser is productforums.php?mrfg=xxxx but the results page says "No products matched your search. Try broadening your criteria or selecting another category."

There are definitely manufacturers in the database (and verified via phpMyAdmin) that have the exact string as chosen from the drop down menu.

Additionally, a text box search for product name (thread title) uses URL as productforums.php?title=yyyy which returns a list of every product in the database, regardless of it being in the thread/product title.

Ideas?

[GCC LLC]

OH and FYI, for a future release I noticed that you had the manufacturers drop down box limited to a maximum of 100 results. We have a large import and our manufacturer's drop down box stopped showing results at the letter N.. I dug through the code and removed the SQL LIMIT statement on that and now it works fine. Others may have a similar problem, so that's how I fixed it on our end.

[Ted S]

OH and FYI, for a future release I noticed that you had the manufacturers drop down box limited to a maximum of 100 results. We have a large import and our manufacturer's drop down box stopped showing results at the letter N.. I dug through the code and removed the SQL LIMIT statement on that and now it works fine. Others may have a similar problem, so that's how I fixed it on our end.

Lists of even 100 names are rather unmanageable for users and should really be changed to search input boxes...

That said I'll take a look at the search bug and see if we can fix it.

[GCC LLC]

Every store in our industry has well over 100 manufactureres so if your going to support a mass import of products then users are going to get a list of companies that stops in the middle because of the 100 set limit whether its manageable or not. I agree there has to more search options but you will still run into this error with bulk imports.