database hatası bu hostıng'denmıdır ?

**axicocuk35** · #1 31-07-2009, 02:33:47

asagıdakı hatayı alıyorum ana sayfada sorun yok diğer hiç bir yere giremıyorum konu ıclerıne vs vs vs hosttanmıdır bu ?

Alıntı:

Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT post.pagetext AS preview,
thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid, thread.dateline, thread.forumid,
thread.sticky, thread.prefixid, thread.taglist, thread.pollid, thread.open, thread.lastpost AS postdateline, thread.visible,
thread.hiddencount, thread.deletedcount, thread.attach, thread.postusername, thread.forumid,
thread.replycount, IF(thread.views<=thread.replycount, replycount+1, thread.views) AS views,
thread.lastpost, thread.lastposter, thread.lastpostid
,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
user.userid AS postuserid
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
FROM thread AS thread
LEFT JOIN user AS user ON(user.userid = thread.postuserid)
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread
ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid IN
(29764, 29763, 29762, 29761, 29760, 29759, 29758, 29757, 29756, 29755, 29754, 29753, 29752, 29751, 29750, 29749, 29748, 29747, 4632, 29746, 29745, 29744, 29743, 29537, 29742);
MySQL Error : Table './setr_db/post' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Request Date : Friday, July 31st 2009 @ 02:29:54 AM
Error Date : Friday, July 31st 2009 @ 02:29:55 AM
Script : http://www.site.com/search.php?searchid=46899
Referrer : http://www.site.com/
IP Address : 78.175.77.126
Username : abcde
Classname : vB_Database
MySQL Version : 5.0.81-community

SqReaL · #2 31-07-2009, 02:36:37

Caps koyarmısınız ?

**axicocuk35** · #3 31-07-2009, 02:39:50

Alıntı:

SqReaL Nickli Üyeden Alıntı

Caps koyarmısınız ?

hocam verdiği hatayı ekledım ya capstada aynısını göreceksın hatta göremeyeceksın iframe içinde cunkı

SqReaL · #4 31-07-2009, 02:44:29

Sorun hosting sağlayıcınızdan kaynaklanıyor olabilir. Çünkü sql kodlarına durduk yerde birşey olması olanaksız.

**axicocuk35** · #5 31-07-2009, 12:49:55

yokmu bu işi çözecek :S

**Postakusu** · #6 31-07-2009, 12:57:29

admincp - bakım - tabloları onar optimize et - hepsini seçip sayaçlarını güncellermisin?

Akbas · #7 31-07-2009, 12:59:24

Tabloları onarın.

**axicocuk35** · #8 31-07-2009, 13:05:30

adminpanelde bi işlem yapamıyorum bakıma tıkladıgımda acılmıyor bıle, admincp de bile database hatası verıyor
asagıdakıde admincpdeki hata

Alıntı:

Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT COUNT(*) AS count
FROM attachment AS attachment
INNER JOIN post AS post USING (postid)
WHERE attachment.visible = 0;
MySQL Error : Table './setr_db/post' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Request Date : Friday, July 31st 2009 @ 01:02:28 PM
Error Date : Friday, July 31st 2009 @ 01:02:28 PM
Script : http://www.site.com/admin/index.php?do=home
Referrer : http://www.site.com/admin/index.php
IP Address : 88.242.127.49
Username : admin
Classname : vB_Database
MySQL Version : 5.0.81-community

~~kaptanblack_12~~ · #9 31-07-2009, 15:19:04

Phpmyadmin'e girip sadece post tablosunu seçin ve onar'a tıklayın.