Mantis

[Resolved] Installation of LongCF 0.0.4 failed

Posted by superbible 
[Resolved] Installation of LongCF 0.0.4 failed
May 14, 2009 04:27AM
I'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 'value' can'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 '', 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's a error in creating table SQL. I guess we can change the part "value TEXT NOT NULL DEFAULT ''" to "value TEXT NOT NULL". But I can't modify the source code because it'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.
Re: Installation of LongCF 0.0.4 failed
May 14, 2009 09:23AM
What is your SQL server?

Vincent


Mantis: 1.1.0, 1.1.5, 1.1.1
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux

Please complete your signature with your environment informations.
Enable skype notification here
Re: Installation of LongCF 0.0.4 failed
May 19, 2009 03:16AM
I'm using MySQL 5.0.77 on Windows XP.
Re: Installation of LongCF 0.0.4 failed
May 19, 2009 08:32AM
Ok, I'll try to regenerate a new package ASAP.

Vincent


Mantis: 1.1.0, 1.1.5, 1.1.1
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux

Please complete your signature with your environment informations.
Enable skype notification here
Re: Installation of LongCF 0.0.4 failed
May 27, 2009 07:14AM
You can try this one.

Vincent


Mantis: 1.1.0, 1.1.5, 1.1.1
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux

Please complete your signature with your environment informations.
Enable skype notification here



Edited 1 time(s). Last edit at 05/27/2009 07:15AM by deboutv.
Re: Installation of LongCF 0.0.4 failed
June 18, 2009 09:53AM
Thanks. Your new plugin works.
Re: Installation of LongCF 0.0.4 failed
January 19, 2010 02:22PM
Dear deboutv,

The longcf-0.0.5a1.mantis.pkg isn't posted at [deboutv.free.fr].

Thanks in advance and sorry my poor english.

Minote.
Sorry, only registered users may post in this forum.

Click here to login



Online Users

Guests: 2
Record Number of Users: 1 on April 02, 2023
Record Number of Guests: 115 on November 09, 2023
Top Users
Hébergeur : Morinie.Fr