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|
|Status||closed||Resolution||no change required|
|Summary||0021624: mantis_user_pref_table.redirect_delay should not be a boolean (broken Account Preferences)|
In My Account > Preferences, entering a Redirect Delay greater than 1 results in the following error:
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|
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.|
This column was initially (i.e. in pre 1.2 days) defined as type 'L' , which actually translates to Boolean under pgsql.
In 1.2.0a1 the type was changed to integer , 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.
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.
|2016-08-17 13:18||dana||New Issue|
|2016-08-17 19:13||dregad||Status||new => feedback|
|2016-08-17 19:13||dregad||Note Added: 0053838|
|2016-08-17 19:16||dana||Note Added: 0053839|
|2016-08-17 19:16||dana||Status||feedback => new|
|2016-08-17 19:42||dregad||Assigned To||=> dregad|
|2016-08-17 19:42||dregad||Status||new => resolved|
|2016-08-17 19:42||dregad||Resolution||open => no change required|
|2016-08-17 19:42||dregad||Note Added: 0053840|
|2016-08-28 01:18||vboctor||Status||resolved => closed|
|2019-09-04 03:08||dregad||Relationship added||related to 0026109|