Gallery 3.2.2 Divide by 0 Error

Encounter the error when selecting the "top rated images" in the gallery.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Error: 8134 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Divide by zero error encountered.
/forums/index.php?app=gallery&module=stats&do=ratings
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
MSSQL query error:
SELECT COUNT(*) as count FROM gallery_images i LEFT JOIN members m ON ( m.member_id=i.member_id )
LEFT JOIN gallery_albums a ON ( i.album_id=a.id )
LEFT JOIN gallery_ratings r ON ( r.img_id=i.id AND r.member_id=6 ) WHERE ( i.category_id IN ( 2,1 ) OR i.album_id IN ( 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,28,29,30,31,32,33,35,38,39,40,41,42,43,44,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99 ) )
AND (i.ratings_total/i.ratings_count) > 0 AND i.approved=1

.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| E:\web\mistyairnet\htdocs\forums\ips_kernel\classDb.php | [db_driver_mssql].query | 1080 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| E:\web\mistyairnet\htdocs\forums\admin\applications_addon\ips\gallery\modules_public\stats\stats.php| [lib_imagelisting].getListingData | 211 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| E:\web\mistyairnet\htdocs\forums\admin\applications_addon\ips\gallery\modules_public\stats\stats.php| [public_gallery_stats_stats].topRated | 122 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| E:\web\mistyairnet\htdocs\forums\admin\sources\base\ipsController.php | [public_gallery_stats_stats].doExecute | 285 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Komentarze:

Brak komentarzy