Hello, I am embedding Gallery2.0.1 in Drupal4.6.3 (latest of both, I believe) using the instructions from this website and the gallery.module from the drupal.org/project/gallery page. Everything works fine right up until I try to enable the Gallery Block.
Fatal error: 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 ')) AND g2_AccessMap.g_permission & 1 = 1' at line query: INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (1, 'php', '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 \')) AND g2_AccessMap.g_permission & 1 = 1\' at line query: INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (1, \'gallery\', \'Unable to get Gallery image block<br/>Error (ERROR_STORAGE_FAILURE)<ul><li><b>in</b> modules/core/classes/GalleryStorage/DatabaseStorage.class <b>at line</b> 1166 (gallerystatus::error) <li><b>in</b> modules/core/classes/GalleryStorage.clas in /home/knaddiso/public_html/includes/database.mysql.inc on line 66
Any advice?
I'd be happy to post this to the Drupal forums if the Gallery forums are the wrong place.
Thanks in advance for any help.
Greg
Posted: Thu, 2005-11-17 02:19
Posts: 32509
watchdog?
seems to be a drupal thing. deactivate it and check if g2 stuff works.
Posts: 189
Please see the replies I made to titus14 in http://gallery.menalto.com/node/22309?from=50&comments_per_page=50 . This may not help you fully, but may help in tracking down the problem. Particularly the code change I suggested there I'm hoping may help to understand the issue. Basically this seems to be a gallery.module issue (perhaps exacerbated by G2?) where it tries to insert an error into the watchdog but that insertion causes a problem. This then hides the real gallery error.
Posts: 13
Hi,
I have installed gallery 2 to drupal4.6.5 .When I tried to activate the image block through admin it displayed the error.
Unable to get Gallery image block
Error (ERROR_CONFIGURATION_REQUIRED)
in modules/core/classes/GalleryEmbed.class at line 764 (gallerystatus::error)
in /wstw/public_html/banter/modules/gallery/gallery.module at line 198 (galleryembed::getimageblock)
in ??? at line 0
in /wstw/public_html/banter/includes/module.inc at line 182
in /wstw/public_html/banter/modules/block.module at line 502
in ??? at line 0
in /wstw/public_html/banter/includes/module.inc at line 182
in /wstw/public_html/banter/includes/theme.inc at line 867
in ??? at line 0
in /home/wstw/public_html/banter/includes/theme.inc at line 194
in /home/wstw/public_html/banter/themes/engines/xtemplate/xtemplate.engine at line 202
in ??? at line 0
in /wstw/public_html/banter/includes/theme.inc at line 190
in /wstw/public_html/banter/modules/block.module at line 387
in ??? at line 0
in /wstw/public_html/banter/includes/menu.inc at line 354
in /wstw/public_html/banter/index.php at line 18
What should I have to do to get over this error.
Please help me.
Posts: 189
Have you installed the Image Block in Gallery2? See http://codex.gallery2.org/index.php/Gallery2:How_to_Embed_Gallery2_in_Drupal#Installation
Posts: 13
Hi,
Thanks for your comment.I have just forgotten to install image block.Now I installed it and working fine.
As I told my site is working fine but during installation time I got an error "Notice: Only variable references should be returned by reference in /home/wstw/public_html/banter/gallery2/lib/adodb/adodb.inc.php on line 2847 " This error is displayed on the screen about on 50 lines . I got this error on step 9 and 10.What should I have to do to get over this.Is it will affect my site badly.
Can you guide me
Shijina