View Full Version : fix the forum
JernejL
11-07-2008, 06:39 PM
Please? i'm getting these crashed database errors and others for last few days.
Could not delete old search id sessions
DEBUG MODE
SQL Error : 126 Incorrect key file for table './savage_phpb3/phpbb_search_results.MYI'; try to repair it
DELETE FROM phpbb_search_results WHERE search_time < 1215797832
Line : 658
File : search.php
savage
11-07-2008, 06:47 PM
I ran a repair yesterday. Are you still getting error?
JernejL
11-07-2008, 08:30 PM
I just got this one 2 seconds ago:
Could not insert search results
DEBUG MODE
SQL Error : 126 Incorrect key file for table './savage_phpb3/phpbb_search_results.MYI'; try to repair it
INSERT INTO phpbb_search_results (search_id, session_id, search_time, search_array) VALUES(1658649170, '481c0ef94f981876d7809caed19f6866', 1215808230, 'a:7:{s:14:"search_results";s:4:"5448";s:17:"total_match_count";i:1;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:6:"topics";s:12:"return_chars";i:200;}')
Line : 707
chronozphere
12-07-2008, 09:13 AM
I couldn't acces the PGD home page for hours because of this error. But everything seems to work fine now. :)
JernejL
22-07-2008, 04:50 PM
phpBB : Critical Error
Error doing DB query userdata row fetch
DEBUG MODE
SQL Error : 145 Table './savage_phpb3/phpbb_sessions' is marked as crashed and should be repaired
SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = 'da067f83824e49cbefc90bd9e8c6f19a' AND u.user_id = s.session_user_id
Line : 315
File : sessions.php
Yesterday this shown up for most of the day.
Legolas
22-07-2008, 06:36 PM
Dunno if it can help, but I would try a dump-frag-restore approach on the database. :think:
savage
24-07-2008, 07:43 PM
Sorry guys I've been way to busy to pay attention to the forums. I'm hoping that will change soon, but I need to talk to some people first.
Thanks for your patience.
JernejL
03-08-2008, 09:56 PM
The website was inaccessible due to corrupt table again this whole weekend..
savage
03-08-2008, 10:55 PM
I've been away all week-end. Should be better now.
Venomizer
26-09-2008, 02:16 AM
I keep geting it
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.