[Imc-web] can't edit my article on IMC web site...

[Daniel S. Lewart]

Randall,

> I posted an article earlier today "Looming Censorship of "Democracy Now!" by
> Urbana mayor (and how you can stop it)". I'd like to make some typographical
> corrections and later add some sound files, but whenever I try to edit the
> article, I get the following error message:

> Database Query Error
> Duplicate entry 'Looming Censorship of "Democracy Now!" by Urbana mayor (and
> how you can stop it)-T-M' for key 4

> At first, I got a different "Database Query Error", something about "no
> table for 'articles'" or something like that (sorry I don't have that
> verbatim for you).

> To clarify, I get these errors after clicking the "Submit Article" button on
> the "Edit Article" page after making changes in the article submission form.

Thank you for reporting this!  The articles table index was corrupt,
but I was able to repair it.  Below are the details.  Then I deleted
article 20109, leaving article 20110.

Peace!
Dan

mysql> check table articles;
+----------+-------+----------+------------------------------------------------+
| Table    | Op    | Msg_type | Msg_text                                       |
+----------+-------+----------+------------------------------------------------+
| articles | check | warning  | Table is marked as crashed                     |
| articles | check | warning  | 10 clients is using or hasn't closed the table |
|          |       |          | properly                                       |
| articles | check | error    | Found 19895 keys of 19896                      |
| articles | check | error    | Corrupt                                        |
+----------+-------+----------+------------------------------------------------+
4 rows in set (0.01 sec)

mysql> repair table articles;
+----------------+--------+----------+----------+
| Table          | Op     | Msg_type | Msg_text |
+----------------+--------+----------+----------+
| ucimc.articles | repair | status   | OK       |
+----------------+--------+----------+----------+
1 row in set (1 min 55.64 sec)

mysql> check table articles;
+----------------+-------+----------+----------+
| Table          | Op    | Msg_type | Msg_text |
+----------------+-------+----------+----------+
| ucimc.articles | check | status   | OK       |
+----------------+-------+----------+----------+
1 row in set (12.89 sec)