اخوانى الكرام ..

اخوانى الكرام .. عندى المنتدى معطل له يومين .. اتمنى ان اجد الحل عندكم كالعاده وعاده هذه المنتدى المتميز ..

عندى المنتدى يتصفح بشكل طبيعي نسخه ابو منار 203 .. ولكن عند فتح اي موضوع تظهر هذه الرساله ..


There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


Database error in vBulletin: Invalid SQL:
SELECT
session.userid AS sessionuserid,
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
LEFT JOIN session ON (session.userid = user.userid
AND session.userid > 0

AND session.lastactivity>1081372492)
WHERE post.postid IN (0,634388)
ORDER BY dateline

mysql error: Can't create/write to file '/tmp/#sql_2b28_0.MYI' (Errcode: 13)
mysql error number: 1
Date: Thursday 08th of April 2004 12:29:30 AM
Script: /vb/showthread.php?s=&threadid=76380
Referer: http://alquma.net/vb/forumdisplay.php?s=&forumid=2

طبعا الرساله تشير الى خطأ في قاعده البيانات ..

قاعده البيانات طبيعيه جدا .. ولكن لفت انتباهى جدول session ..

Table Action Records Type Size Overhead
access 25 MyISAM 2.2 KB -
adminlog 6,379 MyISAM 381.1 KB -
announcement 0 MyISAM 1.0 KB -
attachment 1,627 MyISAM 51.0 MB -
avatar 0 MyISAM 1.0 KB -
bbcode 23 MyISAM 4.6 KB -
calendar_events 0 MyISAM 1.0 KB -
customavatar 371 MyISAM 1.6 MB -
forum 26 MyISAM 32.4 KB -
forumpermission 12 MyISAM 3.4 KB -
icon 14 MyISAM 4.8 KB -
moderator 43 MyISAM 4.7 KB -
poll 185 MyISAM 28.7 KB -
pollvote 819 MyISAM 36.8 KB -
post 547,365 MyISAM 343.8 MB -
privatemessage 13,032 MyISAM 5.5 MB -
profilefield 4 MyISAM 3.2 KB -
replacement 57 MyISAM 5.7 KB -
replacementset 1 MyISAM 2.2 KB -
search 455 MyISAM 1.6 MB 65,512 Bytes
searchindex 2,892,257 MyISAM 64.1 MB -
session 87 HEAP 536.0 KB 39,004 Bytes
setting 169 MyISAM 41.8 KB -
settinggroup 31 MyISAM 5.2 KB -
smilie 78 MyISAM 18.2 KB -
style 1 MyISAM 2.3 KB -
subscribeforum 1,581 MyISAM 49.1 KB -
subscribethread 125,343 MyISAM 3.7 MB -
template 489 MyISAM 530.1 KB -
templateset 1 MyISAM 2.2 KB -
thread 64,331 MyISAM 7.9 MB -
threadrate 255 MyISAM 14.9 KB -
user 8,869 MyISAM 1.8 MB -
userfield 8,869 MyISAM 8.6 MB -
usergroup 8 MyISAM 4.0 KB -
usertitle 3 MyISAM 2.7 KB -
word 341,283 MyISAM 23.8 MB -


لاحظت ان جدول السيزون مكتوب امامه HEAP .. ويختلف عن باقي الجداول ..

عملت عمليه ربير لقاعده البيانات ونفس المشكله

فهل من مساعده يا اخوان لمن مرت عليه هذه المشكله

تحياتى للجميع