You are not logged in.

#1 2005-12-11 11:13:08

arooaroo
Member
From: London, UK
Registered: 2005-01-13
Posts: 1,268
Website

SQL error for searches within Arch forums

Hi guys,

Since last night, when ever I try to run a search, whether it be a pre-defined search like New Posts or last 12h, or a keyword search within the search page, I get an error:

Could not delete old search id sessions

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_search_results.MYI' (errno: 145)

DELETE FROM phpbb_search_results WHERE session_id NOT IN ('b8a882a76bd524ca2cae00763907813a', 'ff63868080729e0ee81c83f1e2b08fac', '153ae6e2b7dfa3b1acab764caf6251a9', '61230f3df774fc9e05bbd91b9de8ab6a', 'ebea35cab271f97e47a0edeb867f350b', '852bae4b6e661b50c6e656eacab5204f', '874a6ac043dfb52bd2162d92f3700b28',
... (goes on for ages) ...
'eb520a66784db4079cf64fbf16316d65', '9f2f2ebe525f98222e32c1cefffd7ea1')

Line : 663
File : search.php

This is rather annoying as I can't look for the latest posts easily.

Offline

#2 2005-12-11 12:39:01

T-Dawg
Forum Fellow
From: Wilmington, NC
Registered: 2005-01-29
Posts: 2,734

Re: SQL error for searches within Arch forums

There's already a discussion about it here:
http://bbs.archlinux.org/viewtopic.php?t=17004

Locking to keep continuity.

Offline

Board footer

Powered by FluxBB