How To: Resolve Crashed Table Messages for the Internal InterWorx Database
==========================================================================

.. contents::

How the Issue May Manifest
--------------------------

- NodeWorx and SiteWorx are inaccessible via the GUI, with either a generic error message, if debug is disabled, or 
  showing a stacktrace that mentions a crashed table if debug is enabled

- Logging stating that there is a crashed table for the iworxdb appears in ``~iworx/var/log/iworx.log``. Example: 

  .. code-block::

     2025-06-10 09:10:25.35824 [nosess-55k6-44x1-WEB] [EMERG] : BEGIN STACKTRACE 1 - from logAnother in IWorx_Exception : /nodeworx/index
     2025-06-10 09:10:25.35888 [nosess-55k6-44x1-WEB] [INFO] : EXCEPTION: IWorx_Exception_DbUtil : /nodeworx/index
     2025-06-10 09:10:25.35909 [nosess-55k6-44x1-WEB] [INFO] : EXCEPTION: DB Error: unknown error SELECT config_value FROM config c : /nodeworx/index
     2025-06-10 09:10:25.35921 [nosess-55k6-44x1-WEB] [INFO] : INNER JOIN config_types t ON t.id = c.type_id : /nodeworx/index
     2025-06-10 09:10:25.35935 [nosess-55k6-44x1-WEB] [INFO] : WHERE t.type_name = 'server' : /nodeworx/index
     2025-06-10 09:10:25.35949 [nosess-55k6-44x1-WEB] [INFO] : AND c.config_key = 'manager' : /nodeworx/index
     2025-06-10 09:10:25.35963 [nosess-55k6-44x1-WEB] [INFO] : AND c.config_name = 'UI_IS_DARK_MODE' [nativecode=144 ** Table './iworx/config' is marked as crashed and last (automatic?) repair failed] in /usr/local/interworx/include/IWorxDbUtil.php line 414 : /nodeworx/index
     2025-06-10 09:10:25.35983 [nosess-55k6-44x1-WEB] [EMERG] : DB Error: unknown error SELECT config_value FROM config c : /nodeworx/index
     2025-06-10 09:10:25.35998 [nosess-55k6-44x1-WEB] [EMERG] : INNER JOIN config_types t ON t.id = c.type_id : /nodeworx/index
     2025-06-10 09:10:25.36012 [nosess-55k6-44x1-WEB] [EMERG] : WHERE t.type_name = 'server' : /nodeworx/index 
     2025-06-10 09:10:25.36026 [nosess-55k6-44x1-WEB] [EMERG] : AND c.config_key = 'manager' : /nodeworx/index
     2025-06-10 09:10:25.36041 [nosess-55k6-44x1-WEB] [EMERG] : AND c.config_name = 'UI_IS_DARK_MODE' [nativecode=144 ** Table './iworx/config' is marked as crashed and last (automatic?) repair failed] : /nodeworx/index

How to Resolve
--------------

#. Log in to the server at the CLI as root, either via SSH or from the terminal
#. At the CLI, run the following command--this will attempt to repair any crashed tables in the iworxdb: 

   .. code::

      ~iworx/bin/iworxdb_tuneup.pex