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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ZombieAndy
    Senior Member
    • Aug 2003
    • 126
    • 1.1.x

    [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.
  • snakes1100
    Senior Member
    • Aug 2001
    • 1249

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

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

    Comment

    • ZombieAndy
      Senior Member
      • Aug 2003
      • 126
      • 1.1.x

      #3
      Originally posted by snakes1100
      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

      • snakes1100
        Senior Member
        • Aug 2001
        • 1249

        #4
        Try running this query in phpmyadmin:

        repair table attachmentviews use_frm;
        Gentoo Geek

        Comment

        • ZombieAndy
          Senior Member
          • Aug 2003
          • 126
          • 1.1.x

          #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

          • snakes1100
            Senior Member
            • Aug 2001
            • 1249

            #6
            welcome
            Gentoo Geek

            Comment

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