fix the forum

[JernejL]

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]

I ran a repair yesterday. Are you still getting error?

[JernejL]

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]

I couldn't acces the PGD home page for hours because of this error. But everything seems to work fine now.

[JernejL]

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]

Dunno if it can help, but I would try a dump-frag-restore approach on the database. :think:

[savage]

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]

The website was inaccessible due to corrupt table again this whole weekend..

[savage]

I've been away all week-end. Should be better now.

[Venomizer]

I keep geting it