Over the past couple of days, I have been trying to install and configure all the required programs for MediaWiki. That includes Apache server, PHP 5.x.x, and MySQL 4+. I got Apache 2.2.4 and PHP 5.2.1 installed and running; I made sure by copying some PHP files from one of my websites to Apache's htdocs directory and going to http://localhost/cada/, which if the server was working would display the files I had just copied. (I configured Apache to just show up as localhost, to the best of my knowledge.) The index.php file showed up just like it would over the Internet. First milestone.
I then (foolishly) tried to run MediaWiki 1.8.2, and the setup script (obviously) gave me an error, since MySQL was not yet present. I installed it and waded through its configuration wizard as best I could. Then I tried again with MediaWiki's setup script. It complained again, saying that PHP didn't have database drivers. I installed both the mysql and mysqli extensions, just to be safe. Then I tried the script once more. Success! It said, "Environment checked, you can install MediaWiki!" Yes!
I filled in all my info, including the root user for MySQL, and hit the install button. MediaWiki came back with a truncated result page. After a couple more failures I eventually decided to create a user for MediaWiki manually through phpMyAdmin, which I had stored along with MediaWiki (I don't remember if I also created the database manually). Once I did that, I went back to the setup script and entered the user info and left the root blank. I made it to the next stage: bad SQL files.
Somehow, the SQL files included with MediaWiki 1.8.2 had a plethora of errors, which I tried and failed to correct (I don't know SQL), clearing the tables from the database before each successive test to prevent errors. (MediaWiki can deal with an empty database and a pre-existing one, but I found that partial wikidbs can cause hiccups.) The first errors were pretty simple to fix -- they involved just removing "DEFAULT" statements -- but then I ran into a cryptic error, something involving "sub-strings," and couldn't continue fixing things (the MySQL engine would stop at the first error). I had to give up temporarily, but I vowed to get the newest MediaWiki version the next time I got Internet access.
It turned out I was several versions behind. MediaWiki 1.8.2 was long gone, replaced by version 1.9.3. I downloaded and unpacked the new version, then copied it to my htdocs folder (under a different subdirectory, so as not to overwrite my old version). I gave the setup script in the new version the same information, clicked the install button, and was quickly congratulated by MediaWiki, which gave me instructions to move the configuration file to the main directory. I did so and then clicked the link to "your wiki".
12 hours ago





