MantisBT - v3.0 Release | |||||
View Issue Details | |||||
ID | Project | Category | View Status | Date Submitted | Last Update |
0001224 | v3.0 Release | [All Projects] General | public | 2012-11-29 03:36 | 2013-08-28 11:17 |
Reporter | MLCrane | ||||
---|---|---|---|---|---|
Assigned To | caseydk | ||||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Platform | OS | OS Version | |||
Product Version | |||||
Target Version | Fixed in Version | 3.0.0 | |||
Summary | 0001224: LDAP user creation dying with SQL errors | ||||
Description | Brand new installation of master as of 2012-11-29 12:00Z to a new database using confirmed LDAP details for authentication (checked using the contact importer), DB users can log in just fine, but when a non-DB LDAP user authenticates, you get a page of errors to the effect that a particular column cannot be NULL. | ||||
Additional Information | ERROR: /var/www/web2project-master/classes/w2p/Database/Query.class.php(1131) : query failed(INSERT INTO `history`(`history_action`,`history_item`,`history_description`,`history_user`,`history_date`,`history_project`,`history_table`) VALUES ('add',NULL,' - ACTION: Create TABLE: contacts ID: ',-1,'2012-11-29 12:32:59',0,'contacts')) - error was: Column 'history_item' cannot be null Backtrace: 0 /var/www/web2project-master/classes/w2p/Database/Query.class.php:1131 dprint() 1 /var/www/web2project-master/includes/cleanup_functions.php:3379 exec() 2 /var/www/web2project-master/classes/w2p/Core/BaseObject.class.php:675 addHistory() 3 /var/www/web2project-master/classes/w2p/Core/BaseObject.class.php:738 hook_postCreate() 4 /var/www/web2project-master/classes/w2p/Core/Dispatcher.class.php:100 publish() 5 /var/www/web2project-master/classes/w2p/Core/BaseObject.class.php:352 publish() 6 /var/www/web2project-master/classes/w2p/Authenticators/LDAP.class.php:136 store() 7 /var/www/web2project-master/classes/w2p/Authenticators/LDAP.class.php:84 createsqluser() 8 /var/www/web2project-master/classes/w2p/Core/CAppUI.class.php:879 authenticate() 9 /var/www/web2project-master/index.php:117 login() ERROR: /var/www/web2project-master/classes/w2p/Database/Query.class.php(1131) : query failed(INSERT INTO `history`(`history_action`,`history_item`,`history_description`,`history_user`,`history_date`,`history_project`,`history_table`) VALUES ('add',NULL,' - ACTION: Create TABLE: contacts ID: ',-1,'2012-11-29 12:32:59',0,'contacts')) - error was: Column 'history_item' cannot be null Backtrace: 0 /var/www/web2project-master/classes/w2p/Database/Query.class.php:1131 dprint() 1 /var/www/web2project-master/includes/cleanup_functions.php:3379 exec() 2 /var/www/web2project-master/classes/w2p/Core/BaseObject.class.php:657 addHistory() 3 /var/www/web2project-master/modules/contacts/contacts.class.php:118 hook_postStore() 4 /var/www/web2project-master/classes/w2p/Core/BaseObject.class.php:738 hook_postStore() 5 /var/www/web2project-master/classes/w2p/Core/Dispatcher.class.php:100 publish() 6 /var/www/web2project-master/classes/w2p/Core/BaseObject.class.php:353 publish() 7 /var/www/web2project-master/classes/w2p/Authenticators/LDAP.class.php:136 store() 8 /var/www/web2project-master/classes/w2p/Authenticators/LDAP.class.php:84 createsqluser() 9 /var/www/web2project-master/classes/w2p/Core/CAppUI.class.php:879 authenticate() 10 /var/www/web2project-master/index.php:117 login() ERROR: /var/www/web2project-master/classes/w2p/Database/Query.class.php(1131) : query failed(INSERT INTO `history`(`history_action`,`history_item`,`history_description`,`history_user`,`history_date`,`history_project`,`history_table`) VALUES ('add',NULL,' - ACTION: Create TABLE: users ID: ',-1,'2012-11-29 12:32:59',0,'users')) - error was: Column 'history_item' cannot be null Backtrace: 0 /var/www/web2project-master/classes/w2p/Database/Query.class.php:1131 dprint() 1 /var/www/web2project-master/includes/cleanup_functions.php:3379 exec() 2 /var/www/web2project-master/classes/w2p/Core/BaseObject.class.php:675 addHistory() 3 /var/www/web2project-master/classes/w2p/Core/BaseObject.class.php:738 hook_postCreate() 4 /var/www/web2project-master/classes/w2p/Core/Dispatcher.class.php:100 publish() 5 /var/www/web2project-master/classes/w2p/Core/BaseObject.class.php:352 publish() 6 /var/www/web2project-master/modules/admin/users.class.php:85 store() 7 /var/www/web2project-master/classes/w2p/Authenticators/LDAP.class.php:146 store() 8 /var/www/web2project-master/classes/w2p/Authenticators/LDAP.class.php:84 createsqluser() 9 /var/www/web2project-master/classes/w2p/Core/CAppUI.class.php:879 authenticate() 10 /var/www/web2project-master/index.php:117 login() ERROR: /var/www/web2project-master/classes/w2p/Database/Query.class.php(1131) : query failed(SELECT * FROM ((`user_preferences` AS upr)) WHERE upr.pref_user = ) - error was: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Backtrace: 0 /var/www/web2project-master/classes/w2p/Database/Query.class.php:1131 dprint() 1 /var/www/web2project-master/classes/w2p/Database/Query.class.php:1168 exec() 2 /var/www/web2project-master/modules/admin/users.class.php:96 loadList() 3 /var/www/web2project-master/classes/w2p/Core/BaseObject.class.php:738 hook_postStore() 4 /var/www/web2project-master/classes/w2p/Core/Dispatcher.class.php:100 publish() 5 /var/www/web2project-master/classes/w2p/Core/BaseObject.class.php:353 publish() 6 /var/www/web2project-master/modules/admin/users.class.php:85 store() 7 /var/www/web2project-master/classes/w2p/Authenticators/LDAP.class.php:146 store() 8 /var/www/web2project-master/classes/w2p/Authenticators/LDAP.class.php:84 createsqluser() 9 /var/www/web2project-master/classes/w2p/Core/CAppUI.class.php:879 authenticate() 10 /var/www/web2project-master/index.php:117 login() ERROR: /var/www/web2project-master/classes/w2p/Database/Query.class.php(1131) : query failed(INSERT INTO `history`(`history_action`,`history_item`,`history_description`,`history_user`,`history_date`,`history_project`,`history_table`) VALUES ('add',NULL,' - ACTION: Create TABLE: users ID: ',-1,'2012-11-29 12:32:59',0,'users')) - error was: Column 'history_item' cannot be null Backtrace: 0 /var/www/web2project-master/classes/w2p/Database/Query.class.php:1131 dprint() 1 /var/www/web2project-master/includes/cleanup_functions.php:3379 exec() 2 /var/www/web2project-master/classes/w2p/Core/BaseObject.class.php:657 addHistory() 3 /var/www/web2project-master/modules/admin/users.class.php:116 hook_postStore() 4 /var/www/web2project-master/classes/w2p/Core/BaseObject.class.php:738 hook_postStore() 5 /var/www/web2project-master/classes/w2p/Core/Dispatcher.class.php:100 publish() 6 /var/www/web2project-master/classes/w2p/Core/BaseObject.class.php:353 publish() 7 /var/www/web2project-master/modules/admin/users.class.php:85 store() 8 /var/www/web2project-master/classes/w2p/Authenticators/LDAP.class.php:146 store() 9 /var/www/web2project-master/classes/w2p/Authenticators/LDAP.class.php:84 createsqluser() 10 /var/www/web2project-master/classes/w2p/Core/CAppUI.class.php:879 authenticate() 11 /var/www/web2project-master/index.php:117 login() | ||||
Tags | No tags attached. | ||||
Relationships | |||||
Attached Files |
Notes | |||||
|
|||||
|
|
||||
|
|||||
|
|
Issue History | |||||
Date Modified | Username | Field | Change | ||
---|---|---|---|---|---|
2012-11-29 03:36 | MLCrane | New Issue | |||
2012-11-29 03:43 | MLCrane | Note Added: 0002736 | |||
2012-12-22 22:29 | caseydk | Note Added: 0002754 | |||
2012-12-22 22:29 | caseydk | Status | new => resolved | ||
2012-12-22 22:29 | caseydk | Resolution | open => fixed | ||
2012-12-22 22:29 | caseydk | Assigned To | => caseydk | ||
2013-08-28 11:14 | caseydk | Fixed in Version | => 3.0.0 | ||
2013-08-28 11:17 | caseydk | Status | resolved => closed |