on: ​http://mediagoblin.org/pages/tour.html

'No compromises on taste'... "Just change the looks of MediaGoblin in any way you want _be_"

<by>

i noticed this issue when i listened to a cool song, send a comment and the song stops playing because the page is reloaded. the same problem when you watch a video.

this should be solved with the use of ajax for commenting, add to collection, on page edit of title, description etc like flickr or youtube.

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)