• 24-11-2008, 21:21:44
    #1
    sitemde forumlara giremiyorum girince database error hatası alıyorum

    Database Error


    Database error in vBulletin 3.6.7:

    Invalid SQL:

    SELECT
    IF(votenum >= 1, votenum, 0) AS votenum,
    IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
    post.pagetext AS preview,
    thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
    thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
    hiddencount, deletedcount

    , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

    , threadredirect.expires
    , nuseo_slug
    FROM thread AS thread
    LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')


    LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

    LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)

    WHERE thread.threadid IN (0,1251)
    ORDER BY sticky DESC, lastpost DESC;


    MySQL Error : Table './seyriale_seyrialem/post' is marked as crashed and should be repaired
    Error Number : 145
    Date : Monday, November 24th 2008 @ 08:34:31 PM
    Script : Seyr-i Alem, Ünlü Resimleri, Film İndir, Dizi İndir, Oyun İndir, Msn, Avatar, Dönem Ödevi İndir Database Error
    Referrer :
    IP Address : 78.168.54.55
    Username :ADMIN
    Classname : vB_Database


    diye bi sayfa çıkıyo karşıma lütfen yardım edin .
  • 24-11-2008, 21:30:09
    #2
    post tablosunu repair edin düzelir
  • 26-11-2008, 00:28:31
    #3
    olmadı öyle yapınca.
  • 26-11-2008, 00:35:21
    #4
    eklentileri disable edin
  • 26-11-2008, 03:20:41
    #5
    database in yedeği varsa direk yedeğini yükleyin.
  • 27-11-2008, 13:55:59
    #6
    çok öncenin yedeği var sitenin chmod ayarlarıyla oynadım sorun ondan olabilirmi
  • 16-01-2009, 00:18:50
    #7
    olabilir ama bu sorun post tablosundan kaynaklanıyor .. post ablosuna bak kullanımda yazar düzeltmesi zor yapman gereken yedeği atmak