https://issues.qgis.org/https://issues.qgis.org/favicon.ico2016-12-29T22:15:39ZQGIS Issue TrackingQGIS Application - Bug report #16020: Error saving new table records in specific field (2.99 110ffe2)https://issues.qgis.org/issues/16020?journal_id=737202016-12-29T22:15:39ZPatrick Dunford
<ul></ul><p>So I'm seeing this adding new records to just about any table that has a field which has two things to it<br />- Rule based styles based on the value of that field<br />- A value map to select values from a drop down list for that field.</p>
<p>In all cases the value of the <type> field is an integer.</p>
<p>This has not been an issue in 2.14 through 2.18</p> QGIS Application - Bug report #16020: Error saving new table records in specific field (2.99 110ffe2)https://issues.qgis.org/issues/16020?journal_id=737212016-12-29T23:04:28ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Category</strong> set to <i>Edit widget</i></li><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li><li><strong>Priority</strong> changed from <i>Normal</i> to <i>Severe/Regression</i></li><li><strong>Target version</strong> set to <i>Version 3.0</i></li></ul><p>@kahukowhai so, to clarify: This is a regression in master about how values from a value map edit widget are written in the attribute table, correct?</p>
<p>Does it happens if the layer has a symbology different from rule based or the above conditions must be true both?</p> QGIS Application - Bug report #16020: Error saving new table records in specific field (2.99 110ffe2)https://issues.qgis.org/issues/16020?journal_id=737372016-12-31T02:47:04ZPatrick Dunford
<ul></ul><p>The issue is that an error is flagged when you try to save a new record and the error occurs in the field that is used by the rule based styling on the table to generate the styles for that table. It will not allow anything except NULL to be saved in that field (so far).</p>
<p>Removing the value map on the field in question did not resolve the problem. There must be an issue primarily with the rule based styling.</p>
<p>For existing records in the table there are no problems with the style rules and the styles are correctly displayed according to those rules.</p> QGIS Application - Bug report #16020: Error saving new table records in specific field (2.99 110ffe2)https://issues.qgis.org/issues/16020?journal_id=737402016-12-31T15:38:05ZPatrick Dunford
<ul><li><strong>File</strong> <a href="/attachments/download/10625/valuemap_Main_South_Line_299.png">valuemap_Main_South_Line_299.png</a> added</li><li><strong>File</strong> <a href="/attachments/download/10624/valuemap_Main_South_Line_214.png">valuemap_Main_South_Line_214.png</a> added</li></ul><p>There seems to be an issue with change of types from different versions of Qgis in that the description of the fields of each table has changed. I assume this has occurred as part of the project conversion which takes place upon opening a project in the new version of Qgis for the first time.</p>
<p>The first file attached is how the fields of the table are described in 2.14 and in the second file how they are described in 2.99. This is exactly the same table on the disk, but attached to two different project files, each of which has been saved in its respective version of Qgis.</p>
<p>In 2.99 what is an integer field is shows as type Qstring with a type name of Integer64. In 2.14 no such ambiguity over the type exists; it is described as type int with typename integer.</p>
<p>The style rules are all based on the assumption this field is an integer which it always has been described at.</p>
<p>I have further discovered that pasting the table style from another table will not paste the value map for this field. Normally this would be pasted.</p>
<p>When you enter a new record in 2.99 and set the value of this field, the new path or place or poly is displayed correctly according to the style rules; the problem is when you come to post the table. As long as the table is still in edit mode and you haven't posted the new record, it will actually be displayed on the map according to the value which is set in the field. It's only when you save the table that it spews.</p> QGIS Application - Bug report #16020: Error saving new table records in specific field (2.99 110ffe2)https://issues.qgis.org/issues/16020?journal_id=737412016-12-31T15:55:44ZPatrick Dunford
<ul><li><strong>File</strong> <a href="/attachments/download/10626/new_integer_field_299.png">new_integer_field_299.png</a> added</li></ul><p>Here is the type of a new field of type integer I added in 2.99 to my table.</p> QGIS Application - Bug report #16020: Error saving new table records in specific field (2.99 110ffe2)https://issues.qgis.org/issues/16020?journal_id=739332017-01-03T09:10:28ZMatthias Kuhn
<ul></ul><p>For me, opening the attached project shows the type qlonglong (Integer64) for the field type. Everything works as expected.</p>
<p>Which GDAL version is shown in Help -> About?<br />Are you using a 32 or 64 bit system?</p> QGIS Application - Bug report #16020: Error saving new table records in specific field (2.99 110ffe2)https://issues.qgis.org/issues/16020?journal_id=740422017-01-08T13:30:39ZPatrick Dunford
<ul></ul><p>QGIS version<br />2.99.0-Master<br />QGIS code revision<br />110ffe2<br />Compiled against Qt<br />5.5.1<br />Running against Qt<br />5.5.1<br />Compiled against GDAL/OGR<br />2.1.0<br />Running against GDAL/OGR<br />2.1.0<br />Compiled against GEOS<br />3.5.0-CAPI-1.9.0<br />Running against GEOS<br />3.5.0-CAPI-1.9.0 r4084<br />PostgreSQL Client Version<br />9.5.2<br />SpatiaLite Version<br />4.3.0a<br />QWT Version<br />6.1.2<br />PROJ.4 Version<br />492<br />QScintilla2 Version<br />2.9.1<br />This copy of QGIS writes debugging output.</p>
<p>The parameter --noplugins is passed to Qgis at startup.</p>
<p>System: Xubuntu 16.04 64-bit</p> QGIS Application - Bug report #16020: Error saving new table records in specific field (2.99 110ffe2)https://issues.qgis.org/issues/16020?journal_id=740432017-01-08T15:59:27ZPatrick Dunford
<ul></ul><p>I'm building a 32 bit VM same version of Xubuntu for comparison</p> QGIS Application - Bug report #16020: Error saving new table records in specific field (2.99 110ffe2)https://issues.qgis.org/issues/16020?journal_id=740752017-01-09T15:36:43ZPatrick Dunford
<ul><li><strong>File</strong> <a href="/attachments/download/10654/qgis_bug_16020_Xubuntu_1610_x86.png">qgis_bug_16020_Xubuntu_1610_x86.png</a> added</li><li><strong>File</strong> <a href="/attachments/download/10655/qgis_bug_16020_Xubuntu_1610_x86_about_qgis.png">qgis_bug_16020_Xubuntu_1610_x86_about_qgis.png</a> added</li></ul><p>Attached are the results from the latest master running on Xubuntu 16.10 32 bit.</p>
<p>Does make it look like a 32 bit / 64 bit problem, but it is running a later master than the one on my 64 bit system.</p>
<p>I am currently updating my 64 bit system to the latest master for comparison.</p> QGIS Application - Bug report #16020: Error saving new table records in specific field (2.99 110ffe2)https://issues.qgis.org/issues/16020?journal_id=740762017-01-09T15:48:10ZPatrick Dunford
<ul><li><strong>File</strong> <a href="/attachments/download/10656/qgis_bug_16020_Xubuntu_1604_x64_015fdf2.png">qgis_bug_16020_Xubuntu_1604_x64_015fdf2.png</a> added</li></ul><p>Here is the result from the latest master 015fdf2 on 64 bit Xubuntu</p>
<p>My testing so far seems to indicate the newest version of master has resolved the problem.</p> QGIS Application - Bug report #16020: Error saving new table records in specific field (2.99 110ffe2)https://issues.qgis.org/issues/16020?journal_id=740842017-01-10T04:19:10ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Open</i></li></ul> QGIS Application - Bug report #16020: Error saving new table records in specific field (2.99 110ffe2)https://issues.qgis.org/issues/16020?journal_id=740902017-01-10T08:45:55ZMatthias Kuhn
<ul></ul><p>Can you shortly describe the status of your investigations?<br />Is this still an issue with latest master or can we close it?</p> QGIS Application - Bug report #16020: Error saving new table records in specific field (2.99 110ffe2)https://issues.qgis.org/issues/16020?journal_id=740982017-01-10T22:40:20ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul> QGIS Application - Bug report #16020: Error saving new table records in specific field (2.99 110ffe2)https://issues.qgis.org/issues/16020?journal_id=746602017-02-27T13:47:26ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>fixed/implemented</i></li></ul><blockquote>
<p>My testing so far seems to indicate the newest version of master has resolved the problem.</p>
</blockquote>
<p>closing then.</p>