by JoyrexJ9 » Thu May 03, 2012 12:35 pm
Ahh ha there seems to be a problem with the database, there's a column missing
May 3 12:50:01 rss.cgi: Failed to run PQexec: ERROR: column "link" of relation "rss_item" does not exist LINE 1: INSERT INTO rss_item (feed_id, title, url, link, date, size)... ^
May 3 12:50:01 rss.cgi: database.c (79) Failed to exec [INSERT INTO rss_item (feed_id, title, url, link, date, size) VALUES (22, 'Game of Thrones 2x5 [720P - HDTV - IMMERSE]', 'http://torrent.zoink.it/Game.of.Thrones.S02E05.720p.HDTV.x264-IMMERSE.[e
May 3 12:50:01 rss.cgi: rss_internal.cpp:809 Failed to exec [INSERT INTO rss_item (feed_id, title, url, link, date, size) VALUES (22, 'Game of Thrones 2x5 [720P - HDTV - IMMERSE]', 'http://torrent.zoink.it/Game.of.Thrones.S02E05.720p.HDTV.x264-IMMER
FIXED IT!
* SSH onto Synology
* Issue command: /usr/syno/pgsql/bin/psql -t -A -U admin -d download
* Execute this SQL: alter table rss_item add column link text;
* Enter \q to leave PSQL