Database error in vBulletin 3.6.1
 

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 @ 02:13:49 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 @ 03:11:51 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