Hi,
After upgrading GA I cannot configure blocks created earlier. After clicking "configure" on block list (I.e. blocks - My Galleries, Galleries etc)
Drupal sends this:

Fatal error: Call to undefined function imagecache_presets() in ...my_domain/public_html/drupal/modules/gallery_assist/gallery_assist.module on line 3019

I'm just a simple user, not coder, please help

On my Drupal I have modules
GA 6.x-1.9-rc2
Gallery Assist for the Cooliris Viewer 6.x-1.1-beta4
Lightbox2 6.x-1.9
Drupal version: 6.16

konik21

konik21

CommentFileSizeAuthor
#2 gallery_assist_module-fix-2716628-1.9-rc2-imagecache_presets.patch788 bytesjcmc
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

jcmc’s picture

jcmc CreditAttribution: jcmc commented

Hello konik21,

please use the dev version (red). In this days I have commited to this Branch all new features and all fixes of knows issues I have solved in the last twoo weeks.

If you have questions after this not hesitate to aks here again.

Regards
Juan Carlos

jcmc’s picture

jcmc CreditAttribution: jcmc commented
FileSize
gallery_assist_module-fix-2716628-1.9-rc2-imagecache_presets.patch788 bytes

and here a patch for the 1.9-rc2 version

jcmc’s picture

jcmc CreditAttribution: jcmc commented
Title: Fatal error during blocks configuration » Fatal error during blocks configuration if imagecache is not installed

I chenge the title for better understanding.

konik21’s picture

konik21 CreditAttribution: konik21 commented

I changed module version you suggest me but the effect is worst. Gallery Blocks are working but I have red box at node page:

    * user warning: Unknown column 'show_in_homepage_block' in 'field list' query: SELECT gid, ref, gref, lang, ganame, description, in_profile, comments, show_title, show_in_homepage_block, gallery_assist_weight, data FROM bz0b_gallery_assist WHERE nid = 12 in /home/lesna/domains/kwiaciarnialesna.pl/public_html/drupal/modules/gallery_assist/gallery_assist.module on line 1403.
    * warning: Invalid argument supplied for foreach() in ...my_domain/public_html/drupal/modules/gallery_assist/gallery_assist.module on line 2283.
    * user warning: Unknown column 'show_in_homepage_block' in 'field list' query: SELECT gid, ref, gref, lang, ganame, description, in_profile, comments, show_title, show_in_homepage_block, gallery_assist_weight, data FROM bz0b_gallery_assist WHERE nid = 11 in ...my _domain/public_html/drupal/modules/gallery_assist/gallery_assist.module on line 1403.
    * user warning: Unknown column 'show_in_homepage_block' in 'field list' query: SELECT gid, ref, gref, lang, ganame, description, in_profile, comments, show_title, show_in_homepage_block, gallery_assist_weight, data FROM bz0b_gallery_assist WHERE nid = 10 in ...my_domain/public_html/drupal/modules/gallery_assist/gallery_assist.module on line 1403.
    * user warning: Unknown column 'show_in_homepage_block' in 'field list' query: SELECT gid, ref, gref, lang, ganame, description, in_profile, comments, show_title, show_in_homepage_block, gallery_assist_weight, data FROM bz0b_gallery_assist WHERE nid = 6 in ...my_domain/public_html/drupal/modules/gallery_assist/gallery_assist.module on line 1403.

Do you suggest me to install ImageCache module, does it helps?
Thank you for your help
konik21

jcmc’s picture

jcmc CreditAttribution: jcmc commented

please you have to run the update.php every time you update modules themes or the Drupal system.

You can call your update.php at http://www.example.com/update.php where example.com is your domain.

try and send ma feedback.

Regards
Juan Carlos

konik21’s picture

konik21 CreditAttribution: konik21 commented

Thank You, that was the problem. During updating I received many "red notes". After this, Drupal come into "Site Off-line" mode (several times) and after this it starts working correctly.

Thank you for your help,
konik21

jcmc’s picture

jcmc CreditAttribution: jcmc commented

Hello konik21,

