[OSM-dev] Planet issues

[Nick Black]

On 2/23/07, Nick Black <nickblack1 at gmail.com> wrote:
> 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,

No, I ran planet2mysql.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
>


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