Sinds enkele dagen komen er dagelijk tientallen verschillende meldingen binnen van de wht server waarvan in ieder geval de volgende error hetzelfde is:
MySQL Error : Out of memory (Needed xxxxxxx bytes)
Error Number : 5
Wat adviseren jullie bij deze error?
Het heeft ook voornamelijk met attachments te maken zie ik.
Invalid SQL:
SELECT filename, attachment.postid, attachment.userid, attachmentid,
attachment.dateline, SUBSTRING(filedata, 1, 2097152) AS filedata, filesize,
attachment.visible, mimetype, thread.forumid, thread.threadid, thread.postuserid,
post.visible AS post_visible, thread.visible AS thread_visible
FROM attachment AS attachment
LEFT JOIN attachmenttype AS attachmenttype ON (attachmenttype.extension = attachment.extension)
LEFT JOIN post AS post ON (post.postid = attachment.postid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
WHERE attachmentid = 4912;
Bedankt alvast!