vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - Product Review Forums ? Research, Review & Compare Items (https://vborg.vbsupport.ru/showthread.php?t=269808)

Ted S 04-13-2015 01:06 AM

Quote:

Originally Posted by tomshawk (Post 2542319)
I'm curious, in the 3rd pic on the OP. The list of products?

How easy would it be to modify this.

I'd like to see
my books image
the name
the rating
the price,
and a link to the description page
but in 3 or 4 columns across

I think it would take up less space and make room for more products on a page.

It's all displayed via a template so, assuming you don't want to add any fields, editing is as quick as you can change the html and corresponding css.

tomshawk 04-13-2015 01:57 AM

Thank you but as a novice changing html and CSS is not my fortay

Could you assist with this?

Also,

I have a few more questions as well if you do not mind

What if I want to add fields for the reviews in pic 1 and 2, for example, a field in my books for reading level, or amount of pages in a book.

Also, is there a way to add more images to the product profile like you see on ebay for example?

Thank you in advance for the outstanding addon BTW

tomshawk 04-15-2015 05:11 AM

Quote:

Originally Posted by Ted S (Post 2493848)
Are you comfortable editing php? If so, try removing the ,1 from line 416 of the script.

If not, tell me about your server... is it using Apache? Shared or dedicated host? Does the review still post?

I installed this onto a friends site and I get this same error.
I removed the ,1 and the error remains.
The star rating does not register, and the review counter does not show up as there being one.

The review truncates into a large wall of text.
I see the review there in the review forum as well as in the AdminCP, if I go to delete it in the admincp I get this error

Warning: mysqli_query() [function.mysqli-query]: (22003/1690): BIGINT UNSIGNED value is out of range in '(`tomwayne_vb422`.`vb422pf_product`.`reviews` - 1)' in ..../includes/class_core.php on line 1393

This is a vbulletin 4.2.2 PL4 fresh install

Any help would be great, thank you

tomshawk 04-16-2015 06:22 PM

Anybody have an idea?

This mod works perfectly on vb 4.0.0 but gives the error above in 4.2.2 PL4

Sorry if I seem impatient but I told my friend about how good it is and well.

Thanks in advance

Ted S 04-16-2015 11:13 PM

Quote:

Originally Posted by tomshawk (Post 2542953)
Thank you but as a novice changing html and CSS is not my fortay

There's a forum here for coding support discussions that may be a good place to try.

Quote:

What if I want to add fields for the reviews in pic 1 and 2, for example, a field in my books for reading level, or amount of pages in a book.
The addon supports custom fields but it's pretty basic. You can't change them by category for example but they will allow this sort if info. They're in the admin settings.

Quote:

Also, is there a way to add more images to the product profile like you see on ebay for example?
You can use bbcode or basic html to embed them if they're already posted somewhere (which works depends on your forum settings).

Ted S 04-16-2015 11:16 PM

Quote:

Originally Posted by tomshawk (Post 2543081)
I installed this onto a friends site and I get this same error.
I removed the ,1 and the error remains.
The star rating does not register, and the review counter does not show up as there being one.

The review truncates into a large wall of text.
I see the review there in the review forum as well as in the AdminCP, if I go to delete it in the admincp I get this error

Warning: mysqli_query() [function.mysqli-query]: (22003/1690): BIGINT UNSIGNED value is out of range in '(`tomwayne_vb422`.`vb422pf_product`.`reviews` - 1)' in ..../includes/class_core.php on line 1393

This is a vbulletin 4.2.2 PL4 fresh install

Any help would be great, thank you

The problem is that the value being posted is negative. Sounds like the counter didn't go up properly and needs to be reset to 1 if the content is still there to delete or 0 if it's been cleared.

You'll have to excuse me but I don't recall the exact details anymore and didn't see what you quoted from in the last few pages of the thread?

tomshawk 04-16-2015 11:29 PM

Thank you Ted, I was able to figure out the custom fields option while playing on my site. I have not customized my friends yet but I know where to start.

I will ask about the HTML changes on the other forum.

The error I am reffereing to is

Writing a review causes
Warning: Only variables should be assigned by reference in ..../productforums.php (line 416)

You suggested this

Are you comfortable editing php? If so, try removing the ,1 from line 416 of the script.

The server is running apache

The star rating does not register, and the review counter does not show up as there being one.

The review truncates into a large wall of text.
I see the review there in the review forum as well as in the AdminCP, if I go to delete it I get this error

Removing the ,1 from that line did not fix the problem.

I am also getting this

Warning: mysqli_query() [function.mysqli-query]: (22003/1690): BIGINT UNSIGNED value is out of range in '(`tomwayne_vb422`.`vb422pf_product`.`reviews` - 1)' in ..../includes/class_core.php on line 1393

when trying to delete the review.

This is vbulletin 4.2.2 PL4 where mine is 4.0.0thank you again for your support on this awesome addon, it is greatly appreciated

tomshawk 04-22-2015 07:17 PM

OK, this problem seems to be related to the socialpages problem with vbulletin 4.2.2
I found it as I noticed I got another error when just trying to use advanced search function in VB on this new site, as soon as I patched that error, this one went away.

So, now the only problem I have now is the truncating of the review into a long wall of text instead of paragraphs and lines as it should be.

Not to drive you up the wall but, as part of my customization, I want to remove the start rating system

I have removed it for all the pages via templates except the review creation screen.
If I remove it from there, I cant not create a review as I did not add a rating.

How do I remove it as a requirement?

Thank you

Ted S 04-23-2015 10:59 PM

Quote:

Originally Posted by tomshawk (Post 2543897)
So, now the only problem I have now is the truncating of the review into a long wall of text instead of paragraphs and lines as it should be.

Do you allow HTML or BBCode on the forum reviews post to? Can you try toggling both on / off to see if it helps?

Quote:

How do I remove it as a requirement?
Remove it from the template and add a hidden form field with a value of 1 in its place. This way it gets past along for the script to check and the database to insert though you won't show it back anywhere.

tomshawk 04-24-2015 01:35 AM

Quote:

Originally Posted by Ted S (Post 2544020)
Do you allow HTML or BBCode on the forum reviews post to? Can you try toggling both on / off to see if it helps?

Remove it from the template and add a hidden form field with a value of 1 in its place. This way it gets past along for the script to check and the database to insert though you won't show it back anywhere.

Forgive my ignorance, again

This hidden form field

Is this done in the Custom form field?
If it is, I do not see a hidden option
and I assume the title does not matter.

What will this do to the Thread creating title.
right now, it says 5 out of 5 rating for (Product title)

I'd rather it just say Rev: (Product Title)


All times are GMT. The time now is 04:48 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02273 seconds
  • Memory Usage 1,758KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete