Subject: Re: phpBB and mysql
To: None <firstname.lastname@example.org>
From: Andy Ruhl <email@example.com>
Date: 08/28/2005 05:57:42
On 8/28/05, Rick Kelly <firstname.lastname@example.org> wrote:
> Rick Kelly said:
> >I do see one error in an ISAM file:
> >wolf# myisamchk --check phpbb_search_results.MYD
> >myisamchk: error: 'phpbb_search_results.MYD' doesn't have a correct inde=
x definition. You need to recreate it before you can do a repair
> >I have no idea how to recreate it...
> I managed to fix the broken table, but phpBB just doesn't talk to the
> database anymore. Due to the lack of php log files showing why it fails
> to connect, I will probably remove everything and start fresh with some
> other forum system.
I don't use MySQL (Postgres seems to make more sense to me), but I do
use phpbb. The only logical thing I can think of is maybe your phpbb
user no longer has rights to the tables it needs? In a crash, the only
likely thing to have happen with that setup is a database table might
be broken. I believe in MySQL you have to have a grant statement for
each table that a certain user gets access to, so maybe that's what it
is? Not sure...
The only time I ever had a problem, I restored my database and it came
back up, just with a few hours of missing posts.