I Uploaded, enabled and created a gallery in Fast Gallery.
There where no images in the folder (it was found).
When going to the new gallery-link in the menu this message appeared:

* user warning: Table 'sypreme_se.cache_fast_gallery' doesn't exist query: SELECT data, created, headers, expire, serialized FROM cache_fast_gallery WHERE cid = 'fast_gallery_sites/default/files/gallery/' in /customers/sypreme.se/sypreme.se/httpd.www/includes/cache.inc on line 26.
* user warning: Table 'sypreme_se.fast_gallery_hierarchy' doesn't exist query: SELECT foid FROM fast_gallery_hierarchy WHERE folder='sites/default/files/gallery' ORDER BY folder in /customers/sypreme.se/sypreme.se/httpd.www/sites/all/modules/fast_gallery/storageengine/default.storage.inc on line 106.
* user warning: Table 'sypreme_se.fast_gallery_file' doesn't exist query: SELECT filename, folder, fgf.foid FROM fast_gallery_file as fgf, fast_gallery_hierarchy as fgh WHERE fgf.foid = fgh.foid AND fgh.folder = 'sites/default/files/gallery' ORDER BY filename asc in /customers/sypreme.se/sypreme.se/httpd.www/sites/all/modules/fast_gallery/storageengine/default.storage.inc on line 85.
* user warning: Table 'sypreme_se.fast_gallery_hierarchy' doesn't exist query: SELECT folder FROM fast_gallery_hierarchy WHERE pid = 0 ORDER BY folder asc in /customers/sypreme.se/sypreme.se/httpd.www/sites/all/modules/fast_gallery/storageengine/default.storage.inc on line 128.
* user warning: Table 'sypreme_se.cache_fast_gallery' doesn't exist query: UPDATE cache_fast_gallery SET data = 'a:0:{}', created = 1268391684, expire = 0, headers = '', serialized = 1 WHERE cid = 'fast_gallery_sites/default/files/gallery/' in /customers/sypreme.se/sypreme.se/httpd.www/includes/cache.inc on line 109.

See also attached image.

The error is probably due to server upgrade to PHP 5.3

Best regards //
Tim, Sweden

CommentFileSizeAuthor
error-fastgallery.jpg509.65 KBtimbrandin

Comments

rapsli’s picture

Status: Active » Postponed (maintainer needs more info)

check out the latest dev version. this should have most of the bugs fixed.

about PHP 5.3 I think Drupal has a problem with it anyways? Let me know if the latest dev version works

rochusweb’s picture

I've got the same problem using alpha3 but with php 6.16.

Replacing alpha3 with the latest dev version solved the problem. But somehow the confiuration (permission, etc.) disappeared. So I switched back to fast_gallery 6.x-4.0-beta7.

rapsli’s picture

well, 6.x-5 is going to go back to the roots. Features are going to get lost for more stability.

rapsli’s picture

Status: Postponed (maintainer needs more info) » Closed (fixed)

haven't heard anything anymore...

zolikonta’s picture

Version: 6.x-5.0-alpha2 » 6.x-5.0-beta1

Same issue here, after upgrading from 6.x-4.0-beta7 to 6.x-5.0-beta1

zolikonta’s picture

Status: Closed (fixed) » Active
rapsli’s picture

I don't think there's an upgrade path. You just have to do a clean install. Please let me know if this fixes your issue so I can make an announcement on the project site

zolikonta’s picture

Not sure about a clean install, but I tell you what I did.
-Disabled fast gallery module 6.x-4.0-beta7
-Uninstalled fast gallery module 6.x-4.0-beta7
-Deleted fast_gallery folder in sites/all/modules
-Copied fast gallery module 6.x-5.0-beta1
-Enabled fast gallery module 6.x-5.0-beta1

After all that, I got these error messages:
* user warning: Table 'cache_fast_gallery' already exists query: CREATE TABLE cache_fast_gallery ( `cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /var/home/***/public_html/includes/database.inc on line 550.
* user warning: Table 'fast_gallery_hierarchy' already exists query: CREATE TABLE fast_gallery_hierarchy ( `foid` INT unsigned NOT NULL auto_increment, `folder` TEXT NOT NULL DEFAULT '', `pid` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (foid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /var/home/***/public_html/includes/database.inc on line 550.
* user warning: Table 'fast_gallery_file' already exists query: CREATE TABLE fast_gallery_file ( `foid` INT unsigned NOT NULL, `filename` VARCHAR(255) NOT NULL DEFAULT '', `runid` INT unsigned NOT NULL DEFAULT 0, `filecreated` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (foid, filename) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /var/home/***/public_html/includes/database.inc on line 550.

Then I visited the admin/settings/fast_gallery/general page, where I noticed, that maybe the uninstall process was not worked correctly, because some of the settings remain as they were. (path to gallery, path alias, title of gallery, javascript framework)

-Finally clearing and rebuilding the gallery solved the problem (no error messages any more).

Though I little bit confused about the missing options that 4.0 branch had. Is there any security issues about the latest version of that 4.0-beta7? I would go back to that if you don't have any counterproposal.

rapsli’s picture

Status: Active » Fixed

Well, seems like you already have the tables in the db, that's what the error comes from. So yes, probably something went wrong with uninstalling everything.

4.0 branch was very feature rich, but also very buggy and hard to maintain. The 5.0 branch is a clean rewrite with the goal to better perform.

I'm looking into better integration with other modules (features, galleria, ...).

no, there are no security issues... if you get the 4.0 branch to work and like the features, just go ahead and use it.

zolikonta’s picture

Thank you for you quick reply.

My problem is with the 5.0 branch, that it is not what I was waiting for (folder image instead of earlier behavior, too big thumbnails etc), and I didn't find any options that could change these.

My other problem is that I can not 'downgrade' to 4.0
I uninstalled the module, and deleted all the files, even manually go to the database to drop tables beginning with fast_gallery.

But when I installed the module (using the quick start in the readme file), I got these errors on the gallery page:
* warning: mysqli_query() [function.mysqli-query]: Empty query in /var/home/***/public_html/includes/database.mysqli.inc on line 108.
* user warning: Table '***.fast_gallery_folders' doesn't exist query: CREATE TEMPORARY TABLE fast_gallery_all_folders Engine=HEAP SELECT * FROM fast_gallery_folders UNION SELECT * FROM fast_gallery_folders_noexif in /var/home/***/public_html/sites/all/modules/fast_gallery/fast_gallery.class.php on line 575.
* user warning: Table '***.fast_gallery_all_folders' 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/home/***/public_html/sites/all/modules/fast_gallery/fast_gallery.class.php on line 583.
* user warning: Table '***.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/home/***/public_html/sites/all/modules/fast_gallery/fast_gallery.class.php on line 583.
* user warning: Table '***.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/home/***/public_html/sites/all/modules/fast_gallery/fast_gallery.class.php on line 597.

Any of your advices would be appreciated.

rapsli’s picture

as for your 5.0 problems: size of the thumbnails: use imagecache and you can define the size of your thumbnails. Folder image: please create a new feature request. I don't think you are the only one. Also for the other features you'd like to see -> feature request: one feature per issue please.

The whole downgrading: I'm sorry... that's the reason we I started the 5.0 branch, the 4.0 branch just got out of hand and I'm not going to support it anymore. from what I can see from the error: there seems to be a problem with the installation of the tables.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.