I think the problem may actually be with the build of GRASS GIS shipped with QGIS. I just installed 6.4.1 RC1 and now get a useful error.<div><br></div><div>Aren<br><br><div class="gmail_quote">On Sat, Feb 5, 2011 at 10:15 PM, Aren Cambre <span dir="ltr"><<a href="mailto:aren@arencambre.com">aren@arencambre.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">I am running <b>v.in.ogr</b> to import a PostGIS table. This table shows up fine in QGIS. Here's the command:<div>
<b><font face="'courier new', monospace">v.in.ogr -o "dsn=PG:dbname='de' host=localhost port=5432 user='[redacted]' password='[redacted]' sslmode=disable" layer=consistent.master output=master_grassX</font></b></div>
<div><br></div><div>This command was produced by QGIS's GRASS Tools.</div><div><br></div><div>The problem is that I get an error but no explanation at all. Here's the output:</div><blockquote style="margin:0 0 0 40px;border:none;padding:0px">
<div><img>Width for column school_zone set to 255 (was not specified by OGR), some strings may be truncated!</div><div><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
<img>Width for column vehicle_color set to 255 (was not specified by OGR), some strings may be truncated!</p></div><div><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
<img>Width for column offense_location set to 255 (was not specified by OGR), some strings may be truncated!</p></div><div><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
<img>Width for column work_zone set to 255 (was not specified by OGR), some strings may be truncated!</p></div><div><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
<span>DBMI-DBF driver error:</span></p></div><div><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
<span><br></span></p></div><div><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span><br>
</span></p></div><div><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><img>Unable to create table: 'create table master_grassX (cat integer, offense_street_name varchar ( 30 ), school_zone varchar ( 255 ), defendant_dl varchar ( 20 ), defendant_dl_state varchar ( 2 ), vehicle_model varchar ( 20 ), offense_code integer, vehicle_color varchar ( 255 ), citation_id_base varchar ( 20 ), vehicle_make varchar ( 20 ), defendant_dob date, speed_limit integer, source varchar ( 20 ), vehicle_registration_expiration_date date, offense_crossstreet_number varchar ( 10 ), defendant_sex varchar ( 1 ), citing_jurisdiction integer, offense_county varchar ( 10 ), officer_id varchar ( 20 ), offense_location varchar ( 255 ), defendant_zip varchar ( 9 ), vehicle_licenseplate_state varchar ( 2 ), offense_street_number varchar ( 10 ), offense_timestamp datetime, citation_id_stub varchar ( 20 ), offense_crossstreet_name varchar ( 30 ), speed_alleged integer, vehicle_year integer, vehicle_licenseplate varchar ( 10 ), work_zone varchar ( 255 ), defendant_race varchar ( 10 ))'</p>
</div><div><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><span style="font-weight:600">Finished with error</span></p></div></blockquote><div><p></p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"></p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"></p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"></p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"></p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"></p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"></p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">The problem is I get no details at all on the error cause. Yes, the driver error really is blank.</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
I turned postgres logging to log all queries (following the recipe at <a href="http://stackoverflow.com/questions/722221/how-to-log-postgres-sql-queries" target="_blank">http://stackoverflow.com/questions/722221/how-to-log-postgres-sql-queries</a>). I analyzed the queries and didn't see anything surprising. I've attached the log in case it's helpful.</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
I checked the <b>/dbf</b> directory, and it has no files. I also checked the <b>vector/master_grassX</b> directory and found no problems, just four files (<b>coor</b>, <b>dbln</b>, <b>head</b>, <b>hist</b>) with unsurprising contents.</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
I'm new to GRASS, so I'm not sure what else to check. Is there another log source? Did I discover a bug that needs to be filed?</p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
<br></p><font color="#888888"><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">Aren Cambre</p></font></div>
</blockquote></div><br></div>