vb.org Archive
Page 132 of 186 « First 3282122130131 132 133134142182 Last »
Show 40 post(s) from this thread on one page

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 09-02-2012 09:15 PM
Quote:
Originally Posted by deverill2010 (Post 2362089)
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 09-03-2012 04:16 PM
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 09-04-2012 05:02 AM
Quote:
Originally Posted by ashimashi (Post 2362277)
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 09-04-2012 05:14 AM
Quote:
Originally Posted by Ted S (Post 2361649)
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 09-04-2012 06:25 AM
Quote:
Originally Posted by 1320Nation (Post 2362461)
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:

Code:

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 09-04-2012 12:51 PM
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 09-04-2012 01:43 PM
its really a buggy mod zzz

Ted S 09-04-2012 09:19 PM
Quote:
Originally Posted by Andrei29 (Post 2362554)
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 09-04-2012 09:21 PM
Quote:
Originally Posted by Andrei29 (Post 2362568)
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 09-06-2012 07:13 PM
Quote:
Originally Posted by Andrei29 (Post 2362568)
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.


All times are GMT. The time now is 05:23 AM.
Page 132 of 186 « First 3282122130131 132 133134142182 Last »
Show 40 post(s) from this thread on one page

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.04682 seconds
  • Memory Usage 1,756KB
  • 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
  • (1)bbcode_code_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)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