Can't Delete Page & Corresponding Category - MySQL

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/m
ediawiki-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.
 
 
 

 

_______________________________________________
MediaWiki-l mailing list
MediaWiki-lWikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l

On 21/12/06, Wayne Marsh <wayne.marshaldatasoftware.com> wrote:
> 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/m
ediawiki-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.

Can you explain why you need to apply that solution to a
MediaWiki
installation running on MySQL?

> 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.

Yes, that's correct...

> 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

No, the "Subversion revision" doesn't correspond
to the MediaWiki
version numbers, it just tracks what revision the entire
source code
repository is at.

MediaWiki 1.8.2 was tagged from the 1.8 release branch,
which was made
from r16913, so the fix in question was resolved in all
1.8.x
versions.

> 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 page is empty? What does "empty" mean here?

> 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)

If you have a dud category link entry, then run the
maintenance/refreshLinks.php script to clear out and update
all the
link tables. This will fix any glitches or other data
corruption which
might have occurred.


Rob Church
_______________________________________________
MediaWiki-l mailing list
MediaWiki-lWikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l