Here's what I get when trying to browse the gallery. Got the "Access denied" error also when I tried to embed an attached file.

# user warning: Access denied for user 'drupaluser'@'localhost' to database 'drupaldb' query: CREATE TEMPORARY TABLE file_gallery (nid INT(10)) in /var/www/example.com/sites/all/modules/fileframework/contrib/gallery/file_gallery.module on line 158.
# user warning: Table 'drupaldb.file_gallery' doesn't exist query: SELECT COUNT(*) FROM file_gallery in /var/www/example.com/sites/all/modules/fileframework/contrib/gallery/file_gallery.module on line 168.
# user warning: Table 'drupaldb.file_gallery' doesn't exist query: SELECT nid FROM file_gallery LIMIT 0, 24 in /var/www/example.com/sites/all/modules/fileframework/contrib/gallery/file_gallery.module on line 168.

Comments

miglius’s picture

miglius commented

File gallery creates a temporal db table to properly display the metadata information in the sortable table. Your database user drupaldb does not have enough privileges in the database to create temporal tables.

miglius’s picture

miglius commented
Status: Active » Postponed (maintainer needs more info)

Can you grant your db user permissions to create new tables?

johanneshahn’s picture

johanneshahn commented
Status: Postponed (maintainer needs more info) » Closed (works as designed)

setting up correct user permission for sql db