Running from current git master ​https://gitorious.org/mediagoblin/mediagoblin/commit/c5f258fec07b9791b35d52298dd71954de81ef20, I get an error when a user uploads media. The file is uploaded, but the user gets a SERVER ERROR page, and I get entries in my logfile.

Here's one such example.

IntegrityError: (IntegrityError) insert or update on table "core__media_entries" violates foreign key constraint "core__media_entries_activity_fkey"
DETAIL:  Key (activity)=(1025) is not present in table "core__activity_intermediators".
 'UPDATE core__media_entries SET activity=%(activity)s WHERE core__media_entries.id = %(core__media_entries_id)s' {'core__media_entries_id': 1278, 'activity': 1025}

If I query the db directly, I see that activity 1025 indeed does not exist.

mediagoblin=# select * from core__activity_intermediators where id > 1010;
  id  |    type
------+------------
 1011 | media
 1012 | media
 1013 | media
 1014 | media
 1015 | media
 1016 | media
 1017 | media
 1018 | media
 1019 | media
 1020 | media
(10 rows)

And if I examine the media entry that was created, I see that its activity id is 1020 (the last id number in the activity intermediators table), not 1025.

mediagoblin=# select * from core__media_entries where id = 1278;
  id  | uploader | title |    slug    |          created           | description |          media_type           |   state   |                   license                   | file_size | fail_error | fail_metadata | transcoding_pr
ogress | queued_media_file |            queued_task_id            | media_metadata | activity | location
------+----------+-------+------------+----------------------------+-------------+-------------------------------+-----------+---------------------------------------------+-----------+------------+---------------+---------------
-------+-------------------+--------------------------------------+----------------+----------+----------
 1278 |        3 |       | tucker12-2 | 2014-10-28 21:13:19.904526 |             | mediagoblin.media_types.image | processed | http://creativecommons.org/licenses/by/3.0/ |         0 |            |               |
       |                   | 3cb0017d-5539-4e78-9b7a-25a4a2e3dce7 | {}             |     1020 |
(1 row)

Perhaps this is related to #984?

Trying to view an atom feed which includes media without a title returns a server error. The log output is below.

Error - <type 'exceptions.ValueError'>: title is required
URL: https://goblinrefuge.com/mediagoblin/u/joauti/atom/
File '/path/to/mediagoblin/lib/python2.7/site-packages/Paste-1.7.5.1-py2.7.egg/paste/exceptions/errormiddleware.py', line 144 in __call__
  app_iter = self.application(environ, sr_checker)
File '/path/to/mediagoblin/lib/python2.7/site-packages/Paste-1.7.5.1-py2.7.egg/paste/urlmap.py', line 203 in __call__
  return app(environ, start_response)
File '/path/to/mediagoblin/mediagoblin/app.py', line 268 in __call__
  return self.call_backend(environ, start_response)
File '/path/to/mediagoblin/lib/python2.7/site-packages/Werkzeug-0.9.6-py2.7.egg/werkzeug/wsgi.py', line 588 in __call__
  return self.app(environ, start_response)
File '/path/to/mediagoblin/mediagoblin/app.py', line 245 in call_backend
  response = controller(request)
File '/path/to/mediagoblin/mediagoblin/user_pages/views.py', line 542 in atom_feed
  'type': 'text/html'}])
File '/path/to/mediagoblin/lib/python2.7/site-packages/Werkzeug-0.9.6-py2.7.egg/werkzeug/contrib/atom.py', line 144 in add
  self.entries.append(FeedEntry(*args, **kwargs))
File '/path/to/mediagoblin/lib/python2.7/site-packages/Werkzeug-0.9.6-py2.7.egg/werkzeug/contrib/atom.py', line 294 in __init__
  raise ValueError('title is required')
ValueError: title is required

So how do you get media without a title? Upload media, edit it, clear the title, and save changes. Maybe saving media with no title should not be allowed.

From ​https://mediagoblin.readthedocs.org/en/latest/pluginwriter/api.html#plugin-api-chapter

"The plan at present is that we are adding hooks as people need them, with community discussion. If you find that you need a hook and MediaGoblin at present doesn’t provide it at present, please ​http://mediagoblin.org/pages/join.html! We’ll evaluate what to do from there."

The api.rst file has the following text.

The plan at present is that we are adding hooks as people need them,
with community discussion.  If you find that you need a hook and
MediaGoblin at present doesn't provide it at present, please
`http://mediagoblin.org/pages/join.html <talk to us>`_!  We'll
evaluate what to do from there.

Obviously the link text is supposed to say "talk to us" and point to join.html, but apparently the rst format is incorrect.