On 21/12/06, Wayne Marsh wayne.marsh@aldatasoftware.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/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.
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