MantisBT - v3.0 Release
View Issue Details
0001224v3.0 Release[All Projects] Generalpublic2012-11-29 03:362013-08-28 11:17
ReporterMLCrane 
Assigned Tocaseydk 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version3.0.0 
Summary0001224: LDAP user creation dying with SQL errors
DescriptionBrand 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 InformationERROR: /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()
TagsNo tags attached.
Attached Files

Notes
(0002736)
MLCrane   
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:
(0002754)
caseydk   
2012-12-22 22:29   
Resolved: https://github.com/caseysoftware/web2project/commit/cde1987d069278bc0495ae5b11921395c1a0d3c9

Issue History
2012-11-29 03:36MLCraneNew Issue
2012-11-29 03:43MLCraneNote Added: 0002736
2012-12-22 22:29caseydkNote Added: 0002754
2012-12-22 22:29caseydkStatusnew => resolved
2012-12-22 22:29caseydkResolutionopen => fixed
2012-12-22 22:29caseydkAssigned To => caseydk
2013-08-28 11:14caseydkFixed in Version => 3.0.0
2013-08-28 11:17caseydkStatusresolved => closed