Thread: New Posting Features - [DBTech] Advanced User Tagging v3 (vB3)
View Single Post
  #628  
Old 12-14-2014, 08:16 PM
JoshHiscocks JoshHiscocks is offline
 
Join Date: Jul 2014
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Anybody have a fix to the following error?:

Quote:
Database error in vBulletin 3.8.7:

Invalid SQL:

(

SELECT
post.pagetext AS message,
post.title AS posttitle,
post.visible AS postvisible,
thread.title AS threadtitle,
thread.visible,
thread.forumid,
mention.dateline,
mention.postid,
mention.type,
user.userid,
user.username,
user.usergroupid,
user.infractiongroupid,
user.displaygroupid,
mentioned.userid AS mentioneduserid,
mentioned.username AS mentionedusername,
mentioned.usergroupid AS mentionedusergroupid,
mentioned.infractiongroupid AS mentionedinfractiongroupid,
mentioned.displaygroupid AS mentioneddisplaygroupid

FROM dbtech_usertag_mention AS mention
LEFT JOIN post AS post ON (post.postid = mention.postid)
LEFT JOIN thread AS thread ON (thread.threadid = post.threadid)
LEFT JOIN user AS user ON (user.userid = mention.userid)
LEFT JOIN user AS mentioned ON (mentioned.userid = mention.mentionedid)
WHERE (mention.mentionedid = 1 OR mention.userid = 1)
AND mention.type = 'post'
ORDER BY dateline DESC
LIMIT 0, 20

)
ORDER BY dateline DESC;

MySQL Error : Can't find record in 'post'
Error Number : 1032
Request Date : Sunday, December 14th 2014 @ 10:10:47 PM
Error Date : Sunday, December 14th 2014 @ 10:10:48 PM
Script : http://***/member.php?u=1
Referrer :
IP Address : ***
Username : Simon
Classname : vB_Database
MySQL Version : 5.5.40-cll
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01069 seconds
  • Memory Usage 1,767KB
  • 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
  • (1)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