Product Review Forums ? Research, Review & Compare Items

[GCC LLC]

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

I had to remove the mysql_real_escape_string() from around the format search input for it to work. Anything better I could replace it with? We use mysqli if that matters. Its working fine without any function wrapped around it, but not sure if that could lead to other issues on the textbox input on product title searches.

[GCC LLC]

I noticed that in your code, you don't include a link identifier on the mysql_real_escape_string:

if($vbulletin->GPC['title']){ $conditions .= " AND pfp.title LIKE '%". mysql_real_escape_string($vbulletin->GPC['title']) ."%'"; } // title of product

It should default to the last used connection, but in my case I think it's not. In the meantime, I've switched to mysql_escape_string() which appears to be working. Do you see any issues with this?

Also all new reviews go into moderation even though I have the option turned off and made sure the forum have all moderation turned off. Thought it might be a conflict with Glowhost so uninstalled that and they still get moderated.

[ynh]

Anyone have an idea of how to add an attachment option to the post new product page?

(productforums.php?do=addproduct)

[Ted S]

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.

Sounds like my comment didn't come ascross right...

The business we run that inspired PRF processes something like 14 million products nightly from hundreds of thousands of manufacturers. And that's small potatoes compared to what our partners do... There's no problem with the structure of how the brands are stored whether you have 1, 100 or 10,000. We have the limit clause in for database speed but as you noted, it's no big deal to remove and perhaps something we can make an option of.

The issue however is in the presentation and resulting UX.

PRF was designed for the typical community owner who, to this point, is generally adding at most a few hundred products from a few dozen brands. As such a dropdown works fine.

However at a scale of say 50 [you'd have to test to find the actual threshold] dropdown lists become unusable for the user. Technically they still work, still load but it's just not feasible to scroll and mentally process. Thus you either need an open search field or progressive autofill...

While it's not a built in feature we designed PRF as a starting place to cover 90% and this is one of those 10% items worth customizing given your particular use yourself. But of course that's just my $0.02

[Ted S]

Anyone have an idea of how to add an attachment option to the post new product page?

(productforums.php?do=addproduct)

There is no simple way to do this. You can however very easily add them to the first post in the product's thread :D

[Ted S]

I noticed that in your code, you don't include a link identifier on the mysql_real_escape_string:

if($vbulletin->GPC['title']){ $conditions .= " AND pfp.title LIKE '%". mysql_real_escape_string($vbulletin->GPC['title']) ."%'"; } // title of product

Escaping the string is essential for preventing injections so good call on working through that...

We'll be redoing the search function a bit in light of your bug report and will try to test with a few mySQLi connections as well.

Also all new reviews go into moderation even though I have the option turned off and made sure the forum have all moderation turned off. Thought it might be a conflict with Glowhost so uninstalled that and they still get moderated.

Does the forum allow for new replies? Closed forums seem to have this issue...

[GCC LLC]

Sounds like my comment didn't come ascross right...

The business we run that inspired PRF processes something like 14 million products nightly from hundreds of thousands of manufacturers. And that's small potatoes compared to what our partners do... There's no problem with the structure of how the brands are stored whether you have 1, 100 or 10,000. We have the limit clause in for database speed but as you noted, it's no big deal to remove and perhaps something we can make an option of.

The issue however is in the presentation and resulting UX.

PRF was designed for the typical community owner who, to this point, is generally adding at most a few hundred products from a few dozen brands. As such a dropdown works fine.

However at a scale of say 50 [you'd have to test to find the actual threshold] dropdown lists become unusable for the user. Technically they still work, still load but it's just not feasible to scroll and mentally process. Thus you either need an open search field or progressive autofill...

While it's not a built in feature we designed PRF as a starting place to cover 90% and this is one of those 10% items worth customizing given your particular use yourself. But of course that's just my $0.02

I'm not disagreeing, just stating that you could come across this when importing large amounts of products. Now if someone searches this thread, they will know why. :)

[GCC LLC]

Does the forum allow for new replies? Closed forums seem to have this issue...


Yes, everything is open. We are using the forumdisplay.


User posts a review. It gets put in moderation, but it still posts the review.

Now it gets strange. It posts the review twice (within the same post). You will get <review><br><review> all within the postbit. The <br> is visible. This seems to happen with users copying and pasting with or without WYSIWYG on.

Now usually as we know, a new post will update the sorting order (newest post first). Even though the review is posted, the forumdisplay will not update the sorting order until I approve the post (review).

[Ted S]

Yes, everything is open. We are using the forumdisplay.


User posts a review. It gets put in moderation, but it still posts the review.

Now it gets strange. It posts the review twice (within the same post). You will get <review><br><review> all within the postbit. The <br> is visible. This seems to happen with users copying and pasting with or without WYSIWYG on.

Now usually as we know, a new post will update the sorting order (newest post first). Even though the review is posted, the forumdisplay will not update the sorting order until I approve the post (review).

So I'm clear only 1 post is made, but with duplicate content in it, and it's always in moderation?

[GCC LLC]

So I'm clear only 1 post is made, but with duplicate content in it, and it's always in moderation?


Yes. User "submits" one review but the content gets posted twice within postbit with a visible <br> in between.

Every review goes into moderation even though I have moderation turned off within the plugin as well as in the forum. I don't think it shows the <br> and duplicate content within the moderation window. I will check and see next time it happen.

[GCC LLC]

Yes. User "submits" one review but the content gets posted twice within postbit with a visible <br> in between.

Every review goes into moderation even though I have moderation turned off within the plugin as well as in the forum. I don't think it shows the <br> and duplicate content within the moderation window. I will check and see next time it happen.


The <br> does show up in the moderation window as well...

[Ted S]

Yes. User "submits" one review but the content gets posted twice within postbit with a visible <br> in between.

Every review goes into moderation even though I have moderation turned off within the plugin as well as in the forum. I don't think it shows the <br> and duplicate content within the moderation window. I will check and see next time it happen.

Wait, is it going into standard vB moderation or the PRF's internal "pending" moderation?

[deverill2010]

I'm having the same issue, it's going into VBmoderation. And when I try to approve it it tells me I haven't selected a valid thread/post to approve (which in theory is correct as its already posted). This is leaving me with loads of threads/posts in the moderation que that I can't approve.

There's an issue regarding moderation for products as well. When a product is posted as it has to be approved it posts a thread which cotains the words -

'product information' < this is viewable to everyone.

Then once the product is approved it will change and show all the product information/template.

[GE-Tom]

hey, this is a very good mod !! i wait a long time for somthing like that. mutch thanks.

but i have 2 questions.

1: is it possible to sort by price in the overview list? over all i think sort by the headlines was a good feature.
2: is it possible to add 2 of the same products (same product name)? i like to add products from different shops with different prices so thats wy i need it.

i hope you can help me. mutch thanks

[GCC LLC]

Wait, is it going into standard vB moderation or the PRF's internal "pending" moderation?


Standard vB moderation.

[Ted S]

I'm having the same issue, it's going into VBmoderation. And when I try to approve it it tells me I haven't selected a valid thread/post to approve (which in theory is correct as its already posted). This is leaving me with loads of threads/posts in the moderation que that I can't approve.

There's an issue regarding moderation for products as well. When a product is posted as it has to be approved it posts a thread which cotains the words -

'product information' < this is viewable to everyone.

Then once the product is approved it will change and show all the product information/template.

You're the only one to have the Product Thread issue so I'm going to break that out as I suspect it's a setting change. In order for that first post to be hidden the thread must be in a PRF enabled forum category and that forum category should allow new threads to be made.

Double check those.

[Ted S]

1: is it possible to sort by price in the overview list? over all i think sort by the headlines was a good feature.

Change your database structure from a text string (varchar) to a decimal and you can order on that field.

2: is it possible to add 2 of the same products (same product name)? i like to add products from different shops with different prices so thats wy i need it.

Sure. Just note the store in the title or other key fields so the filter doesn't think it's a dup.

[GE-Tom]

Hey Ted S,

thanks but i not realy understand the answer from question 1. some other problem is that i get this exception if i try to add a product.

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

We had an issue posting your review, please try again or contact support and use code 164261-A.

first i can build some product threads but now i get this exception.

thanks again !!

[Ted S]

Hey Ted S,

thanks but i not realy understand the answer from question 1. some other problem is that i get this exception if i try to add a product.

first i can build some product threads but now i get this exception.

thanks again !!

You have not configured all of your settings or are using forums that can not accept posts/ threads. Be sure to re-read the install guide as this mod requires specific settings to be completed if you want to use the corresponding options.

As far as moderation, as far as I know there have been no sites with moderation issues on products when things were configured properly. There is an open bug for moderation on reviews which we're reviewing.

[GCC LLC]

I have everything configured properly. I still get double postings and moderation issues.

[Ted S]

I have everything configured properly. I still get double postings and moderation issues.

Understood. That remark was only intended for the individual who we were quoting as his/her issues are different with that error being explicitly caused by a lack of settings or invalid posting forum.

We should have time to chase these down tomorrow or friday...

[GCC LLC]

Gotcha. Thanks!

[ashimashi]

This is an amazing mod! I have been looking for something like this for almost a year now. I can't believe I missed this.

Thanks for the mod. I just have 2 questions regarding it.
IS it possible to edit a product after it has been published? To change the price for example. Or even delete it

Also, Is it possible to delete a review? I can delete the post but the product page says there is one review. After you click to see the review, it will say: No Thread specified. If you followed a valid link, please notify the administrator

[Ted S]

Thanks for the mod. I just have 2 questions regarding it.
IS it possible to edit a product after it has been published? To change the price for example. Or even delete it

Yup. That's the main point of the mod... products are stored in a database table so you can edit them, update them, etc. Edit through the PRF admin options.

Also, Is it possible to delete a review? I can delete the post but the product page says there is one review. After you click to see the review, it will say: No Thread specified. If you followed a valid link, please notify the administrator

Delete it through the PRF admin options.

[ashimashi]

Yup. That's the main point of the mod... products are stored in a database table so you can edit them, update them, etc. Edit through the PRF admin options.



Delete it through the PRF admin options.

Oh I got it. I am supposed to search for it using ID.

Thank you, and thank you again for this great mod. :)

[ashimashi]

Sorry for posting again but I just have one more question. I tried searching in the How to page but I couldn't find a fix to it.

How do I add or remove additional fields when adding a product. For example if I want a field that says Year of release or if I want to remove a field like "UPC / ISBN / EIN Code" which came with the mod.

Thanks

[Ted S]

Sorry for posting again but I just have one more question. I tried searching in the How to page but I couldn't find a fix to it.

How do I add or remove additional fields when adding a product. For example if I want a field that says Year of release or if I want to remove a field like "UPC / ISBN / EIN Code" which came with the mod.

Thanks

Removing fields is as simple as editing the review template so they don't show in the display.

Adding fields requires a database modification at this point although you can put anything you like in the description.

[ashimashi]

Removing fields is as simple as editing the review template so they don't show in the display.

Adding fields requires a database modification at this point although you can put anything you like in the description.

Okay thank you. I found the template needed and was able to edit the unwanted fields out.

But regarding adding fields, is it very complicated to do so? How must I add them? Adding them to the same template I removed fields from will most likely not do it.


Also just a suggestion if you ever do decide to upgrade this mod, I think it would be better if there was a dollar sign next to the Retail Price box when adding product. I noticed that it automatically puts dollar sign for you, so if someone puts it as well, there will be 2 of them displayed.

[Ted S]

Okay thank you. I found the template needed and was able to edit the unwanted fields out.

But regarding adding fields, is it very complicated to do so? How must I add them? Adding them to the same template I removed fields from will most likely not do it.


It's not insane but it's not a template edit either.

1. Add a column [int or varchar] to the product table in your database for each field.
2. Update the admin php script to include this row in adding & editing products with database hooks to match.
3. Edit the template to display it back.

Also just a suggestion if you ever do decide to upgrade this mod, I think it would be better if there was a dollar sign next to the Retail Price box when adding product. I noticed that it automatically puts dollar sign for you, so if someone puts it as well, there will be 2 of them displayed.

Not everyone uses US dollars. But you're correct, it's a great idea to add in your local currency sign.

[Ted S]

Yes. User "submits" one review but the content gets posted twice within postbit with a visible <br> in between.

Every review goes into moderation even though I have moderation turned off within the plugin as well as in the forum. I don't think it shows the <br> and duplicate content within the moderation window. I will check and see next time it happen.

Please try the attached version of upload/productforums.php which addresses the dup content issue [note: I couldn't duplicate it so this may take another shot or two].

For moderation I'm honestly stumped and unable to recreate it thus I'll have to unfortunately as for a little help on your part...

Next time a review gets stuck in the queue before you release it please check it's status in your SQL database:

SELECT visible FROM post WHERE postid = XXXX;

We'll keep going from there until it's all fixed.

[GCC LLC]

Thanks Ted, appreciate it. Did you forget to attach the file?

[GCC LLC]

mysql> select visible from post where postid = xxxxxxx;
+---------+
| visible |
+---------+
| 1 |
+---------+
1 row in set (0.00 sec)

[deverill2010]

Right ted this is what mine does when it a review is pisted. I don't have moderation for reviews turned on but yet they end up in moderation as you'll see below -

This was from a review posted earlier and the pictures are all of the SAME review.

The review shows up in moderation -

140855

The same review shows up 'unregistered' in the activity stream for some reason.

140856

The actual review on the thread, as you can see it isn't 'moderated'.

140857

Trying to approve the reviews and the error I get -

140858

140859




Regarding my request for the stars images on the view forum bit, please see the image below. It would be great if you could show the overall star rating instead of the words "Rated: 0.0 / 5". -

140860




And I had a question. Is there a way for the 'normal' threads within the product forum to show normally. I.e don't show the Rated: 0.0 / 5 & reviews column as this looks confusing and messy. They are normal threads not products so shouldn't be interefered with. See image -

140861

[GCC LLC]

Deverill, you could probably edit the threadbit with a conditional to check for the thread prefix - it looks like you use Book Review: as a prefix on all reviews. The conditional to look into is $thread[prefix_rich]. Possibly something like <vb:if conditional = "$thread[prefix_rich]">display threadbit with the Rated: code here <vb:else /> show regular threadbit here </vb:if>

The thing I'm not sure about, without diving in and looking at it is that these changes may need to be made inside of forumdisplay.php itself (core vb PHP file hack that you made to have it change the threadbit on product review forums in the first place). Hope this helps at least point you in the right direction!

[deverill2010]

GCC LCC that's great thank you but In reality I have no idea unless someone says find x and replace it with y lol.

Thanks any how.

[Ted S]

Thanks Ted, appreciate it. Did you forget to attach the file?

Me, forget, never? :eek:

[Ted S]

mysql> select visible from post where postid = xxxxxxx;
+---------+
| visible |
+---------+
| 1 |
+---------+
1 row in set (0.00 sec)

1?? 1 means active, visible post. Hrmm....

Does the post show up to guests / other users and go to moderation at the same time or is treated like a normal thread and completely hidden in the queue?

[Ted S]

Right ted this is what mine does when it a review is pisted. I don't have moderation for reviews turned on but yet they end up in moderation as you'll see below -

Try this version of upload/productforums.php

It will still put things into moderation I suspect [although i'm not sure why] but I'm wondering if you'll be able to properly approve them afterwords...

[ashimashi]

It's not insane but it's not a template edit either.

1. Add a column [int or varchar] to the product table in your database for each field.
2. Update the admin php script to include this row in adding & editing products with database hooks to match.
3. Edit the template to display it back.



Not everyone uses US dollars. But you're correct, it's a great idea to add in your local currency sign.

Thank you but sorry that is just a little too complicated for me. You lost me at step one. Where do I find the product table?

Do you think it would be possible for you to make a quick tutorial on how to do this. I Believe many others would like this too if they would like to add their own custom fields to it.

Thanks!

[Ted S]

Thank you but sorry that is just a little too complicated for me. You lost me at step one. Where do I find the product table?

Do you think it would be possible for you to make a quick tutorial on how to do this. I Believe many others would like this too if they would like to add their own custom fields to it.

Thanks!

If you don't know where your database tables are you probably shouldn't try and do this, until you learn some mySQL & php that is. :up:

Messing around with your system at this level risks your entire forum if you do the wrong thing. Not the kind of stuff we like to document as the easier it appears, the more likely people are to jump in without paying attention to the warning system.

[Ted S]

And I had a question. Is there a way for the 'normal' threads within the product forum to show normally. I.e don't show the Rated: 0.0 / 5 & reviews column as this looks confusing and messy. They are normal threads not products so shouldn't be interefered with.

Mixing normal threads with review threads is just fine. Changing the forumdisplay however changes it for the entire forum... You can tweak the prodforums_threadbit template to adjust however you like.

The code you're looking at is:


<vb:if condition="!$show['notificationtype']">
<ul class="threadstats td alt" title="<vb:if condition="$thread['dot_count'] > 0">{vb:rawphrase have_x_posts_in_thread_last_y, {vb:raw thread.dot_count}, {vb:raw thread.dot_lastpost}}</vb:if>">
<li>{vb:rawphrase prodforums_rating,{vb:raw thread.pf_rating}}</li>
<li>{vb:rawphrase prodforums_reviews,{vb:raw thread.pf_reviews}}</li>
<li class="hidden">{vb:rawphrase rating}{vb:raw thread.rating} / 5</li>
</ul>
</vb:if>

[GCC LLC]

Ok, next up.. lol. Sorry to make it seem like all I'm doing is pointing out problems - because overall this is an excellent product. We have an issue where a user submitted their own new product which we approved. That seemed to work fine. However, when the user (or anyone for that matter) go to leave a review of the product, we (including myself as an admin) get this error:

We had an issue posting your review, please try again or contact support and use code 164251-E.

That error, according to your code seems to relate to something having to do with not being able to add new posts to the thread (build_new_post() function not adding the post?). When I turn on debugging, the only additional info I get in the error is Array (not the contents of the array).

The thread appears to be open and able to be posted in, according to mysql:

mysql> select open from thread where threadid = xxxxxx;
+------+
| open |
+------+
| 1 |
+------+
1 row in set (0.00 sec)

mysql> select visible from thread where threadid = xxxxxx;
+---------+
| visible |
+---------+
| 1 |
+---------+
1 row in set (0.00 sec)

[Ted S]

Ok, next up.. lol. Sorry to make it seem like all I'm doing is pointing out problems - because overall this is an excellent product. We have an issue where a user submitted their own new product which we approved. That seemed to work fine. However, when the user (or anyone for that matter) go to leave a review of the product, we (including myself as an admin) get this error:

We had an issue posting your review, please try again or contact support and use code 164251-E.


Not to worry. It's actually good to see people going to this detail to use the features. Unfortunately with endless combinations errors do come up so I appreciate your tolerance to working through them.

That message means vB was not able to build a reply. We can diagnose this further if open up productforums.php and go to around like 544

Replace eval(standard_error(fetch_error('prodforums_review _critdebug','164251-E',$errors))); with:


echo "debug code:<br>";
print_r($errors);
die;


Run a review on a user made product and you should see more detail but in short what it's saying is that it couldn't post the reply so likely a permission issue.

[GCC LLC]

Thanks, it was due to the length of the post title. The product itself had a long name, then when you added on the "x out of 5 rating for" plus the product name, it exceeded vB's length.

As a hack, I just edited the construction on newpost['title'] to make it much shorter.

[GCC LLC]

Please try the attached version of upload/productforums.php which addresses the dup content issue [note: I couldn't duplicate it so this may take another shot or two].

For moderation I'm honestly stumped and unable to recreate it thus I'll have to unfortunately as for a little help on your part...

Next time a review gets stuck in the queue before you release it please check it's status in your SQL database:

SELECT visible FROM post WHERE postid = XXXX;

We'll keep going from there until it's all fixed.

The updated php seems to have fixed the duplicate content issue. The posts still go into moderation though. At least it's much easier to just go in and approve them from admincp now though. I know you're working hard on this so I just wanted to take the time to say thanks for your time and effort!

[GCC LLC]

Ok, moderation issue fixed. Just before your build_new_post() function is called, I added the following two lines:

$forumperms = fetch_permissions($foruminfo['forumid']);
$foruminfo['moderatenewthread'] = 0;

[ashimashi]

If you don't know where your database tables are you probably shouldn't try and do this, until you learn some mySQL & php that is. :up:

Messing around with your system at this level risks your entire forum if you do the wrong thing. Not the kind of stuff we like to document as the easier it appears, the more likely people are to jump in without paying attention to the warning system.

Okay thanks still!

Well I don't think there would be a mistake if there was a step by step guide on what to do. Besides I always back up files before doing something like this.

thanks anyways

[Ted S]

Thanks, it was due to the length of the post title. The product itself had a long name, then when you added on the "x out of 5 rating for" plus the product name, it exceeded vB's length.

As a hack, I just edited the construction on newpost['title'] to make it much shorter.

Awesome...

Now to find out how long is too long...

[Ted S]

Okay thanks still!

Well I don't think there would be a mistake if there was a step by step guide on what to do. Besides I always back up files before doing something like this.

thanks anyways

People should back that up every time they install a mod, but they don't. People should read the install guide for a mod, but they don't. And this isn't about your files, it's your entire forum's data is.

While I totally want to see people grow their sites and make that easy [hence all the free mods], I'm certain that this passes the "risk to reward" threshold. Sorry!

If you want to take your forum beyond a certain point you really have to either learn some code or hire someone who knows it. There's great resources for both here @ vB.org too

[Ted S]

Ok, moderation issue fixed. Just before your build_new_post() function is called, I added the following two lines:

$forumperms = fetch_permissions($foruminfo['forumid']);
$foruminfo['moderatenewthread'] = 0;

Dude, rock on. For some reason those were hardset the other way.... and yet not breaking things for most forums?

Did this fix the posts and threads?

[GCC LLC]

Awesome...

Now to find out how long is too long...

It's a vb setting (for thread title length) so probably wouldnt be hard to find the variable for it from vb and then either truncate or replace the post title if it exceeds that? For us we don't care so much about the post title so we made it just the rating.

[GCC LLC]

Dude, rock on. For some reason those were hardset the other way.... and yet not breaking things for most forums?

Did this fix the posts and threads?

I've seen stranger things with vbulletin...lol

[ashimashi]

People should back that up every time they install a mod, but they don't. People should read the install guide for a mod, but they don't. And this isn't about your files, it's your entire forum's data is.

While I totally want to see people grow their sites and make that easy [hence all the free mods], I'm certain that this passes the "risk to reward" threshold. Sorry!

If you want to take your forum beyond a certain point you really have to either learn some code or hire someone who knows it. There's great resources for both here @ vB.org too


What I will do is make a test forum just for this until I can get this working. So if anything does go wrong, it is only a test forum.

Thanks!

[1320Nation]

""Good or bad everyone wants to know what you think. Write a review and share your opinion of ********
Your review comments must be at least 1 characters long.""

This mod on my board is giving the above message for everyone that attempts to give a review for a product. Is there something I can check to stop this?

[Ted S]

""Good or bad everyone wants to know what you think. Write a review and share your opinion of ********
Your review comments must be at least 1 characters long.""

This mod on my board is giving the above message for everyone that attempts to give a review for a product. Is there something I can check to stop this?

Try this version.

[deverill2010]

Try this version of upload/productforums.php

It will still put things into moderation I suspect [although i'm not sure why] but I'm wondering if you'll be able to properly approve them afterwords...

That didn't work ted, still cant approve them in the front end VB moderation.

[deverill2010]

Mixing normal threads with review threads is just fine. Changing the forumdisplay however changes it for the entire forum... You can tweak the prodforums_threadbit template to adjust however you like.

The code you're looking at is:


<vb:if condition="!$show['notificationtype']">
<ul class="threadstats td alt" title="<vb:if condition="$thread['dot_count'] > 0">{vb:rawphrase have_x_posts_in_thread_last_y, {vb:raw thread.dot_count}, {vb:raw thread.dot_lastpost}}</vb:if>">
<li>{vb:rawphrase prodforums_rating,{vb:raw thread.pf_rating}}</li>
<li>{vb:rawphrase prodforums_reviews,{vb:raw thread.pf_reviews}}</li>
<li class="hidden">{vb:rawphrase rating}{vb:raw thread.rating} / 5</li>
</ul>
</vb:if>


Ok thats brilliant, I have managed to change it back to normal which looks ace with your help and a user previously who posted a conditon.

One last question then I am finally done! How can I get the 'thread' icon to look like normal if not a review?


Oh and I've noticed when on the activity stream if I click on the title of a product, it redirects me to a "No Thread specified. If you followed a valid link, please notify the administrator" error. The URL at that point is - http://www.midwiferyonline.co.uk/showthread.php?t=[ARG:4

[Ted S]

That didn't work ted, still cant approve them in the front end VB moderation.

Try this version as influenced by the oh so helpful GCC LLC (https://vborg.vbsupport.ru/member.php?u=115129)

[Ted S]

Ok thats brilliant, I have managed to change it back to normal which looks ace with your help and a user previously who posted a conditon.

One last question then I am finally done! How can I get the 'thread' icon to look like normal if not a review?


Oh and I've noticed when on the activity stream if I click on the title of a product, it redirects me to a "No Thread specified. If you followed a valid link, please notify the administrator" error. The URL at that point is - http://www.midwiferyonline.co.uk/showthread.php?t=[ARG:4

If you don't want the icons and threads why not just remove the hack to forumdisplay.php all together?

The icon is controlled a little higher up in the same template.

[deverill2010]

Because I want them to show for the products just not the normal threads, within the forum.

Or have I completely missed something?

Thanks I'll try that other file tomorrow as on iPad now.

Any idea regarding the product titles in the activity stream?

[Ted S]

Because I want them to show for the products just not the normal threads, within the forum.

Or have I completely missed something?

Thanks I'll try that other file tomorrow as on iPad now.

Any idea regarding the product titles in the activity stream?

Gotcha. Well, that's going to mean continuing to tweak the template but if you compare the default threadbit and the PRF version you can find the change easily.

We'll take a look at titles...

[ashimashi]

Is it possible so that other people could approve products as well? For example I would like my moderators to have access in approving products.

[Ted S]

Is it possible so that other people could approve products as well? For example I would like my moderators to have access in approving products.

Not possible at this time...

[1320Nation]

Try this version.

I added the file to the forum root and the results are below. However, I reinstalled the other file back in the forum root and it still shows the same error below.

Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT
pfp.productid,pfp.title,pfp.rating,pfp.reviews,pfp .price,pfp.threadid,pfp.short_desc,pfp.mainphoto_t humb,DATE_FORMAT(pfp.createddate,'%a %b %D, %Y') as posteddate,
pfc.categoryid,pfc.title as category

FROM vb_pf_product as pfp
LEFT JOIN vb_pf_category as pfc ON pfp.categoryid = pfc.categoryid
WHERE pfp.active = 1


ORDER BY pfp.title desc
LIMIT 0, 25;

MySQL Error : Unknown column 'pfp.mainphoto_thumb' in 'field list'

[Ted S]

I added the file to the forum root and the results are below. However, I reinstalled the other file back in the forum root and it still shows the same error below.

Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT
pfp.productid,pfp.title,pfp.rating,pfp.reviews,pfp .price,pfp.threadid,pfp.short_desc,pfp.mainphoto_t humb,DATE_FORMAT(pfp.createddate,'%a %b %D, %Y') as posteddate,
pfc.categoryid,pfc.title as category

FROM vb_pf_product as pfp
LEFT JOIN vb_pf_category as pfc ON pfp.categoryid = pfc.categoryid
WHERE pfp.active = 1


ORDER BY pfp.title desc
LIMIT 0, 25;

MySQL Error : Unknown column 'pfp.mainphoto_thumb' in 'field list'

Looks like the upgrade script wasn't able to run.

You'll need to manually perform a few queries:



CREATE TABLE IF NOT EXISTS pf_options (
optionid INT UNSIGNED NOT NULL AUTO_INCREMENT,
title VARCHAR (75) NOT NULL DEFAULT '',
fieldtype TINYINT NOT NULL DEFAULT '1',
defaultval TINYINT NULL,
active TINYINT NOT NULL DEFAULT '1',
PRIMARY KEY (optionid),
KEY title (title)
)

CREATE TABLE IF NOT EXISTS pf_roptions (
addedid INT UNSIGNED NOT NULL AUTO_INCREMENT,
reviewid INT NOT NULL,
optionid INT NOT NULL,
resposnse VARCHAR (75) NOT NULL DEFAULT '',
PRIMARY KEY (addedid),
KEY optionid (optionid),
KEY reviewid (reviewid)
)

INSERT INTO activitystreamtype SET packageid = 1, section = 'product', type = 'review', enabled = 1

ALTER TABLE `pf_product` ADD mainphoto_thumb VARCHAR(150) NOT NULL DEFAULT ''

ALTER TABLE `pf_product` ADD mainphoto_small VARCHAR(150) NOT NULL DEFAULT ''

ALTER TABLE `pf_product` ADD uploadimg TINYINT NOT NULL DEFAULT '0'



Be sure to add your table prefixes as needed.

[Andrei29]

Fatal error: Class 'vB_ActivityStream_Manage' not found in /home/fishbook/public_html/productforums.php on line 588

I got this error when I click on "be the first to review"

Any idea?

[Andrei29]

its really a buggy mod zzz

[Ted S]

Fatal error: Class 'vB_ActivityStream_Manage' not found in /home/fishbook/public_html/productforums.php on line 588

I got this error when I click on "be the first to review"

Any idea?

Do you have the activity system installed on your forum?

[Ted S]

its really a buggy mod zzz

I could argue that at length, show you a few of the hundreds of forums using it, and explain that the more complex a mod is, the more it has to be adapted to work with the nearly endless combination of forum settings out there but at the end of the day you should only use what you feel is right for your site.

If this isn't right for you, well, thanks for giving it a try. :up:

[GCC LLC]

its really a buggy mod zzz

For the number of and complexity of the features it provides, I thought it was relatively low in terms of the number of bugs. Pair that on top of the fact that the author is very active in this form to help, and I think it ranks up there as one of the best I've seen here on vb.org.

[GCC LLC]

I may begin tackling adding on a way to calculate and display the top ranked products, unless you already have something like that in the works? I'm not 100% sure how to rank them yet, but I think it will need to be weighted against the total number of reviews and the score rather than just the score (ie. a product reviewed 10 times with a 4.9 rating would rank better than a product reviewed 1 time with a 5.0 rating) and also should take into consideration how recent the reviews are. I guess this would be sort of a "best of the most popular products" hack so to speak.

[Ted S]

PRF users, there's a release level update out today marked as 1.3.5 [skipping .3 and .4 as those were posted as patches].

This is a bug fix designed to address issues with moderated posts, blank reviews [too short & duplicate content] review links and a few other details that impacted a few, but not all sites. If you do not have any of these issues you do not need to upgrade.

To update install the new plugin file and upload/productforums.php into your forum folder. There no other changed files.

Thanks to GCC LLC for tracking down the moderation issue too.

[GCC LLC]

Also if anyone's interested, I added BMP support in the image resync functions. Some of the images at the remote URL from my XML feed were BMP and the image processing script at
includes/prodforums_uploader.php wouldn't process them. Here's the changes I made:

In the load() function, added:
elseif( $this->image_type == IMAGETYPE_BMP ) {

$this->image = imagecreatefromwbmp($filename);
return '.bmp';
}

In the save() function, added:
elseif( $image_type == IMAGETYPE_BMP ) {
$white = 0x00FFFFFF;
imagewbmp($this->image,$filename,$white);
}

(Note: I defined the color for white for processing bitmaps because in the imagewbmp() function, it defaults everything to a black alpha channel (background) - so you may want to adjust this to your own preferences)

In the output() function, added:
elseif( $image_type == IMAGETYPE_BMP ) {

imagewbmp($this->image);
}

[Ted S]

Also while I will be supporting this update today I am out all of next week [and not just ignoring you]. Please continue to post as other members may help and I will review everything when I return.

[Ted S]

I may begin tackling adding on a way to calculate and display the top ranked products, unless you already have something like that in the works? I'm not 100% sure how to rank them yet, but I think it will need to be weighted against the total number of reviews and the score rather than just the score (ie. a product reviewed 10 times with a 4.9 rating would rank better than a product reviewed 1 time with a 5.0 rating) and also should take into consideration how recent the reviews are. I guess this would be sort of a "best of the most popular products" hack so to speak.

Are you thinking of this in place of the current productforums.php index or as a standalone feature [say a widget for the widebar]?

mySQL isn't great for formulas on the fly as they add load time but if it's just rating sum & count it's pretty simple.... I'll play around with some queries when I return after next week.

[Ted S]

Also if anyone's interested, I added BMP support in the image resync functions. Some of the images at the remote URL from my XML feed were BMP and the image processing script at
includes/prodforums_uploader.php wouldn't process them. Here's the changes I made:

Hate bmps and really should expand on this to convert them as well but this is very helpful. Thanks for the contribution, it will be rolled into 1.3.6

[GCC LLC]

Are you thinking of this in place of the current productforums.php index or as a standalone feature [say a widget for the widebar]?

mySQL isn't great for formulas on the fly as they add load time but if it's just rating sum & count it's pretty simple.... I'll play around with some queries when I return after next week.

In our case we use the forum display and don't really send anyone directly to productforums.php, so I'd need to think outside the box a little on how/where to display it. More of an idea at the moment rather than anything.

[GCC LLC]

Hate bmps and really should expand on this to convert them as well but this is very helpful. Thanks for the contribution, it will be rolled into 1.3.6

Makes two of us, that's the reason I added that. Our XML feed was full of 300kb+ .BMP files that were being loaded on every page view. Hosting them locally, the JPGs are down to 12-15kb and page times are much faster for the end user.

[Ted S]

In our case we use the forum display and don't really send anyone directly to productforums.php, so I'd need to think outside the box a little on how/where to display it. More of an idea at the moment rather than anything.

Would a sidebar widget work? If not maybe a forum block above the threads with product photos [remember the old photopost integration?]

[imported_dfmafia]

installing and testing latest and greatest!
thnx agian Ted S!

[Ted S]

installing and testing latest and greatest!
thnx agian Ted S!

I head out of town in a few hours so please let me know of anything you need asap!

[GCC LLC]

Would a sidebar widget work? If not maybe a forum block above the threads with product photos [remember the old photopost integration?]

Sidebar widget would be excellent! I know you're leaving so no big rush, I'll probably mess with it while you're gone anyway.

[Ted S]

Trip got pushed back a day... So here's a few thoughts.

Sidebar widgets are pretty simple. First you need to learn how to build containers which you can do either with a plugin that shows php code or as an actual block [more control, more work].

Once you have your empty widget you'll need to write a new query pulling either the latest reviews [with a join to get the product data] or random products.

Each product has all the needed details self contained so you can just format the output with images [easy since you use the uploader] and no needing to reconstruction anything like you would a vB post or setting.

[deverill2010]

Hi ted I haven't upgraded but just spotted a missing review.

In this thread - http://www.midwiferyonline.co.uk/threads/4115-Twelve-Babies-on-a-Bike?p=36422#post36422

Two reviews have been posted but only one is showing (the very last one), however one has been submitted by another member as you can see the product says two reviews but its not showing?

Also is the title issue on activity stream fixed in the latest update?

[UK CHI3F]

Little issue, It says i dont have permissions

Sorry, you don't have permission to access the administrative controls on this page.

If you need to access this page, ask your lead administrator to enable your permissions for this page using the Administrator Permissions section of the control panel.

I am in the config file as super admin and undeletable, in the usergroup I'm enabled to use the forum but still wont let me use it, what am i missing?

[Ted S]

Hi ted I haven't upgraded but just spotted a missing review.

In this thread - http://www.midwiferyonline.co.uk/threads/4115-Twelve-Babies-on-a-Bike?p=36422#post36422

Two reviews have been posted but only one is showing (the very last one), however one has been submitted by another member as you can see the product says two reviews but its not showing?

Also is the title issue on activity stream fixed in the latest update?

You'll need to update to confirm issue #1 is still happening

Issue #2 I was unable to duplicate and will look into this weekend for a patch-level release once we can recreate it. Does this happen for all threads? Do you have any changes to the default activity settings that you recall?

[Ted S]

Little issue, It says i dont have permissions



I am in the config file as super admin and undeletable, in the usergroup I'm enabled to use the forum but still wont let me use it, what am i missing?

Where do you see this?

[Bruce1984]

Awesome mod! Definitely marked as installed :).

I keep bumping into a problem though. As soon as I try to add a product using the forums (not the ACP), I get the following vBulletin Message: "This feature is currently not in use"

Any ideas/suggestions?

- I am currently running vB 4.2.0 and the product installed fine.

- What I'm trying to do:
I'd like basically two sections; one for movies (and if I get everything working, I'd like the same for TV series and music albums as well) and one for hardware components at the moment (possibly software in the future, when I get things working/sorted out).
I'd like users (or myself) to be able to add either a movie (eventually a TV series and music albums) or an actual product (like a headset, monitor, hard drive, etc) and add a review, with for now basically one thread per product (and the reviews/responses/etc).
If I can set it up correctly, eventually perhaps one thread with all reviews and one with responses to the product/reviews, just not entirely sure how to set that up properly.

The separate forums are already present; a category with sub-forum called 'Movies' and a category for the hardware (& software) with a sub-forum 'Hardware'. I created a test product using the ACP in the Movie section, which worked flawlessly. Other users and myself are able to add a review to that product without issues.

However, as soon as either myself or a user tries to add a new product, I receive the aforementioned message. I did check the usergroups and the option 'Can add new products (moderated)' has been set to 'Yes', not only for myself but basically most usergroups.

I hope what I'm trying to achieve is possible (I believe it is?), but for some reason, I can't get it working. I did read the instructions carefully and have enabled the option in the usergroup manager, but am probably still missing some setting?

Any help would be greatly appreciated, thanks in advance!

[Ted S]

Awesome mod! Definitely marked as installed :).

I keep bumping into a problem though. As soon as I try to add a product using the forums (not the ACP), I get the following vBulletin Message: "This feature is currently not in use"

Open up the install link and read through the required fields... Essentially you're missing required settings and to prevent the mod from destroying your forum [no joke] it's erroring out.

In this case it's either the option to post products or the forum for the threads to go but where one is missing others are likely incomplete as well. I know it's long but you really need to go through the guide & options.

[Bruce1984]

Thanks for the response, appreciated!

I think that what I'm looking for (the separate forums, different products) isn't possible, well, not exactly what I was looking for. Hopefully I can explain everything clearly enough, pretty hard to explain without visuals.

But I think I've managed a work-around (not exactly a work-around, but a setting I had to adjust). Before, I had no forum ID entered, as there were several different forums (movies, hardware, etc). Now, I've created a sub-forum in the 'staff area' where new products will be posted once submitted, up for moderation. When moderated, they can then be placed in their respective categories and along with it the proper sub-forums.

As far as I can tell by the way the mod works, and please do correct me if I'm wrong, not trying to step on any toes or what not, but it looks like it will not be possible for me to have separate threads for the reviews and comments, rather than a single thread for both reviews and comments?

With the initial, to-be-moderated, products listed in the sub-forum in the staff section, it works fine, since it only creates a 'review' thread for the product. But if I would like an accompanying thread for comments, so I can keep reviews and comments separate, that would be a different thing entirely, wouldn't it?

Or will the "Create New Thread on Review", if enabled, be moved along with the original product thread to the proper destination once moderated?

In that case, users can simply comment on the individual review thread, rather than the original product review thread. So if both happen automatically, I spoke way too soon, meaning this is sort of what I'm looking for.

Again, don't get me wrong, it's an awesome mod and works fine! I'm guessing it's just the setting up which is the hard part, for it to work perfectly.

Edit: Also, thanks for your continuous support on this, I'm sure many would agree that's a big plus :).

[Ted S]

I think that what I'm looking for (the separate forums, different products) isn't possible, well, not exactly what I was looking for. Hopefully I can explain everything clearly enough, pretty hard to explain without visuals.

But I think I've managed a work-around (not exactly a work-around, but a setting I had to adjust). Before, I had no forum ID entered, as there were several different forums (movies, hardware, etc). Now, I've created a sub-forum in the 'staff area' where new products will be posted once submitted, up for moderation. When moderated, they can then be placed in their respective categories and along with it the proper sub-forums.


I wouldn't call that a workaround so much as intent...

The idea is that you have "users" suggesting products and "admins" approving them for the right category. The problem with data is it's origin and while it's faster to let people just add to any given forum that ups the risk.

Rather than a single thread for both reviews and comments?

Essentially all reviews are always appended as a post and optionally as a thread too. Whether or not you allow comments is up to you. If you don't want the review post you can hack it out but it is cross linked in a few places.

With the initial, to-be-moderated, products listed in the sub-forum in the staff section, it works fine, since it only creates a 'review' thread for the product. But if I would like an accompanying thread for comments, so I can keep reviews and comments separate, that would be a different thing entirely, wouldn't it?

Correct. I can offer a hook location up after the product thread is made to let you come back in and add another thread for your specific forum.

[Bruce1984]

Essentially all reviews are always appended as a post and optionally as a thread too. Whether or not you allow comments is up to you. If you don't want the review post you can hack it out but it is cross linked in a few places.
Gotcha. Is the appending of the posts (extra reviews) using the permissions of the forums? Otherwise perhaps I could restrict users from posting comments in the initial/original product thread, only allowing the extra reviews to be added as posts to the original thread -and- separate threads, in which users could reply.



Correct. I can offer a hook location up after the product thread is made to let you come back in and add another thread for your specific forum.
Alright, and I guess that would be awesome. If that would bring some automation to the process.

So to get things clear (and in case I might have explained things not clear enough), here's what I'm eventually looking for:

Various categories for 'products':
- Movies with reviews
- Music with reviews
- TV Series with reviews
- Hardware (actual products) with reviews
- Software (programs) with reviews

When a user submits a 'product', albeit a movie, a headset or a TV series:
- Thread is created in a Staff Only forum (done)
- Administrator either approves or denies it.

Upon denial:
- Either nothing happens, thread stays in staff forum or thread is moved to a 'Trash' forum

Upon approval:
- Product is added to the proper category (happens/done)
- Thread is created in proper sub-forum (happens/done)
- Thread is closed for regular postings/comments, only open to additional review posts

When a review is added:
- Post replied to original product thread (happens by default)
- New thread created in proper sub-forum for the additional review, open for commenting

So if it wasn't quite clear what I was hoping for, I hope it is now :). Anything you could help me with to achieve something like the above, would be great. I do hope it's not too much to ask though.

[Ted S]

Gotcha. Is the appending of the posts (extra reviews) using the permissions of the forums?

No. It's hard coded into the mod with overwrite rules to insure reviews still show up even if you disable responding.


When a user submits a 'product', albeit a movie, a headset or a TV series:
- Thread is created in a Staff Only forum (done)
- Administrator either approves or denies it.


The mod will allow the thread to be approved/ rejected/ moved as you described. As far as the closed status, you can set permissions in the forum to not allow replies but that will apply to all threads and you'd still need to create your comment thread as well. You'd likely want to create an extension for either/ both for to save yourself the manual work. Or tweak your requirements to allow both reviews & comments together.

To be clear a hook won't do this for you but rather would let you mod the mod to develop further without having to make a change each time the core code is updated.

[Bruce1984]

Alright, understood.

Unfortunately, I'm not too experienced with creating modifications myself. I'm usually perfectly fine with installing, checking all settings and fix small things, for example if reported in the mod thread. So I'll either have to change the 'requirements' as you stated, or learn how to develop the mod haha :).

I think that for now I'll just leave the things be, because it does seem to be working now (as to be expected obviously).

---

Oh, and here's me thinking out loud, hopefully not too far out of place, but is there 'an easy way' perhaps to alter the order in which certain posts are displayed/added to a thread?
Like, could I 'flag' the additional reviews posted in the product thread as being reviews/pinned/sticky/whatever and have them appear at the top of the thread, and have all regular posts/comments on the product to be appended? Or could that be a requested feature?

[Ted S]

Oh, and here's me thinking out loud, hopefully not too far out of place, but is there 'an easy way' perhaps to alter the order in which certain posts are displayed/added to a thread?

Like, could I 'flag' the additional reviews posted in the product thread as being reviews/pinned/sticky/whatever and have them appear at the top of the thread, and have all regular posts/comments on the product to be appended? Or could that be a requested feature?

Ordering by another attribute before date is certainly possible. If it's in demand we can look at bringing it into the mod.

[Bruce1984]

That would be awesome, now if only I could get this specific request under the attention of everyone, hoping for more support :).

Either way, thanks for all your support, hopefully the feature will be added in the (near) future!

[deverill2010]

I would be interested in that request.

I noticed when you click through to reviews from productforums.php it doesn't actually take you to the specific review but instead the start of the thread.

Having the reviews pinned to the front would be handy to save users having to trawl through posts in between reviews.

[UK CHI3F]

Where do you see this?

It is in the admin panel when i click on the product reviews and try to use:
custom rating fields
or anything in the product review items section

[Ted S]

I would be interested in that request.

I noticed when you click through to reviews from productforums.php it doesn't actually take you to the specific review but instead the start of the thread.

Having the reviews pinned to the front would be handy to save users having to trawl through posts in between reviews.

It should take you to the post...?

Are you using the review thread option or not?

[Ted S]

It is in the admin panel when i click on the product reviews and try to use:
custom rating fields
or anything in the product review items section

The script checks for the right to make posts [since reviews are posts].

Double check your admin account has this specific right and if not I'm sure we can add an explicit user group for the option in the future.

[Noerenberg]

HI, i want to say it is a great mod, i have just one problem now.

when i click on the productforums.php the button Add new product i get this error:
This feature is currently not in use

But i have set Members Can Post Products to yes and in the admingroup Can add new products is also on yes.

can you support me please?

EDIT, sorryy i fund my mistake i forgett to set the
New Product Forum ID
The forum where user-created product threads are placed by default.

[Ted S]

EDIT, sorryy i fund my mistake i forgett to set the
New Product Forum ID
The forum where user-created product threads are placed by default.

Hooray for the install guide making some sense!

[UK CHI3F]

The script checks for the right to make posts [since reviews are posts].

Double check your admin account has this specific right and if not I'm sure we can add an explicit user group for the option in the future.

I have the forum permissions, the forum is set to use PRF, in admin permissions we can add products, but still nothing.
Is there another permission we need?

[Ted S]

I have the forum permissions, the forum is set to use PRF, in admin permissions we can add products, but still nothing.
Is there another permission we need?

There's only one permission check... Can Post. Not forums but posts.

[Bruce1984]

I think the Product Review section itself is working fine for me now, I'll probably edit some fields here and there, but I'm slowly filling the list with products, so that's all good :). Loving it!

One thing I can't seem to change is the styling; it's probably me missing something pretty obvious, but the colors don't seem to change for me.

I am changing various variables in /clientscript/vbulletin_css/productforums.css, but as soon as I save/upload the edited version, nothing changes.

Is it a setting I'm missing? Or an additional step I need to perform for the changed .css-file to be used/activated?

[Ted S]

I think the Product Review section itself is working fine for me now, I'll probably edit some fields here and there, but I'm slowly filling the list with products, so that's all good :). Loving it!

One thing I can't seem to change is the styling; it's probably me missing something pretty obvious, but the colors don't seem to change for me.

I am changing various variables in /clientscript/vbulletin_css/productforums.css, but as soon as I save/upload the edited version, nothing changes.

Is it a setting I'm missing? Or an additional step I need to perform for the changed .css-file to be used/activated?

That file will edit the productforums.php index but not writing reviews or their display. Those elements are controlled with standard vB styling.

[Bruce1984]

That file will edit the productforums.php index but not writing reviews or their display.

Yes, I knew that :). The weird thing was, the overview wouldn't change at all once I made changed, but when I checked back this morning, one of the defined colors I changed was indeed showing up as that color.

I made some changes this afternoon and uploaded it, no changes then either, if the changes appear later tonight, it's somehow delayed... Which is weird.

[Ted S]

Yes, I knew that :). The weird thing was, the overview wouldn't change at all once I made changed, but when I checked back this morning, one of the defined colors I changed was indeed showing up as that color.

I made some changes this afternoon and uploaded it, no changes then either, if the changes appear later tonight, it's somehow delayed... Which is weird.

Hold the shift key when you reload the page. What you're seeing is cached.

[Bruce1984]

Hold the shift key when you reload the page. What you're seeing is cached.

Was afraid it was something this simple haha, all changes show up :), but I do feel kind of stupid now :o :p , but thanks for the patience & help!

[Noerenberg]

Hei this is a great mod but i have just little problem.

On your sreenshot i can see the editor when use want to put a new review, like this

https://vborg.vbsupport.ru/attachment.php?attachmentid=139758&d=1342151549

but on my site i have no editor

http://www.webpagescreenshot.info/i/166134-921201283744am.png

what do i wrong?

[Ted S]

Hei this is a great mod but i have just little problem.

On your sreenshot i can see the editor when use want to put a new review, like this

https://vborg.vbsupport.ru/attachment.php?attachmentid=139758&d=1342151549

but on my site i have no editor

http://www.webpagescreenshot.info/i/166134-921201283744am.png

what do i wrong?

Is the editor enabled for your site? For replies? It will pick up the global setting.

[Noerenberg]

Yes it is.

[ashimashi]

Hey I am currently using the 1.3.1. What is the difference between the current version and my version?

Does this new upgrade allow customizations of the fields?

[Ted S]

Hey I am currently using the 1.3.1. What is the difference between the current version and my version?

Does this new upgrade allow customizations of the fields?

Minor releases are essentially bugs and small features. Check the change log for full details or look back for the thread as a post is made with each update.

[ashimashi]

What has to be done to change the fields? If I would like to add to the current fields?

Like the first pic you shared: https://vborg.vbsupport.ru/attachment.php?attachmentid=139758&d=1342151549

The fields shown are not like the ones in the mod.

[Ted S]

What has to be done to change the fields? If I would like to add to the current fields?

Like the first pic you shared: https://vborg.vbsupport.ru/attachment.php?attachmentid=139758&d=1342151549

The fields shown are not like the ones in the mod.

Those custom fields have been an option since 1.3 beta 1 came out and are controlled through your ACP.

[ashimashi]

Those custom fields have been an option since 1.3 beta 1 came out and are controlled through your ACP.


Really? I don't seem to have that option. I deleted the whole mod and installed this just to be safe and make sure there are no problems or anything. I checked giftery website and reread everything and didn't see anything about customized fields. I also played around with it in ACP and couldn't find it either. Seems the same as before to me.

