Announcement

Collapse
No announcement yet.

mysql error: The table 'attachment' is full error message

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql error: The table 'attachment' is full error message

    Today our users started having troubles uploading attachments. Below is the error message I am being sent. How can I or my host fix this?
    Database error in vBulletin 3.0.3:
    Invalid SQL:
    INSERT INTO attachment
    (userid, dateline, filename, filedata, filesize, visible, filehash, posthash, thumbnail, thumbnail_dateline, thumbnail_filesize)
    VALUES
    (2, 1145583715, 'buy.gif',
    'GIF89a+\0\0‡\0\0W”X”X•Z–]˜^˜^™`™`šd!œe\"l-¡n/¢s7¦v;¨K¯…Q±ˆT³ŒZµ_¸`¸’c¹›p¿¥~Ū…ȯÌµ–ÐĪÙŬÚÇ®ÛÌ·ßÕÃäÚËçÛËèÝÎéàÒëäÙîåÚîéàñëâòîçôûùüÿÿ ÿ\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0!ù\0\0\0ÿ\0,\0\0\0\0+\0\0\0¼\0H° Áƒ*\\ÈP¡Š‡#JœH±\"D‚*\Zjtˆq£Gƒ†”(0¤H\0&Kˆà @”#;¦D©²¦&.,8³¦Ê™1}ZPq„‡\n :ž¤yhS‚\nF<L!¢ƒ†˜Ö$©ÕgW$– P kП{Dða*ˆ\r\Z0ë5£Ó¥\'¨@ƒ„J·*5yW`&20à98\"Ƈ F€0àeàÕbÎüØ¢çÏ7‹MÚ`@\0;', 991, 1, '707576c47a2a72daf17dedb118624b30', '4309ca808bd4eb68aec7ee4db3e83d93', '', 0, 0)

    mysql error: The table 'attachment' is full
    mysql error number: 1114
    Date: Thursday 20th of April 2006 06:41:55 PM
    Script: http://www.designoutpost.com/forums/newattachment.php
    Referer: http://www.designoutpost.com/forums/...c7ee4db3e83d93
    Username: Palmer
    IP Address: removed
    Founder/Owner - The Outpost Network

  • #2
    To add to this, the table is 4.0GB and has 51,820 records.
    Founder/Owner - The Outpost Network

    Comment


    • #3
      ... holy poop on a stick batman!

      You've reach the max filesize limit possibley not only for your filesystem, but also mysql

      I urge you to think about exporting your attachments into the filesystem!

      Comment


      • #4
        How would I do that?
        Founder/Owner - The Outpost Network

        Comment


        • #5
          ACP -> Attachments -> Attachment Storage & Type
          Lats...

          Comment


          • #6
            Originally posted by Lats
            ACP -> Attachments -> Attachment Storage & Type
            Ok, I'll give that a try. Thank you.
            Founder/Owner - The Outpost Network

            Comment

            Loading...
            Working...
            X