NOTE:: Before reporting an issue, make sure you are running the latest version, currently 3.3.1
|Anonymous | Login | Signup for a new account||28-03-17 14:52 BST|
|My View | View Issues | Change Log | Roadmap|
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0017648||phplist application||User Management||public||17-04-15 00:54||06-07-15 18:04|
|Target Version||3.0.X||Fixed in Version||3.2.0|
|Summary||0017648: Cannot create new admin users|
|Description||Creating new admin users via the admin console always results in 'Error adding new admin, login name and/or email not inserted, email not valid or admin already exists' even if all fields are set properly. I checked the source in /admin.php and saw that the insert query in line 48 does not include the 'email' field causing the error. Adding the email column and value in the query solves this problem.|
|Steps To Reproduce||1. Go to admin console -> Config -> Manage Administrators -> Add a new Administrator|
2. Fill up the form and click 'Save changes'
|Additional Information||Adding the email column and value in the insert query (admin.php, line 48) solves this problem.|
|Tags||No tags attached.|
|Interesting. I can see what you mean in adding the email column, but strangely enough it works for me on the existing code. Needs a bit of digging to understand better.|
edited on: 17-04-15 10:33
The email column is defined as not null without a default value, so it is "wrong" to try to insert without giving the column a value.
Depending on the mysql mode (strict or not), either the insert statement will fail or mysql will use an implicit default value. I guess that strict mode is in effect in your case.
|ah, that explains it, indeed.|
|Copyright © 2000 - 2017 MantisBT Team|