[GRASS-dev] Inconsistent number of columns in the table

After importing a vector map in GRASS GIS, when I try to open the table manager, I get the message that there is a “Inconsistent number of columns in the table <reptiles_east_Africa>”

I can open the same table without problems in sqlite managers such as navigat and sqlite manager.

I suspect the text in one or more of the entries contains a character that is interpreted as delimiter by the table manager. What characters are interpreted as delimiters by the table manager (so I know what to look for)? Or is there another likely reason for this problem?

Paulo

Running GRASS 7dev on Linux.

On Fri, Apr 3, 2015 at 5:22 AM, Paulo van Breugel <p.vanbreugel@gmail.com>
wrote:

After importing a vector map in GRASS GIS, when I try to open the table
manager, I get the message that there is a "Inconsistent number of columns
in the table <reptiles_east_Africa>"

I can open the same table without problems in sqlite managers such as
navigat and sqlite manager.

I suspect the text in one or more of the entries contains a character that
is interpreted as delimiter by the table manager. What characters are
interpreted as delimiters by the table manager (so I know what to look
for)? Or is there another likely reason for this problem?

That's weird because the separator is composed of multiple characters (it
is string '{_sep_}'), so very unlikely to be in the data. Could you share
the data to test?

Anna

Paulo

Running GRASS 7dev on Linux.

_______________________________________________
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev

On Fri, Apr 3, 2015 at 8:34 AM, Anna Petrášová <kratochanna@gmail.com>
wrote:

On Fri, Apr 3, 2015 at 5:22 AM, Paulo van Breugel <p.vanbreugel@gmail.com>
wrote:

After importing a vector map in GRASS GIS, when I try to open the table
manager, I get the message that there is a "Inconsistent number of columns
in the table <reptiles_east_Africa>"

I can open the same table without problems in sqlite managers such as
navigat and sqlite manager.

I suspect the text in one or more of the entries contains a character
that is interpreted as delimiter by the table manager. What characters are
interpreted as delimiters by the table manager (so I know what to look
for)? Or is there another likely reason for this problem?

That's weird because the separator is composed of multiple characters (it
is string '{_sep_}'), so very unlikely to be in the data. Could you share
the data to test?

New ticket:
http://trac.osgeo.org/grass/ticket/2640

There is a newline in record #406, try to remove it first (it shouldn't be
there anyway in this case), then it should work.

Anna

Paulo

Running GRASS 7dev on Linux.

_______________________________________________
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev

On Fri, Apr 3, 2015 at 4:42 PM, Anna Petrášová <kratochanna@gmail.com>
wrote:

On Fri, Apr 3, 2015 at 8:34 AM, Anna Petrášová <kratochanna@gmail.com>
wrote:

On Fri, Apr 3, 2015 at 5:22 AM, Paulo van Breugel <p.vanbreugel@gmail.com
> wrote:

After importing a vector map in GRASS GIS, when I try to open the table
manager, I get the message that there is a "Inconsistent number of columns
in the table <reptiles_east_Africa>"

I can open the same table without problems in sqlite managers such as
navigat and sqlite manager.

I suspect the text in one or more of the entries contains a character
that is interpreted as delimiter by the table manager. What characters are
interpreted as delimiters by the table manager (so I know what to look
for)? Or is there another likely reason for this problem?

That's weird because the separator is composed of multiple characters (it
is string '{_sep_}'), so very unlikely to be in the data. Could you share
the data to test?

New ticket:
http://trac.osgeo.org/grass/ticket/2640

There is a newline in record #406, try to remove it first (it shouldn't be
there anyway in this case), then it should work.

Thanks Anna. Out of curiosity, and so I can find this kind of problems
myself next time, how did you find the problematic line?

Anna

Paulo

Running GRASS 7dev on Linux.

_______________________________________________
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev

On Fri, Apr 3, 2015 at 10:53 AM, Paulo van Breugel <p.vanbreugel@gmail.com>
wrote:

On Fri, Apr 3, 2015 at 4:42 PM, Anna Petrášová <kratochanna@gmail.com>
wrote:

On Fri, Apr 3, 2015 at 8:34 AM, Anna Petrášová <kratochanna@gmail.com>
wrote:

On Fri, Apr 3, 2015 at 5:22 AM, Paulo van Breugel <
p.vanbreugel@gmail.com> wrote:

After importing a vector map in GRASS GIS, when I try to open the table
manager, I get the message that there is a "Inconsistent number of columns
in the table <reptiles_east_Africa>"

I can open the same table without problems in sqlite managers such as
navigat and sqlite manager.

I suspect the text in one or more of the entries contains a character
that is interpreted as delimiter by the table manager. What characters are
interpreted as delimiters by the table manager (so I know what to look
for)? Or is there another likely reason for this problem?

That's weird because the separator is composed of multiple characters
(it is string '{_sep_}'), so very unlikely to be in the data. Could you
share the data to test?

New ticket:
http://trac.osgeo.org/grass/ticket/2640

There is a newline in record #406, try to remove it first (it shouldn't
be there anyway in this case), then it should work.

Thanks Anna. Out of curiosity, and so I can find this kind of problems
myself next time, how did you find the problematic line?

I put some print statements in gui/wxpython/dbmgr/base.py and the last
printed record was the bad one.

Anna

Paulo

Running GRASS 7dev on Linux.

_______________________________________________
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev