Database error in vBulletin 3.6.1

محروم.كوم · #1 04-11-2009, 12:00 PM

I did a search and went through some posts but to be honest I got confused. So I created this new topic.

Problem description: There have been 2-3 occasions (3-4 weeks apart) that we get several emails (more than 50 each time) with subject line "Database error in vBulletin".

The last ones (61 email messages) were received last night from 22:53 until 01:11. The text is not the same so I will copy the different texts here below.

1 email message with following text:
Quote:
Database error in vBulletin :

mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111
/home/fouskoto4allgr/fouskoto4all.gr/forum/includes/class_core.php on line 271

MySQL Error :
Error Number :
Date : Thursday, April 9th 2009 @ 01:43:04 PM
Script : http://fouskoto4all.gr/forum/showthread.php?t=161
Referrer :
IP Address : 72.44.43.67
Username :
Classname : vB_Database
Several email messages with following text
Quote:
Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT thread.threadid, thread.title, post.attach,
thread.postusername, thread.dateline, podcastitem.*,
forum.forumid,
post.pagetext AS message, post.allowsmilie, post.postid

FROM thread AS thread
INNER JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN podcastitem AS podcastitem ON (podcastitem.postid = thread.firstpostid)

WHERE 1=1
AND thread.forumid IN(15,22,23,11,10)

AND thread.visible = 1
AND post.visible = 1
AND open 10
AND thread.dateline > 1236801216

ORDER BY thread.dateline DESC
LIMIT 25;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Date : Friday, April 10th 2009 @ 12:53:37 PM
Script : http://fouskoto4all.gr/forum/external.php
Referrer : http://fouskoto4all.gr/forum/external.php
IP Address : 67.205.48.93
Username : Μη εγγεγραμμένος (translation: not registered)
Classname : vB_Database
Several emails with following text:
Quote:
Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=617 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Date : Friday, April 10th 2009 @ 01:08:07 PM
Script : http://fouskoto4all.gr/forum/private.php?
Referrer : http://fouskoto4all.gr/forum/showthr...p?t=476&page=8
IP Address : 212.152.97.49
Username : focus4100
Classname : vB_Database
Several email messages with following text:
Quote:
Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=91 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Date : Friday, April 10th 2009 @ 0249 PM
Script : http://fouskoto4all.gr/forum/private.php?
Referrer : http://fouskoto4all.gr/forum/
IP Address : 85.72.191.194
Username : bon
Classname : vB_Database
Several email messages with following text:
Quote:
Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT thread.threadid, thread.title, post.attach,
thread.postusername, thread.dateline, podcastitem.*,
forum.forumid,
post.pagetext AS message, post.allowsmilie, post.postid

FROM thread AS thread
INNER JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN podcastitem AS podcastitem ON (podcastitem.postid = thread.firstpostid)

WHERE 1=1
AND thread.forumid IN(15,22,23,11,10)
AND thread.visible = 1
AND post.visible = 1
AND open 10
AND thread.dateline > 1236809511

ORDER BY thread.dateline DESC
LIMIT 25;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Date : Friday, April 10th 2009 @ 0351 PM
Script : http://fouskoto4all.gr/forum/external.php?type=RSS2
Referrer :
IP Address : 135.196.27.62
Username : Μη εγγεγραμμένος (translation: not registered)
Classname : vB_Database
Any ideas please?

Thanks in advance!

Michalis __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Database error in vBulletin 4.0.3	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-24-2010 04:40 PM
Forum Vbulletin database error but i can still access database via phpMyAdmin, wat's wrong?	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	02-12-2010 06:40 PM
Forum Database error in vBulletin 4.0.1: Error 1146	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	02-10-2010 09:10 AM
Database error in vBulletin 3.8.4	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	12-02-2009 07:30 PM
Database error in vBulletin Error Number : 1054	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-25-2009 03:50 AM