I&
#039;m using Mantis 1.1.2, and when I install plugin LongCF 0.0.4 from the link "Available plugin list", I got below error:
Quote
Check packager version 0.4.0
Plugin name LongCF
Plugin version 0.0.4
Check the Apache version No test performed/required
Check the PHP version OK
Check the SQL version No test performed/required
Check the Mantis version OK
Check the Plugins version OK
Install or Upgrade?
APPLICATION ERROR
#401
Database query failed. Error received from database was
#1101: BLOB/TEXT column &
#039;value&
#039; can&
#039;t have a default value for the query: CREATE TABLE IF NOT EXISTS mantis_plugins_longcf_custom_field_string_table ( field_id INT(11) NOT NULL DEFAULT 0, bug_id INT(11) NOT NULL DEFAULT 0, value TEXT NOT NULL DEFAULT &
#039;&
#039;, PRIMARY KEY ( field_id, bug_id ), KEY `idx_custom_field_bug` (`bug_id`) )
Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.
It seems there&
#039;s a error in creating table SQL. I guess we can change the part "value TEXT NOT NULL DEFAULT &
#039;&
#039;" to "value TEXT NOT NULL". But I can&
#039;t modify the source code because it&
#039;s in .pkg format.
Please fix this, or, tell me how to unpack the .pkg file.
Thanks in advance.
Edited 1 time(s). Last edit at 05/14/2009 04:29AM by superbible.