• 20-11-2007, 11:30:43
    #1
    ArkadaşLar Ana Sayfada Bi Sorunum Yok Ama Herhangi Bi Konuya TıkLadığımda Direk Database Hatası aLıyorum iLgiLenebiLcek Bi arkadaş Var mı Sorunun Ne oLduğunu Çözmekte Yardım EdebiLecek Varsa Sevinirim..

    Database error in vBulletin 3.6.8:
    
    Invalid SQL:
    
    		SELECT
    			post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
    			user.*, userfield.*, usertextfield.*,
    			icon.title as icontitle, icon.iconpath,
    			
    			deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
    			editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
    			editlog.reason AS edit_reason,
    			postparsed.pagetext_html, postparsed.hasimages,
    			sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
    			sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
    			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
    			
    			
    		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 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 = 1 AND postparsed.languageid = 3)
    		LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 1 AND sigparsed.languageid = 3)
    		LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
    			
    		WHERE post.postid IN (0,171602)
    		ORDER BY post.dateline;
    
    MySQL Error  : Can't find file: 'sigparsed' (errno: 2)
    Error Number : 1017
    Date         : Tuesday, November 20th 2007 @ 03:22:11 AM
    Script       : http://www.tikkyforum.org/showthread.php?t=65557
    Referrer     : http://www.tikkyforum.org/
    IP Address   : 88.246.102.233
    Username     : ChaCa
    Classname    : vb_database
  • 20-11-2007, 16:45:34
    #2
    sigparsed tablonuz eksik..

    PhpMyAdmin'den veya admin panelinizden aşağıdaki sorguyu işletin.

    CREATE TABLE `sigparsed` (
      `userid` int(10) unsigned NOT NULL default '0',
      `styleid` smallint(5) unsigned NOT NULL default '0',
      `languageid` smallint(5) unsigned NOT NULL default '0',
      `signatureparsed` mediumtext,
      `hasimages` smallint(5) unsigned NOT NULL default '0',
      PRIMARY KEY  (`userid`,`styleid`,`languageid`)
    );
  • 21-11-2007, 23:28:28
    #3
    Üyeliği durduruldu
    bendede forum tablosu eksik bu tip bir hata alıyorum nasıl çözerim?
  • 22-11-2007, 04:17:50
    #4
    tam hatayı alalım Serenity
  • 13-04-2009, 19:59:32
    #5
    Arkadaşlar bendede bu şekilde hata veriyor ne yapmam alzım ayda hangi sorguyu çalıştırmam gerekiyor ?

    Database error in vBulletin 3.8.2:
    Invalid SQL:
    REPLACE INTO postparsed(postid, dateline, hasimages, pagetext_html , styleid, languageid) VALUES
    (12513,