[1.8RC1] Trouble with thumbnails
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