View Single Post
  #15  
Old 09-07-2011, 11:14 AM
Ramsesx's Avatar
Ramsesx Ramsesx is offline
 
Join Date: Aug 2005
Location: Southern Germany
Posts: 512
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If I click at "be the first to write a review" get following db error:
Quote:
Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT pf.threadid,pf.title,pf.reviews,pf.rating,pf.price ,pf.short_desc,pf.mfrg,pf.upc,pf.sku,thread.forumi d
FROM vb3_pf_product as pf
JOIN vb3_thread ON pf.threadid = thread.threadid
WHERE productid = '1' AND active = 1;

MySQL Error : Unknown column 'thread.forumid' in 'field list'
Error Number : 1054
Also the tools menu is below the product listing and the manufacturer is not visible.
The above error is only if I have in the acp "Create New Thread on Review" set to no.
If it is set to yes I get the message "This feature is not configured yet. Please check back soon." if trying to write a review.
And if I add a forum ID in the acp setting "Review Thread Forum ID" get above db error again.
There are also db errors when clicking at "Manage" in "Manage Product Reviews Forums" (value 0)
Quote:
Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT COUNT(productid) AS count
FROM vb3_pf_product
WHERE pf_product.productid <> 0;

MySQL Error : Unknown column 'pf_product.productid' in 'where clause'
Error Number : 1054
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01321 seconds
  • Memory Usage 1,764KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete