Loading...
 
Features / Usability

Features / Usability


[1.8RC1] Trouble with thumbnails

posts: 1

Hello there,

I'm trying to get the thumbnails to work in Image Galleries under PHP 4.3.3/Red Hat 7.2. I re-compiled PHP to include gd, which shows up properly under phpinfo(), yet I'm still getting an empty (red-cross) thumbnail image, which generates an error message (see below) when clicked on.

I also have a local copy running under Win2000/Apache, which does show an image in the thumbnails space, but it's not scaled!

1.8 bug / server setup / installation issue / option not set?

The question marks in the SQL query look suspicious to me.

Please let me know whether you have faced the same problem, and if so, whether you've been able to solve it.

Thanks,
Spiff06



Error message follows:

Input Array does not match ?: select i.`imageId`, i.`galleryId`, i.`name`, i.`description`, i.`created`, i.`user`, i.`hits`, i.`path`, d.`xsize`,d.`ysize`,d.`type`,d.`filesize`, d.`filetype`,d.`filename` from `tiki_images` i, `tiki_images_data` d where i.`imageId`='2' and d.`imageId`=i.`imageId` and d.`type`='s' and d.`xsize`='80' and d.`ysize`=

Warning: mysql 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 '' at line 9 in query:
select i.`imageId`, i.`galleryId`, i.`name`, i.`description`, i.`created`, i.`user`, i.`hits`, i.`path`, d.`xsize`,d.`ysize`,d.`type`,d.`filesize`, d.`filetype`,d.`filename` from `tiki_images` i, `tiki_images_data` d where i.`imageId`=? and d.`imageId`=i.`imageId` and d.`type`=? and d.`xsize`=? and d.`ysize`=?
in /home/spiff/public_html/tiki/lib/tikilib.php on line 276
Values:
Array ( 0 => 2 1 => s 2 => 80 )
$result is false
$result is empty

posts: 1001 Canada

Hey spiff,
Is it you that already reported this red cross bug?
If not and you can't find it at ImageGalleryDev I'll try to find it for you, but anyway it's not solved yet.
At least we may be able to find what's the problem.
About the problem you get on Windows, it's a post-1.7.3 problem except if you tested with GIFs.
By the way PHP 4.3 should include GD by default :question:and this is not the right forum for such messages, go to SourceForge instead (sorry...).