[openstreetmap/openstreetmap-website] can't append osm data into database (#1638)

[nafis042]

at first I upload data into database using this command-
osmosis --read-pbf previous.osm.pbf \
  --write-apidb host="localhost" database="openstreetmap" \
  user="postgres" password="postgres" validateSchemaVersion="no"
and its working fine. Next I produce a diff.osc.gz using following command-
osmosis --read-pbf latest.osm.pbf --read-pbf previous.osm.pbf --derive-change --write-xml-change diff.osc.gz
Then I use the following command to append data into database-
osmosis --read-xml-change diff.osc.gz --write-pgsql-change user="postgres" database="openstreetmap" password="postgres" validateSchemaVersion="no"
It shows me following error:
SEVERE: Thread for task 1-read-xml-change failed
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT id, name FROM users WHERE id = ?]; nested exception is org.postgresql.util.PSQLException: ERROR: column "name" does not exist

Am I doing something wrong? what is the right procedure?


-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/issues/1638
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20170911/eff67ac4/attachment.html>