Bug (done?)

sql exception occurred,when add a new person / #6738

Summary

done?
Jul 31, 2008
100%
Jul 31, 2008 / bozhi521
Nov 17, 2008 / pixtur
 

Attached files

No files uploaded

Issue report

Major
Always
apache2.0,php5.26, mysql5.051,windowsXp(sp2)
0.803
login with admin, create a new person,when click the submit button,a sql exception occured.
 

5 Comments

guest

Jul 31, 2008
View comment
What is the exact error message?

bozhi521

Aug 6, 2008
View comment

from errors.log.php

Error 20080731032232 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 20080731032232                 db\db.inc.php : 251 -> MysqlException::__construct("Querry=INSERT INTO person(id,s")
Error 20080731032232            db\db_item.inc.php : 839 -> DB_MysqlStatement::execute("", int1)
Error 20080731032232          pages\person.inc.php :2714 -> DbProjectItem::insert()
Error 20080731032232 std\class_pagehandler.inc.php : 729 -> personEditSubmit()
Error 20080731032232                     index.php : 212 -> PageHandler::show("personEditSubmit")
Error 20080731032232 
Error 20080731032232      Variables in __construct():
Error 20080731032232                       message = Querry=INSERT INTO person(id,state,name,nickname,tagline,mobile_phone,office_phone,office_fax,office_street,office_zipcode,office_homepage,office_email,personal_phone,personal_fax,personal_street,personal_zipcode,personal_homepage,personal_email,birthdate,color,description,password,security_question,security_answer,profile,theme,language,show_tasks_at_home,date_highlight_changes,can_login,last_login,last_logout,user_rights,cookie_string,ip_address,identifier,settings,notification_last,notification_period,time_zone,time_offset,user_level_create,user_level_view,user_level_edit,user_level_reduce,category,salary_per_hour,ldap) VALUES('12','1','New person','te','','','','','','','','12@3.com','','','','','','','0000-00-00','','','','0','0','3','0','en','1','2008-07-31 03:22:32','1','0000-00-00 00:00:00','2008-07-31 03:22:32','8192','9df786317eac6d30ecc42abf2503b1d1','0','a8efe43f2cd479b0854b3a6b0174c8a6','218','2008-07-28 03:22:31','3','25','0','0','0','0','0','0','0','')
Error 20080731032232 
Error 20080731032232                          code = NULL
Error 20080731032232                       sql_obj = OBJECT
Error 20080731032232                   mysql_error = Incorrect integer value: '' for column 'ldap' at row 1
Error 20080731032232    v0.0803, personEditSubmit, from 127.0.0.1,  uri:/test/streber_0.803/index.php

bozhi521

Aug 6, 2008
View comment
When MySQL worked in stricked mode,it 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 ''.

pixtur

Sep 9, 2008
Excellent report!
We should fix this in the next release...


pixtur

Oct 29, 2008
fixed?
I believe I found the bug and fixed it in v0.0808. Can you test it, if there new version is released?

 

Comment / Update