Solutions to this ERROR

[lasto]

Database error

Invalid SQL:
SELECT filename, filesize, postid, attachment.userid,
filedata,
dateline,
visible, mimetype, NOT ISNULL(deletionlog.primaryid) AS isdeleted,doitrepondre
FROM attachment AS attachment
LEFT JOIN attachmenttype AS attachmenttype ON(attachmenttype.extension = SUBSTRING_INDEX(attachment.filename, '.', -1))
LEFT JOIN deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
WHERE attachmentid = 4783

mysql error: MySQL client run out of memory

mysql error number: 2008

Board was running fine all week - have added nothing or changed anything then today get the error above when trying to download a rar.
if i try to upload a rar to the board it times out and gives me page not displayed but liek said everything was fine till today.

Any solutions - have emailed host regarding it but waiting on reply so wondering what you lot make of it ??

[filburt1]

MySQL is likely configured poorly, or the server itself has too little memory. In general, your host will need to fix this error.

As a slight hunch, back up (if you need it) and then delete the post deletion log.

[lasto]

cheers filburt seems host has now fixed it as attachments download fine now but can u tell me why delete post deletion log ??

[filburt1]

I was thinking that the joining of the two tables was what consumed so much memory, possibly. By freeing up one of them, there would be a smaller virtual table used for the query.