Had a test site running fine for several weeks and not changed anything for over 2 weeks but got a Fatal Error. I wonder if any of you experts can tell me why from the server log...
[Sat Oct 20 15:20:18 2012] [error] [client 212.113.35.162] PHP WARNING: 2012-10-20 15:20:18 (BST): "file_get_contents(/tmp/sess_04b1bpccljvpf8rkoeni2hbc02): failed to open stream: No such file or directory" in file /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/sessions.php (line 551)
[Sat Oct 20 15:20:18 2012] [error] [client 212.113.35.162] Deprecated in 1.8: register_elgg_event_handler() was deprecated by elgg_register_event_handler() Called from [#6] /home/sites/thealbertinn.com/public_html/social_albert/mod/time/start.php:42
[Sat Oct 20 15:20:18 2012] [error] [client 212.113.35.162] Deprecated in 1.8: register_elgg_event_handler() was deprecated by elgg_register_event_handler() Called from [#6] /home/sites/thealbertinn.com/public_html/social_albert/mod/smart_theme/start.php:3
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] Exception #1350742833: exception 'DatabaseException' with message 'Table './web53@002dnawtnet/elgg_users_entity' is marked as crashed and should be repaired, referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] , referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] QUERY: SELECT * from elgg_users_entity where guid=115' in /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/database.php:261, referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] Stack trace:, referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #0 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/database.php(405): execute_query('SELECT * from e...', Resource id #55), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #1 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/database.php(366): elgg_query_runner('SELECT * from e...', '', true), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #2 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/users.php(30): get_data_row('SELECT * from e...'), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #3 /home/sites/thealbertinn.com/public_html/social_albert/engine/classes/ElggUser.php(126): get_user_entity_as_row('115'), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #4 /home/sites/thealbertinn.com/public_html/social_albert/engine/classes/ElggUser.php(64): ElggUser->load(Object(stdClass)), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #5 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/entities.php(644): ElggUser->__construct(Object(stdClass)), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #6 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/entities.php(697): entity_row_to_elggstar(Object(stdClass)), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #7 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/users.php(534): get_entity(115), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #8 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/sessions.php(430): get_user(115), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #9 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/elgglib.php(2121): _elgg_session_boot(), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #10 [internal function]: _elgg_engine_boot('boot', 'system', NULL), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #11 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/elgglib.php(773): call_user_func_array('_elgg_engine_bo...', Array), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #12 /home/sites/thealbertinn.com/public_html/social_albert/engine/start.php(99): elgg_trigger_event('boot', 'system'), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #13 /home/sites/thealbertinn.com/public_html/social_albert/index.php(12): require_once('/home/sites/the...'), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #14 {main}, referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] File does not exist: /home/sites/thealbertinn.com/public_html/social_albert/favicon.ico
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] Exception #1350742854: exception 'DatabaseException' with message 'Table './web53@002dnawtnet/elgg_users_entity' is marked as crashed and should be repaired, referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] , referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] QUERY: SELECT * from elgg_users_entity where guid=115' in /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/database.php:261, referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] Stack trace:, referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #0 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/database.php(405): execute_query('SELECT * from e...', Resource id #55), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #1 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/database.php(366): elgg_query_runner('SELECT * from e...', '', true), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #2 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/users.php(30): get_data_row('SELECT * from e...'), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #3 /home/sites/thealbertinn.com/public_html/social_albert/engine/classes/ElggUser.php(126): get_user_entity_as_row('115'), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #4 /home/sites/thealbertinn.com/public_html/social_albert/engine/classes/ElggUser.php(64): ElggUser->load(Object(stdClass)), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #5 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/entities.php(644): ElggUser->__construct(Object(stdClass)), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #6 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/entities.php(697): entity_row_to_elggstar(Object(stdClass)), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #7 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/users.php(534): get_entity(115), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #8 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/sessions.php(430): get_user(115), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #9 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/elgglib.php(2121): _elgg_session_boot(), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #10 [internal function]: _elgg_engine_boot('boot', 'system', NULL), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #11 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/elgglib.php(773): call_user_func_array('_elgg_engine_bo...', Array), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #12 /home/sites/thealbertinn.com/public_html/social_albert/engine/start.php(99): elgg_trigger_event('boot', 'system'), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #13 /home/sites/thealbertinn.com/public_html/social_albert/engine/handlers/action_handler.php(17): require_once('/home/sites/the...'), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #14 {main}, referer: http://community.thealbertinn.com/activity
Thanks
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by RaĆ¼l Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
- iconMatrix@SteveAquila
iconMatrix - 0 likes
- Brett@brett.profitt
Brett - 0 likes
- Burgs@burgs
Burgs - 0 likes
- Burgs@burgs
Burgs - 0 likes
- Team Webgalli@webgalli
Team Webgalli - 0 likes
- Burgs@burgs
Burgs - 0 likes
- Burgs@burgs
Burgs - 0 likes
- Steve Clay@steve_clay
Steve Clay - 0 likes
- Burgs@burgs
Burgs - 0 likes
You must log in to post replies.this looks suspect to me, is that a deleted user?
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] Exception #1350742833: exception 'DatabaseException' with message 'Table './web53@002dnawtnet/elgg_users_entity' is marked as crashed and should be repaired, referer: http://aidnabet.com/index
Like Steve pointed out, you need to repair your database tables. This should be an option in your database management interface if you don't know how to do it manually.
Thanks Steve & Bret... I'm on shared hosting and the MySQL database can be managed via phpMyAdmin. I can see that 2 tables...
elgg_users_entity
elgg_users_sessions
Both are listed as "IN USE" unlike any other table and if I select either of them it states in RED...
"marked as crashed and should be repaired" but I cannot find any method to repair them. Any ideas anyone?
I have read many times on here "keep out of the database" Should I be worried? :)
Go to phpmyadmin > select the db > in the bottom. you will see a link called select all (click that) > next to that there is a pull down showing with the selected, select an action > Select repair option. Thats it.
@TW... SpotOn thanks.
One more Q... Most tables in the DB are TYPE - MyISAM, Collation - utf8_general_ci
But a couple are TYPE - MEMORY, Collation - latin1_swedish_ci
Why is that when my website is English (UK)?
Oh, any clues to how the DB crashed would be helpful.
I've never been able to pinpoint how tables crash under normal situations, but power outages/OS crashes can break them.
Table charset has nothing to do with the language of the content, though collation can affect sorting strings.
Thanks everyone, great support.