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
Comment #1
caskraker CreditAttribution: caskraker commentedI'm having the same problem on my testsite. Is this module still being supported?
It looks promising!
Comment #2
JThan CreditAttribution: JThan commentedThis is just a guess as I do not have these problems Did you call the update.php script aftre updating the module?
Comment #3
Bruce Tomalin CreditAttribution: Bruce Tomalin commentedHi,
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.
Comment #4
drudude CreditAttribution: drudude commentedhell.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:
...so i went to
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 :)