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
--
Travis McArthur
Systems Administrator