id summary reporter owner description type status priority milestone component version severity resolution keywords cc 5604 missing CPLString().FormatC(..) when using doubles - fails on systems using Decimal.Comma mj10777 Even Rouault "While trying the 'Rasterlite' Format, the images no longer showed. I have recently updated to Ubuntu 14.04 from 12.04 where this problem was not noticed. ---- The following error showed in the terminal while loading 'Rasterlite' Databases: ERROR 1: In ExecuteSQL(): sqlite3_prepare(SELECT m.geometry, r.raster, m.id, m.width, m.height FROM ""TrueMarble_metadata"" AS m, ""TrueMarble_rasters"" AS r WHERE m.rowid IN (SELECT pkid FROM ""idx_TrueMarble_metadata_geometry"" WHERE xmin < 22,916666666666668 AND xmax > 14,583333333333334 AND ymin < 39,416666666666664 AND ymax > 31,083333333333329) AND m.pixel_x_size >= 0,016666666666666 AND m.pixel_x_size <= 0,016666666666668 AND m.pixel_y_size >= 0,016666666666666 AND m.pixel_y_size <= 0,016666666666668 AND r.id = m.id): near "","": syntax error --- For: frmts/rasterlite/ and ogr/ogrsf_frmts/sqlite I have replaced in all of the '.Printf(' the '%.15f' or '%.12f' and '%.18g' everywhere where ' '%.1' could be found with '%s' and a corresponding: CPLString().FormatC(padfXResolutions[nLevel] - 1e-15,""%.15f"").c_str() --- After recompiling gdal and QGIS all of my 'Rasterlite' Rasters show up correctly. --- The diff was created with: svn upgrade svn diff frmts/rasterlite > 20140804.rasterlite_formatc.diff svn diff ogr/ogrsf_frmts/sqlite > 20140804.ogrsf_frmts_sqlite_formatc.diff for whatever reason 'svn upgrade' had to be called first --- the diff for 'sqlite' also includes changes already submitted in: [GDAL] #5582: SpatialView - writable --- This problem is also meantioned in: [GDAL] #5603: Rasterlite2 (spatialite) --- I have NOT looked at other areas of the project to see if there are also other areas when machine specific formatting is needed for doubles " defect closed high 2.0.0 default svn-trunk critical fixed FormatC, doubles, Decimal.Comma