From 7482f3eff8cd5c2c567265b576daae9c794fc2af Mon Sep 17 00:00:00 2001 From: Damyan Ivanov Date: Thu, 11 Nov 2021 09:20:17 +0000 Subject: [PATCH] fixed SQL param numbers --- bin/mpd-feeder | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/bin/mpd-feeder b/bin/mpd-feeder index 95227e9..ddc4a92 100755 --- a/bin/mpd-feeder +++ b/bin/mpd-feeder @@ -186,7 +186,7 @@ use constant DEFAULT_CONFIG_FILE => '/etc/mpd-feeder/mpd-feeder.conf'; $db->prepare_cached( <<'SQL')->execute( $song, $artist, $album, $db_generation ); INSERT INTO songs(path, artist, album, generation) -VALUES($1, $2, $3, $3) +VALUES($1, $2, $3, $4) ON CONFLICT ON CONSTRAINT songs_pkey DO UPDATE SET artist = $2 , album = $3 -- 2.39.5