Alternative Version - New Features and Fixed Issues

Thanks, this is by far the best gallery module to Drupal

Hello

I've try this version on one web site and it work without problems, great job !
On a second web site I have some problemes:
after configuring the module I clic on the link to show the galleries and I have this messages: see message.png

It look like the temporary tables are not created.
I've check the rights on mysql for this database and all the right are good (see mysql.png)

What can I do to find where is the problem ?
Drupal 6.4
MySQL: 5.0.32

Hi

I've found the problem:
In fast_gallery.class.php when you create a temporary table it's without the prefix (see in http://api.drupal.org/api/function/db_query_temporary/6 ).
then when you want to read this tables you must not put {} around the name of the table.
voilà

A second problem now:
My drupal is in a subfolder: drupal
when I clic on Fast galleries on my menu I have the first level of my galleries (http://xxx.xxx/drupal/fast_gallery) OK
If I clic on this first image it send me to http://xxx.xxx/drupal/drupal<?b>/fast_gallery/events and so on for each level!!!

OK I've found a solution for the second the problem, see the attached file for a version with a correction of the tow problems

Best regards
Philippe

Cool this works! However, when I click the thumbnail for a folder, it links to the adress like this:
http://mysite.com/ttp%3A/%252Fmysite.com/galleries/my-first-album
When I delete the incorrect part that has been added after the domain ("ttp%3A/%252F"), the gallery works, lightbox also works.

Philippe, thanks, your patched version in #4 solves my url problem too.

This now works on both my local testserver and the live server, very cool! This will be a very effective way of managing albums.

Happy that's help !!!
Thanks for your module is really usefull

Hi there,

I just tried this alt_v3 version, and it worked a lot better for me, but with hierarchy enabled, it shows no list of directories... Flat view works without a problem, but I eventually want to move this from a local test server to a live site, which has a lot of pictures in a lot of subfolders.

What it does show is an empty page, with only inside the div #fast_gallery are few div's with .clear followed by a br, and the pager, containing the exact same amount of pages as it would with just a flat view.

- Tried imagecache and internal one
- Tried adding pictures in the "root" gallery folder, didn't change anything
- the map name contains spaces, numbers and capitals, allthough I tried removing the spaces, numbers and capitals, and that didn't change anything.
- Friendly urls are on, turning them off didn't change anything..

So, again troubles with hierarchy... :(

Hm, I haven't tried the difference with this version, but what happens if you set the "sort by" to "name" for all sort options in Advanced?

Wow, fast reply :).

I'm using a xampplite install on a windows machine, and the live site is also on a windows machine, allthough it probably doesn't use xampp :).

1) is there a way to test/check for this? I have complete control over my local install...

2) Yes, but I disabled them and uninstalled them.

3) I always do that after changing settings. Clear DB, rescan and CTRL F5.

4) There is atm only 1 (sub)folder, containing 30 pictures, all in the format of DSC00001.JPG. Next to that subfolder, there are some testpics in the root folder. Those were added later, after I discovered that hierarchy didn't work for me.

5) No, and that won't be an issue for me. :)

6) I have my images located in the drupal root folder. Clarification: "path to gallery = foto/" for me. Inside that foto gallery, there are some loose images, and 1 folder, all lowercase, nothing special. Inside that folder are 30-ish images in the format of DSC00001.JPG.

7) Both those tables exist, and there is data in them. Data looks good to me. The only thing that looked strange to me, is that in the path contains both slashes and backslashes ( example: foto/subfolder\DSC00001.JPG ). Also, the parent field is empty for all my entries. Could the windows backslashes be it?

EDIT:

Skimming through the readme, I stumbled upon this:
* Filenames are treated with no regard to case, so don't give files the
same name.

Does that mean every filename needs to be unique, regardless of where they are? That would possibly be a big turnoff for me, as most files are straight from the camera, and don't have fancy filenames. So there could be dupes in the live site.

At the moment, the live site uses weatimages as gallery. Obviously this is not integrated in drupal, so I was looking for a good replacement of that one. This module has for me the most potential, so kudos for developing a straightforward, do-what-needs-to-be-done module! :)

Well, that fixed it only for a little bit. I uninstalled the module, flushed the caches, reinstalled v4. Still no bueno with hierarchy.

The only change is that there is no longer a pager in the sourcecode of the generated page. The page still consists of clearing div's and an (now empty) pager div.

In the database the backward slashes are indeed turned into forward slashes, BUT, the "parent" field is still empty for all images. What should be in the parent field anyway, the subfolder name?

EDIT: also, small fix suggestion: you use <br>. Most drupal themes are xhtml, so it should be <br />. If there really is a need for xhtml, is a totally different discussion, but the point is that we're stuck with xhtml, might as well conform with it :). With that said, is there really a need for a clearing div AND a br?

And it works now. :) Many thanks!

@br:
In your case you could give .single-image some extra bottom-padding.

Short story: It's the most stable work around. There are more elegant solutions, but enough time to worry about that later. :)

So, I moved the module to the live site, but guess what, more problems! :) Now the pager stopped working, it shows exactly the amount of pictures it should on 1 page, but no pager to different pages... And there are more pictures, of that I'm sure :P.

Seriously though, somehow magically the pager stopped functioning...

As a feature request: Could you make the folder list an item list?
$output = theme_item_list($tmp, NULL, 'ul', NULL) . $img_output;
instead of:
$output = implode(' | ', $tmp) . $img_output;

Another feature request: breadcrumbs while navigating through subfolders. Would be cool. :)

good work, but i have one problem, the special characters from the Portuguese language like "ç or à or ó" does not appear but if i go to mysql and do the update, then it works fine.

Woops, yup, breadcrumbs are out of my (custom) theme. I added it in the module for myself, since I don't need the breadcrumbs sitewide. :)

I'll also look into the pager stuff.... So far the tables look allright, all the fields have entries, and no backslashes, but I'll examine them more thorough.

I found a (dirty) solution for the pager problem:

// We need to specify a count query for pager_query()
//'.($result->num_rows + $result2->num_rows - $extra_count). '
$sql_count = 'SELECT COUNT(*) FROM fast_gallery_all_images';

This works for me....

I used print_r($sql_count), and that returned 0 for me while in a gallery which should have multiple pages. "extra_count" also returned zero, so I knew something went wrong with the counting of the rows. I just didn't know what :). After talking about it with my fellow siteadmin, who knows more about sql commands, but less of drupal, he suggested this and it worked. I realized that it didn't exactly do what you wanted it to do.

I'll try your code in a few hours and report back.

After changing it to your code
$sql_count = 'SELECT '.$result->num_rows;

it gives me the following error:

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT

And no pager. :)

Yup, that works. Thanks :)

When will the alternative version become the official?
It is already better.

ncy: Thank you for your work!

The German characters äöü are not recognized in this version, the remainder of the text is cut off (also in lightbox), cf. attached picture.
The caption should read "Ganz schön eng hier"...

Regards
jan

When just rescanning the gallery, my images got added again to the db. This is another consequence of the backslash problem, and it's fixed by doing this:

        // Only make database changes if there's no previous record found
        $value_slash = str_replace("\\", "/", $value);
        $sql = "SELECT gid FROM {fast_gallery} WHERE path = '%s'";
        $result = db_query($sql, $value_slash);

:)

I tried to install the new version but everytime i try to open the galerie it spams me with messages like:

user warning: Unknown column 'filetype' in 'field list' query: CREATE TEMPORARY TABLE fast_gallery_images_noexif Engine=HEAP SELECT path, folder, gid, filetype FROM fast_gallery WHERE folder='galerie' AND filetype <> 'jpg' AND filetype <> 'jpeg' ORDER by path asc

Was on vacation ... boa... lots happened here. I'll get my head around. I got no problems replacing the current version with this one... give me a couple days.

Man... I always have to go on vacation if code gets fixed like this :) Good work. I just had a very quick look at it today. For the most part. So, I suggest, I'm going to make this the new version in alpha stage, then I'm gonna have to go through the queue and clean a little bit up. New version should be out tomorrow.

a great module and great team work!!!

btw, it's possible to put the image description in the thumbnail view in the bottom of each thumbnail?

oky. next round is open...

How do I set the discription, I havent found that?

One more thing, the active class isn't added to my fast gallery menu link when I add it to my primary or secondary links. Could this have anything to do with the module?

It's a css class that dynamically get's added to a link in the primary or secondary menu, corresponding to the page your visiting.

For example, if you're on the page "test", the menu code would show as following:

<ul>
   <li><a href="www.domain.com/home" class="">Home</a></li>
   <li><a href="www.domain.com/test" class="active">Test</a></li>
   <li><a href="www.domain.com/page" class="">Page</a></li>
</ul>

...providing visual confirmation in the menu to show you where you are.

This works for all my current modules, but yet it fails for the gallery. I was wondering if it was something I did wrong, or that it might be a setting/bug in the module itself.

added the folderimage feature again -> user has the possibility to set an image to be displayed as folder (just like in win explorer). It's though still not finished.

ncy: I did some simple modules myself, and I don't recall setting the active class _myself_. I think it's something with the menu callback that goes wrong.

ncy i was not using the beta version... now everthing is fine, but:

- if you change the size of the thumbnail for a smaller size the text (description) will appear before the thumbnail at the left. Maybe if the text was center the problem does not happen . (look attachment file)

- the special characters not appear. If i wrote my first name "André" (like Andrew) it will appear "Andr", if i wrote something like "máquina" (machine) it will appear "m". but if i go to the sql and make and update to the field it works fine... this is very important for me and for all the people that no speak English (German, French, Portuguese, Brazilian, Spanish, and much more all have special characters)

thks

ncy if i change the css it works fine, thks.

About the special characters i lost some of my time study php (i am a ASP, VB developer) and i discover this:

on the fast_gallery.class.php if you change the line 246 to

   $param['description'] = $exif['IFD0']['ImageDescription'];
   $param['description'] = mb_convert_encoding( $param['description'], "UTF-8");

the special characters disappear but the rest of the word stays ok.

for example a Portuguese word like "rígido" became "rgido" in your version "rígido" became "r"

but the good news is, if you add this in the line 246

    $param['description'] = $exif['IFD0']['ImageDescription'];
   
    $bad = array("ú", "ç", "ã", "á", "ê", "é", "ó", "í");
    $good   = array("ú", "ç", "ã", "á", "ê", "é", "ó", "Ã");

    $param['description'] = str_replace($bad, $good, $param['description']);

the string appear ok!!!!!!

EDITED: just put the line 246 like this and it will work fine (i guess)

    $param['description'] = mb_convert_encoding($exif['IFD0']['ImageDescription'], "UTF-8", "ISO-8859-1");

committed to head