ZenphotoCMS Forum
issue with Zenphoto version 1.4.4-DEV [10882] - Printable Version

+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: issue with Zenphoto version 1.4.4-DEV [10882] (/thread-10458.html)



issue with Zenphoto version 1.4.4-DEV [10882] - vincent3569 - 2012-09-29

hi

I want to have a first look on Zp 1.4.4.

I can't see any pictures of albums because I have thie fatal error :

`

Fatal error: MySQL Error: ( SELECT * FROM ``[prefix]imagesWHEREalbumid= 26 ORDER BY manual ) failed. MySQL returned the error Unknown column 'manual' in 'order clause' in /home/.../zenphoto_dev/zp-core/functions-db-MySQL.php on line 61




issue with Zenphoto version 1.4.4-DEV [10882] - sbillard - 2012-09-30

Do you have more information, for instance the stack trace. Should be able to find it in your debug log.




issue with Zenphoto version 1.4.4-DEV [10882] - fretzl - 2012-09-30

I can reproduce the error. It happens if images are sorted manually.
My stack trace:

`
USER ERROR: MySQL Error SELECT * FROM ''[prefix]images' WHERE 'albumid'= 4 ORDER BY manual ) failed. MySQL returned the error: Unknown column 'manual' in 'order clause'. in .../zp-core/functions-db-MySQL.php on line 61

trigger_error called from query (functions-db-MySQL.php [61])

from Album->sortImageArray (class-album.php [969])

  from Album->getImages (class-album.php [911])

    from printAlbumEditRow (admin-functions.php [2012])

      from printNestedAlbumsList (admin-functions.php [3476])

        from admin-edit.php [1673]

`




issue with Zenphoto version 1.4.4-DEV [10882] - acrylian - 2012-09-30

I can reproduce it as well.




issue with Zenphoto version 1.4.4-DEV [10882] - sbillard - 2012-09-30

Thanks, got it. Fix will be in tonight's build.