Help My Site Has Crashed!

It was fine then suddenly "fatal error" If logged as a site user, this is what you get when logging out:

An unrecoverable error has occurred and has been logged. Contact the site administrator with the following information:

Exception #1371617355.

If you try to log in as admin, it turns to a fatal error page about 5 pages long

  • what does the fatal error say?  Just a relevant part of it would be helpful.

    Otherwise: check your logs

  • This is what I get when logging in as admin:

     

    Fatal Error.

    Table './djamdire_elgg425/elgg_system_log' is marked as crashed and should be repaired
    QUERY: INSERT DELAYED into elgg_system_log (object_id, object_class, object_type, object_subtype, event, performed_by_guid, owner_guid, access_id, enabled, time_created, ip_address) VALUES ('35','ElggUser','user', '', 'update', 35, 0, 2, 'yes', '1371619400', '50.156.62.34')

    DatabaseException Object (     [message:protected] => Table './djamdire_elgg425/elgg_system_log' is marked as crashed and should be repaired
    QUERY: INSERT DELAYED into elgg_system_log (object_id, object_class, object_type, object_subtype, event, performed_by_guid, owner_guid, access_id, enabled, time_created, ip_address) VALUES ('35','ElggUser','user', '', 'update', 35, 0, 2, 'yes', '1371619400', '50.156.62.34')     [string:Exception:private] => exception 'DatabaseException' with message 'Table './djamdire_elgg425/elgg_system_log' is marked as crashed and should be repaired
    QUERY: INSERT DELAYED into elgg_system_log (object_id, object_class, object_type, object_subtype, event, performed_by_guid, owner_guid, access_id, enabled, time_created, ip_address) VALUES ('35','ElggUser','user', '', 'update', 35, 0, 2, 'yes', '1371619400', '50.156.62.34')' in /home/djamdire/public_html/engine/lib/database.php:274 Stack trace: #0 /home/djamdire/public_html/engine/lib/database.php(468): execute_query('INSERT DELAYED ...', Resource id #54) #1 /home/djamdire/public_html/engine/lib/system_log.php(219): insert_data('INSERT DELAYED ...') #2 /home/djamdire/public_html/engine/lib/system_log.php(274): system_log(Object(ElggUser), 'update') #3 [internal function]: system_log_default_logger('log', 'systemlog', Array) #4 /home/djamdire/public_html/engine/lib/elgglib.php(784): call_user_func_array('system_log_defa...', Array) #5 /home/djamdire/public_html/engine/lib/system_log.php(292): elgg_trigger_event('log', 'systemlog', Array) #6 [internal function]: system_log_listener('update', 'user', Object(ElggUser)) #7 /home/djamdire/public_html/engine/lib/elgglib.php(784): call_user_func_array('system_log_list...', Array) #8 /home/djamdire/public_html/engine/lib/entities.php(434): elgg_trigger_event('update', 'user', Object(ElggUser)) #9 /home/djamdire/public_html/engine/classes/ElggEntity.php(1281): update_entity(35, '0', '2', '0', '1362440327') #10 /home/djamdire/public_html/engine/classes/ElggUser.php(127): ElggEntity->save() #11 /home/djamdire/public_html/engine/lib/sessions.php(308): ElggUser->save() #12 /home/djamdire/public_html/actions/login.php(48): login(Object(ElggUser), false) #13 /home/djamdire/public_html/engine/lib/actions.php(97): include('/home/djamdire/...') #14 /home/djamdire/public_html/engine/handlers/action_handler.php(20): action('login') #15 {main}     [code:protected] => 0     [file:protected] => /home/djamdire/public_html/engine/lib/database.php     [line:protected] => 274     [trace:Exception:private] => Array         (             [0] => Array                 (                     [file] => /home/djamdire/public_html/engine/lib/database.php                     [line] => 468                     [function] => execute_query                     [args] => Array                         (                             [0] => INSERT DELAYED into elgg_system_log (object_id, object_class, object_type, object_subtype, event, performed_by_guid, owner_guid, access_id, enabled, time_created, ip_address) VALUES ('35','ElggUser','user', '', 'update', 35, 0, 2, 'yes', '1371619400', '50.156.62.34')                             [1] => Resource id #54                         )
                    )
                [1] => Array                 (                     [file] => /home/djamdire/public_html/engine/lib/system_log.php                     [line] => 219                     [function] => insert_data                     [args] => Array                         (                             [0] => INSERT DELAYED into elgg_system_log (object_id, object_class, object_type, object_subtype, event, performed_by_guid, owner_guid, access_id, enabled, time_created, ip_address) VALUES ('35','ElggUser','user', '', 'update', 35, 0, 2, 'yes', '1371619400', '50.156.62.34')                         )
                    )
                [2] => Array                 (                     [file] => /home/djamdire/public_html/engine/lib/system_log.php                     [line] => 274                     [function] => system_log                     [args] => Array                         (                             [0] => ElggUser Object                                 (                                     [url_override:protected] =>                                     [icon_override:protected] =>                                     [temp_metadata:protected] => Array                                         (                                         )
                                        [temp_annotations:protected] => Array                                         (                                         )
                                        [temp_private_settings:protected] => Array                                         (                                         )
                                        [volatile:protected] => Array                                         (                                         )
                                        [attributes:protected] => Array                                         (                                             [guid] => 35                                             [type] => user                                             [subtype] => 0                                             [owner_guid] => 0                                             [site_guid] => 1                                             [container_guid] => 0                                             [access_id] => 2                                             [time_created] => 1362440327                                             [time_updated] => 1368427300                                             [last_action] => 1368427323                                             [enabled] => yes                                             [tables_split] => 2                                             [tables_loaded] => 2                                             [name] => Rich Brunelle                                             [username] => admin                                             [password] => 7bf8997411a8c2ba12821115c6e043ba                                             [salt] => sgeu6hej                                             [email] => admin@djamdirectory.info                                             [language] => en                                             [code] =>                                             [banned] => no                                             [admin] => yes                                             [prev_last_action] => 1368427318                                             [last_login] => 1368427300                                             [prev_last_login] => 1366228879                                         )
                                        [valid:protected] =>                                 )
                                [1] => update                         )
                    )
                [3] => Array                 (                     [function] => system_log_default_logger                     [args] => Array                         (                             [0] => log                             [1] => systemlog                             [2] => Array                                 (                                     [object] => ElggUser Object                                         (                                             [url_override:protected] =>                                             [icon_override:protected] =>                                             [temp_metadata:protected] => Array                                                 (                                                 )
                                                [temp_annotations:protected] => Array                                                 (                                                 )
                                                [temp_private_settings:protected] => Array                                                 (                                                 )
                                                [volatile:protected] => Array                                                 (                                                 )
                                                [attributes:protected] => Array                                                 (                                                     [guid] => 35                                                     [type] => user                                                     [subtype] => 0                                                     [owner_guid] => 0                                                     [site_guid] => 1                                                     [container_guid] => 0                                                     [access_id] => 2                                                     [time_created] => 1362440327                                                     [time_updated] => 1368427300                                                     [last_action] => 1368427323                                                     [enabled] => yes                                                     [tables_split] => 2                                                     [tables_loaded] => 2                                                     [name] => Rich Brunelle                                                     [username] => admin                                                     [password] => 7bf8997411a8c2ba12821115c6e043ba                                                     [salt] => sgeu6hej                                                     [email] => admin@djamdirectory.info                                                     [language] => en                                                     [code] =>                                                     [banned] => no                                                     [admin] => yes                                                     [prev_last_action] => 1368427318                                                     [last_login] => 1368427300                                                     [prev_last_login] => 1366228879                                                 )
                                                [valid:protected] =>                                         )
                                        [event] => update                                 )
                            )
                    )
                [4] => Array                 (                     [file] => /home/djamdire/public_html/engine/lib/elgglib.php                     [line] => 784                     [function] => call_user_func_array                     [args] => Array                         (                             [0] => system_log_default_logger                             [1] => Array                                 (                                     [0] => log                                     [1] => systemlog                                     [2] => Array                                         (                                             [object] => ElggUser Object                                                 (                                                     [url_override:protected] =>                                                     [icon_override:protected] =>                                                     [temp_metadata:protected] => Array                                                         (                                                         )
                                                        [temp_annotations:protected] => Array                                                         (                                                         )
                                                        [temp_private_settings:protected] => Array                                                         (                                                         )
                                                        [volatile:protected] => Array                                                         (                                                         )
                                                        [attributes:protected] => Array                                                         (                                                             [guid] => 35                                                             [type] => user                                                             [subtype] => 0                                                             [owner_guid] => 0                                                             [site_guid] => 1                                                             [container_guid] => 0                                                             [access_id] => 2                                                             [time_created] => 1362440327                                                             [time_updated] => 1368427300                                                             [last_action] => 1368427323                                                             [enabled] => yes                                                             [tables_split] => 2                                                             [tables_loaded] => 2                                                             [name] => Rich Brunelle                                                             [username] => admin                                                             [password] => 7bf8997411a8c2ba12821115c6e043ba                                                             [salt] => sgeu6hej                                                             [email] => admin@djamdirectory.info                                                             [language] => en                                                             [code] =>                                                             [banned] => no                                                             [admin] => yes                                                             [prev_last_action] => 1368427318                                                             [last_login] => 1368427300                                                             [prev_last_login] => 1366228879                                                         )
                                                        [valid:protected] =>                                                 )
                                                [event] => update                                         )
                                    )
                            )
                    )
                [5] => Array                 (                     [file] => /home/djamdire/public_html/engine/lib/system_log.php                     [line] => 292                     [function] => elgg_trigger_event                     [args] => Array                         (                             [0] => log                             [1] => systemlog                             [2] => Array                                 (                                     [object] => ElggUser Object                                         (                                             [url_override:protected] =>                                             [icon_override:protected] =>                                             [temp_metadata:protected] => Array                                                 (                                                 )
                                                [temp_annotations:protected] => Array                                                 (                                                 )
                                                [temp_private_settings:protected] => Array                                                 (                                                 )
                                                [volatile:protected] => Array                                                 (                                                 )
                                                [attributes:protected] => Array                                                 (                                                     [guid] => 35                                                     [type] => user                                                     [subtype] => 0                                                     [owner_guid] => 0                                                     [site_guid] => 1                                                     [container_guid] => 0                                                     [access_id] => 2                                                     [time_created] => 1362440327                         &

  • I may have fixed it by using my PhpmyAdmin to repair the database table

  • That is the correct course of action, well done