• 15-04-2008, 15:17:16
    #1
    Dun vbadvenced kurdum burdakı anlatıma göre


    Kurulum tamamlanmadan SQL hatası cıktı ardından da sıteye baglanamıyorum sureklı sql hatası verıyor vbadvanced kaldırayım dedım kaldırma bıtmeden hata verıyor ındextekı hata asagıda nasıl halledebılırım acba


    Alıntı
    Database error in vBulletin 3.6.9:

    Invalid SQL:

    ## GET LATEST THREADS ##
    SELECT thread.*,thread.iconid AS threadiconid , post.pagetext AS preview
    FROM thread AS thread
    LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
    LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
    WHERE open <> 10
    AND forumid NOT IN (0)
    AND thread.visible = '1'
    AND deletionlog.primaryid IS NULL
    ORDER BY lastpost
    DESC LIMIT 10;

    MySQL Error : Table 'thread' is marked as crashed and last (automatic?) repair failed
    Error Number : 1195
    Date : Tuesday, April 15th 2008 @ 03:14:06 PM
    Script :
    Referrer :

    Classname : vB_Database
  • 15-04-2008, 15:24:46
    #2
    sunucuoptimizasyon.com
    tablo repair denedinmi thread tablosunda bir çakışma var
  • 15-04-2008, 15:32:51
    #3
    SSH den denedım 2-3 kere ama duzelmedı
  • 15-04-2008, 15:36:24
    #4
    [root@client-215-112 xxxxx_yyyyy]# myisamchk -r thread.MYI
    - recovering (with sort) MyISAM-table 'thread.MYI'
    Data records: 410162
    myisamchk: error: Can't create new tempfile: 'thread.TMD'
    MyISAM-table 'thread.MYI' is not fixed because of errors
    Try fixing it by using the --safe-recover (-o), the --force (-f) option or by no t using the --quick (-q) flag
  • 15-04-2008, 15:40:46
    #5
    Üyeliği durduruldu
    ekle görüşelim

    mustafacan46@hotmail.com