I get the following error when trying to create dir and thumbs, and if I look at the logs it seems to only be with AVI files, I used to has the exact same album running fine, I have just reinstalled and this the error I am getting the only diff is the new versions of mysql apache and php, it seems none of the avi's have thumbs now, any ideas
mysql error: [1064: 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 'WHERE id='6248'' at line 1] in EXECUTE("UPDATE linpha_photos SET thumbnail= WHERE id='6248'")
100.00 % done, working on file: albums/Trips & Travels/Croyde/Clips/Pic55.avi
Error while creating image ./albums/Trips & Travels/Croyde/Clips/Pic55.avi! Return Value: 255
C:\convert -quality 100 "./graphics/avi_mov.gif" -resize "36x36" miff:- | C:\composite -quality 75 -size "120x120" -dissolve 100 -gravity southeast -geometry +5+5 "-" ".\albums\Trips & Travels\Croyde\Clips\Pic55.avi" -resize "120x120" +profile "*" -colorspace RGB ".\sql\tmp\video_thumbnail_528710bb03f064450a4549780b59e412_0.jpg"
I get the following error when trying to create dir and thumbs, and if I look at the logs it seems to only be with AVI files, I used to has the exact same album running fine, I have just reinstalled and this the error I am getting the only diff is the new versions of mysql apache and php, it seems none of the avi's have thumbs now, any ideas
mysql error: [1064: 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 'WHERE id='6248'' at line 1] in EXECUTE("UPDATE linpha_photos SET thumbnail= WHERE id='6248'")
100.00 % done, working on file: albums/Trips & Travels/Croyde/Clips/Pic55.avi
Error while creating image ./albums/Trips & Travels/Croyde/Clips/Pic55.avi! Return Value: 255
C:\convert -quality 100 "./graphics/avi_mov.gif" -resize "36x36" miff:- | C:\composite -quality 75 -size "120x120" -dissolve 100 -gravity southeast -geometry +5+5 "-" ".\albums\Trips & Travels\Croyde\Clips\Pic55.avi" -resize "120x120" +profile "*" -colorspace RGB ".\sql\tmp\video_thumbnail_528710bb03f064450a4549780b59e412_0.jpg"
./sql/tmp/video_thumbnail_528710bb03f064450a4549780b59e412_0.jpg
Windows XP SP2
Apache 2.0
Mysql 4.1.11
PHP 4.3.11
disable the option to create video thumbnails in the admin pages
greets flo