We have a server with several sites running various version of Expression Engine. We upgraded PHP last night and after the upgrade 2 sites has the table exp_online_users corrupt. I ran a repair command on the tables and the number of rows was reduced by 2 in each database and then the site ran fine. These 2 sites run older versions of Expression Engine.

Ideas of what could have caused the table to be corrupt?

  • If you have the 2 table versions you could do a text comparison and see if anything stands out? – Romans-8---31-39 Mar 16 '17 at 14:42
  • I did not make a backup of the database before I ran the repair. I am thinking the there was some writing going on in the database when apache was restarted and when that happened not all of the database writes had a chance to complete. – Trevor Orr Mar 16 '17 at 23:06
  • It shouldn't have been as a result of Apache being restarted, unless the database server was also restarted? In any case, that happens on occasion with MySQL, seems like it may be coincidence that it was the same table on two separate databases, though. That table doesn't hold any critical information and can be repaired and truncated as needed, too; it's just for site stats. – Derek Jones Mar 17 '17 at 21:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.