Arch Linux

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.

---

arooaroo | Jacman (Pacman GUI) | Getting to Grips with LaTeX | flickr

T-Dawg

Forum Fellow

From: Charlotte, NC

Registered: 2005-01-29

Posts: 2,736

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.