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.