Database error
Submitted Rimi, Aug 09 2012 03:00 AM | Last updated Aug 09 2012 09:41 AM
http://community.inv...embers-gallery/
Nuff said.
Nuff said.
| Status: | Fixed |
| Version: | 5.0.0 Beta 1 |
| Fixed In: | 5.0.0 Beta 1 |
2 Comments
I'm not getting an SQL error there, but it looks like others are. Here's what's logged
Date: Thu, 09 Aug 2012 04:07:52 +0000 Error: 1054 - Unknown column 'image_date' in 'order clause' IP Address: xyz - /gallery/category/4-members-gallery/ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT a.*,m.members_display_name, m.members_seo_name, m.member_id,mx.members_display_name as owners_members_display_name, mx.members_seo_name as owners_members_seo_name FROM ibf_gallery_albums a LEFT JOIN ibf_members m ON ( a.album_owner_id=m.member_id ) LEFT JOIN ibf_members mx ON ( a.album_owner_id=mx.member_id ) WHERE a.album_category_id IN (4) AND ( ( a.album_category_id IN(1,2,4,5) OR ( a.album_type=1 OR ( a.album_type=2 AND a.album_owner_id=0) OR ( a.album_type=3 AND ( a.album_owner_id=0) ) ) ) ) ORDER BY image_date asc LIMIT 0,25 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/ips/gallery/sources/classes/gallery/albums.php | [gallery_albums]._fetchAlbums | 575 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/gallery/modules_public/albums/category.php | [gallery_albums].fetchAlbumsByFilters | 253 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [public_gallery_albums_category].doExecute | 306 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'Updating Status to: Fixed
I was viewing grouped by members. Error came up when viewing by albums.