[Librefm-commits] [1160] use reportError() in stc

[Clint Adams]

Revision: 1160
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1160
Author:   clint
Date:     2009-05-03 20:23:26 +0000 (Sun, 03 May 2009)
Log Message:
-----------
use reportError() in stc

Modified Paths:
--------------
    trunk/gnukebox/scrobble-utils.php

Modified: trunk/gnukebox/scrobble-utils.php
===================================================================
--- trunk/gnukebox/scrobble-utils.php   2009-05-03 20:19:18 UTC (rev 1159)
+++ trunk/gnukebox/scrobble-utils.php   2009-05-03 20:23:26 UTC (rev 1160)
@@ -140,14 +140,17 @@
        }
 
        if(!$res->numRows()) {
-               // Create new track
-               $res = $mdb2->exec("INSERT INTO Scrobble_Track (name, artist, 
album, mbid, track) VALUES ("
+               $sql = "INSERT INTO Scrobble_Track (name, artist, album, mbid, 
track) VALUES ("
                        . "lower(" . ($track) . "), "
                        . "lower(" . ($artist) . "), "
                        . (($album == 'NULL') ? "NULL" : "lower(" . ($album)) . 
"), "
                        . (($mbid == 'NULL') ? "NULL" : "lower(" . ($mbid)) . 
"), "
-                       . ($tid) . ")");
+                       . ($tid) . ")";
+               $res = $mdb2->exec($sql);
                if(PEAR::isError($res)) {
+                       $msg = $res->getMessage() . " - " . $res->getUserInfo();
+                       reportError($msg, $sql);
+
                        die("FAILED stc " . $res->getMessage() . "\n");
                }
                return getScrobbleTrackCreateIfNew($artist, $album, $track, 
$mbid, $tid);