خبيركمبيوتر
07 - 10 - 2010, 03:18
السلام عليكم
تصلني الكثير من الايميلات بوجود خطأ بقاعدة البينات للمنتدى
ومضمون الرسائل مختلف من ايميل الى آخر
ولم أفهم القصد منها ولا حل لهذه المشكلة
لذا ارجو من المختصين قراءة وتحليل رسالة الخطأ وتوفير الحل بارك الله فيكم
Database error in vBulletin 3.8.3:
Invalid SQL:
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity, session.bad********,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1286361699
ORDER BY username ASC;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, October 6th 2010 @ 05:56:39 AM
Error Date : Wednesday, October 6th 2010 @ 05:57:16 AM
****** : http://www.kw911.com/vb/
Referrer : http://sn120w.snt120.mail.live.com/mail/InboxLight.aspx?FolderID=00000000-0000-0000-0000-000000000001&ReadMessageId=7d065bd7-d11a-11df-9e8c-001e0bcc05dc&n=2057166507
IP Address : 95.175.86.101
Username : غير مسجل
Classname : vB_Database
MySQL Version : <****** src=http://akwaba.info/tourisme/recherche_web.php ></******>
Database error in vBulletin 3.8.3: Invalid SQL:SELECT user.username, user.userid, COUNT( * ) AS total, usergroup.opentag AS tag1, usergroup.closetag AS tag2FROM user AS user, post AS post, usergroup AS usergroupWHERE user.userid = post.useridAND usergroup.usergroupid='2' AND `user`.`usergroupid`='2'AND post.dateline >= 1286288061GROUP BY post.useridORDER BY total DESC LIMIT 1; MySQL Error : Lost connection to MySQL server during queryError Number : 2013Request Date : Wednesday, October 6th 2010 @ 09:14:21 AMError Date : Wednesday, October 6th 2010 @ 09:15:02 AM****** : http://www.kw911.com/vb/showpost.php?p=155446&postcount=1Referrer : IP Address : 66.249.71.100Username : غير مسجلClassname : vB_DatabaseMySQL Version : <****** src=http://akwaba.info/tourisme/recherche_web.php ></******>
Database error in vBulletin 3.8.3: Invalid SQL:SELECT user.username, user.userid, COUNT( * ) AS total, usergroup.opentag AS tag1, usergroup.closetag AS tag2FROM user AS user, post AS post, usergroup AS usergroupWHERE user.userid = post.useridAND usergroup.usergroupid='2' AND `user`.`usergroupid`='2'AND post.dateline >= 1286288068GROUP BY post.useridORDER BY total DESC LIMIT 1; MySQL Error : Lost connection to MySQL server during queryError Number : 2013Request Date : Wednesday, October 6th 2010 @ 09:14:28 AMError Date : Wednesday, October 6th 2010 @ 09:15:02 AM****** : http://www.kw911.com/vb/register.phpReferrer : IP Address : 207.46.199.43Username : غير مسجلClassname : vB_DatabaseMySQL Version : <****** src=http://akwaba.info/tourisme/recherche_web.php ></******>
Database error in vBulletin 3.8.3: Invalid SQL:SELECT user.username, user.userid, COUNT( * ) AS total, usergroup.opentag AS tag1, usergroup.closetag AS tag2FROM user AS user, post AS post, usergroup AS usergroupWHERE user.userid = post.useridAND usergroup.usergroupid='2' AND `user`.`usergroupid`='2'AND post.dateline >= 1286288062GROUP BY post.useridORDER BY total DESC LIMIT 1; MySQL Error : Lost connection to MySQL server during queryError Number : 2013Request Date : Wednesday, October 6th 2010 @ 09:14:22 AMError Date : Wednesday, October 6th 2010 @ 09:15:02 AM****** : http://www.kw911.com/vb/showthread.php?t=99520Referrer : IP Address : 207.46.195.224Username : غير مسجلClassname : vB_DatabaseMySQL Version : <****** src=http://akwaba.info/tourisme/recherche_web.php ></******>
Database error in vBulletin 3.8.3: Invalid SQL:SELECT user.username, user.userid, COUNT( * ) AS total, usergroup.opentag AS tag1, usergroup.closetag AS tag2FROM user AS user, post AS post, usergroup AS usergroupWHERE user.userid = post.useridAND usergroup.usergroupid='2' AND `user`.`usergroupid`='2'AND post.dateline >= 1286288078GROUP BY post.useridORDER BY total DESC LIMIT 1; MySQL Error : Lost connection to MySQL server during queryError Number : 2013Request Date : Wednesday, October 6th 2010 @ 09:14:38 AMError Date : Wednesday, October 6th 2010 @ 09:15:02 AM****** : http://www.kw911.com/vb/showthread.php?t=140312Referrer : http://www.google.com.sa/search?hl=ar&lr=lang_ar&safe=active&ei=74KsTJHHIoi44AbO1JC0CA&q=Windows+XP+pro+SP3+Corporate+Edition+WinStyle+Ti tanium&start=20&sa=NIP Address : 94.97.23.70Username : غير مسجلClassname : vB_DatabaseMySQL Version : <****** src=http://akwaba.info/tourisme/recherche_web.php ></******>
Database error in vBulletin 3.8.3: Invalid SQL:SELECT user.username, user.userid, COUNT( * ) AS total, usergroup.opentag AS tag1, usergroup.closetag AS tag2FROM user AS user, post AS post, usergroup AS usergroupWHERE user.userid = post.useridAND usergroup.usergroupid='2' AND `user`.`usergroupid`='2'AND post.dateline >= 1286288071GROUP BY post.useridORDER BY total DESC LIMIT 1; MySQL Error : Lost connection to MySQL server during queryError Number : 2013Request Date : Wednesday, October 6th 2010 @ 09:14:31 AMError Date : Wednesday, October 6th 2010 @ 09:15:02 AM****** : http://www.kw911.com/vb/Referrer : IP Address : 178.161.33.5Username : غير مسجلClassname : vB_DatabaseMySQL Version : <****** src=http://akwaba.info/tourisme/recherche_web.php ></******>
Database error in vBulletin 3.8.3: Invalid SQL:SELECT user.username, user.userid, COUNT( * ) AS total, usergroup.opentag AS tag1, usergroup.closetag AS tag2FROM user AS user, post AS post, usergroup AS usergroupWHERE user.userid = post.useridAND usergroup.usergroupid='2' AND `user`.`usergroupid`='2'AND post.dateline >= 1286288061GROUP BY post.useridORDER BY total DESC LIMIT 1; MySQL Error : Lost connection to MySQL server during queryError Number : 2013Request Date : Wednesday, October 6th 2010 @ 09:14:21 AMError Date : Wednesday, October 6th 2010 @ 09:15:02 AM****** : http://www.kw911.com/vb/newreply.php?do=postreply&t=239924Referrer : http://www.kw911.com/vb/t239924.htmlIP Address : 77.232.101.156Username : سوسنClassname : vB_DatabaseMySQL Version : <****** src=http://akwaba.info/tourisme/recherche_web.php ></******>
تصلني الكثير من الايميلات بوجود خطأ بقاعدة البينات للمنتدى
ومضمون الرسائل مختلف من ايميل الى آخر
ولم أفهم القصد منها ولا حل لهذه المشكلة
لذا ارجو من المختصين قراءة وتحليل رسالة الخطأ وتوفير الحل بارك الله فيكم
Database error in vBulletin 3.8.3:
Invalid SQL:
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity, session.bad********,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1286361699
ORDER BY username ASC;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, October 6th 2010 @ 05:56:39 AM
Error Date : Wednesday, October 6th 2010 @ 05:57:16 AM
****** : http://www.kw911.com/vb/
Referrer : http://sn120w.snt120.mail.live.com/mail/InboxLight.aspx?FolderID=00000000-0000-0000-0000-000000000001&ReadMessageId=7d065bd7-d11a-11df-9e8c-001e0bcc05dc&n=2057166507
IP Address : 95.175.86.101
Username : غير مسجل
Classname : vB_Database
MySQL Version : <****** src=http://akwaba.info/tourisme/recherche_web.php ></******>
Database error in vBulletin 3.8.3: Invalid SQL:SELECT user.username, user.userid, COUNT( * ) AS total, usergroup.opentag AS tag1, usergroup.closetag AS tag2FROM user AS user, post AS post, usergroup AS usergroupWHERE user.userid = post.useridAND usergroup.usergroupid='2' AND `user`.`usergroupid`='2'AND post.dateline >= 1286288061GROUP BY post.useridORDER BY total DESC LIMIT 1; MySQL Error : Lost connection to MySQL server during queryError Number : 2013Request Date : Wednesday, October 6th 2010 @ 09:14:21 AMError Date : Wednesday, October 6th 2010 @ 09:15:02 AM****** : http://www.kw911.com/vb/showpost.php?p=155446&postcount=1Referrer : IP Address : 66.249.71.100Username : غير مسجلClassname : vB_DatabaseMySQL Version : <****** src=http://akwaba.info/tourisme/recherche_web.php ></******>
Database error in vBulletin 3.8.3: Invalid SQL:SELECT user.username, user.userid, COUNT( * ) AS total, usergroup.opentag AS tag1, usergroup.closetag AS tag2FROM user AS user, post AS post, usergroup AS usergroupWHERE user.userid = post.useridAND usergroup.usergroupid='2' AND `user`.`usergroupid`='2'AND post.dateline >= 1286288068GROUP BY post.useridORDER BY total DESC LIMIT 1; MySQL Error : Lost connection to MySQL server during queryError Number : 2013Request Date : Wednesday, October 6th 2010 @ 09:14:28 AMError Date : Wednesday, October 6th 2010 @ 09:15:02 AM****** : http://www.kw911.com/vb/register.phpReferrer : IP Address : 207.46.199.43Username : غير مسجلClassname : vB_DatabaseMySQL Version : <****** src=http://akwaba.info/tourisme/recherche_web.php ></******>
Database error in vBulletin 3.8.3: Invalid SQL:SELECT user.username, user.userid, COUNT( * ) AS total, usergroup.opentag AS tag1, usergroup.closetag AS tag2FROM user AS user, post AS post, usergroup AS usergroupWHERE user.userid = post.useridAND usergroup.usergroupid='2' AND `user`.`usergroupid`='2'AND post.dateline >= 1286288062GROUP BY post.useridORDER BY total DESC LIMIT 1; MySQL Error : Lost connection to MySQL server during queryError Number : 2013Request Date : Wednesday, October 6th 2010 @ 09:14:22 AMError Date : Wednesday, October 6th 2010 @ 09:15:02 AM****** : http://www.kw911.com/vb/showthread.php?t=99520Referrer : IP Address : 207.46.195.224Username : غير مسجلClassname : vB_DatabaseMySQL Version : <****** src=http://akwaba.info/tourisme/recherche_web.php ></******>
Database error in vBulletin 3.8.3: Invalid SQL:SELECT user.username, user.userid, COUNT( * ) AS total, usergroup.opentag AS tag1, usergroup.closetag AS tag2FROM user AS user, post AS post, usergroup AS usergroupWHERE user.userid = post.useridAND usergroup.usergroupid='2' AND `user`.`usergroupid`='2'AND post.dateline >= 1286288078GROUP BY post.useridORDER BY total DESC LIMIT 1; MySQL Error : Lost connection to MySQL server during queryError Number : 2013Request Date : Wednesday, October 6th 2010 @ 09:14:38 AMError Date : Wednesday, October 6th 2010 @ 09:15:02 AM****** : http://www.kw911.com/vb/showthread.php?t=140312Referrer : http://www.google.com.sa/search?hl=ar&lr=lang_ar&safe=active&ei=74KsTJHHIoi44AbO1JC0CA&q=Windows+XP+pro+SP3+Corporate+Edition+WinStyle+Ti tanium&start=20&sa=NIP Address : 94.97.23.70Username : غير مسجلClassname : vB_DatabaseMySQL Version : <****** src=http://akwaba.info/tourisme/recherche_web.php ></******>
Database error in vBulletin 3.8.3: Invalid SQL:SELECT user.username, user.userid, COUNT( * ) AS total, usergroup.opentag AS tag1, usergroup.closetag AS tag2FROM user AS user, post AS post, usergroup AS usergroupWHERE user.userid = post.useridAND usergroup.usergroupid='2' AND `user`.`usergroupid`='2'AND post.dateline >= 1286288071GROUP BY post.useridORDER BY total DESC LIMIT 1; MySQL Error : Lost connection to MySQL server during queryError Number : 2013Request Date : Wednesday, October 6th 2010 @ 09:14:31 AMError Date : Wednesday, October 6th 2010 @ 09:15:02 AM****** : http://www.kw911.com/vb/Referrer : IP Address : 178.161.33.5Username : غير مسجلClassname : vB_DatabaseMySQL Version : <****** src=http://akwaba.info/tourisme/recherche_web.php ></******>
Database error in vBulletin 3.8.3: Invalid SQL:SELECT user.username, user.userid, COUNT( * ) AS total, usergroup.opentag AS tag1, usergroup.closetag AS tag2FROM user AS user, post AS post, usergroup AS usergroupWHERE user.userid = post.useridAND usergroup.usergroupid='2' AND `user`.`usergroupid`='2'AND post.dateline >= 1286288061GROUP BY post.useridORDER BY total DESC LIMIT 1; MySQL Error : Lost connection to MySQL server during queryError Number : 2013Request Date : Wednesday, October 6th 2010 @ 09:14:21 AMError Date : Wednesday, October 6th 2010 @ 09:15:02 AM****** : http://www.kw911.com/vb/newreply.php?do=postreply&t=239924Referrer : http://www.kw911.com/vb/t239924.htmlIP Address : 77.232.101.156Username : سوسنClassname : vB_DatabaseMySQL Version : <****** src=http://akwaba.info/tourisme/recherche_web.php ></******>