How do I change the fields?

Thanks!

[Ted S]

Really? I don't seem to have that option. I deleted the whole mod and installed this just to be safe and make sure there are no problems or anything. I checked giftery website and reread everything and didn't see anything about customized fields. I also played around with it in ACP and couldn't find it either. Seems the same as before to me.

How do I change the fields?

Thanks!

In your ACP go to the Product Review forums nav group and you'll see the Custom Rating Fields option.

This is controlled by the upload/includes/xml files packaged with the mod.

[ashimashi]

In your ACP go to the Product Review forums nav group and you'll see the Custom Rating Fields option.

This is controlled by the upload/includes/xml files packaged with the mod.

OH...

Sorry that was not what I meant, now that I am looking at the picture, that is for commenting.

Is there a way to make custom fields for post products? That is what I would love, Thanks!

[Ted S]

OH...

Sorry that was not what I meant, now that I am looking at the picture, that is for commenting.

Is there a way to make custom fields for post products? That is what I would love, Thanks!

There is not a GUI to do that but it is certainly something you can do if you extend the addon.

[ashimashi]

There is not a GUI to do that but it is certainly something you can do if you extend the addon.


How do I do that exactly? I would love a quick tutorial on that if possible. I am sure many others would love to learn this as well. I already know how to remove unwanted fields like SKU and UPC that I removed when adding products.

let me know
Thanks

[Subieforums]

Love this mod, but I am having a hard time getting the images to show up when I upload them. My current forum settings are on a test server. So my site path would be: http://www.mysite.com/test/forum/productreviews (that is where I put the folder for the images to go to)

In the core settings, I am having issues and am getting errors when I go to upload the photo.

The core settings suggest: [i.e. /var/www/home/forum/productphotos]

So I assume my path would be /public_html/test/forum/productphotos ?

I am just a bit confused on how to set my paths. Also I assume that will affect the image view url?

The second issue I am having is getting the image to show as the forum thread image. So when the member goes to the forum section reviews, they would see the product image to the left of the thread description etc. Do we have to create this image ourselves, or is there a way it will make the image resized itself? I am able to make it work by adding the url to the image file i just resized but was not sure if once I get the upload to work, if it'll automatically do this for me. Thanks

Any help would be greatly appreciated!!

[Subieforums]

Also, the stars are not working for me on the review page itself:

http://www.subieforums.com/test/showthread.php?18-Invidia-Q300-Cat-Back-Exhaust-Hatchback-08-12-STi

Thanks

[Ted S]

How do I do that exactly? I would love a quick tutorial on that if possible. I am sure many others would love to learn this as well. I already know how to remove unwanted fields like SKU and UPC that I removed when adding products.

let me know
Thanks

Look back through the thread... The details were posted up a few pages ago as an overview of what you'd need to do.

Removing fields is as simple as editing the write a review template in the frontend and ignoring them in the backend.

[Ted S]

Also, the stars are not working for me on the review page itself:

http://www.subieforums.com/test/showthread.php?18-Invidia-Q300-Cat-Back-Exhaust-Hatchback-08-12-STi

Thanks

Did you upload the stars to your images folder? If so, where is it?

[Ted S]

Love this mod, but I am having a hard time getting the images to show up when I upload them. My current forum settings are on a test server. So my site path would be: http://www.mysite.com/test/forum/productreviews (that is where I put the folder for the images to go to)

In the core settings, I am having issues and am getting errors when I go to upload the photo.

The core settings suggest: [i.e. /var/www/home/forum/productphotos]

So I assume my path would be /public_html/test/forum/productphotos ?


That's really not something I can answer as every server is different.

1. This path needs to be from root, so in this case you are stating that /public_html/ is your first level folder, that sounds unlikely for most linux boxes but if you view the folder via FTP you can quickly confirm if anything is actually going into it.

2. The other path is a display link that corresponds to where images in that folder appear relative to your site. Thus if you're placing them in the /forum/ level folder [from web-root] the path would be /forum/productforums/.

I am just a bit confused on how to set my paths. Also I assume that will affect the image view url?

If the path is wrong the image can't be created so yes, that would impact things :D

The second issue I am having is getting the image to show as the forum thread image. So when the member goes to the forum section reviews, they would see the product image to the left of the thread description etc.

Please read the install guide. This is not done out of the box and requires code hacking.

Do we have to create this image ourselves, or is there a way it will make the image resized itself? I am able to make it work by adding the url to the image file i just resized but was not sure if once I get the upload to work, if it'll automatically do this for me

External urls are not resized. Uploaded or synced images [you can have the script sync urls] are.

[Ted S]

Yes it is.

Is the option enabled in your PRF settings?

Use WYSIWYG Editor
Displays the advanced editor for new reviews. If you are experiencing issues with the display or validation, you should disable this.

[Noerenberg]

Is the option enabled in your PRF settings?

Use WYSIWYG Editor
Displays the advanced editor for new reviews. If you are experiencing issues with the display or validation, you should disable this.


YES

[Ted S]

YES

The mod picks up that setting and your forum configuration. Other than that it's the same exact editor used for posting. Thus if it's not displaying there is either a setting you have overlooked or an error in how it is rendering in your specific forum.

Are you getting any javascript errors loading the page? Any 404 requests in your server logs?

[Noerenberg]

The mod picks up that setting and your forum configuration. Other than that it's the same exact editor used for posting. Thus if it's not displaying there is either a setting you have overlooked or an error in how it is rendering in your specific forum.

Are you getting any javascript errors loading the page? Any 404 requests in your server logs?

I got no errors , nothing.
I dont know which setting i have to check, the standard editor is the WYSIWYG Editor.

[Ted S]

I got no errors , nothing.
I dont know which setting i have to check, the standard editor is the WYSIWYG Editor.

All of them. The mod picks up your forum's settings for the editor.

What's the url to the write a review page?

[Subieforums]

Did you upload the stars to your images folder? If so, where is it?

Yes, I uploaded it as described. I noticed that the url for the image shows two "-", is that what it's supposed to be?

http://www.subieforums.com/test/images/rating/pf/stars--5.png

When I look in the folder, there is no "stars--5.png".

Thanks! Looking into your other help now.

[Subieforums]

That's really not something I can answer as every server is different.

1. This path needs to be from root, so in this case you are stating that /public_html/ is your first level folder, that sounds unlikely for most linux boxes but if you view the folder via FTP you can quickly confirm if anything is actually going into it.

2. The other path is a display link that corresponds to where images in that folder appear relative to your site. Thus if you're placing them in the /forum/ level folder [from web-root] the path would be /forum/productforums/.



If the path is wrong the image can't be created so yes, that would impact things :D



Please read the install guide. This is not done out of the box and requires code hacking.



External urls are not resized. Uploaded or synced images [you can have the script sync urls] are.

Tried different variations. I attached a screen shot.

[Ted S]

Tried different variations. I attached a screen shot.

If you don't know your server paths check with your hosting provider ans ask them for the location from root to your forum folder.

There is a literally infinite number of options and thus no way for me to be able to tell you what your individual settings should be.

[Ted S]

Yes, I uploaded it as described. I noticed that the url for the image shows two "-", is that what it's supposed to be?

http://www.subieforums.com/test/images/rating/pf/stars--5.png

When I look in the folder, there is no "stars--5.png".

Thanks! Looking into your other help now.

Good catch. The first value is the color of the stars {green or pink} which you need to set in your admin options. This should be a default but those don't always stick.

[Subieforums]

Good catch. The first value is the color of the stars {green or pink} which you need to set in your admin options. This should be a default but those don't always stick.

Ok, the color was selected, but I changed the colors around in the drop down, saved, and now working so thanks. I'll check on the forum path issue and keep you posted, thanks!

[TomasDR]

Escaping the string is essential for preventing injections so good call on working through that...

We'll be redoing the search function a bit in light of your bug report and will try to test with a few mySQLi connections as well.

All I did was use VB's standards and it worked.

Replaced all instances of:
mysql_real_escape_string

With
$db->escape_string

Works fine now and I believe I am still safe.

[Ted S]

All I did was use VB's standards and it worked.

Replaced all instances of:
mysql_real_escape_stringWith
$db->escape_stringWorks fine now and I believe I am still safe.

That's a totally safe approach which uses mysql_real_escape_string or whatever version is relevant for your mySQL / db install. We'll move over to this for best practices in the next version...

[Subieforums]

Got this just about ironed out and absolutely love it!

Just one question however, I am trying to get it so the "Post New Thread" button actually is "Add New Product" like in this screenshot: https://vborg.vbsupport.ru/attachment.php?attachmentid=139761&d=1342151619

Any quick answer to that, thanks!

[Noerenberg]

All of them. The mod picks up your forum's settings for the editor.

What's the url to the write a review page?

EDIT

DELETE

After 10 days of waiting tzzzzzzzzz

[fwulfers]

Are there any demos for this mod or sites that have it running so we can take a look before we install?

[snotek]

Are there any demos for this mod or sites that have it running so we can take a look before we install?

I don't know about "demo" per se, but we are running this plugin and have a few products added.

http://diydronesafety.com/productforums.php

[halilkoca]

hi.

it s about payment page or purchase url.

we can write some url to the "purchase url".

but i don't want this option.

i want to see paypal buy it now page.

URL must be forward to paypal page. user can not change the url.

can you helP?

[Ted S]

hi.

it s about payment page or purchase url.

we can write some url to the "purchase url".

but i don't want this option.

i want to see paypal buy it now page.

URL must be forward to paypal page. user can not change the url.

can you helP?

People can always change the url of the page they go to. And if you force them into a box without the option they just leave, go to Google and find it themselves.

p.s. Sending a PM and posting the same question to the mod thread means two places to check & reply wasting both your time and mine. Stick to the thread.

[fwulfers]

I tried this out on one of my sites but found the following issues that prevent me from using this, unfortunately. Unless I am missing something.

1) No sub-categories for main categories
2) No custom fields for each category

Looks like a great mod though, perhaps this will be available in a future version.

[Ted S]

I tried this out on one of my sites but found the following issues that prevent me from using this, unfortunately. Unless I am missing something.

1) No sub-categories for main categories
2) No custom fields for each category

Looks like a great mod though, perhaps this will be available in a future version.

Neither exists at this time and while they've been suggested, neither has much demand thus far. We'll add this as another vote.

[deverill2010]

Ted your mod makes the folder 'productimages' in the root directory doesn't it?

[L2Insomnia]

1) No sub-categories for main categories
2) No custom fields for each category

I would love to see this as well. I plan to use this for a hosting based community and sub-categories would really be needed. I will be trying this mod out over the next few weeks thanks!

[Afresh07]

Is there an option (or one in the Near future) for mutiple pictures per product? I have this installed on my site and it looks great!

Also, my two cents the next great option would be to compare products? I think this would work great?

When the page is shared on Facebook? It does not share the image? Can that be repaired to work or NO?

[Ted S]

Ted your mod makes the folder 'productimages' in the root directory doesn't it?

The mod doesn't make the folder anywhere... You can place it wherever you want so long as it's web accessible.

[Ted S]

I would love to see this as well. I plan to use this for a hosting based community and sub-categories would really be needed. I will be trying this mod out over the next few weeks thanks!

Thanks and noted! :D

[Ted S]

Is there an option (or one in the Near future) for mutiple pictures per product? I have this installed on my site and it looks great!

Also, my two cents the next great option would be to compare products? I think this would work great?

When the page is shared on Facebook? It does not share the image? Can that be repaired to work or NO?

There is not a multiple photo option but with the uploader that's easier to do than it was in the past so probably part of the next major release.

Product comparing is less likely as it takes a lot of data structure and that's hard when you have disparate product types between communities [and in many cases not products at all].

Facebook is an easy tweak as we just need to throw some meta data into the page. I'll see if I can do a patch-level release for that today.

[Afresh07]

