Announcement

Collapse
No announcement yet.

How to clear attachments in database

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

  • [Forum] How to clear attachments in database

    vBulletin Suite 4.05 but CMS and Blog not yet enabled so running forum only with vBSEO.

    I had my attachments stored in the file system. After upgrading to vB 4.05, I had a problem withj attachments not showing - this turned out to be a vBSEO issue, not a vBulletin issue.

    However, in my attempts to track down the problem, I tried changing the option for attachments to store them in the database. This was generating a lot of file not found errors (as it should given that vBSEO was providing incorfrect URLs). I therefore interrupted the change in storage type.

    So now my attachments are still stored in the file system. BUT... the size of my database has increased substantially so obviously some/many of the attachments were transferred to the database before the process was interrupted.

    Now I'm wondering about the best way to get rid of that redundant database bloat.

    Should I reinitiate transferring the attachments to the database and then reverse it once it completes to store them back in the file system? Or is that simply going to compound my problpoem by creating more dupliucates?

    Is there an easier way to get rid of the bloat?

    Suggestions?
    Psychlinks Web Services Affordable Web Design & Site Management
    Specializing in Small Businesses and vBulletin/Xenforo Forums

  • #2
    Resolved via a support ticket thanks to Lynne.
    Psychlinks Web Services Affordable Web Design & Site Management
    Specializing in Small Businesses and vBulletin/Xenforo Forums

    Comment

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