R10.net

R10.net (https://www.r10.net/index.php)
-   vBulletin (https://www.r10.net/vbulletin/)
-   -   database hatası bu hostıng'denmıdır ? (https://www.r10.net/vbulletin/423428-database-hatasi-bu-hostingdenmidir.html)

axicocuk35 31-07-2009 02:33:47

database hatası bu hostıng'denmıdır ?
 
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 31-07-2009 02:36:37

Caps koyarmısınız ?

axicocuk35 31-07-2009 02:39:50

Alıntı:

SqReaL Nickli Üyeden Alıntı (Mesaj 1059134729)
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 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 31-07-2009 12:49:55

yokmu bu işi çözecek :S

Postakusu 31-07-2009 12:57:29

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

Akbas 31-07-2009 12:59:24

Tabloları onarın.

axicocuk35 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 :confused:
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 31-07-2009 15:19:04

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


Tüm Zamanlar GMT +3 Olarak Ayarlanmış. Şuanki Zaman: 16:04:48.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.