Help My Site Has Crashed!
By RichBrunelle
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
Elgg Technical Support
Get support from other Elgg users
- Matt Beckett@Beck24
Matt Beckett - 0 likes
- RichBrunelle@richbrunelle
RichBrunelle - 0 likes
- RichBrunelle@richbrunelle
RichBrunelle - 0 likes
- Matt Beckett@Beck24
Matt Beckett - 0 likes
You must log in to post replies.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