New subject: [Mediawiki-l] Can't Delete Page & Corresponding Category - MySQL

21 Dec 2006


      Hey everyone,
Sorry to be a pain but I have a problem, and I almost thought I had fixed
it, following the instructions you can get by following this:
http://mail.wikipedia.org/pipermail/mediawiki-l/2006-September/014816.html.
If you go to next message a few times you get 2 commands, and later 1
command, for a total of 3 commands to run.  So I read it, and not being the
MySQL, or SQL anything for that matter, expert I can assume some MediaWiki
users are, I need some assistance converting this solution into something
usable for MySQL.  The problem is, there is no "drop constraint" in MySQL.
There is "add constraint", but no drop.  So this leaves me in a kind of a
pickle.
If I go to the page that I want to delete, it deletes all of the content but
if I revisit it, it says:  "This page has no text, you can search for the
page or edit it" or something to that effect.
Also mentioned in the article above, is this issue has been resolved in
subversion 15672.  Although it doesn't mention what version the issue is in
anyway.  Seeing as I got my version last week, Friday, December 15th 2006 I
do believe, I think I should at least have that.  For arguments sake, I have
MediaWiki 1.8.2.....  Assuming that subversion 15672 is 1.8.15672, it looks
like it isn't resolved, unless, I have a different version altogether.
So I'm stuck with an empty page and a Special:Categories reference to a page
that doesn't even have a [[Category:name]] to reference it.  It's completely
blank.
What I'm really asking is: What can someone with MySQL do to resolve this
issue?  Since it gives me a syntax error at "constraints" when I tried the
solution provided in a response to the link above.  (The solution is linked
from there but that is the parent message)
Any ideas or solutions would be greatly appreciated.  I thought about
dropping foreign keys but like I said, I'm no SQL expert and you usually
make constraints on foreign keys.