Witajcie,
zaktualizowałem galerię do wersji 4, jednak po kliknięciu przycisku Browse na stronie głównej wyskakuje Driver Error. Log:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 08 Mar 2011 18:15:42 +0000
Error: 1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
IP Address: 127.0.0.1 - /dev/gallery/browse/
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT count(*) as count,i.*,m.members_display_name, m.members_seo_name FROM ibf_gallery_albums_main a LEFT JOIN ibf_gallery_images i ON ( i.id=a.album_cover_img_id )
LEFT JOIN ibf_members m ON ( i.member_id=m.member_id ) WHERE a.album_parent_id IN (0) AND ( ( (a.album_is_global=0 AND (
( a.album_is_public=1 AND ( ( FIND_IN_SET(2,a.album_g_perms_view) ) OR ( a.album_g_perms_view='*' ) ))
OR ( a.album_is_public=0 AND a.album_owner_id=0 )
OR ( a.album_is_public=2 AND ( a.album_owner_id=0 ) )
) ) OR (a.album_is_global=1 AND ( ( FIND_IN_SET(2,a.album_g_perms_view) ) OR ( a.album_g_perms_view='*' ) )) ) )
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| D:\www\dev\admin\applications_addon\ips\gallery\sources\classes\gallery\albums.php| [gallery_albums]._fetchAlbums | 441 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| D:\www\dev\admin\applications_addon\ips\gallery\modules_public\albums\browse.php| [gallery_albums].fetchAlbumsByFilters | 122 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| D:\www\dev\admin\applications_addon\ips\gallery\modules_public\albums\browse.php| [public_gallery_albums_browse]._getImageListing | 64 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| D:\www\dev\admin\sources\base\ipsController.php | [public_gallery_albums_browse].doExecute | 285 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
Dzieje się to również na świeżej instalacji. Jak to naprawić?