Getting hundreds of errors

محروم.كوم · #1 09-22-2009, 07:50 PM

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 @ 0837 AM
Error Date : Tuesday* September 22nd 2009 @ 0844 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 : __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Errors, etc...	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-05-2010 07:10 PM
I receive hundreds of database errors !	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	03-07-2010 05:10 AM
Forum Post-upgrade function.array_merge errors - plus other display errors	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	01-30-2010 06:41 AM
CMS 340 CSS Errors	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	01-06-2010 06:10 PM
Comment counter errors & last comments errors	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-03-2009 08:30 AM