Bug 267311 - Error while inserting row when field has "Not null" atribute
Summary: Error while inserting row when field has "Not null" atribute
Status: CLOSED FIXED
Alias: None
Product: KEXI
Classification: Applications
Component: Tables (show other bugs)
Version: 2.3.1 (KOffice 2.3.1)
Platform: Ubuntu Linux
: NOR crash
Target Milestone: ---
Assignee: Jarosław Staniek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-02-28 15:12 UTC by Marcelo Escobal
Modified: 2011-03-04 01:36 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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