Database error Help

[goshalim]

Hi , Since this morning iam receiving Database error. I run my Db from the Cpanel but still doesnt work or fixed.

this is the message received in the cpanel

canarybr_canary.fnewfiledata
error : 12 when fixing table
error : Not enough memory for blob at 342578404 (need 10133987)
status : Operation failed

[QUOTEcanarybr_canary.fnewfiledata
warning : Table is marked as crashed and last repair failed
warning : Size of indexfile is: 879616 Should be: 296960
error : Not enough memory (10133987) for blob at 342578404
][/QUOTE]


Also vbulletin gives you this message as well

Database error in vBulletin 4.1.1 Beta 1:

Invalid SQL:
(
SELECT
COUNT(*) AS count, SUM(fd.filesize) AS sum
FROM fnewattachment AS a
INNER JOIN fnewfiledata AS fd ON (a.filedataid = fd.filedataid)
LEFT JOIN fnewattachmenttype AS at ON (at.extension = fd.extension)
INNER JOIN fnewalbum AS album ON (album.albumid = a.contentid)
LEFT JOIN fnewprofileblockprivacy AS pbp ON (pbp.userid = a.userid AND pbp.blockid = 'albums')
LEFT JOIN fnewuser AS user ON (a.userid = user.userid)
WHERE
a.contenttypeid = 8 AND
(
(
a.contentid = 0
AND
a.userid = 1
)
OR
(
a.contentid <> 0
)
)
AND a.userid = 1
) UNION ALL (
SELECT
COUNT(*) AS count, SUM(fd.filesize) AS sum
FROM fnewattachment AS a
INNER JOIN fnewfiledata AS fd ON (a.filedataid = fd.filedataid)
LEFT JOIN fnewattachmenttype AS at ON (at.extension = fd.extension)
LEFT JOIN fnewpost AS post ON (post.postid = a.contentid)
LEFT JOIN fnewthread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN fnewuser AS user ON (a.userid = user.userid)
WHERE
a.contenttypeid = 1 AND
(
(
a.contentid = 0
AND
a.userid = 1
)
OR
(
thread.forumid IN (0, 6, 50, 116, 5, 28, 21, 83, 69, 70, 36, 111, 117, 4, 105, 71, 91, 92, 93, 94, 19, 14, 15, 13, 109, 106, 108, 52, 53, 59, 54, 60, 55, 61, 56, 62, 58, 38, 110, 73, 98, 40, 75, 42, 49, 12, 104, 99, 100, 101, 102, 103, 107, 120, 121, 122, 123, 124, 125, 127, 128, 126, 39, 16, 17, 84, 79, 85, 86, 87, 23, 88, 89, 90, 130, 29, 112, 113, 114, 115, 129, 32, 30, 81, 82, 118, 119) AND (
thread.forumid IN (0, 6, 50, 116, 5, 28, 21, 83, 69, 70, 36, 111, 117, 4, 105, 71, 91, 92, 93, 94, 19, 14, 15, 13, 109, 106, 108, 52, 53, 59, 54, 60, 55, 61, 56, 62, 58, 38, 110, 73, 98, 40, 75, 42, 49, 12, 104, 99, 100, 101, 102, 103, 107, 120, 121, 122, 123, 124, 125, 127, 128, 126, 39, 16, 17, 84, 79, 85, 86, 87, 23, 88, 89, 90, 130, 29, 112, 113, 114, 115, 129, 32, 30, 81, 82, 118, 119)
OR
thread.postuserid = 1
) AND (
a.state <> 'moderation'
OR
a.userid = 1
OR
thread.forumid IN (0, 6, 50, 116, 5, 28, 21, 83, 69, 70, 36, 111, 117, 4, 105, 71, 91, 92, 93, 94, 19, 14, 15, 13, 109, 106, 108, 52, 53, 59, 54, 60, 55, 61, 56, 62, 58, 38, 110, 73, 98, 40, 75, 42, 49, 12, 104, 99, 100, 101, 102, 103, 107, 120, 121, 122, 123, 124, 125, 127, 128, 126, 39, 16, 17, 84, 79, 85, 86, 87, 23, 88, 89, 90, 130, 29, 112, 113, 114, 115, 129, 32, 30, 81, 82, 118, 119)
) AND (
(
post.visible = 1
AND
thread.visible = 1
)
OR
(
thread.forumid IN (0, 6, 50, 116, 5, 28, 21, 83, 69, 70, 36, 111, 117, 4, 105, 71, 91, 92, 93, 94, 19, 14, 15, 13, 109, 106, 108, 52, 53, 59, 54, 60, 55, 61, 56, 62, 58, 38, 110, 73, 98, 40, 75, 42, 49, 12, 104, 99, 100, 101, 102, 103, 107, 120, 121, 122, 123, 124, 125, 127, 128, 126, 39, 16, 17, 84, 79, 85, 86, 87, 23, 88, 89, 90, 130, 29, 112, 113, 114, 115, 129, 32, 30, 81, 82, 118, 119)
)
OR
(
thread.forumid IN (0, 6, 50, 116, 5, 28, 21, 83, 69, 70, 36, 111, 117, 4, 105, 71, 91, 92, 93, 94, 19, 14, 15, 13, 109, 106, 108, 52, 53, 59, 54, 60, 55, 61, 56, 62, 58, 38, 110, 73, 98, 40, 75, 42, 49, 12, 104, 99, 100, 101, 102, 103, 107, 120, 121, 122, 123, 124, 125, 127, 128, 126, 39, 16, 17, 84, 79, 85, 86, 87, 23, 88, 89, 90, 130, 29, 112, 113, 114, 115, 129, 32, 30, 81, 82, 118, 119)
AND
post.visible = 2
AND
thread.visible = 2
)
)
)
)
AND a.userid = 1
) UNION ALL (
SELECT
COUNT(*) AS count, SUM(fd.filesize) AS sum
FROM fnewattachment AS a
INNER JOIN fnewfiledata AS fd ON (a.filedataid = fd.filedataid)
LEFT JOIN fnewattachmenttype AS at ON (at.extension = fd.extension)
INNER JOIN fnewsocialgroupmember AS sgm ON (sgm.userid = a.userid AND sgm.groupid = a.contentid AND sgm.type = 'member')
INNER JOIN fnewsocialgroup AS sg ON (sg.groupid = a.contentid)
LEFT JOIN fnewuser AS user ON (a.userid = user.userid)
WHERE
a.contenttypeid = 7 AND
(
(
a.contentid = 0
AND
a.userid = 1
)
OR
(
sg.options & 8 AND (
a.state <> 'moderation'
OR
a.userid = 1
)
)
)
AND a.userid = 1
) UNION ALL (
SELECT
COUNT(*) AS count, SUM(fd.filesize) AS sum
FROM fnewattachment AS a
INNER JOIN fnewfiledata AS fd ON (a.filedataid = fd.filedataid)
LEFT JOIN fnewattachmenttype AS at ON (at.extension = fd.extension)
LEFT JOIN fnewblog AS blog ON (a.contentid = blog.blogid)
LEFT JOIN fnewblog_user AS bu ON (bu.bloguserid = blog.userid)
LEFT JOIN fnewuser AS user ON (user.userid = blog.userid)
LEFT JOIN fnewblog_groupmembership AS gm ON (blog.userid = gm.bloguserid AND gm.userid = 1)
WHERE
a.contenttypeid = 15 AND
(
(
a.contentid = 0
AND
a.userid = 1
)
OR
(
a.contentid <> 0 AND
(
(
blog.state <> 'draft'
AND
blog.pending = 0
)
OR
blog.userid IN (1)
)

)
)
AND a.userid = 1
) UNION ALL (
SELECT
COUNT(*) AS count, SUM(fd.filesize) AS sum
FROM fnewattachment AS a
INNER JOIN fnewfiledata AS fd ON (a.filedataid = fd.filedataid)
LEFT JOIN fnewattachmenttype AS at ON (at.extension = fd.extension)
LEFT JOIN fnewcms_node AS node ON (a.contentid = node.nodeid)
LEFT JOIN fnewuser AS user ON (user.userid = node.userid)
WHERE
a.contenttypeid = 18 AND
(
(
a.contentid = 0
AND
a.userid = 1
)
OR
(
a.contentid <> 0
)
)
AND a.userid = 1
);

MySQL Error : Table './canarybr_canary/fnewfiledata' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Request Date : Thursday, October 13th 2011 @ 09:58:17 PM
Error Date : Thursday, October 13th 2011 @ 09:58:17 PM
Script : http://www.canarybreeder.net/up/forum/private.php
Referrer : http://www.canarybreeder.net/up/forum/forum.php
IP Address : 62.152.16.169
Username : admin
Classname : vB_Database
MySQL Version : 5.1.56

Please i need some help

Thanks