Re: There are no articles on the site

[Davyd Madeley <davyd madeley id au>]

On Thu, Nov 29, 2007 at 09:04:32AM -0500, Jim Hodapp wrote:
> Nice, thanks Davyd. I think this has happened before. MySQL's fault or
> TextPatterns, now that's the question.

It seems related to using the editing functionality in Textpattern.
I know that doesn't really point the finger, but while MySQL has
some 'issues', I've never seen it have consistent corruption on this
scale.

--d

> Jim
> 
> On Nov 29, 2007 9:02 AM, Davyd Madeley < davyd madeley id au> wrote:
> 
>     On Thu, Nov 29, 2007 at 07:04:07AM -0500, Ken VanDine wrote:
>     > I just got an email from someone pointing out that there are no past or
>     > present articles on the site.  Can someone look into it?
> 
>     Fixed.
> 
>     The magic, from master.gnome.org is:
> 
>     mysql -u gnomejournal -h button-back gnomejournal
> 
>     Then:
>     REPAIR TABLE gj_textpattern EXTENDED;
> 
>     To test:
>     select Title from gj_textpattern;
> 
>     Regards,
>     --d
> 
>     --
>     Davyd Madeley
> 
>     http://www.davyd.id.au/
>     08B0 341A 0B9B 08BB 2118  C060 2EDD BB4F 5191 6CDA
>     _______________________________________________
>     Gnome-journal-list mailing list
>     Gnome-journal-list gnome org
>     http://mail.gnome.org/mailman/listinfo/gnome-journal-list
> 
> 

-- 
Davyd Madeley

http://www.davyd.id.au/
08B0 341A 0B9B 08BB 2118  C060 2EDD BB4F 5191 6CDA