Announcement

Collapse
No announcement yet.

Attachment DB Table corrupt after update to 4.2.0 (from 4.0.x)

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

  • [Forum] Attachment DB Table corrupt after update to 4.2.0 (from 4.0.x)

    Since updating our forums, several members are complaining they can no longer view attachments. Ive been investigating and when running a database optimize/repair in the admin cp, it comes back with this:



    Help!!
    My Forums - A Forum dedicated to the horror films comprising the George A. Romero "Dead" series of films, Night of the Living Dead, Dawn of the Dead, Day of the Dead, Land of the Dead, Diary of the Dead and Survival of the Dead.

  • #2
    What table type is attachmentviews, myisam or innodb?

    Do you have root ssh access to the server?
    Gentoo Geek

    Comment


    • #3
      Originally posted by snakes1100 View Post
      What table type is attachmentviews, myisam or innodb?

      Do you have root ssh access to the server?
      Not sure and no i dont have access, im only admin. I Will send a message to our webmaster and ask him to post here.
      My Forums - A Forum dedicated to the horror films comprising the George A. Romero "Dead" series of films, Night of the Living Dead, Dawn of the Dead, Day of the Dead, Land of the Dead, Diary of the Dead and Survival of the Dead.

      Comment


      • #4
        Try running this query in phpmyadmin:

        repair table attachmentviews use_frm;
        Gentoo Geek

        Comment


        • #5
          Thanks alot snakes, that fixed it.
          My Forums - A Forum dedicated to the horror films comprising the George A. Romero "Dead" series of films, Night of the Living Dead, Dawn of the Dead, Day of the Dead, Land of the Dead, Diary of the Dead and Survival of the Dead.

          Comment


          • #6
            welcome
            Gentoo Geek

            Comment

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