Thread: New Posting Features - [DBTech] Advanced User Tagging v3 (vB3)
View Single Post
  #594  
Old 08-28-2014, 06:18 PM
Mrcorn Mrcorn is offline
 
Join Date: Sep 2006
Posts: 36
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

any ideas what would cause this error?

Code:
Database error in vBulletin 3.8.2:

Invalid SQL:

			SELECT IF(visible = 2, 1, 0) AS isdeleted,
			

			NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid,threadread.readtime AS threadread, forumread.readtime AS forumread,
			thread.*
			
			, post.pagetext AS description 
			FROM thread AS thread
			
			LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1  AND subscribethread.canview = 1)
			
			
				LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
				LEFT JOIN forumread AS forumread ON (forumread.forumid = thread.forumid AND forumread.userid = 1)
			
			
			 LEFT JOIN post AS post ON(post.postid = thread.firstpostid) 
			WHERE thread.threadid = 54;

MySQL Error   : Column 'visible' in field list is ambiguous
Error Number  : 1052
Request Date  : Thursday, August 28th 2014 @ 07:13:34 PM
Error Date    : Thursday, August 28th 2014 @ 07:13:34 PM
Script        : http://www.********.com/forum/showthread.php?goto=newpost&t=54
Referrer      : http://www.********.com/forum/index.php
IP Address    : ******
Username      : harry
Classname     : vB_Database
MySQL Version : 5.5.37-cll
tried disabling all plugins but mentions, tried a fresh install of vbulletin and uninstalled and reinstalled countless times

I've got an idea it's something to do with my php or mysql version? Just wanted to see if anyone has any suggestions before I give up all hope, cheers :up:
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01347 seconds
  • Memory Usage 1,766KB
  • 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