Last modified: 2007-12-05 20:34:36 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T13915, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 11915 - SQL Error On The MamboWiki Component
SQL Error On The MamboWiki Component
Status: RESOLVED INVALID
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
unspecified
PC Windows XP
: Normal blocker (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2007-11-09 23:54 UTC by Chris Rutherfurd
Modified: 2007-12-05 20:34 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Chris Rutherfurd 2007-11-09 23:54:15 UTC
* PHP 5.2.4: ok
* PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title)
* Have XML / Latin1-UTF-8 conversion support.
* PHP's memory_limit is 8M. If this is too low, installation may fail! Attempting to raise limit to 20M... ok.
* Have zlib support; enabling output compression.
* Neither Turck MMCache nor eAccelerator are installed, can't use object caching functions
* GNU diff3 not found.
* Couldn't find GD library or ImageMagick; image thumbnailing disabled.
* Installation directory: C:\wamp\www\Joomla2\components\com_mambowiki
* Script URI path: /joomla2/components/com_mambowiki
* Connecting to joomla2 on dbserver as root...success.
* Connected to 5.0.45-community-nt; using enhancements for mySQL 4.
Current directory is C:\wamp\www\Joomla2\components\com_mambowiki\config
* Creating tables... using MySQL 3/4 table defs...Query "CREATE TABLE wiki_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_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 '', user_token char(32) binary NOT NULL default '', user_email_authenticated CHAR(14) BINARY, user_email_token CHAR(32) BINARY, user_email_token_expires CHAR(14) BINARY, PRIMARY KEY user_id (user_id), UNIQUE INDEX user_name (user_name), INDEX (user_email_token) ) TYPE=InnoDB" failed with error code "BLOB/TEXT column 'user_password' can't have a default value".
Comment 1 Chris Rutherfurd 2007-11-09 23:56:01 UTC
This error is in relation to the mambowiki component.
Comment 2 Brion Vibber 2007-12-05 20:34:36 UTC
Well, MamboWiki looks like something unrelated to MediaWiki, or at least not under our control.

But offhand the error message you show looks like you're running older MySQL 3/4 table definitions on a version of MySQL 5 configured with extremely strict mode (which is sometimes the default on Windows, but not usually on other operating systems because this default is only in the *windows installer* and not in MySQL itself).

Upgrade MediaWiki to a more modern version which uses kinder, gentler settings, or disable strict mode on your mysql server.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links