Announcement

Collapse
No announcement yet.

Site down - 11GB of ? in vb3_album

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

  • [CMS] Site down - 11GB of ? in vb3_album

    Site is not running. vb3_cache table is crashed.

    When looking in phpMyAdmin, I found vb3_album has 11 GB of stuff in it.

    Is album the same place the images for CMS articles are stored? User has uploaded tonnes of stuff?

    Anyway to remove this? It seems to crash before I can do anything.

    Thanks,
    JM
    Hmmm. Cheese.

  • #2
    Images from articles are stored in the attachment table (unless you've opted to use the filesystem for attachments). Album is purely related to albums.
    Vote for:

    - *Admin Settable Paid Subscription Reminder Timeframe*
    -
    *PM - Add ability to reply to originator only*
    - Add Admin ability to auto-subscribe users to specific channel(s)
    - "Quick Route" Interface...

    Comment


    • #3
      Originally posted by Trevor Hannant View Post
      Images from articles are stored in the attachment table (unless you've opted to use the filesystem for attachments). Album is purely related to albums.
      Thanks!

      I was able to reboot the server and go straight to it before it crashed or hung. Just emptied it and disabled user albums.

      Is there any way to figure out after emptying the table who uploaded all the crap?

      Thanks,
      JM
      Hmmm. Cheese.

      Comment


      • #4
        Originally posted by socceronly View Post
        Thanks!

        I was able to reboot the server and go straight to it before it crashed or hung. Just emptied it and disabled user albums.

        Is there any way to figure out after emptying the table who uploaded all the crap?

        Thanks,
        JM
        Do you really think one user uploaded 11 gigs of images?
        The default values are max hight and width 600px and 100 images max.
        This means the user had to upload 100 images and each of these images must've had a size of 110 MB. Or 50 images with a size of 220 MB etc.
        .......

        Comment


        • #5
          Site down - 11GB of ? in vb3_album

          Unless nessacery , You should move attachments to the file system. That's way to big to be in the database.
          UniteTheCows - File Sharing & Digital Media Resource

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X