مشكله قواعد البيانات Database error in vBulletin 3.6.8
بسم الله الرحمن الرحيم
السلام عليكم ورحمة الله وبركاته
في البدايه عندي مشكله وبحثت في سوالف وبحثت في ترايدنت
ومحد قدر يحلها حقي او بمعنى اصح ماعطوني وجه
وفي ناس انصحوني بالموده وقالوا في خبراء اهم اللي راح يفيدونك
مشكلتي كالاتي لما اسوي اصلاح للقواعد جدول التيمب في السيرفر يوقف يصير 100%
temp 100%
بعدين صارت عندي مشكله بجدول البوست post
والحين لما ادش على اي قسم يطلع الخطأ التالي
Database error in vBulletin 3.6.8:
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
, threadread.readtime AS threadread
, threadredirect.expires
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 2)
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,114832,104835,113664,1 13935,97055,114564,114701 ,114771,114801,114774,114 013,109011,80377,104816,9 5707,102221,102219,113136 ,95696,101469,113628,1133 89,110853,114259,104680,1 14142,113556,100559,11310 2,100970,109159,104245,11 3609,114074,114186,101185 ,114203,113784,113773,113 977,80766,111914,80637,99 228,109039,113177)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Table 'post' is marked as crashed and last (automatic?) repair failed
Error Number : 1195
Date : Sunday, October 28th 2007 @ 06:21:36 PM
Script : http://75.126.226.212/~q8upcom/vb/fo...play.php?f=104
Referrer : http://75.126.226.212/~q8upcom/vb/
او ادش على اي موضوع يطلع الخطأ التالي
Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT MIN(postid) AS postid
FROM post
WHERE threadid = 114832
AND visible = 1
AND dateline > 1192720955
LIMIT 1;
MySQL Error : Table 'post' is marked as crashed and last (automatic?) repair failed
Error Number : 1195
Date : Sunday, October 28th 2007 @ 06:22:35 PM
Script : http://75.126.226.212/~q8upcom/vb/sh...wpost&t=114832
Referrer : http://75.126.226.212/~q8upcom/vb/
فمادري شنو المشكله وشنو الحل الحين؟؟
رد مع اقتباس
مواقع النشر (المفضلة)