Actually I have. This table should not exist and is referencing an orphaned table that had to be removed to perform a mysqldump. The mysqldump works now but it apparently has broken the save and preview functions of the wiki. I only posted it a few times because of the weekend and more traffic comes during the work week. Contrary to what you think, I have put allot of effort into this. There is only one knowledgebase reference to this and it is not the answer. This is not a mysql error, it is a mediawiki error. This wiki is a very large community effort with a couple of thousand pages. It would be devastating to have the efforts of 22 people ruined by my tinkering. I'm not a DBA by any stretch. I look to the mediawiki group for good solid answers, not smartypants ones. Brion Vibber <brion(a)pobox.com> wrote: -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Eccentric 67 wrote: I notice you've asked this question several times. The reason nobody's answering you is probably that you already have your answer right there, yet you've apparently put no effort into following through. According to the error message, you have a missing or damaged table. Please see general MySQL documentation or help forums for how to check table integrity. - -- brion vibber (brion @ pobox.com) _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l --------------------------------- Everyone is raving about the all-new Yahoo! Mail beta.

Actually I have. This table should not exist and is referencing an orphaned table that had to be removed to perform a mysqldump. The mysqldump works now but it apparently has broken the save and preview functions of the wiki. I only posted it a few times because of the weekend and more traffic comes during the work week. Contrary to what you think, I have put allot of effort into this. There is only one knowledgebase reference to this and it is not the answer. This is not a mysql error, it is a mediawiki error. This wiki is a very large community effort with a couple of thousand pages. It would be devastating to have the efforts of 22 people ruined by my tinkering. I'm not a DBA by any stretch. I look to the mediawiki group for good solid answers, not smartypants ones. Brion Vibber <brion(a)pobox.com> wrote: -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Eccentric 67 wrote: I notice you've asked this question several times. The reason nobody's answering you is probably that you already have your answer right there, yet you've apparently put no effort into following through. According to the error message, you have a missing or damaged table. Please see general MySQL documentation or help forums for how to check table integrity. - -- brion vibber (brion @ pobox.com) _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l --------------------------------- Any questions? Get answers on any topic at Yahoo! Answers. Try it now.

I did try the mysqldump on a fresh system with a fresh mediawiki install. This new system does the exact same thing. This only cropped up after the mysqldump problem was resolved by moving several orphaned *.frm files out that prevented database backups. Now it appears as if this has broken the save and preview functions. Fernando Correia <fernandoacorreia(a)gmail.com> wrote: It seems the table "archive" does not exist. It should, because it is used by MediaWiki. Or the "horsewiki.horse_" prefix is wrong. You could try installing a local copy of the wiki on your machine to make some experiments. Maybe restore a backup. 2006/12/5, Eccentric 67 : _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l --------------------------------- Everyone is raving about the all-new Yahoo! Mail beta.

If you have daily backups, maybe you should roll back to a point before this error. If not, maybe exporting the wiki and importing it again would solve it. Even if that means keeping only the current version, without the change history. I don't really know much about MySQL or MediaWiki. This general help is all I can give you. If that fails, maybe you can get some paid support by people more experienced in these tools. 2006/12/6, Brion Vibber <brion(a)pobox.com>om>: