| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
| 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 | ||||||
| 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. | ||||||||
| Attached Files |
| ||||||||
 Relationships |
|
 Relationships |
| Notes |
|
|
MLCrane (reporter) 2012-11-29 03:43 |
And by way of being an obvious "first thing to try", I altered 'history' so 'history_item' can be NULL, tried logging in again, and I get a "login failed" message back. The NULL lines have turned up in 'history', but no user or contact is created. == Dumping data for table history |197|2012-11-29 12:38:39|-1|add|NULL|contacts|0|NULL|NULL| - ACTION: Create TABLE: contacts ID: |198|2012-11-29 12:38:39|-1|add|NULL|contacts|0|NULL|NULL| - ACTION: Create TABLE: contacts ID: |199|2012-11-29 12:38:39|-1|add|NULL|users|0|NULL|NULL| - ACTION: Create TABLE: users ID: |200|2012-11-29 12:38:39|-1|add|NULL|users|0|NULL|NULL| - ACTION: Create TABLE: users ID: |
|
caseydk (administrator) 2012-12-22 22:29 |
Resolved: https://github.com/caseysoftware/web2project/commit/cde1987d069278bc0495ae5b11921395c1a0d3c9 |
| 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 |
| Issue History |