Hello,
I submitted the following problem within the mediawiki irc chat, and it was suggested I mail this list to get some help. Please excuse me if this problem is on my end and an obvious issue, I have not managed to locate it in any FAQs.
The basic issue is that the installation of MediaWiki fails with the following messages:
PHP 4.3.10: ok
PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title)
Have XML / Latin1-UTF-8 conversion support.
PHP is configured with no memory_limit.
Have zlib support; enabling output compression.
Found ImageMagick: /usr/local/bin/convert; image thumbnailing will be enabled if you enable uploads.
Installation directory: /usr/local/webroot/users/travis/wiki
Script URI path: /wiki
Connected as root (automatic)
Connected to database... 4.1.10; enabling MySQL 4 enhancements
Created database wiki
Creating tables...Query "CREATE TABLE user ( user_id int(5) unsigned NOT NULL auto_increment, user_name varchar(255) binary NOT NULL default '''', user_real_name varchar(255) binary NOT NULL default '''', user_rights tinyblob NOT NULL default '''', user_password tinyblob NOT NULL default '''', user_newpassword tinyblob NOT NULL default '''', user_email tinytext NOT NULL default '''', user_options blob NOT NULL default '''', user_touched char(14) binary NOT NULL default '''', UNIQUE KEY user_id (user_id) ) PACK_KEYS=1" failed with error code "BLOB/TEXT column 'user_rights' can't have a default value".
Obviously, mysql does support this. The first time I got this error, I modified tables.sql to add a "use wiki:" line, and fed it into the CLI mysql client, and it created everything. I did the same with interwiki and indexes, and proceeded to hack config/index.cgi to force it to continue as though the database had just been initialized, the tables just created, and it needed to setup the DB (I commented out the lines which executed tables.sql et al, and added a && 0 to the if statement which checks if tables exist). This let it go a bit further, to the point where it would initialize the mediawiki namespace, where it would then fail with yet another improper query error.
My initial thoughts were that perhaps my php installation was corrupt, I reinstalled it (upgraded it, actually, from 4.3.8 to 4.3.10) and specified the correct mysql header location. All other php scripts work flawlessly, as dose mysql.
Below is the output from php -v, apache -v, mysqld -V, and uname -prs.
PHP 4.3.10 (cli) (built: Mar 6 2005 08:53:09) Copyright (c) 1997-2004 The PHP Group Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
Server version: Apache/2.0.53 Server built: Feb 10 2005 11:08:01
/usr/local/libexec/mysqld Ver 4.1.10 for portbld-freebsd5.3 on i386 (FreeBSD port: mysql-server-4.1.10)
FreeBSD 5.3-RELEASE i386
Thanks alot, Travis