Bug

Error creating new person on MySQL Strict.

Summary

open
Aug 23, 2007
Aug 23, 2007 / oyvind.kinsey
Jun 2, 2008 / stenyak
 

Attached files

No files uploaded
 
Strickt MySQL does not accept '' as a value for an integer/boolean field(0).
For this reason streber fails to create a person with account as it tries to set the field ldap to ''.

This is the error from errors.log.php

Error 20070823140803 ERROR: db/db.inc.php : 39 Database exception. Please read <a href=http://streber.pixtur.de/index.php?go=taskView&tsk=1272'> next steps on database errors.</a>
Error 20070823140803 db/db.inc.php : 251 -> MysqlException::__construct("Querry=UPDATE person SET nickn")
Error 20070823140803 db/db_item.inc.php : 974 -> DB_MysqlStatement::execute("", int1)
Error 20070823140803 pages/person.inc.php :2761 -> DbProjectItem::update()
Error 20070823140803 std/class_pagehandler.inc.php : 729 -> personEditSubmit()
Error 20070823140803 index.php : 210 -> PageHandler::show("personEditSubmit")
Error 20070823140803
Error 20070823140803 Variables in __construct():
Error 20070823140803 message = Querry=UPDATE person SET nickname='andre.kalstad', can_login='1', identifier='3cbd4d8a7edd3be773b605656b246fe8', ldap='' WHERE id=6917
Error 20070823140803
Error 20070823140803 code = NULL
Error 20070823140803 sql_obj = OBJECT
Error 20070823140803 mysql_error = Incorrect integer value: '' for column 'ldap' at row 1
Error 20070823140803 v0.0801, personEditSubmit, from 10.0.5.30, uri:/index.php

Database exception is probably related

Issue report

Minor
Always
Gentoo/Apache/ MySQL 5.0.44 Strict
0.0801 (2007-05-15)
Create a new user and check the person with account checkbox.
 

No Comments