i've been investigating more of your wonderful plugins recently, but have run into an issue where two of them failed during installation, but are listed in the Mantis app, and are not uninstallable.

specifically, CFNotes and LongCF failed, and here is what i see in the plugin list:

Plugin:   Website   Installed / Current Version   Uninstall a Plugin
CFNotes    www [^]   0.0.5 / -    Install 
LongCF     www [^]   0.0.3 / -    Install

notice it doesn't have an uninstall link. worse still, when i view bugs i get the following error:

APPLICATION ERROR #401 
Database query failed
Error received from database was #1146:
Table 'mantis.mantis_plugins_longcf_custom_field_string_table' doesn't exist for the query:
SELECT value
FROM mantis_plugins_longcf_custom_field_string_table
WHERE bug_id='3' AND
field_id='1'
 
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.

as the error message suggests, the table was not created when the plugin was installed. in a previous post of mine you had me make sure that my 'mantis' db user had sufficient privs, and i've given it all rights against the 'mantis' schema, so that shouldn't be an issue. plus i've verified via straight SQL that "create table" is allowed.

any ideas on this? is there a manual way to uninstall these plugins?

btw, here is the error message when trying to install LongCF 0.4.0. i'm running Mantis 1.1.4 against MySQL 5.0.67..

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`)
)

Try to install these versions:

CFNotes
LongCF

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

that fixed the problem. i successfully installed the updated plugins, was able to configure them, and use them as expected.

thanks so much for the quick response and fixes.

the community of mantis, especially you and and your quick responses, are likely what will tip us to go with Mantis instead of the other bug-tracking systems we're evaluating.

dlgrasse