Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-02-2012, 06:31 PM
Sir Chase Sir Chase is offline
 
Join Date: Mar 2012
Posts: 5
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default kbank - Database error

Well I recently installed kbank and now I have a "Database error". Error code is

Code:
<!--
Database error in vBulletin 3.8.7:

Invalid SQL:

		SELECT 
			userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
			IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid,
			language.phrasegroup_global AS phrasegroup_global,
			language.phrasegroup_adv_portal AS phrasegroup_adv_portal,
			language.phrasegroup_calendar AS phrasegroup_calendar,
			language.phrasegroup_postbit AS phrasegroup_postbit,
			language.phrasegroup_prefix AS phrasegroup_prefix,
			language.options AS lang_options,
			language.languagecode AS lang_code,
			language.charset AS lang_charset,
			language.locale AS lang_locale,
			language.imagesoverride AS lang_imagesoverride,
			language.dateoverride AS lang_dateoverride,
			language.timeoverride AS lang_timeoverride,
			language.registereddateoverride AS lang_registereddateoverride,
			language.calformat1override AS lang_calformat1override,
			language.calformat2override AS lang_calformat2override,
			language.logdateoverride AS lang_logdateoverride,
			language.decimalsep AS lang_decimalsep,
			language.thousandsep AS lang_thousandsep
			
		,kbank_granted.allow_count AS kbank_granted_count
		,kbank_granted.allow_userid AS kbank_granted_userid
		,kbank_granted.allow_username AS kbank_granted_username
		,kbank_granted.allow_usergroupid AS kbank_granted_usergroupid
		,kbank_granted.allow_membergroupids AS kbank_granted_membergroupids
		,kbank_granted.allow_money AS kbank_granted_money
	
		FROM user AS user
		LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
		LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
		
		LEFT JOIN (
			SELECT
				kbank_granted.userid AS userid
				,COUNT(*) AS allow_count
				,GROUP_CONCAT(user.userid SEPARATOR '|') AS allow_userid
				,GROUP_CONCAT(user.username SEPARATOR '|') AS allow_username
				,GROUP_CONCAT(user.usergroupid SEPARATOR '|') AS allow_usergroupid
				,GROUP_CONCAT(user.membergroupids SEPARATOR '|') AS allow_membergroupids
				,GROUP_CONCAT(user.money SEPARATOR '|') AS allow_money
			FROM `kbank_granted_permission` AS kbank_granted
			INNER JOIN `user` AS user ON (user.userid = kbank_granted.allowid)
			WHERE kbank_granted.userid = 5
			GROUP BY kbank_granted.userid
		) AS kbank_granted ON (kbank_granted.userid = user.userid)
	
		WHERE user.userid = 5;

MySQL Error   : Table '--_forum.kbank_granted_permission' doesn't exist
Error Number  : 1146
Request Date  : Thursday, August 2nd 2012 @ 02:27:46 PM
Error Date    : Thursday, August 2nd 2012 @ 02:27:46 PM
Script        : http://runeadventure.com/index.php
Referrer      : 
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 
-->
Any idea on how to fix this would be great.
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:24 PM.


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.03809 seconds
  • Memory Usage 2,263KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadedmode.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete