View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0006638 | mantisbt | sql | public | 2006-01-26 03:58 | 2006-04-20 06:23 |
Reporter | waldo | Assigned To | thraxisp | ||
Priority | normal | Severity | block | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Platform | Win32 / MySQL 5.0.18 / PHP 5.1.1 | OS | Windows 2003 server | OS Version | 2003 |
Product Version | 1.0.0rc5 | ||||
Fixed in Version | 1.0.2 | ||||
Summary | 0006638: 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, Database query failed. | ||||
Tags | No tags attached. | ||||
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. |
|
thraxisp, thanks, but I did that at the time of upgrade. No joy. The check.php script does return some BAD statuses, but that's related to e-mail notifications and file uploads which I temporarily disabled. |
|
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. |
|
There are a number of changes required to support MySQL 5.0. |
|
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" ? >:) |
|
Fixed in CVS CVS HEAD: 1.0.2 branch |
|