Thread: New Posting Features - [DBTech] Advanced User Tagging v3 (vB4)
View Single Post
  #1173  
Old 06-22-2016, 12:43 PM
logic@ logic@ is offline
 
Join Date: Mar 2009
Posts: 2
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hello. MYSQL error when attempting to view people's profiles. Help me please.

Code:
Database error in vBulletin 4.2.3:

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 prxdbtech_usertag_mention AS mention
				LEFT JOIN prxpost AS post ON (post.postid = mention.postid)
				LEFT JOIN prxthread AS thread ON (thread.threadid = post.threadid)
				LEFT JOIN prxuser AS user ON (user.userid = mention.userid)
				LEFT JOIN prxuser 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
			 ) UNION ALL ( 
					SELECT 
						blog_text.pagetext AS message,
						blog_text.title AS posttitle,
						IF(blog_text.state = 'visible', 1, 0) AS postvisible,
						blog.title AS threadtitle,
						IF(blog.state = 'visible', 1, 0) AS visible,
						0 AS 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 prxdbtech_usertag_mention AS mention
					LEFT JOIN prxblog_text AS blog_text ON (blog_text.blogtextid = mention.postid)
					LEFT JOIN prxblog AS blog ON (blog.blogid = blog_text.blogid)
					LEFT JOIN prxuser AS user ON (user.userid = mention.userid)
					LEFT JOIN prxuser AS mentioned ON (mentioned.userid = mention.mentionedid)
					WHERE (mention.mentionedid = 1 OR mention.userid = 1)
						AND mention.type = 'blog'
					ORDER BY dateline DESC
					LIMIT 0, 20
				
				)
				ORDER BY dateline DESC;

MySQL Error   : Illegal mix of collations for operation 'UNION'
Error Number  : 1271
Request Date  : Wednesday, June 22nd 2016 @ 02:41:37 PM
Error Date    : Wednesday, June 22nd 2016 @ 02:41:37 PM
Classname     : vB_Database
MySQL Version : 5.5.50-cll
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01114 seconds
  • Memory Usage 1,772KB
  • 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_code
  • (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