• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Duyuru

Gizle
No announcement yet.

Database Hatası

Gizle
X
 
  • Filtrele
  • Zaman
  • Göster
Hepsini Sil
new posts

  • Database Hatası

    Sitede kendiliğinden artık konulara girmedi. Db error verdi. Konu tablosunda sorun var sanıyorum. hata aşağıda

    Kod:
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html>
    <head>
    	<title>xxxxxxxxxxxxxxxxx Database Error</title>
    	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
    	<style type="text/css">
    	<!--
    	blockquote { margin-top: 75px; }
    	p { font: 11px tahoma, verdana, arial, sans-serif; }
    	-->
    	</style>
    </head>
    <body>
    	<blockquote>
    		<blockquote>
    			<p><strong>There seems to have been a problem with the xxxxxxxxxxxxxxxx database.</strong><br />
    				Please try again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</p>
    			<p>An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, whom you can also contact if the problem persists.</p>
    			<p>We apologise for any inconvenience.</p>
    
    			<form><textarea rows="15" cols="70" wrap="off">Database error in vBulletin 3.5.4:
    
    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,
    			avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
    			level,
    			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,
    			post_parsed.pagetext_html, post_parsed.hasimages,
    			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
    			
    			
    		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.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
    			LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
    		LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
    		LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid AND post_parsed.styleid_code = -1 AND post_parsed.styleid_html = -1 AND post_parsed.styleid_php = -1 AND post_parsed.styleid_quote = -1)
    			
    		WHERE post.postid IN (0,11741)
    		ORDER BY post.dateline;
    
    MySQL Error  : Table 'sanalkab_forum.post_parsed' doesn't exist
    Error Number : 1146
    Date         : Tuesday, July 4th 2006 @ 02:55:47 PM
    Script       : http://www.xxxxxxx.com/showthread.php?p=11741#post11741
    Referrer     : http://www.xxxxxxx.com/index.php?
    IP Address   : xxxxxxxxxxx
    Username     : admin
    Classname    : vb_database</textarea></form>
    
    		</blockquote>
    	</blockquote>
    </body>
    </html>
  • #2

    post_parsed isimli tablo yok görünüyor başına bir haller gelmiş.

    alttaki kodları SQL sorgusu olarak çalıştırmayı dene.. ama index bilgileri olmadığı için %100 garanti veremem..

    DROP TABLE IF EXISTS `post_parsed`;
    CREATE TABLE IF NOT EXISTS `post_parsed` (
    `postid` int(10) unsigned NOT NULL default '0',
    `dateline` int(10) unsigned NOT NULL default '0',
    `styleid_code` int(11) NOT NULL default '-1',
    `styleid_html` int(11) NOT NULL default '-1',
    `styleid_php` int(11) NOT NULL default '-1',
    `styleid_quote` int(11) NOT NULL default '-1',
    `hasimages` smallint(6) NOT NULL default '0',
    `pagetext_html` mediumtext NOT NULL,
    PRIMARY KEY (`postid`,`styleid_code`,`styleid_html`,`styleid_p hp`,`styleid_quote`),
    KEY `dateline` (`dateline`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    Yorum yap

    • #3

      phpmyadmine baktım postparsed var ama alt çizgisiz

      Yorum yap

      • #4

        ozaman tablonun içine girerek (structure) bilgi varmı yokmu kontrol et.

        Yorum yap

        • #5

          içinde bilgiler var. 70 sayfa filan

          Yorum yap

          • #6

            tablonun varolduğu halde yokmuş gibisinden hata vermesi ilginç. tüm tabloları işaretleyip onar & optimize etmeyi dene. bunu yapmadan önce forumu kapat ve 10 dakika bekle işlemi ondan sonra yap.

            Yorum yap

            • #7

              bir de veritabanında konuları görüyorum. bazı konular geçersiz link diyor. ama veritabanında var. yanii

              Yorum yap

              Hazırlanıyor...
              X