There is not a multiple photo option but with the uploader that's easier to do than it was in the past so probably part of the next major release..
Awesome to hear, do you know when the next major release is expected, Just asking?

Product comparing is less likely as it takes a lot of data structure and that's hard when you have disparate product types between communities [and in many cases not products at all]...

Facebook is an easy tweak as we just need to throw some meta data into the page. I'll see if I can do a patch-level release for that today.
AWESOME---- > Happy, happy.. yay. :)

[Ted S]

Awesome to hear, do you know when the next major release is expected, Just asking?

Not date is set, no features in progress. We build based on usage & interest... 1.3 this summer was a major, major update but we didn't see a huge spike in use so we've held towards more "core". Probably mid fall.

[Ted S]

AWESOME---- > Happy, happy.. yay. :)

Give this version a whirl to add the facebook meta support... It's only single site tested so if something seems off revert.

[Mr Anarch]

I tried this out on one of my sites but found the following issues that prevent me from using this, unfortunately. Unless I am missing something.

1) No sub-categories for main categories
2) No custom fields for each category

Looks like a great mod though, perhaps this will be available in a future version.

I would love to see these things as well!

[Stefan84]

while using the uploader, in core settings i must enter my path to the images folder. I created in my public_html/images/ folder a sub folder named products, and chmod it to 777. What do i enter in the core settings at images uploader path, i tryed alot but none worked..and yes GD and cUrl are enabled.


Image Upload Path: The absolute path images should be posted too [i.e. /var/www/home/forum/productimages chmod 0777]

[Stefan84]

while using the uploader, in core settings i must enter my path to the images folder. I created in my public_html/images/ folder a sub folder named products, and chmod it to 777. What do i enter in the core settings at images uploader path, i tryed alot but none worked..and yes GD and cUrl are enabled.

Got it using /home/{loginname of website}/public_html/images/products/ in my case!

[Afresh07]

Give this version a whirl to add the facebook meta support... It's only single site tested so if something seems off revert.


Ill install it later on today and give you the heads up, if it worked fine or not !!!

Thanks !!!

[Ted S]

Got it using /home/{loginname of website}/public_html/images/products/ in my case!

Tree paths are unique from host to host so while I'm glad you figured it out, others should be sure to check their settings before trying to jump in on this one or it can be a long, long guessing game.

[Afresh07]

Give this version a whirl to add the facebook meta support... It's only single site tested so if something seems off revert.

I gave it a try last night and it was a no go, when i shared it via addthis, nothing came up either, it posted on FB:


No image
Name of site
Description of site
Post title


Any suggestions ?

[Ted S]

I gave it a try last night and it was a no go, when i shared it via addthis, nothing came up either, it posted on FB:

No image
Name of site
Description of site
Post title
Any suggestions ?

View the source of your product page and let me know if you see og:title filled in [or listed at all].

[Subieforums]

Looking for two things:

1. I see that users can not upload an image for a review, unless I (admin on site), manually add the image to the review through the admin panel. Is there a way to allow a regular registered member to upload an image with the review, and if the review is approved by staff, it will use the photo submitted?

&

2. I am looking for a way that any time a new review is approved, a comment is automatically made to our site's facebook and/or twitter account. I think the power of this mod would really enhance it automatically shared it with the social sites.

Thanks in advance, love this mod!

[Ted S]

1. I see that users can not upload an image for a review, unless I (admin on site), manually add the image to the review through the admin panel. Is there a way to allow a regular registered member to upload an image with the review, and if the review is approved by staff, it will use the photo submitted?

Reviews do not support photos at this time from either users or staff.

Products however do support images. Users can add them via URL, admins via upload. If a user provides a link you can sync the image to save and resize it locally. There is no option for user uploading.

2. I am looking for a way that any time a new review is approved, a comment is automatically made to our site's facebook and/or twitter account. I think the power of this mod would really enhance it automatically shared it with the social sites.

I'm not a believer in automated posting, especially when it could amount to many simultaneous posts flooding followers & essentially turning the account into a broadcast feed. That's not social. It seems far more appropriate to highlight a select review here & there with a personal comment and an active discussion but that's just my $0.02 as an enterprise social strategist.

In our next release we'll include a hook location to insert a function after a review has been posted where you could automate an API call to Facebook, Twitter or any other platform. How's that?

[Subieforums]

Reviews do not support photos at this time from either users or staff.

Products however do support images. Users can add them via URL, admins via upload. If a user provides a link you can sync the image to save and resize it locally. There is no option for user uploading.



I'm not a believer in automated posting, especially when it could amount to many simultaneous posts flooding followers & essentially turning the account into a broadcast feed. That's not social. It seems far more appropriate to highlight a select review here & there with a personal comment and an active discussion but that's just my $0.02 as an enterprise social strategist.

In our next release we'll include a hook location to insert a function after a review has been posted where you could automate an API call to Facebook, Twitter or any other platform. How's that?

1. Ya for the image uploads in the admin panel I see that. I may be missing it, but can a "registered" usergroup member submit a photo for approval or moderation to go with the review they have submitted to be approved? If not, then I (as an admin) have to either upload or add the url for an image. Not an issue, was just wondering.

2. In regards to the new post upon a new review, that is exactly what I am looking for, that would be perfect! Any ETA on a new release? Thank you so much.

Greatly appreciate the mod Ted, and your response! Cheers :up:

[Ted S]

1. Ya for the image uploads in the admin panel I see that. I may be missing it, but can a "registered" usergroup member submit a photo for approval or moderation to go with the review they have submitted to be approved? If not, then I (as an admin) have to either upload or add the url for an image. Not an issue, was just wondering.

There is no option for user uploading.

2. In regards to the new post upon a new review, that is exactly what I am looking for, that would be perfect! Any ETA on a new release? Thank you so much.

Nothing scheduled but if you build your extension into the core code and tell me where you're hooking in I'll see that we add the hook there so upgrading just takes a few clicks...

[UK CHI3F]

I cant see an answer only the questin has anyone worked out how to change the order of the reviews, ie to the latest uploaded rather than reverse alpahbetical order.

Check our page if you are confused in any way
http://www.xboxplayers.co.uk/site/productforums.php?tabid=98

[Ted S]

Pop open productreviews.php and about a third of the way down is the ranking routine. You can manually change the default.

[Harpo]

Hi.

I'm having problems uploading images. I don't know my correct path to past into the options. see the attached image.

I tried out. /public html/images/product images/
still no luck.

Everything else is working great though. manually uploading and adding the url seems to work only.



Also I'll be using this for articles like "my top fives" etc... having those Manfactures, ISBN, where to purchase, options are useless to me. can I replace these with something else?

[Ted S]

Hi.

I'm having problems uploading images. I don't know my correct path to past into the options. see the attached image.

I tried out.
[/quote[

You need to check with your host. File paths can range to any number of options depending on the provider's setup and there's nothing we know here that will help with that.

[quote]Also I'll be using this for articles like "my top fives" etc... having those Manfactures, ISBN, where to purchase, options are useless to me. can I replace these with something else?

You can relabel the fields in the templates. The AdminCP doesn't change as easily but only you see that.

[Harpo]

Thanks for the quick reply.

I'll try relabeling. Stupid me, which templates do I edit?

[UK CHI3F]

Pop open productreviews.php and about a third of the way down is the ranking routine. You can manually change the default.

Awesome just for everyones elses reference its line 139/140
// sort up or down
$sortorder = strtolower($sortorder);
if ($sortorder != 'asc')
{
$sortorder = 'asc';
$oppositesort = 'desc';

Change the $sortorder to 'asc' like we have

Thanks Ted

[Ted S]

Awesome just for everyones elses reference its line 139/140
// sort up or down
$sortorder = strtolower($sortorder);
if ($sortorder != 'asc')
{
$sortorder = 'asc';
$oppositesort = 'desc';Change the $sortorder to 'asc' like we have


Thanks!

[ludachris]

I know there is no live demo site to look at, but can anyone share a live installation so we can poke around a little to see how it works in a community environment? I for one would just like to see how it's being used.

[ludachris]

Would just like to confirm something on the functionality - the admin is able to specify usergroups who can add products, correct? Are they able to add products on the front end or do they have to have ACP access? Can they edit product info (as well as affiliate links) without going into ACP after the product is posted?

[Ted S]

Would just like to confirm something on the functionality - the admin is able to specify usergroups who can add products, correct? Are they able to add products on the front end or do they have to have ACP access? Can they edit product info (as well as affiliate links) without going into ACP after the product is posted?

Correct, product additions are a usergroup level permission as well as an overall mod option.

Users add products on the frontend but can not upload photos directly. URLs to external links can however be sync'd.

Users can not add to products after the fact or change links.

1.4 will update both those last points and may allow multiple stores per product.

[ludachris]

Correct, product additions are a usergroup level permission as well as an overall mod option.

Users add products on the frontend but can not upload photos directly. URLs to external links can however be sync'd.

Users can not add to products after the fact or change links.

1.4 will update both those last points and may allow multiple stores per product.
So editing the product information and links would have to be done in ACP then?

When do you estimate 1.4 to be ready, roughly?

[Ted S]

So editing the product information and links would have to be done in ACP then?

Yes. Only an admin will have access to approve / update an item.

When do you estimate 1.4 to be ready, roughly?

I have no real estimate yet as we haven't had the level of input / requests we look for before starting changes. Thus right now our focus is on working with forums to insure the mod fits, works as intended and learn where we can take it.

[KeystoneAirsoft]

Hi all,

Ok I have added this to one of my sites and have an issue and a question pertaining to my issue as well as another question.

My issue is when I try to do a Review on a product and click submit I get this error message - Fatal error: Class 'vB_ActivityStream_Manage' not found in /home/xxxxxx/public_html/productforums.php on line 588. I noticed on page 88 of this post, post #1316 someone else had the same issue and in post #1318 located here (https://vborg.vbsupport.ru/showpost.php?p=2362700&postcount=1318) you made mention of having a activity system installed. Now is this a completely different mod or one built into this one that I am overlooking?

Now my other question, I have a forum area for Product Reviews, now I have several sub category forums under product reviews(Forum ID 7) such as Spring Guns (Forum ID 8), CO2 Guns ( Forum ID 9), AEG's (Forum ID 10), Scopes(Forum ID 11), etc, etc. Is there a way to allow Reviews under each one of these sub categories instead of the main Forum Area?

Thanks much in advance.

[Ted S]

My issue is when I try to do a Review on a product and click submit I get this error message - Fatal error: Class 'vB_ActivityStream_Manage' not found in /home/xxxxxx/public_html/productforums.php on line 588. I noticed on page 88 of this post, post #1316 someone else had the same issue and in post #1318 located here (https://vborg.vbsupport.ru/showpost.php?p=2362700&postcount=1318) you made mention of having a activity system installed. Now is this a completely different mod or one built into this one that I am overlooking?

The activity stream is a default part of vBulletin 4.

What version of 4 are you running?

Now my other question, I have a forum area for Product Reviews, now I have several sub category forums under product reviews(Forum ID 7) such as Spring Guns (Forum ID 8), CO2 Guns ( Forum ID 9), AEG's (Forum ID 10), Scopes(Forum ID 11), etc, etc. Is there a way to allow Reviews under each one of these sub categories instead of the main Forum Area?

Add your products to the respective forum categories and the reviews will be included as post replies to them.

[KeystoneAirsoft]

Hi Ted S,

Thanks for your prompt reply.

Ok cool, will have to see if I can find it. I am currently using VB 4.0.4.

Ok I figured out how to add the Reviews to the specified forum areas. Didn't think that one through enough before posting. Sorry for that :(.

[Ted S]

Ok cool, will have to see if I can find it. I am currently using VB 4.0.4.

That's fairly old... probably why the error.

[Caseycase]

Hi,

I've been testing the Mod for a few days now and I'd just like to say it is excellent.

To keep up the tradition, there is a but...

firstly can I add a vote to the custom rating fields being controlled on the review by product category, product sub categories sounds good to me as well.

I think a lot more development effort, but my third vote would be for a mechanism to control product field labels by category. e.g. Create 5 additional fields in the product table on the DB and then have a mechanism to apply different labels to the user based on the product category. Obviously these fields could not be used for structured searches as the data wouldn't necessarily be relevant across product categories but it would allow more flexibility for uses where you want users to create data, but at the same time make it more obvious / structured to what they populate where.

The next thing is a funny that has me stumped, but this could be vb related, which I am also new to. When I posted my first review to a product I noticed that the custom rating fields in the review, posted with the html tags visible.

<strong>Quality</strong>: 1 stars<br><strong>Value for Money</strong>: 1 stars<br>

However I carried on testing, creating new products, reviews etc. When I went back to the original review that had the problem it was displayed correctly without the tags. (though there is a possibility that I did edit the post, which I guess may have corrected it)

Now though I have another product that has 2 reviews, with the custom rating fields showing the tags. One review was created by my admin account the other was created by a normal user account. Once I spotted this problem I tried to creating another review, however this was created fine displaying no html tags.

I'm 99% certain that no configuration changes have been made between posting the various reviews, and unfortunately I'm not able to replicate the issue.

I guess it is something unique to my set up, and as it is no longer happening not really a problem, however I thought I'd mention it in case it does happen to someone else, or someone can tell me the error of my ways!

Thanks again for the excellent mod

[Ted S]

firstly can I add a vote to the custom rating fields being controlled on the review by product category, product sub categories sounds good to me as well. .

Sure... Noted :D

The next thing is a funny that has me stumped, but this could be vb related, which I am also new to. When I posted my first review to a product I noticed that the custom rating fields in the review, posted with the html tags visible.

We insert the HTML but vBulletin's CSS kills it in many cases depending on your theme although it should happen all the time or none... perhaps the admin had rights to post it while the users did not thus the parser filtered differently... It's on the table to revisit.

[Phrost]

Dumb question: can members add products or does this have to be done by an administrator?

-Someone who should have never upgraded to VB4 because it killed GARS.

[Ted S]

Dumb question: can members add products or does this have to be done by an administrator?

-Someone who should have never upgraded to VB4 because it killed GARS.

Members can add products if you enable it on their usergroup.

They cannot upload images but they can provide urls which will import if you want to use the thumbnail options.

[Subieforums]

For some reason, my Create Product Review button is not showing up in the forum section anymore, not sure if I mixed up a setting but it was there before...

http://www.subieforums.com/f24/

Any help would be appreciated, thanks!

[Ted S]

For some reason, my Create Product Review button is not showing up in the forum section anymore, not sure if I mixed up a setting but it was there before...

http://www.subieforums.com/f24/

Any help would be appreciated, thanks!

The setting is in two places: the overall mod option and per-usergroup. Check both then check that your forumdisplay templates aren't missing any default hooks.

[Subieforums]

Ted,
I checked the forumdisplay.php file, and my edit is still there.

I am also checking the control panel options and nothing...where exactly would that feature be at there? Just want to double check...it's weird because i had it there...

[Subieforums]

Also, inquiring about the following:

Is there a way that when a user adds a url for the product image, it can automatically be downsized to the thumbnail sizes etc, like it does when manually uploaded to server?

And, is there a way that a usergroup pre-defined, can have access to moderate the approval of a submitted review? I made a specific usergroup that can submit reviews, I want to be able to allow them to approve the product reviews, but I dont want them to have access to my admin panel.

Thanks!

[Ted S]

Ted,
I checked the forumdisplay.php file, and my edit is still there.

I am also checking the control panel options and nothing...where exactly would that feature be at there? Just want to double check...it's weird because i had it there...

Your usergroup permissions and the PRF options.

[Ted S]

Is there a way that when a user adds a url for the product image, it can automatically be downsized to the thumbnail sizes etc, like it does when manually uploaded to server?

No. Users add links, not uploaded images. But if you run the sync script it will save them locally and resize for you.

And, is there a way that a usergroup pre-defined, can have access to moderate the approval of a submitted review? I made a specific usergroup that can submit reviews, I want to be able to allow them to approve the product reviews, but I dont want them to have access to my admin panel.

Nope.

[Subieforums]

No. Users add links, not uploaded images. But if you run the sync script it will save them locally and resize for you.



Nope.

When i go to sync external images and click on the proceed button, nothing happens..

[Ted S]

When i go to sync external images and click on the proceed button, nothing happens..

Do you get a white page? An error? Endless loading request?

Have you setup all the image folder / path options?

[Subieforums]

Hey Ted,

Thank you for your support, I'm sure it's a minor mistake on my part...


Right now I am creating a new product review and adding the photo url. So when I go to approve the review, I have to then save the image to my desktop or wherever, and manually upload it through the upload option. From what it looks like, by syncing it, it should allow me to just click that and it will automatically grab those image urls that have been added and add the photos, thumbnails etc automatically. Is that the way its supposed to work?

When I click on "Proceed" in the sync option, (when reviews are waiting to be approved), i get the following:

Couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
All Done!

And I still have to manually upload the image. Are my folder permissions off?

[Ted S]

Hey Ted,

Thank you for your support, I'm sure it's a minor mistake on my part...


Right now I am creating a new product review and adding the photo url. So when I go to approve the review, I have to then save the image to my desktop or wherever, and manually upload it through the upload option. From what it looks like, by syncing it, it should allow me to just click that and it will automatically grab those image urls that have been added and add the photos, thumbnails etc automatically. Is that the way its supposed to work?

When I click on "Proceed" in the sync option, (when reviews are waiting to be approved), i get the following:

Couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
couldnt save the image for - skipping
All Done!And I still have to manually upload the image. Are my folder permissions off?

That's hardly nothing ;)

Either your folder is not writable (chmod 755 or 777) or the path to it is not correct. Remember the path is from root, not local.

[prophetmuhammad]

uninstalling this mod broke my forum. the user profile pages and "what's new" page don't work now.

[Ted S]

uninstalling this mod broke my forum. the user profile pages and "what's new" page don't work now.

Are you looking for help or just to tell us that you're not using the mod?

[jgruberman]

The mod doesn't change any settings (it follows however the forum is setup) so for the sake of argument try adjusting the settings down or up and see if that makes the moderation queue go away (or work correctly).

I'm having this same issue too. I understand that it follows the forum permissions, but what permissions exactly within VB would also dictate the ability for the products to go into Moderation?

Screen New Reviews? - Set to NO

I've been reading about this mod a lot in the thread, and I'm sure there's a way to skip the moderation queue completely... just struggling to find it through 97 pages.

Suggestions Ted?

Edit:: Also, I'm having issues with the Product_Create template. When someone goes to submit something and a required field isn't complete, it loops back to the page but doesn't generate any error text. I added a static phrase saying something like "If this page reloads after clicking Submit, please check all fields for completion.", but was hoping to add the logic code in to check the specific fields and notify the user.

[Ted S]

I'm having this same issue too. I understand that it follows the forum permissions, but what permissions exactly within VB would also dictate the ability for the products to go into Moderation?

The modification tries to overrule any forum settings but let's start there... Does the forum or usergroup have any moderation / posting restrictions placed on it? And of course I assume you're using the very latest version?

Edit:: Also, I'm having issues with the Product_Create template. When someone goes to submit something and a required field isn't complete, it loops back to the page but doesn't generate any error text. I added a static phrase saying something like "If this page reloads after clicking Submit, please check all fields for completion.", but was hoping to add the logic code in to check the specific fields and notify the user.

Is this with any field error or just a specific one?

[jgruberman]

The modification tries to overrule any forum settings but let's start there... Does the forum or usergroup have any moderation / posting restrictions placed on it? And of course I assume you're using the very latest version?


Very latest forum version, just installed brand new so no moderation/posting restrictions.


Is this with any field error or just a specific one?

This is with any required field on the Product Create page - no single specific one.

[Shazz]

Ted, great product. I can't figure out why these thumbnails aren't showing.
Also when I upload a photo it doesn't show but in the FTP it will show its there. Permissions are 777

Thanks in advance

[Ted S]

Ted, great product. I can't figure out why these thumbnails aren't showing.
Also when I upload a photo it doesn't show but in the FTP it will show its there. Permissions are 777

Thanks in advance

Have you checked the path in your pages against the folder structure?

[Shazz]

After a triple check and troubleshoot, which you reminded me to do it works. Thanks Ted!

[revaxmedia]

Just started uploading this - looks really good!

[zapiy]

Would someone kindly point me in the direction of remove the UPC / ESIN / ISBN and the part number please?

[Ted S]

Would someone kindly point me in the direction of remove the UPC / ESIN / ISBN and the part number please?

Just edit the template to remove the field.

[zapiy]

Hi Ted, Which template?

[insanewhip]

Hello I downloaded and installed and nothing happen. No error codes or anything. Have you heard of this, can you help?

[Ted S]

Hello I downloaded and installed and nothing happen. No error codes or anything. Have you heard of this, can you help?

Did you enable it in any forums or set the mandatory options as noted in the install file?

[zapiy]

Please help me out here fella..

[Ted S]

Please help me out here fella..

Search your templates and you'll find the one you want to edit.

[werneri]

Hi!
I'm struggling - where to set the admin rights for the AdminCP for another Admin.
Everything runs fine, but not I would like to give another admin rights for accessing the admin features and also approve products.
I searched for this setting, but do not find it - probably I'm just blind :confused:
please help.
Thank you in advance.

[Ted S]

Hi!
I'm struggling - where to set the admin rights for the AdminCP for another Admin.
Everything runs fine, but not I would like to give another admin rights for accessing the admin features and also approve products.
I searched for this setting, but do not find it - probably I'm just blind :confused:
please help.
Thank you in advance.

There is no distinct Admin function for this mod. If an admin can manager users / groups / posts they can access products.

[zapiy]

Hi, i have managed to edit the correct templates.

I need to make some more changes if possible.

I have using this as a review mod, i dont want users to review a review so can i disable this and enable the reply to the thread option?

Cheers

[werneri]

Hi Ted!

There is no distinct Admin function for this mod. If an admin can manager users / groups / posts they can access products.

Strange. I myself can access product fine. I have another admin who is also in the Admin Group - he can access the "Product Review Settings" in AdminCP, but as soon as he hits "Product Review items" (e.g Manage Products & Reviews) he gets an Access Denied from AdminCP. :confused:

Can you think of any reason for this behaviour?

Thank you in advance,
Regards,
Werner

[Ted S]

Hi, i have managed to edit the correct templates.

I need to make some more changes if possible.

I have using this as a review mod, i dont want users to review a review so can i disable this and enable the reply to the thread option?

Cheers

Sure. Just turn off replies in the forum where reviews go.

[Ted S]

Hi Ted!



Strange. I myself can access product fine. I have another admin who is also in the Admin Group - he can access the "Product Review Settings" in AdminCP, but as soon as he hits "Product Review items" (e.g Manage Products & Reviews) he gets an Access Denied from AdminCP. :confused:

Can you think of any reason for this behaviour?

Thank you in advance,
Regards,
Werner

Strange.

The permission check in the mod is for canadminposts [since reviews are post content]. Does this admin have the right to edit posts?

[qpurser]

Your mod works great and does exactly what we need for our forum.

I have a small issue when trying to post a review.
On top of the web page I get the message:

Warning: Invalid argument supplied for foreach() in [path]/includes/functions_editor.php(467) : eval()'d code on line 89

I tried WYSIWYG and regular editor settings and both give me this error.

Any idea what could be wrong?

Thanks

EDIT: I installed the mod on another test server and the problem doesn't show up anymore

[qpurser]

However I still have one more issue:

In the particular forum where my products and reviews go the "Post new thread" still shows up.

Edited the forumdisplay.php
have made the forum a PRF forum in the forum manager
Usergroups are allowed to use the MOd

The forum display is correct. It shows the picture thumbnail etc.

Just the "post new thread" is still there which is not supposed to be

Any help greatly appreciated

[Ted S]

However I still have one more issue:

In the particular forum where my products and reviews go the "Post new thread" still shows up.

Edited the forumdisplay.php
have made the forum a PRF forum in the forum manager
Usergroups are allowed to use the MOd

The forum display is correct. It shows the picture thumbnail etc.

Just the "post new thread" is still there which is not supposed to be

Any help greatly appreciated

Posting threads is forum permission issues just like you'd do on any other forum without this mod running. Turn that off and you're good to go.

[qpurser]

Posting threads is forum permission issues just like you'd do on any other forum without this mod running. Turn that off and you're good to go.

Thank you so much.
I should have thought of that.
I set in the forum manager this forum is open to NO and it works great.
It came up in my mind but I thought when a forum is not open your MOD wouldn't be able to post the thread in there which was obviously wrong thinking.

Now I added the code from post #1099 in my forumdisplay and the "Add new product" shows up nicely.

[Ted S]

Thank you so much.
I should have thought of that.
I set in the forum manager this forum is open to NO and it works great.
It came up in my mind but I thought when a forum is not open your MOD wouldn't be able to post the thread in there which was obviously wrong thinking.


Great!

The mod goes through a number of checks to try and override forum rules for posting content [within the rules you set for the mod of course] but do be sure to check your moderation queue in case anything lands in there [and if so let us know].

[JesterP]

This is a pre-test question:

I am developing a site and I'd like to include product reviews. This looks like it would be perfect. However, I still would like normal forum functionality.

Would it work if I created a child skin and modified that forumdisplay to your specs, then forced those forums to use that style?

Thanks!!

[Ted S]

This is a pre-test question:

I am developing a site and I'd like to include product reviews. This looks like it would be perfect. However, I still would like normal forum functionality.

Would it work if I created a child skin and modified that forumdisplay to your specs, then forced those forums to use that style?

Thanks!!

Sure but there's no need to change the style unless you want to. The mod integrates alongside normal forum functions with the suggestion that you limit some of the posting options in product areas to keep things streamlined.

[JesterP]

Sure but there's no need to change the style unless you want to. The mod integrates alongside normal forum functions with the suggestion that you limit some of the posting options in product areas to keep things streamlined.

Ahh ok. When I looked at your site I didn't see any forums and I assumed it just over took it all.

Thank you for the prompt response!

[Ted S]

Ahh ok. When I looked at your site I didn't see any forums and I assumed it just over took it all.

We don't offer a demo so wherever you looked is someone's particular customizations and settings...

[JesterP]

We don't offer a demo so wherever you looked is someone's particular customizations and settings...

It was giftery.me.... Thanks again

[Ted S]

It was giftery.me.... Thanks again

We make the mod but that site doesn't run vB in any shape or size.... Sorry for the confusion.

[svtsnake01]

Does anyone that has installed this care to share their URL? I may be interested in using this, but I will need to see a demo first.

[marccap]

I notice the reviews are in reverse alphabetical order - I cant see any settings to amend that so any clues how to change it?

[Ted S]

I notice the reviews are in reverse alphabetical order - I cant see any settings to amend that so any clues how to change it?

The ordering is coded into productforums.php

ORDER BY title ASC

ASC is in order (a-z, 1-9)
DESC is reverse (z-a, 9-1)

[CoZmicShReddeR]

Ug I just updated this and it wiped all my style edits... :(

Is there anything in the future to make the style match the theme automatically or a least give the choice??

[Ted S]

Ug I just updated this and it wiped all my style edits... :(

Is there anything in the future to make the style match the theme automatically or a least give the choice??

That stinks.

The templates in this addon work in the same way all vBulletin addon templates work... There is no "skip logical upgrade" option for developers that we checked. No "force override and piss people off" box either. :D

In theory the system tracks changed done [I]through the template editor and prompts a revision when needed but in practice that tool is far from perfect. It certainly should never change a template that is not updated in our core and few have been in the last year.

[Action-N]

Not sure what Cozmic meant, but I've been working on setting this mod up myself an have an issue I think he meant. This mod has it's own css stylesheet for the productforum.php an doesn't use the default forums layout. For example your tables are squared with a black border, an I see even the forum overall width changes. On mine the search box is bunching up at a fixed 1024px forum so they must not be percentage based with nowrap. I broke the add product button some how so turned off user add products , but on the listing page the links still visible, although it does link to a feature disabled error. So if he had to fix those issues an updated an it reset them I can see what he meant. Basically I'll have to rewrite the templates for that page to use the forums default tables an not your custom ones. I see alot of mods doing that an sucks having to fix them all. I guess you can say the mod authors are reinventing the wheel with their layouts.

A couple more quick updates needed is on your own screenshot of the threaded reviews the forum header still has "Replies/ Views" shown, simple edit I'm sure. An the little green subscribe icon is pushed to the bottom of the table. I ended up deleting that stuff from my template, but you should consider fixing that or option to disable them.

I think your mod has great potential, however it was a pia getting it set up and learning to add products. The having to manually add the thumbnail pictures sucks, I have to open my ftp program an look for the images created last to guess which ones to use, was no id to know which images go to what product. Maybe have it use a product id number to atleast.

[Ted S]

Thanks for the comments Action-N... lengthy reply below (sorry).

I guess you can say the mod authors are reinventing the wheel with their layouts.

Pretty much although it's rarely for the sake of doing so versus just being efficient. It's simply easier to build new than try and figure out what vB element would apply, much less explain to people how to customize it without changing the entire forum when the questions come in.

We make mods to bring functionality to sites and try to apply some best practices to go along with it [like being able to edit our mod's style without breaking your entire forum as we've seen others do]. While we keep to vB's squares and tables the layout their anything but modern nor is there a container to handle product type elements so you're dead on, we broke the box.

Certainly we could have made it all stock elements but we made a conscious decision on where to spend our time. If that results in a deal breaker that's great feedback but not likely to change.

I ended up deleting that stuff from my template, but you should consider fixing that or option to disable them.Thanks, we'll take a look for sure. Obviously fixing quirks and making logical decisions to the design is high on goal list but really we want to encourage sites to customize beyond the box especially where it's not possible for us to make a change without a code hack (like the column header for a forum).

It doesn't sound like this applies to you but most forums get sucked in to sticking to how things run by default and then wonder why their conversion rate, retention, revenue, or other KPIs are so bad. The web has too many options, too many great sites to be cookie-cutter.

The having to manually add the thumbnail pictures sucksWe added an image uploader and bulk importer almost a year ago. Both autocreate thumbnails as long as have [to your first point] the template calls to get them.

and learning to add productsNot sure what the problem is here but all for feedback?

[Action-N]

I'm not sure we are talking about the same thing, what I was afraid of. I mean the point of style sheets on a website is so user wants to change his category color he edits one variable an it changes all his pages to new color. What addon authors do is make their own style sheets so if I want to change my category color I do it for vbulletin then sort through my addons an change thier css variables. Just would make sense to me if mod makers shared the default vb's css variables. An for your addon you have your css as a file still (productforums.css)? Since I've already had to edit my vbtube mod I have the code saved, looks simpler to me:


<div class="block pfblock">
<h2 class="blockhead">Heading Text</h2>
<div class="blockbody">
<div class="blockrow pftext">
Block Content
</div>
</div>
</div>


the pfblock and pftext would be your mods personal css variables. I understand your set in not using the stock elements, but it's your personal taste your hardcoding in the style. What I said I broke was the add product button doesn't show up anymore.


Yeah the sticky icon was easier to delete the code than figure out why it was on the bottom of the table. An I figured it being a special review only forum I didn't need the clutter.

Yes about cookie cutter websites, that's why the more variable you give them to turn on or off the better chance for them to be different. I don't want to spend hours customizing templates, checkboxs are much faster.

What I'm referring to is with adding product images I think from the forum I added one image link, then did the sync external images an that is where it makes them but didn't add the new images to the products for me. Haven't tried uploading from my computer yet. If it does yay, but fyi sync didn't.

I spent a few hours this morning trying to learn the addon an get products added an setup correctly. The product title can't handle quotes so it kept cutting my title short. So anyone wanting to review something described with inches has to spell out "inch".

Not trying to bust on your addon, like I said this is nice one to have, just trying to give feedback good and bad. Can I assume you being active on here that you are still working on the mod? Thanks for the effort with this, I wanted to make something an I couldn't even figure out how to start an addon.

One more thing, what's the deal with having to disable template comments? I want to edit the templates in this mod an need them to know what 's what?

[Ted S]

I'm not sure we are talking about the same thing, what I was afraid of. I mean the point of style sheets on a website is so user wants to change his category color he edits one variable an it changes all his pages to new color.

We're talking about the same thing.

Yes about cookie cutter websites, that's why the more variable you give them to turn on or off the better chance for them to be different. I don't want to spend hours customizing templates, checkboxs are much faster.Fair enough although a checkbox is not the customization level I was implying... Ideally I think sites should really reach in beyond the options others determine they should have. Options are always limited by the ideas of their creator and more of them just adds to the load on the server.

Haven't tried uploading from my computer yet. If it does yay, but fyi sync didn't.Sync and upload work in the exact same way through the same process which first resizes a photo and then posts it to the product. If it's not sticking odds are the product didn't get a match and a new one, with the photo, was created.

The product title can't handle quotes so it kept cutting my title short. So anyone wanting to review something described with inches has to spell out "inch".Easy enough. Is it removing quotes or stopping the title entirely when they're entered?

Can I assume you being active on here that you are still working on the mod? Thanks for the effort with this, I wanted to make something an I couldn't even figure out how to start an addon.Of course. Our primary interest right now is monitoring and responding to any problems that may arise, including things like the icon you mentioned.

As for new features it's entirely demand driven. We combine community feedback with our own sense of what will help move the needle to push forward if there is interest for more. This mod has been pretty slow for the past few months so no plans for anything major yet.

One more thing, what's the deal with having to disable template comments? I want to edit the templates in this mod an need them to know what 's what?It's a quirk [or a bug depending on how you see it] in how vBulletin makes posts. When we fake a thread for a review it runs through the default vB post manager which brings in everything in the post template. For some reason this does not filter out comments and they will appear if the feature is not disabled.

Since it's a load constraint most sites we've worked with already have it off except during debugging.

[flash84]

Awesome mod! I just have one little issue, same as the user I quoted below. When you click to read a review it is using showthread.php which takes you to the top of the product thread. Is there anyway you can get it to use showpost.php to take you to the actual review post?

I have the "Create New Thread on Review" option turned off, so the reviews are posts all in one single thread.

Thanks so much if you can help me!

Originally Posted by deverill2010

I noticed when you click through to reviews from productforums.php it doesn't actually take you to the specific review but instead the start of the thread.

Having the reviews pinned to the front would be handy to save users having to trawl through posts in between reviews.

[sadiq6210]

Q: What will happen to the threads if I uninstall it?

+

I try to uninstall the mod but I got this error

Database error in vBulletin 4.1.12:

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

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

_________________________________________

In 4.1.12 there is no activity stream

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

[Ted S]

Awesome mod! I just have one little issue, same as the user I quoted below. When you click to read a review it is using showthread.php which takes you to the top of the product thread. Is there anyway you can get it to use showpost.php to take you to the actual review post?

I have the "Create New Thread on Review" option turned off, so the reviews are posts all in one single thread.

Thanks so much if you can help me!

Does the url loaded show a #xxx bit at the end as if it is trying to load a post?

[Ted S]

Q: What will happen to the threads if I uninstall it?

+

I try to uninstall the mod but I got this error

Database error in vBulletin 4.1.12:

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

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

_________________________________________

In 4.1.12 there is no activity stream

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

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

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

As for threads, they'd be a bit weird. The first post which has no content and is hidden would return and the product data which is stored in tables unique to this mod would be removed. In short you'd either want to add it back to those threads or remove the section.

[sadiq6210]

In short you'd either want to add it back to those threads or remove the section.

I see. Are you planing to update this mod to VB5 (in future**)?
** I am not planing to upgrade to VB5 this year.

I am sorry to ask a lot of questions but I will install it in a busy forum (~1 million posts) so I must think about the future to avoid any data lost after upgrading.

Thanks for support :)

[Ted S]

I see. Are you planing to update this mod to VB5 (in future**)?
** I am not planing to upgrade to VB5 this year.


It really depends on how vB5 goes. Updating mods to the new platform require a serious amount of work beyond what was required from 3 to 4.

[Aramist]

Hi

I'm getting this error when trying to proceed with image sync:

Fatal error: Call to undefined function imagecreatefromjpeg() in /home/myuser/public_html/myboard.com/forum/includes/prodforums_uploader.php on line 36

Any tip?

Ty in advance

[Ted S]

Hi

I'm getting this error when trying to proceed with image sync:

Fatal error: Call to undefined function imagecreatefromjpeg() in /home/myuser/public_html/myboard.com/forum/includes/prodforums_uploader.php on line 36

Any tip?

Ty in advance

Sounds like your server does not have the GD image library installed. It's pretty common so check with your host about getting it added.

[flash84]

Does the url loaded show a #xxx bit at the end as if it is trying to load a post?

There is no #xxx in the URL, only the thread like this:

http://www.mysite.com/showthread.php?t=38020

[Ted S]

There is no #xxx in the URL, only the thread like this:

http://www.mysite.com/showthread.php?t=38020

Thanks.

Are you using the create review thread option by chance?

[BlogTwits]

Is this fine to install on 4.2?

[flash84]

Thanks.

Are you using the create review thread option by chance?


I am using the Write Your Own link in the product description. It has a URL like this:
http://www.mysite.com/productforums.php?do=write_review&productid=2


When I write a new review and click the Post Review button the vbulletin message "Your review on xxxxxxxx has been posted!" is linking me to the correct review post with a URL like this:
http://www.mysite.com/showpost.php?p=345392


But when I go back to Read All Reviews and click on one of the reviews it will just take me to the beginning of the thread showing the product description instead of the actual review post.