[OSM-dev] GPX Import failure

Fabian Fingerle otih at datensalat.eu
Wed Sep 12 15:26:34 BST 2007


it seems like a bug, could anybody help me?
gpx file is ok! (if anybody needs it, please write me)


Am Wed, 12 Sep 2007 15:17:57 +0100
schrieb abuse at openstreetmap.org:

> Hi,
> 
> It looks like your GPX file
> 
>   Exp_070912_34_7Km_Sulzbach_Murrhardt_Grab_Tour.gpx
> 
> failed to import. Here's the error:
> 
>   Mysql::Error: Column 'tile' cannot be null: INSERT INTO gps_points
> (`timestamp`, `latitude`, `altitude`, `tile`, `gpx_id`, `longitude`,
> `trackid`) VALUES('2007-09-12T12:29:21+00:00', 48983003, 289.0, NULL,
> 38467, 9559936,
> 0) /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract_adapter.rb:128:in
> `log' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:243:in
> `execute' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:253:in
> `insert' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:1811:in
> `create_without_callbacks' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/callbacks.rb:254:in
> `create_without_timestamps' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/timestamp.rb:39:in
> `create' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:1789:in
> `create_or_update_without_callbacks' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/callbacks.rb:242:in
> `create_or_update' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:1551:in
> `save_without_validation!' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/validations.rb:762:in
> `save_without_transactions!' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/transactions.rb:133:in
> `save!' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/database_statements.rb:59:in
> `transaction' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/transactions.rb:95:in
> `transaction_without_deadlock_handling' /var/www/rails/lib/daemons/../../config/../vendor/plugins/deadlock_retry/lib/deadlock_retry.rb:45:in
> `transaction' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/transactions.rb:121:in
> `transaction' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/transactions.rb:133:in
> `save!' /var/www/rails/lib/daemons/../../config/../app/models/trace.rb:198:in
> `import' /var/www/rails/lib/daemons/../../config/../lib/osm.rb:122:in
> `points' /usr/local/lib/ruby/1.8/rexml/parsers/sax2parser.rb:140:in
> `call' /usr/local/lib/ruby/1.8/rexml/parsers/sax2parser.rb:140:in
> `parse' /usr/local/lib/ruby/1.8/rexml/parsers/sax2parser.rb:140:in
> `each' /usr/local/lib/ruby/1.8/rexml/parsers/sax2parser.rb:140:in
> `parse' /var/www/rails/lib/daemons/../../config/../lib/osm.rb:130:in
> `points' /var/www/rails/lib/daemons/../../config/../app/models/trace.rb:185:in
> `import' /var/www/rails/lib/daemons/gpx_import.rb:21 /var/www/rails/lib/daemons/gpx_import.rb:15:in
> `each' /var/www/rails/lib/daemons/gpx_import.rb:15 /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/active_support/dependencies.rb:488:in
> `load' /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/active_support/dependencies.rb:488:in
> `load' /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/active_support/dependencies.rb:342:in
> `new_constants_in' /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/active_support/dependencies.rb:488:in
> `load' /usr/local/lib/ruby/gems/1.8/gems/daemons-1.0.6/lib/daemons/application.rb:158:in
> `start_load' /usr/local/lib/ruby/gems/1.8/gems/daemons-1.0.6/lib/daemons/application.rb:235:in
> `start' /usr/local/lib/ruby/gems/1.8/gems/daemons-1.0.6/lib/daemons/controller.rb:69:in
> `run' /usr/local/lib/ruby/gems/1.8/gems/daemons-1.0.6/lib/daemons.rb:136:in
> `run' /usr/local/lib/ruby/gems/1.8/gems/daemons-1.0.6/lib/daemons/cmdline.rb:105:in
> `call' /usr/local/lib/ruby/gems/1.8/gems/daemons-1.0.6/lib/daemons/cmdline.rb:105:in
> `catch_exceptions' /usr/local/lib/ruby/gems/1.8/gems/daemons-1.0.6/lib/daemons.rb:135:in
> `run' lib/daemons/gpx_import_ctl:15


-- 
+---                        		  - ! -          +
|  Fabian Fingerle         fabian-fingerle.de            |
|  mail/jid -  otih at datensalat.eu			 |
|  3D17 CAC8 1955 1908 65ED  5C51 FDA3 6A09 AB41 AB85 	 |
+          - ! -   		                      ---+
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20070912/e280caa6/attachment.pgp>


More information about the dev mailing list