From e912d72ed4470f1d99fcf7c0ca3efc96d5cc4093 Mon Sep 17 00:00:00 2001 From: Kevin James 'purdyk' Purdy Date: Thu, 14 Aug 2008 22:34:40 +0000 Subject: Updated handshake stats SQL broken by lack of genre column in songs table. --- lib/class/api.class.php | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/lib/class/api.class.php b/lib/class/api.class.php index 09cb9997..6ccebe50 100644 --- a/lib/class/api.class.php +++ b/lib/class/api.class.php @@ -103,7 +103,7 @@ class Api { // Now we need to quickly get the totals of songs $sql = "SELECT COUNT(`id`) AS `song`,COUNT(DISTINCT(`album`)) AS `album`," . - "COUNT(DISTINCT(`artist`)) AS `artist`,COUNT(DISTINCT(`genre`)) as `genre` FROM `song`"; + "COUNT(DISTINCT(`artist`)) AS `artist` FROM `song`"; $db_results = Dba::query($sql); $counts = Dba::fetch_assoc($db_results); @@ -118,7 +118,6 @@ class Api { 'songs'=>$counts['song'], 'albums'=>$counts['album'], 'artists'=>$counts['artist'], - 'genres'=>$counts['genre'], 'playlists'=>$playlist['playlist']); } // match -- cgit