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 04-22-2010, 04:08 PM
ITDarasgah's Avatar
ITDarasgah ITDarasgah is offline
 
Join Date: Mar 2009
Location: Pakistan
Posts: 144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database Critical Error

My Forum is down since last 2 days, with this database error niter plug-in or upgrading, every thing is normal since last 1 month I disable All modification in Config.php with efine('DISABLE_HOOKS', true); But Same kindly advice further

PHP Code:
Database error in vBulletin 3.8.5:

Invalid SQL:

        
SELECT post.postidpost.pagetextIFNULLuser.username post.username ) AS usernamedateline
        FROM post 
AS post
        LEFT JOIN user 
AS user ON (user.userid post.userid)
        
WHERE threadid 8868
            
AND visible 1
            
        ORDER BY dateline ASC
        LIMIT 0
,250;

MySQL Error   Unknown column 'user.username' in 'field list'
Error Number  1054
Request Date  
TuesdayApril 20th 2010 11:28:58 PM
Error Date    
TuesdayApril 20th 2010 11:28:58 PM
Script        
http://www.itdarasgah.com/archive/index.php/t-8868.html
Referrer      
IP Address    66.249.65.66
Username      

Classname     vB_Database
MySQL Version 

and this
PHP Code:
Database error in vBulletin 3.8.5:

Invalid SQL:

        
SELECT
            post
.*, post.username AS postusernamepost.ipaddress AS ip, IF(post.visible 210) AS isdeleted,
            
user.*, userfield.*, usertextfield.*,
            
icon.title as icontitleicon.iconpath,
            
avatar.avatarpathNOT ISNULL(customavatar.userid) AS hascustomavatarcustomavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
            
            
            
editlog.userid AS edit_userideditlog.username AS edit_usernameeditlog.dateline AS edit_dateline,
            
editlog.reason AS edit_reasoneditlog.hashistory,
            
postparsed.pagetext_htmlpostparsed.hasimages,
            
sigparsed.signatureparsedsigparsed.hasimages AS sighasimages,
            
sigpic.userid AS sigpicsigpic.dateline AS sigpicdatelinesigpic.width AS sigpicwidthsigpic.height AS sigpicheight,
            IF(
displaygroupid=0user.usergroupiddisplaygroupid) AS displaygroupidinfractiongroupid
            
'' AS field5
            
        FROM post 
AS post
        LEFT JOIN user 
AS user ON(user.userid post.userid)
        
LEFT JOIN userfield AS userfield ON(userfield.userid user.userid)
        
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid user.userid)
        
LEFT JOIN icon AS icon ON(icon.iconid post.iconid)
        
LEFT JOIN avatar AS avatar ON(avatar.avatarid user.avataridLEFT JOIN customavatar AS customavatar ON(customavatar.userid user.userid)
        
            
        
LEFT JOIN editlog AS editlog ON(editlog.postid post.postid)
        
LEFT JOIN postparsed AS postparsed ON(postparsed.postid post.postid AND postparsed.styleid AND postparsed.languageid 1)
        
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid user.userid AND sigparsed.styleid AND sigparsed.languageid 1)
        
LEFT JOIN sigpic AS sigpic ON(sigpic.userid post.userid)
            
        
WHERE post.postid IN (0,388835,389101,389219,396352)
        
ORDER BY post.dateline;

MySQL Error   Unknown column 'displaygroupid' in 'field list'
Error Number  1054
Request Date  
TuesdayApril 20th 2010 11:28:51 PM
Error Date    
TuesdayApril 20th 2010 11:28:51 PM
Script        
http://www.itdarasgah.com/showthread.php?t=33029
Referrer      
IP Address    204.236.235.245
Username      
Unregistered
Classname     
vB_Database
MySQL Version 

--------------- Added [DATE]1272005139[/DATE] at [TIME]1272005139[/TIME] ---------------

any info about this ?
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 06:05 AM.


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.04813 seconds
  • Memory Usage 2,614KB
  • Queries Executed 13 (?)
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
  • (3)bbcode_php
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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_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