Bug 267311

Summary:	Error while inserting row when field has "Not null" atribute
Product:	[Applications] KEXI	Reporter:	Marcelo Escobal <marcelo.escobal>
Component:	Tables	Assignee:	Jarosław Staniek <staniek>
Status:	CLOSED FIXED
Severity:	crash	CC:	marcelo.escobal
Priority:	NOR
Version:	2.3.1 (KOffice 2.3.1)
Target Milestone:	---
Platform:	Ubuntu
OS:	Linux
Latest Commit:		Version Fixed In:
Sentry Crash Report:

Description Marcelo Escobal 2011-02-28 15:12:24 UTC

Version:           2.2 rc1 (KOffice 2.2 rc1) (using KDE 4.5.1) 
OS:                Linux

When you try to insert a record and there's a field with "Not null" atribute, you can't insert it despite the field being with content.

Reproducible: Always

Steps to Reproduce:
Create a Kexy project (Mysql). Create a table with at least one field "not null". Try to enter data (including data in the "not null" field). Try to save changes.

Actual Results:  
You can't insert the row. The only option is cancel the input.

Expected Results:  
Insert the row since the "not null" field has content.

Comment 1 Jarosław Staniek 2011-02-28 23:34:23 UTC

Thanks for reporting, Marcelo. I confirm this is rather serious and exists also in 2.3.1. .kexi files have the same problem.
Will be fixed ASAP, with patches for 2.2 series too.

Comment 2 Marcelo Escobal 2011-03-01 05:30:50 UTC

OK. Thanks.

Marcelo.

2011/2/28 Jarosław Staniek <staniek@kde.org>

> https://bugs.kde.org/show_bug.cgi?id=267311
>
>
> Jarosław Staniek <staniek@kde.org> changed:
>
>           What    |Removed                     |Added
>
> ----------------------------------------------------------------------------
>             Status|UNCONFIRMED                 |ASSIGNED
>            Version|2.2 rc1 (KOffice 2.2 rc1)   |2.3.1 (KOffice 2.3.1)
>     Ever Confirmed|0                           |1
>           Severity|normal                      |crash
>
>
>
>
> --- Comment #1 from Jarosław Staniek <staniek kde org>  2011-02-28 23:34:23
> ---
> Thanks for reporting, Marcelo. I confirm this is rather serious and exists
> also
> in 2.3.1. .kexi files have the same problem.
> Will be fixed ASAP, with patches for 2.2 series too.
>
> --
> Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You are on the CC list for the bug.
> You reported the bug.

Comment 3 Jarosław Staniek 2011-03-03 00:20:28 UTC

Fixed, I plan to commit tomorrow.

Comment 4 Marcelo Escobal 2011-03-03 01:34:28 UTC

That's fast!!!!! Thanks.

Marcelo.

2011/3/2 Jarosław Staniek <staniek@kde.org>

> https://bugs.kde.org/show_bug.cgi?id=267311
>
>
>
>
>
> --- Comment #3 from Jarosław Staniek <staniek kde org>  2011-03-03 00:20:28
> ---
> Fixed, I plan to commit tomorrow.
>
> --
> Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You are on the CC list for the bug.
> You reported the bug.
>

Comment 5 Jarosław Staniek 2011-03-04 00:12:50 UTC

Git commit c4ccddc80e93bdc81cf44e5a19d46517305a245b by Jaroslaw Staniek.
Committed on 04/03/2011 at 00:08.
Pushed by staniek into branch 'master'.

Tables: fix inserting row when field has "required" atribute set

CCBUG:267311

M  +8    -7    kexi/widget/tableview/kexitableviewdata.cpp     

http://commits.kde.org/calligra/c4ccddc80e93bdc81cf44e5a19d46517305a245b

Comment 6 Jarosław Staniek 2011-03-04 00:12:52 UTC

Git commit fccaf7bc3f04f80cf38c58242ac66340fe680134 by Jaroslaw Staniek.
Committed on 04/03/2011 at 00:08.
Pushed by staniek into branch 'tools-koabstraction_refactoring1-staniek'.

Tables: fix inserting row when field has "required" atribute set

CCBUG:267311

M  +8    -7    kexi/widget/tableview/kexitableviewdata.cpp     

http://commits.kde.org/calligra/fccaf7bc3f04f80cf38c58242ac66340fe680134

Comment 7 Jarosław Staniek 2011-03-04 00:16:25 UTC

SVN commit 1223592 by staniek:

Tables
*fix inserting row when field has "required" atribute set
BUG:267311

*backported to 2.3.x



 M  +8 -7      kexitableviewdata.cpp  


WebSVN link: http://websvn.kde.org/?view=rev&revision=1223592

Comment 8 Jarosław Staniek 2011-03-04 00:17:33 UTC

SVN commit 1223593 by staniek:

Tables
*fix inserting row when field has "required" atribute set
CCBUG:267311

**backported to 2.2.x



 M  +8 -7      kexitableviewdata.cpp  


WebSVN link: http://websvn.kde.org/?view=rev&revision=1223593

Comment 9 Jarosław Staniek 2011-03-04 01:36:41 UTC

Patch and explanation published: http://userbase.kde.org/KOffice/Download#Kexi:_Fix_inserting_row_when_field_has_.22required.22_attribute_set