View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0011586mantisbtcustom fieldspublic2010-03-01 15:302012-10-22 15:54
Reporterjmunro Assigned Todhx  
PrioritynormalSeveritycrashReproducibilityalways
Status closedResolutionunable to reproduce 
Product Version1.2.0 
Summary0011586: Application Error 0000401 when attempting to add a Custom Field
Description

I am trying to create a Custom Field called "Jade Contact", but every time I click New Custom Field, I get an error 401.

Additional Information

APPLICATION ERROR 0000401

Database query failed. Error received from database was #1364: Field 'default_value' doesn't have a default value for the query: INSERT INTO mantis_custom_field_table
( name, possible_values )
VALUES
( ?,?).

TagsNo tags attached.

Activities

dhx

dhx

2010-03-04 02:56

reporter   ~0024621

Which database backend do you use? Which database version?

The column is created with:

default_value C(255) NOTNULL DEFAULT ''

So I assume that if you don't specify a value for default_value on the INSERT statement, it'll just revert to being a blank string.
jmunro

jmunro

2010-03-04 10:33

reporter   ~0024638

I am using MySQL v5.1.32

How can i specify a default value? manage_custom_field_page.php only has one text box on it, for the name of the custom field to create...
dhx

dhx

2010-03-12 07:29

reporter   ~0024706

I can't see how the error you're describing would appear upon submitting the name of a custom field to add. The default value field is specified on the next page, after you've specified the name of the new field.

Can anyone else reproduce this error (because I can't)?
kma

kma

2010-07-07 02:23

reporter   ~0026031

Last edited: 2010-07-07 02:31

I have the exact same problem.

If i type in a custom field name and push the button, then it gives the exact same warning as mentioned in this issue.

I have administrator rights and have checked that i'm allowed to add custom fields.

We're running mantis 1.2.0 on a Windows 2000 machine with MySQL as database.
kma

kma

2010-11-02 03:27

reporter   ~0027213

To fix this bug you need to open the table mantis_custom_field_table in MySQL Administrator and assign a default value to all VARCHAR fields.

After this, you can create custom fields in Mantis Management again.
dregad

dregad

2012-10-10 13:05

developer   ~0033135

This issue is not reproducible with the current version of MantisBT.

We recommend that you upgrade to the latest stable version [1]; if after doing so the problem persists, do not hesitate to reopen the issue, with additional relevant information.

[1] https://sourceforge.net/projects/mantisbt/files/mantis-stable/