I have just installed mantis on different servers, and I have the same problem
Everything works fine except for adding new users, which gives me a 401 warning that there was a failure to connect to the database. The new user is added but the email notification is not sent
any ideas what the problem might be?
Adding a new user failure
Moderators: Developer, Contributor
More information
This is the error I get in all cases when trying to add a user
APPLICATION ERROR #401
Database query failed. Error received from database was #1054: Unknown column 'email_on_new_minimum_severity' in 'field list' for the query: INSERT INTO mantis_user_pref_table
(user_id, project_id, default_profile, default_project, advanced_report, advanced_view, advanced_update, 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_minimum_severity, email_on_assigned_minimum_severity, email_on_feedback_minimum_severity, email_on_resolved_minimum_severity, email_on_closed_minimum_severity, email_on_reopened_minimum_severity, email_on_bugnote_minimum_severity, email_on_status_minimum_severity, email_on_priority_minimum_severity, email_bugnote_limit, language)
VALUES
('5', '0', '0', '0', '0', '0', '0', '30', '2', 'ASC', '1', '1', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'english')
Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.
APPLICATION ERROR #401
Database query failed. Error received from database was #1054: Unknown column 'email_on_new_minimum_severity' in 'field list' for the query: INSERT INTO mantis_user_pref_table
(user_id, project_id, default_profile, default_project, advanced_report, advanced_view, advanced_update, 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_minimum_severity, email_on_assigned_minimum_severity, email_on_feedback_minimum_severity, email_on_resolved_minimum_severity, email_on_closed_minimum_severity, email_on_reopened_minimum_severity, email_on_bugnote_minimum_severity, email_on_status_minimum_severity, email_on_priority_minimum_severity, email_bugnote_limit, language)
VALUES
('5', '0', '0', '0', '0', '0', '0', '30', '2', 'ASC', '1', '1', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'english')
Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.
Its a version of mantis I used before wit the configuration I used before.....
I tried installing the new mantis and havent had any success. This version I am using is fine I just have the problem with the user table. I installed a fresh database.
How do I find out the version information, in which file can I look?
Thanks
I tried installing the new mantis and havent had any success. This version I am using is fine I just have the problem with the user table. I installed a fresh database.
How do I find out the version information, in which file can I look?
Thanks
Unless you've changed something, the version should be mentioned at the bottom of each page (just above the copyright message).
I'm still a little confused as to whether this is a totally new 'instance' of Mantis, or just a new version of Mantis (code), using the same (older) database as a previous version of Mantis (code)?
If I had to take a wild guess without knowing anything else, I'd say that you're using an older Mantis database, with a newer Mantis codebase, and you haven't run the upgrade scripts under http://yourhostname/mantis/admin/ . If that's the case, then run the upgrade scripts and see how things go...
I'm still a little confused as to whether this is a totally new 'instance' of Mantis, or just a new version of Mantis (code), using the same (older) database as a previous version of Mantis (code)?
If I had to take a wild guess without knowing anything else, I'd say that you're using an older Mantis database, with a newer Mantis codebase, and you haven't run the upgrade scripts under http://yourhostname/mantis/admin/ . If that's the case, then run the upgrade scripts and see how things go...