now I don't know or this was a help or it is only irony.

Is this bug fixed or not. The run of the update.php belong to Drupal.
You left this issue open so I assume the problem still exists.

My english is not the best and sometimes I can not decrypt the message.

Please clarify me.

I thank you in advance
Juan Carlos

konik21’s picture

konik21 CreditAttribution: konik21 commented

Hi, Juan!

No worries! English it isn't my native language too.
Your notes helped me very much.
After updating (update.php) I saw his:



    * 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 ' data = 'a:7:bz0b_s:8:"ga_align";s:4:"left";s:9:"gap_align";s:4:"left";s:10:"t_g' at line 1 query: UPDATE bz0b_gallery_assist set show_in_homepage_block = , data = 'a:7:bz0b_s:8:"ga_align";s:4:"left";s:9:"gap_align";s:4:"left";s:10:"t_ga_float";s:4:"none";s:10:"p_ga_float";s:4:"none";s:11:"show_layout";s:4:"grid";s:14:"hide_in_teaser";i:0;s:6:"shadow";s:1:"1";' WHERE gref = 2 in ...l/public_html/drupal/modules/gallery_assist/gallery_assist.install on line 530.
    * 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 ' data = 'a:7:bz0b_s:8:"ga_align";s:6:"center";s:9:"gap_align";s:6:"center";s:10:' at line 1 query: UPDATE bz0b_gallery_assist set show_in_homepage_block = , data = 'a:7:bz0b_s:8:"ga_align";s:6:"center";s:9:"gap_align";s:6:"center";s:10:"t_ga_float";s:4:"none";s:10:"p_ga_float";s:4:"none";s:11:"show_layout";N;s:18:"show_download_link";N;s:6:"shadow";s:1:"0";' WHERE gref = 5 in.../public_html/drupal/modules/gallery_assist/gallery_assist.install on line 530.
    * 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 ' data = 'a:9:bz0b_s:8:"ga_align";s:6:"center";s:9:"gap_align";s:6:"center";s:10:' at line 1 query: UPDATE bz0b_gallery_assist set show_in_homepage_block = , data = 'a:9:bz0b_s:8:"ga_align";s:6:"center";s:9:"gap_align";s:6:"center";s:10:"t_ga_float";s:4:"none";s:10:"p_ga_float";s:4:"none";s:11:"show_layout";s:4:"grid";s:14:"hide_in_teaser";i:0;s:18:"show_download_link";i:0;s:11:"item_effect";s:7:"default";s:6:"shadow";s:1:"0";' WHERE gref = 4 in .../public_html/drupal/modules/gallery_assist/gallery_assist.install on line 530.
    * 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 ' data = 'a:9:bz0b_s:8:"ga_align";s:6:"center";s:9:"gap_align";s:6:"center";s:10:' at line 1 query: UPDATE bz0b_gallery_assist set show_in_homepage_block = , data = 'a:9:bz0b_s:8:"ga_align";s:6:"center";s:9:"gap_align";s:6:"center";s:10:"t_ga_float";s:4:"none";s:10:"p_ga_float";s:4:"none";s:11:"show_layout";N;s:6:"shadow";s:1:"0";s:18:"show_download_link";N;s:17:"ga_db_order_field";s:6:"weight";s:11:"ga_db_order";s:4:"DESC";' WHERE gref = 22 in .../public_html/drupal/modules/gallery_assist/gallery_assist.install on line 530.

but after this Drupal starts working correctly.

Why?

I have no idea :-)

konik21

jcmc’s picture

jcmc CreditAttribution: jcmc commented
Status: Active » Fixed

Ah ok konik21,

this is because I use db_query in the update function intead to use update_sql.

The last result is but correct.
The fields are changed and the data is update.
I think I will change this action to avoid this error. It is a cosmetic issue but better if not exists.

Thanks very much for clarify me.

Regards
Juan Carlos

jjancel’s picture

jjancel CreditAttribution: jjancel commented

Hi, Juan!

Thanks very much for the patch.

Thank you for your help

Regards
jjancel

Status: Fixed » Closed (fixed)

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