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.

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?

When using a client such as pypump to post content to GMG via the API, postgresql complains about an invalid timestamp syntax. Postgresql seems to expect a datetime string instead of Unix epoch integer.

DataError: (DataError) invalid input syntax for type timestamp: "1414412402"