On Fri, Jun 11, 2010 at 4:40 PM, M Naveed Akram <cmn...@gmail.com> wrote:
> hi,
> i am unabel to write-apidb form osm file to mysql.
>
> my mysql schema version is 25(25 migrations)
> and i am getting the following problem
>
> Caused by:
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationExceptions:
> Cannot add or update a child ros: a foreign key constraing fails
> ('osm_database'.'changeset_tags', CONSTRAINT 'changeset_tags_ibfk_1' FOREIGN
> KEY ('id') REFERENCE 'changesets' ('id'))
>
Do you have to use MySQL? I no longer test on MySQL, and only use
PostgreSQL. MySQL might still work, but I'd rather not invest too much time
in supporting it.
However the error message you're getting seems a bit strange. It seems like
a changeset_tags is being added or modified to point to a non-existent
changesets row. That shouldn't happen. Is your database empty prior to the
import? Even that may not explain it though ...
_______________________________________________
osmosis-dev mailing list
osmosis-dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/osmosis-dev
