Hi,

accessing the path "fast_gallery" results in the following errors in a fresh, but cleanly working D6 installation:

user warning: Access denied for user 'drupal'@'localhost' to database 'test_drupal' query: CREATE TEMPORARY TABLE fast_gallery_images Engine=HEAP SELECT path, folder, fg.gid, value FROM fast_gallery AS fg, fast_gallery_exif AS fe WHERE folder='sites/default/files/images/import' AND fg.gid=fe.gid AND fe.field='dateTaken' ORDER by value desc in /var/www/test/sites/all/modules/fast_gallery/fast_gallery.class.php on line 518.
user warning: Access denied for user 'drupal'@'localhost' to database 'test_drupal' query: CREATE TEMPORARY TABLE fast_gallery_folders Engine=HEAP SELECT path, fg.folder, fg.gid, fe.value FROM fast_gallery AS fg, fast_gallery_exif AS fe RIGHT JOIN (SELECT DISTINCT folder FROM fast_gallery WHERE parent='sites/default/files/images/import') AS fldrs ON 1 WHERE fg.folder=fldrs.folder AND fg.gid=fe.gid AND fe.field='dateTaken' GROUP by folder ORDER by value desc in /var/www/test/sites/all/modules/fast_gallery/fast_gallery.class.php on line 519.
user warning: Access denied for user 'drupal'@'localhost' to database 'test_drupal' query: CREATE TEMPORARY TABLE fast_gallery_images_noexif Engine=HEAP SELECT path, folder, gid, filetype FROM fast_gallery WHERE folder='sites/default/files/images/import' AND filetype <> 'jpg' AND filetype <> 'jpeg' AND filetype <> 'flv' AND filetype <> 'mov' AND filetype <> 'wmv' AND filetype <> 'asx' AND filetype <> 'swf' AND filetype <> 'pdf' ORDER by path desc in /var/www/test/sites/all/modules/fast_gallery/fast_gallery.class.php on line 532.
user warning: Access denied for user 'drupal'@'localhost' to database 'test_drupal' query: CREATE TEMPORARY TABLE fast_gallery_folders_noexif Engine=HEAP SELECT path, folder, gid, filetype FROM fast_gallery WHERE parent='sites/default/files/images/import' AND filetype <> 'jpg' AND filetype <> 'jpeg' AND filetype <> 'flv' AND filetype <> 'mov' AND filetype <> 'wmv' AND filetype <> 'asx' AND filetype <> 'swf' AND filetype <> 'pdf' GROUP by folder ORDER by path desc in /var/www/test/sites/all/modules/fast_gallery/fast_gallery.class.php on line 536.
user warning: Table 'test_drupal.fast_gallery_images' doesn't exist query: SELECT * FROM fast_gallery_images UNION SELECT * FROM fast_gallery_images_noexif in /var/www/test/sites/all/modules/fast_gallery/fast_gallery.class.php on line 541.
user warning: Access denied for user 'drupal'@'localhost' to database 'test_drupal' query: CREATE TEMPORARY TABLE fast_gallery_all_images Engine=HEAP SELECT * FROM fast_gallery_images UNION SELECT * FROM fast_gallery_images_noexif in /var/www/test/sites/all/modules/fast_gallery/fast_gallery.class.php on line 542.
user warning: Access denied for user 'drupal'@'localhost' to database 'test_drupal' query: CREATE TEMPORARY TABLE fast_gallery_all_folders Engine=HEAP SELECT * FROM fast_gallery_folders UNION SELECT * FROM fast_gallery_folders_noexif in /var/www/test/sites/all/modules/fast_gallery/fast_gallery.class.php on line 543.
user warning: Table 'test_drupal.fast_gallery_all_images' doesn't exist query: SELECT SUM(count) FROM (SELECT COUNT(*) AS count FROM fast_gallery_all_images UNION SELECT COUNT(*) AS count FROM fast_gallery_all_folders) AS tbl in /var/www/test/sites/all/modules/fast_gallery/fast_gallery.class.php on line 551.
user warning: Table 'test_drupal.fast_gallery_all_folders' doesn't exist query: SELECT path, folder, gid FROM fast_gallery_all_folders UNION SELECT path, folder, gid FROM fast_gallery_all_images LIMIT 0, 20 in /var/www/test/sites/all/modules/fast_gallery/fast_gallery.class.php on line 551.
user warning: Table 'test_drupal.fast_gallery_all_folders' doesn't exist query: SELECT path, folder, gid FROM fast_gallery_all_folders UNION SELECT path, folder, gid FROM fast_gallery_all_images in /var/www/test/sites/all/modules/fast_gallery/fast_gallery.class.php on line 558.

Accessing /admin/settings/fast_gallery/advanced results in those error(s):

warning: Invalid argument supplied for foreach() in /var/www/test/includes/form.inc on line 1416.
warning: Invalid argument supplied for foreach() in /var/www/test/includes/form.inc on line 1416.

On this page, clicking on the button "Install IC Presets" results in a JavaScript error message:

Ein Fehler ist aufgetreten. 
/fast_gallery/presets_install
&lt;br /&gt;
&lt;b&gt;Fatal error&lt;/b&gt;:  Call to undefined function imagecache_preset_save() in &lt;b&gt;/var/www/test/sites/all/modules/fast_gallery/fast_gallery.module&lt;/b&gt; on line &lt;b&gt;1030&lt;/b&gt;&lt;br /&gt;
&lt;div class=&quot;dev-memory-usage&quot;&gt;&lt;h3&gt;Memory usage:&lt;/h3&gt; Memory used at: devel_init()=&lt;strong&gt;1.38&lt;/strong&gt; MB, devel_shutdown()=&lt;strong&gt;17.87&lt;/strong&gt; MB.&lt;/div&gt;

Regards, -asb

Comments

rapsli’s picture

rapsli commented
Status: Active » Closed (won't fix)

it seems like your hosting doesn't support the creating of temporary tables, which you need.

asb’s picture

asb commented

Hi,

I'm on hosting on root servers for several years and never a similar issue with my Drupal installations. How would I tell this to MySQL, if the default permissions don't suffice?

MySQL permissions according to Installation guide:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON databasename.* TO 'username'@'localhost' IDENTIFIED BY 'password';

Greetings, -asb

rapsli’s picture

rapsli commented

sorry, I'm not very good with server stuff, but there is probably some permission to allow temporary tables. Ask google.

asb’s picture

asb commented

Hi,

the Faceted Search also requires (required?) non-standard database permissions; according to David Lesieur, one has to addinionally grant the LOCK TABLES and CREATE TEMPORARY TABLES permissions on the database; this might help "Fast Gallery", also.

Thanks & greetings, -asb