Drupal & IE: special Image Block fails after first time (help!!!) not solved!!!!

Continental

Joined: 2004-06-14
Posts: 243
Posted: Tue, 2006-01-17 14:42

1/ I am using some sort of code to display Images from the gallery on Drupal pages via php (some sort of ImageBlock, but just code). Now I have to display three different images (code two of them is below)

Under Opera and FireFox everything is ok. Under IE I have the problem: if I go first time on that page, it's ok. When I go second time and then, I see the ERROR (see below). It's everytime. I can delete cookies and the page will be loaded again, but only once, because after first time the error is repeating (noly on IE).

Link to see: [url]http://www.travelcamera.ru/lastadded [/url](try to load some times by F5)
Gallery: 2.0.2+ month ago
Module: gallery.module 2.1 *under Drupal 4.6.4*


<table width="100%">
<tr><td>
<strong>Последная Страна</strong>

<?php
require_once('/home/.oly/kostik/travelcamera.ru/content/embed.php');

$ret = GalleryEmbed::init(array(
'embedUri' => 'gallery', embedPath => '/', 'relativeG2Path' => 'content',
));

list ($ret, $bodyHtml, $headHtml) = GalleryEmbed::getImageBlock(array('blocks' => 'recentAlbum',
'show' => 'title', 'maxSize' => '550', 'itemId' => '3928', 'albumFrame' => 'dots'));

print $bodyHtml;
?>

</td><td><strong>Последний Город</strong>

<?php
require_once('/home/.oly/kostik/travelcamera.ru/content/embed.php');

$ret = GalleryEmbed::init(array(
'embedUri' => 'gallery', embedPath => '/', 'relativeG2Path' => 'content',
));

list ($ret, $bodyHtml, $headHtml) = GalleryEmbed::getImageBlock(array('blocks' => 'recentAlbum',
'show' => 'title', 'maxSize' => '550', 'itemId' => '4549', 'albumFrame' => 'dots'));

print $bodyHtml;
?>


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 t2_AccessMap.t_permission & 1 = 1' at line 8 query: INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (0, '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 &#039;)) AND t2_AccessMap.t_permission &amp; 1 = 1&#039; at line 8 query: SELECT totalcount, daycount, timestamp FROM node_counter WHERE nid = 77 в /home/.oly/kostik/travelcamera.ru/includes/database.mysql.inc на строке 66.', 2, '', '/node?PHPSESSID=80ad49ede310e3593d6ee8a7f285c04b', '85.140.187.208', 1137507379) in /home/.oly/kostik/travelcamera.ru/includes/database.mysql.inc on line 66

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 t2_AccessMap.t_permission & 1 = 1' at line 8 query: UPDATE sessions SET uid = 0, hostname = '85.140.187.208', session = 'messages|a:0:{}', timestamp = 1137507379 WHERE sid = '80ad49ede310e3593d6ee8a7f285c04b' in /home/.oly/kostik/travelcamera.ru/includes/database.mysql.inc on line 66

Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0

 
Continental

Joined: 2004-06-14
Posts: 243
Posted: Wed, 2006-01-18 11:45

Seems to be I found a solution. I wrote init(array... three times, on one page, that's was a problem. I just merged all three php-codes in one with one init and it worked out! Srange, that I saw it only on IE. Gonna learn basic php sometimes, now I need to show "Hello World" inside php and have no idea how to do it. Have to look somewhere.. thx and sorry for making waves in this forum. Hope, I found the right decision above.

 
Continental

Joined: 2004-06-14
Posts: 243
Posted: Wed, 2006-01-18 20:51

ha-ha... the solutions were wrong and didn't help later.
the mistake were in php-code filter in drupal, that doens't creat sql entry for "number of view for the node", that I used to create my image blocks (node_counts table, see error above). no entry - then error when trying to read it. that's not gallery, than' only drupal; sorry again for posting even not right forum but the wrong "site". ;-))))

 
Continental

Joined: 2004-06-14
Posts: 243
Posted: Sun, 2006-02-05 16:50

If anybody can help me? I'm trying again to start display image blocks and have the error:

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 t2_AccessMap.t_permission & 1 = 1' at line 8 query: INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (0, '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 &#039;)) AND t2_AccessMap.t_permission &amp; 1 = 1&#039; at line 8 query: SELECT * FROM blocks WHERE status = 1 AND region IN (0) ORDER BY weight, module в /home/.oly/kostik/travelcamera.ru/includes/database.mysql.inc на строке 66.', 2, '', '/', '82.148.12.48', 1139157907) in /home/.oly/kostik/travelcamera.ru/includes/database.mysql.inc on line 66

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 t2_AccessMap.t_permission & 1 = 1' at line 8 query: UPDATE sessions SET uid = 0, hostname = '82.148.12.48', session = '', timestamp = 1139157907 WHERE sid = '8099fb6fdcba8c8f71f9826e61b6de4d' in /home/.oly/kostik/travelcamera.ru/includes/database.mysql.inc on line 66

Still not solved! Anybody? Please!

 
Continental

Joined: 2004-06-14
Posts: 243
Posted: Mon, 2006-02-06 09:45

I moved further in my investigaion this issue and found who is guilty. It's Image Block. Image Block that are showed on Drupal pages from gallery.module. If it on, the problem persist. It it is no, the problem disappear. This is also kind of mess because I'm using it with combination with front_page module+displaying images from gallery by php code (found here). Now I switch it off, exept one page: http://www.travelcamera.ru/countries. You go to this page, then press logo to go to main and server crashes. If it is no, just try some more times. It will.

Kiz, any comments about this?

p.s.s.! in fact, it may be connected with my php-code I show multimply images. the switching off this block forced only the less crashes, but they are still present. To be continiued..