Image rotate not working

McBain

I'm trying to get my images rotated in my gallery. I need to rotate almost all of them by 270 degrees clockwise. I'm not sure if this is a problem with the installation of a user error on my part.

When I go into the albums -> gallery -> Images tab where it lists all the photos it does give me the option for Rotation under the utilities tab for each image. When I click on 270 degrees button and click apply it does nothing. When I click the box at the top right for the image and have the 270 degree button selected it still does nothing. When I have the 270 degree button selected and click on Refresh metadata it still does nothing.

What gives?

sbillard

Be sure you have cleared out any caches that might have captured the image before rotation. Also review all error logs to see if an error is occurring.

Some versions of the GD library do not support image rotation, but then the selection is disabled.

McBain

Yeah I cleared the cache folder then tried to re-rotate and still no rotation.

I do get a lot of these in my debug log:

{1111:Sun, 20 Oct 2013 03:27:55 GMT}
NOTICE: Undefined index: mysql_prefix in /var/www/zenphoto/zp-core/functions-db-MySQLi.php on line 297
db_show called from db_list_fields (functions-db-MySQLi.php [309])
from lookupSortKey (functions.php [265])
from Gallery->getAlbumSortKey (class-gallery.php [152])
from Gallery->getAlbums (class-gallery.php [192])
from Gallery->getNumAlbums (class-gallery.php [260])
from getTotalPages (template-functions.php [710])
from printPageListWithNav (template-functions.php [938])
from include (gallery.php [41])
from include (index.php [13])
from include (index.php [122])
from index.php [22]

McBain

I'm running CentOS 6.4 with php 5.3.3 and mysql 5.1.69

Would this mean that every time I rotate an image I have to clear the cache folder for the album?

sbillard

If an image is cached zenphoto displays it from the cache. So if you make any changes to the image rendition you will need to clear its cache--rotation and watermark are things that come quickly to mind.

You can clear just the album caches of the images you change.

Your error is strange indeed. What does your `overview` page show for the `Table prefix` in the `installation information`? It is pretty hard to see how anything could work if that index is not setup.

Also, for completeness, what Zenphoto version are you using and what is your theme?

McBain

Well since I'm using my own zenphoto DB I left the table prefix empty on the install so it doesn't even show a prefix there. I guess I should have left it the default?

I just installed the latest version, 1.4.5.5 and using the included Zenpage theme

sbillard

Empty should work. There will still be a prefix, just an empty one.

I really cannot see any path that leaves the `mysql_prefix` index missing but still allows anything at all to work. But perhaps since the prefix is actually empty things would work even with the error. Check your configuration file and be sure the prefix is defined in it.