[ckan-dev] Fwd: DB migration bug and quoted extras

[Adrià Mercader]

(sorry, sent the previous one accidentally)


Hi,

Just flagging this here in case some finds the same issue on the 2.0
release branch. A bug was introduced a while ago [1] that made that
the extras were not correctly saved as json, as the original migration
script intended. Joe pushed a fix for it [2], but if you run a `paster
db upgrade` on the meantime the script did not do what expected. The
main symptom of this is that extras appear quoted on the frontend and
some stuff like the dataset map does not work.

Unfortunately there is not an elegant fix, as running `paster db
upgrade` will not run the script and say that:

"CKAN database version remains as: 67"

You need to update the migrate_version table version on the database
and set the version field to 66 so next time you run `paster db
upgrade` the script is run.

It is unlikely that this affects people, but just in case.

Adrià



[1] https://github.com/okfn/ckan/commit/7677d69e
[2] https://github.com/okfn/ckan/pull/706