View Single Post
  #1  
Old 07-20-2008, 11:23 AM
Khalid-B's Avatar
Khalid-B Khalid-B is offline
 
Join Date: Apr 2007
Location: NL
Posts: 450
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database Error , Help Needed.

Hello i am getting database error , can some please help me to solve this issue?
PHP Code:
Database error in vBulletin 3.6.4Invalid SQLSELECTpost.*, 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 avheightdeletionlog.userid AS del_useriddeletionlog.username AS del_usernamedeletionlog.reason AS del_reason,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  FROM post AS postLEFT 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.useridLEFT JOIN deletionlog AS deletionlog ON(post.postid deletionlog.primaryid AND deletionlog.type 'post')LEFT JOIN editlog AS editlog ON(editlog.postid post.postid)LEFT JOIN postparsed AS postparsed ON(postparsed.postid post.postid AND postparsed.styleid 76 AND postparsed.languageid 1)LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid user.userid AND sigparsed.styleid 76 AND sigparsed.languageid 1)LEFT JOIN sigpic AS sigpic ON(sigpic.userid post.useridWHERE post.postid IN (0,57758,57891,58245)ORDER BY post.datelineMySQL Error Unknown column 'editlog.hashistory' in 'field list'Error Number 1054Date SundayJuly 20th 2008 06:16:33 AMScript http://mysite.com/showthread.php?p=58245Referrer : http://mysite.com/IP Address : 89.107.104.890Username : UserIDClassname : vb_database 

Thank you
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01274 seconds
  • Memory Usage 1,819KB
  • 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_php
  • (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