View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0021624 | mantisbt | db postgresql | public | 2016-08-17 13:18 | 2019-09-04 03:08 |
Reporter | dana | Assigned To | dregad | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | no change required | ||
Product Version | 1.3.0 | ||||
Summary | 0021624: mantis_user_pref_table.redirect_delay should not be a boolean (broken Account Preferences) | ||||
Description | In My Account > Preferences, entering a Redirect Delay greater than 1 results in the following error: <blockquote> This appears to be because the <code>mantis_user_pref_table.redirect_delay</code> field in the database is type <code>boolean</code> instead of <code>integer</code>. | ||||
Steps To Reproduce |
| ||||
Additional Information | Configuration info: Ubuntu 14.04 Trusty We've been using the same Mantis installation since 2007 so it's gone through a lot of upgrades; not sure when the problem started. | ||||
Tags | No tags attached. | ||||
Hello, This column was initially (i.e. in pre 1.2 days) defined as type 'L' [1], which actually translates to Boolean under pgsql. In 1.2.0a1 the type was changed to integer [2], so the installer should have updated the column as part of the upgrade process. Have you always been running under PostgreSQL ? If so, did you manually create or update the schema at some point ? In any case, I am not able to reproduce this behavior; a fresh pgsql install shows the column correctly defined as follows: <pre>redirect_delay integer NOT NULL DEFAULT 0</pre>. I would suggest you compare your current schema with one from a fresh install, to identify any discrepancies. [1] https://github.com/mantisbt/mantisbt/blob/release-1.3.0/admin/schema.php#L356 |
|
Hmm. It could be that one of my predecessors failed to upgrade it correctly. I'll update the schema manually, thank you. |
|
Thanks for your feedback. I'm resolving this as no change required; feel free to reopen if you feel this was caused by a bug in Mantis. |
|