[OSM-dev] Planet issues

[Nick Black]

Hello,

Am I missing a trick with the latest planet?  I did what I usually do, I got :

planet-070221.osm

Then I sanitised it:

./UTF8sanitize < /home/nick/OSM/planet-070221.osm > planet-sanitized-070221.osm

then I ran planet.rb, adding some debugging, and it dies at this line:


planet2mysql.rb:41:in `query': You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near 'A5\\";upload_tag=ojw_20060813;source=GPS
waypoint", "2006-08-13 20:25:41")' at line 1 (Mysql::Error)
        from planet2mysql.rb:41:in `save_mysql'
        from planet2mysql.rb:72
        from planet2mysql.rb:67
rt into current_nodes values (13352376, 52.6710146675544,
0.952120929053951, 1, 1, "created_by=JOSM", "2007-01-26 19:57:05");

I think this is comming from here:

2390917   <node id="13353261" lat="51.8215204859385"
lon="-0.415635415920875" timestamp="2006-08-13T20:25:41+01:00">
2390918     <tag k="name" v="junction" />
2390919     <tag k="created_by" v="almien_upload" />
2390920     <tag k="notes" v="\"A5\"" />
2390921     <tag k="upload_tag" v="ojw_20060813" />
2390922     <tag k="source" v="GPS waypoint" />
2390923   </node>


Presumably other people are importing successfully into MySQL?  Whats the trick!



-- 
Nick Black
--------------------------------
http://www.blacksworld.net