reset pwd link 401 error

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
tparry
Posts: 4
Joined: 12 Aug 2015, 13:35

reset pwd link 401 error

Post by tparry »

Having just installed mantis 1.2.9 using PgSql 7.4.19
I reset password of a user just added and I get this error message on the link provided in the email:

Code: Select all

APPLICATION ERROR #401

Database query failed. Error received from database was #-1: ERROR: invalid input syntax for type boolean: "2" for the query: INSERT INTO mantis_user_pref_table (user_id, project_id, default_profile, default_project, refresh_delay, redirect_delay, bugnote_order, email_on_new, email_on_assigned, email_on_feedback, email_on_resolved, email_on_closed, email_on_reopened, email_on_bugnote, email_on_status, email_on_priority, email_on_new_min_severity, email_on_assigned_min_severity, email_on_feedback_min_severity, email_on_resolved_min_severity, email_on_closed_min_severity, email_on_reopened_min_severity, email_on_bugnote_min_severity, email_on_status_min_severity, email_on_priority_min_severity, email_bugnote_limit, language, timezone) VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?).
Is this an issue with PgSql version or Mantis issue?
atrol
Site Admin
Posts: 8572
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: reset pwd link 401 error

Post by atrol »

tparry wrote:Having just installed mantis 1.2.9
Really? Or is this just a typo and you mean 1.2.19?
tparry wrote: Is this an issue with PgSql version 7.4.19
I am not complete but quite sure it is related to this version (we recommend version 8 and above) and/or PgSql in general.
Please use Search before posting and read the Manual
tparry
Posts: 4
Joined: 12 Aug 2015, 13:35

Re: reset pwd link 401 error

Post by tparry »

Sorry, typo version is 1.2.19 for MantisBt

Why not PgSql in general?

OK So I can try to re-install using MySql instead (version 5.1.68-community-log)
atrol
Site Admin
Posts: 8572
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: reset pwd link 401 error

Post by atrol »

tparry wrote: Why not PgSql in general?
- there are known bugs running Mantis
- most of the Mantis developers are using MySQL
- most of the Mantis users are using MySQL
- most of all PHP applications that are using a database are using MySQL

So if you want the most stable combination, use MySQL.

This does not mean that MySQL is a better database than PostgreSQL, but that's another story ...
Please use Search before posting and read the Manual
tparry
Posts: 4
Joined: 12 Aug 2015, 13:35

Re: reset pwd link 401 error

Post by tparry »

Thanks,
I use PgSql for my own development for last five years or more, quitting MySql!
Post Reply