• Registered: 2009-02-23

Topic: Were there any changes to the Database Schema this month?

I am running a Replication of the mbzdb I went to do an update on my database and I got this error.

Unknown column 'cover_art_presence'
SQL: 'INSERT INTO `release_meta` (`amazon_asin`,`info_url`,`date_added`,`cover_art_presence`,`amazon_store`,`id`) values (NULL,NULL,'2012-01-12 21:38:15.604328+00','absent',NULL,'1112267')'

if I look at  http://musicbrainz.org/doc/Database_Schema I don't even have a release_meta database.  If I look at my Schema I have a release_meta table, but no cover_art_presence column. 

was there an update to the Database?
can someone check there database and let me know if I am missing a cover_art_presence column? If so what is the structure?

  • From: Tartu, EE
  • Registered: 2010-11-24

Re: Were there any changes to the Database Schema this month?

Anyone who has a replicated server should probably either subscribe to the blog feed ( http://blog.musicbrainz.org/ ) or follow us on Twitter ( https://twitter.com/MusicBrainz ) to avoid surprises :) But yes, there was an update: see http://blog.musicbrainz.org/?p=1243 and http://blog.musicbrainz.org/?p=1254 (the latter is a fix to the instructions in the former)

  • From: Tartu, EE
  • Registered: 2010-11-24

Re: Were there any changes to the Database Schema this month?

Also: http://blog.musicbrainz.org/?p=1170 Next schema change will be in mid-May, and the following one in mid-October.

  • Registered: 2009-02-23

Re: Were there any changes to the Database Schema this month?

I am using a MySQL database. I was thinking I could just change the database schema