wxgui: attribute table manager fails with "Inconsistent number of columns in the table"

[mlennert]

After having filled the attribute table of polygons resulting from segmentation with a whole series of variables, I get the following error when trying to display the attribute table:

"Error in v.db.s..."

and then

"Inconsistent number of columns in the table"

This comes from the test at line 249 in gui/wxpython/dbmgr/base.py. Adding some print statements I can see that while there are 159 columns, the gui only detects 97 fields in the actual record (second to last record of the table).

Using v.db.select from the GUI or at the command line I can see all lines without any problems.

Printing out the record on which the GUI fails, after it went through

record = record.split(fs)

I see the following at the 97th field:

'0.014715{_sep_'

and nothing after that.

All the fields before that are correct.

When I export the file to shp and the reimport it again, I get a similar error, but this time it happens on the last record, record length is 88, and the record in that line is normal, without the '{_sep_'.

I'll attach the shapefile to the ticket.

Any hints ?

Moritz

[mlennert]

Since the shapefile is too big to attach it here, you can get it from:

​http://tomahawk.ulb.ac.be:8014/segtest.tgz

Moritz

[annakrat]

I didn't have any problems with loading the table in attribute manager, all columns seem to be there. I am running Ubuntu with US locale. The '{__sep__}' is the the separator which is used internally for v.db.select because it's highly improbable that it could appear in the data. Strange is that you can see only a part of the separator without the one curly bracket. Are you running it on Windows?

[mlennert]

Replying to annakrat:

I didn't have any problems with loading the table in attribute manager, all columns seem to be there. I am running Ubuntu with US locale. The '{__sep__}' is the the separator which is used internally for v.db.select because it's highly improbable that it could appear in the data. Strange is that you can see only a part of the separator without the one curly bracket. Are you running it on Windows?

No, Debian. Locale=fr_BE.UTF-8, but I just tried with setting to C and relaunching the GUI and I get the same error. Also in grass64release.

Moritz

[martinl]

Still an issue?

[mlennert]

I don't have the shapefile anymore to test, but I haven't encounted the issue since then, so closing...