​https://github.com/campadrenalin/mediagoblin/tree/document-ubuntu-trusty-ffmpeg-issue

Starting in 14.04, Ubuntu mysteriously does not include the gstreamer0.10-ffmpeg package. It includes the various other gstreamer packages that the GMG audio and video code needs - it's just missing the one.

The easiest and safest way to get your ffmpeg fix is to add the universe repos from the previous version of Ubuntu to your sources.list. Trustworthy source, version numbers will be lower so it won't clobber any Trusty packages, etc. That's all it takes to get the missing package to work.

This branch updates the docs, to point users to the aforementioned fix, using the power of footnotes. Or rather, one footnote referenced in two places.

the coreprivileges_users table consists of two foreign key columns: coreuser_id and coreprivilege_id. However, coreuser_id contains privilege ids and coreprivilege_id contains user ids! For example, running the query "DELETE FROM coreprivileges_users WHERE coreuser_id=3;" will delete all of the uploader privileges. Bad stuff.

Here is the offending code:

class PrivilegeUserAssociation(Base):

This table holds the many-to-many relationship between User and Privilege

tablename = 'coreprivileges_users'

privilege_id = Column(

'coreprivilege_id', Integer, ForeignKey(User.id), primary_key=True)

user_id = Column(

'coreuser_id', Integer, ForeignKey(Privilege.id), primary_key=True)

The core__privileges_users table consists of two foreign key columns: core__user_id and core__privilege_id. However, core__user_id contains privilege ids and core__privilege_id contains user ids! For example, running the query DELETE FROM core__privileges_users WHERE core__user_id=3; will delete all uploader privileges for all users. Bad stuff.

Here is the offending code:

class PrivilegeUserAssociation(Base):
    '''
    This table holds the many-to-many relationship between User and Privilege
    '''

    __tablename__ = 'core__privileges_users'

    privilege_id = Column(
        'core__privilege_id',
        Integer,
        ForeignKey(User.id),
        primary_key=True)
    user_id = Column(
        'core__user_id',
        Integer,
        ForeignKey(Privilege.id),
        primary_key=True)