Getting hundreds of errors
 

I am swamped with emails about errors on my database. My host said this:

Quote:
This is a code issue. Looking at the connections* it seems some of your queries are running long and you are running many queries. To improve performance make sure your queries are efficient and that you are closing the connections as soon as possible. Otherwise you will hit the limit of 30 simultaneous connections to the database.
The errors I am getting are below. Any ideas?

Thanks*

Jon

Quote:
Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT
post.** post.username AS postusername* post.ipaddress AS ip* IF(post.visible = 2* 1* 0) AS isdeleted*
user.** userfield.** usertextfield.**
icon.title as icontitle* icon.iconpath*
avatar.avatarpath* NOT ISNULL(customavatar.userid) AS hascustomavatar* customavatar.dateline AS avatardateline*customavatar.width AS avwidth*customavatar.height AS avheight*


editlog.userid AS edit_userid* editlog.username AS edit_username* editlog.dateline AS edit_dateline*
editlog.reason AS edit_reason* editlog.hashistory*
postparsed.pagetext_html* postparsed.hasimages*
sigparsed.signatureparsed* sigparsed.hasimages AS sighasimages*
sigpic.userid AS sigpic* sigpic.dateline AS sigpicdateline* sigpic.width AS sigpicwidth* sigpic.height AS sigpicheight*
IF(displaygroupid=0* user.usergroupid* displaygroupid) AS displaygroupid* infractiongroupid


FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)


LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 2 AND postparsed.languageid = 1)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 2 AND sigparsed.languageid = 1)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)

WHERE post.postid IN (0*529732*529898)
ORDER BY post.dateline;

MySQL Error : Can't find file: './lawrance/userfield.frm' (errno: 24)
Error Number : 1017
Request Date : Tuesday* September 22nd 2009 @ 08:09:37 AM
Error Date : Tuesday* September 22nd 2009 @ 08:09:44 AM
Script : http://www.access-programmers.co.uk/...d.php?t=115968
Referrer : http://www.google.com/search?hl=en&q...US299&ie=UTF-8
IP Address : 66.93.106.2
Username : Unregistered
Classname : vb_database
MySQL Version :