View Issue Details

IDProjectCategoryView StatusLast Update
0006638mantisbtsqlpublic2006-04-20 06:23
Reporterwaldo Assigned Tothraxisp  
PrioritynormalSeverityblockReproducibilityalways
Status closedResolutionfixed 
PlatformWin32 / MySQL 5.0.18 / PHP 5.1.1OSWindows 2003 serverOS Version2003
Product Version1.0.0rc5 
Fixed in Version1.0.2 
Summary0006638: Can't submit issues after upgrading from 0.18.2 - SQL error #1364
Description

Whenever I try to submit an entry to my Mantis installation,
I get the following error:

Database query failed.
Error received from database was #1364: Field 'fixed_in_version' doesn't have a default value for the query: INSERT INTO mantis_bug_table
( project_id,
reporter_id, handler_id,
duplicate_id, priority,
severity, reproducibility,
status, resolution,
projection, category,
date_submitted, last_updated,
eta, bug_text_id,
os, os_build,
platform, version,
build,
profile_id, summary, view_state, sponsorship_total, sticky )
VALUES etc...

TagsNo tags attached.

Relationships

child of 0006907 closedvboctor Mantis 1.0.2 Release 

Activities

thraxisp

thraxisp

2006-01-26 21:37

reporter   ~0012026

You need to update the database schema after any upgrade in the source tool. In your case, you need to run the "admin/upgrade.php" script.

waldo

waldo

2006-01-28 01:38

reporter   ~0012033

thraxisp, thanks, but I did that at the time of upgrade. No joy.
I remember seeing a checklist of database upgrade steps, but I don't know whether that checklist is available now.

The check.php script does return some BAD statuses, but that's related to e-mail notifications and file uploads which I temporarily disabled.
Everything else look ok to me, but I keep getting the #1364 error.
Mind you, the MySQL engine is version 5.0.

waldo

waldo

2006-01-30 18:18

reporter   ~0012045

I've worked around this by modifying the 'mantis_bug_table.fixed_in_version' field so as to allow NULL values, and it seems to be working now.

thraxisp

thraxisp

2006-01-31 07:45

reporter   ~0012049

There are a number of changes required to support MySQL 5.0.

waldo

waldo

2006-01-31 11:24

reporter   ~0012051

Last edited: 2006-01-31 11:25

It would be really cute if someone could update the Mantis "Requirements" page (http://www.mantisbt.org/requirements.php), presently stating clearly that "MySQL database 3.23.2 and higher" is sufficient for running Mantis.

How about "MySQL database 3.23.2 up to 4.9.9" ? >:)

thraxisp

thraxisp

2006-04-17 20:53

reporter   ~0012563

Fixed in CVS

CVS HEAD:
admin/upgrades/1_00_inc.php -> 1.11
core/bug_api.php -> 1.100

1.0.2 branch
admin/upgrades/1_00_inc.php -> 1.9.12.1
core/bug_api.php -> 1.95.8.1.6.1