المشكلة
Invalid SQL:
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1141921235
ORDER BY username ASC;
MySQL Error : Can't open file: 'session.MYI' (errno: 145)
Error Number : 1016
الحل هو حذف جدول السيزن و انشاءه من جديد
1-
كود PHP:
DELETE FROM session;
2-
كود PHP:
CREATE TABLE `session` (
`sessionhash` char(32) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`host` char(15) NOT NULL default '',
`idhash` char(32) NOT NULL default '',
`lastactivity` int(10) unsigned NOT NULL default '0',
`location` char(255) NOT NULL default '',
`useragent` char(100) NOT NULL default '',
`styleid` smallint(5) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`loggedin` smallint(5) unsigned NOT NULL default '0',
`inforum` smallint(5) unsigned NOT NULL default '0',
`inthread` int(10) unsigned NOT NULL default '0',
`incalendar` smallint(5) unsigned NOT NULL default '0',
`badlocation` smallint(5) unsigned NOT NULL default '0',
`bypass` tinyint(4) NOT NULL default '0',
`profileupdate` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`sessionhash`)
) TYPE=HEAP;
المشكلة
صورة من المشكلة
Database error in vBulletin 3.6.4:
Invalid SQL:
UPDATE session
SET lastactivity = 1164695903, location = '/vb/admincp/email.php?do=dosendmail&do=dosendmail', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = 'bb54ff31f2d2aabe4c51f2a3338e09a6';
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Tuesday, November 28th 2006 @ 12:54:01 AM
Script :
http://xxxx/vb/admincp/email.php?do=dosendmail
Referrer :
http://xxxx/vb/admincp/email.php?do=start
IP Address : xxxxxxxxx
Username : xxxxxx
Classname : vb_database
الحل
MySQL Error : Lost connection to MySQL server during query
الرساله معناها فقدان الاتصال بقاعده البيانات ...
المشكله من السيرفر ..