Hi,

I upgraded to the Gallery Assist 6.18 and now gallery assist doesn't work at all. I get the following error when I attempt to access module content.

user warning: Unknown column 'comments' in 'field list' query: SELECT gid, ref, gref, lang, ganame, description, in_profile, comments, show_title, show_in_homepage_block, gallery_assist_weight, data, (SELECT COUNT(DISTINCT(pid)) FROM gallery_assist_item p WHERE p.gref = gref) ga_counter FROM gallery_assist WHERE nid = 35 in /var/www/vhosts/awards.builderandengineer.co.uk/sites/all/modules/gallery_assist/gallery_assist.module on line 1816.

The content it still there but none of the images are visible.

I've tried re-saving the content without any success. I've tried re-running update.php and still no success.

I did get some errors when I upgraded to 6.18. The error log shows this at the time:-

Unknown column 'comments' in 'field list' query: SELECT gid, ref, gref, lang, ganame, description, in_profile, comments, show_title, show_in_homepage_block, gallery_assist_weight, data, (SELECT COUNT(DISTINCT(pid)) FROM gallery_assist_item p WHERE p.gref = gref) ga_counter FROM gallery_assist WHERE nid = 35 in /var/www/vhosts/awards.builderandengineer.co.uk/sites/all/modules/gallery_assist/gallery_assist.module on line 1816.

I don't have a back up to restore the database to as my useless hosting company say that the back up files are corrupt.

I don't have a copy of the an older version of Gallery assist to roll back to either.

Any advice gratefully received.

Comments

caskraker’s picture

I'm having the same problem on my testsite. Is this module still being supported?
It looks promising!

JThan’s picture

This is just a guess as I do not have these problems Did you call the update.php script aftre updating the module?

Bruce Tomalin’s picture

Hi,

Thank you for the reply, but yes we did run the update.php script, it is best to do that everytime you update a module or theme.

It's been so long since I posted this question that I have moved on and use a combination of lightbox and image styles now as we cannot get gallery assist to work.

drudude’s picture

hell.o - and first of all, please excuse my bad english ^_^

now bruce, i have to tell u that i was having the same problem.

My solution is not the best, but somehow, it worked - i'm not a programmer or somethin' like that :)

Now about you're comment:

user warning: Unknown column 'comments' in 'field list' query: SELECT gid, ref, gref, lang, ganame, description, in_profile, comments, show_title, show_in_homepage_block, gallery_assist_weight, data, (SELECT COUNT(DISTINCT(pid)) FROM gallery_assist_item p WHERE p.gref = gref) ga_counter FROM gallery_assist WHERE nid = 35 in /var/www/vhosts/awards.builderandengineer.co.uk/sites/all/modules/gallery_assist/gallery_assist.module on line 1816.

...so i went to

/sites/all/modules/gallery_assist/gallery_assist.module on line 1816

and deleted 'comments', then i went and flush all the image cache, i had to do a bunch of directory permissions for the gallery, also in the drupal permissions, and finally i gave all my galleries a -public for all- in the gallery assist settings. Oh yeah! the gallery lost a lot of customization, and somehow some of the content is missing - in action

if u find another way, please let me know :)