PDA

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 &#58; 658
File &#58; 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 &#58; 126 Incorrect key file for table './savage_phpb3/phpbb_search_results.MYI'; try to repair it

INSERT INTO phpbb_search_results &#40;search_id, session_id, search_time, search_array&#41; VALUES&#40;1658649170, '481c0ef94f981876d7809caed19f6866', 1215808230, 'a&#58;7&#58;&#123;s&#58;14&#58;"search_results";s&#58;4&#58;"5448";s&#58;17&#58;"total_match_count";i&#58;1;s&#58;12&#58;"split_search";N;s&#58;7&#58;"sort_by";i&#58;0;s&#58;8&#58;"sort_dir";s&#58;4&#58;"DESC";s&#58;12&#58;"show_results";s&#58;6&#58;"topics";s&#58;12&#58;"return_chars";i&#58;200;&#125;'&#41;

Line &#58; 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 &#58; Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error &#58; 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 &#58; 315
File &#58; 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