[Postgres] Uppercase column issues #1411
Description
When a new feed is added, or when you want to change the category of a feed, it fails and the following comes to the log:
SQL error updateFeed: ERROR: column "pathentries" of relation "tcit_feed" does not exist
Indeed the schema is :
freshrss=# \d+ tcit_feed
Table "public.tcit_feed"
Column | Type | Modifiers | Storage | Stats target | Description
-----------------+------------------------+--------------------------------------------------------+----------+--------------+-------------
id | integer | not null default nextval('tcit_feed_id_seq'::regclass) | plain | |
url | character varying(511) | not null | extended | |
category | smallint | default 0 | plain | |
name | character varying(255) | not null | extended | |
website | character varying(255) | | extended | |
description | text | | extended | |
lastUpdate | integer | default 0 | plain | |
priority | smallint | not null default 10 | plain | |
pathEntries | character varying(511) | default NULL::character varying | extended | |
httpAuth | character varying(511) | default NULL::character varying | extended | |
error | smallint | default 0 | plain | |
keep_history | integer | not null default '-2'::integer | plain | |
ttl | integer | not null default '-2'::integer | plain | |
cache_nbEntries | integer | default 0 | plain | |
cache_nbUnreads | integer | default 0 | plain | |
Indexes:
"tcit_feed_pkey" PRIMARY KEY, btree (id)
"tcit_feed_url_key" UNIQUE CONSTRAINT, btree (url)
"tcit_keep_history_index" btree (keep_history)
"tcit_name_index" btree (name)
"tcit_priority_index" btree (priority)
Foreign-key constraints:
"tcit_feed_category_fkey" FOREIGN KEY (category) REFERENCES tcit_category(id) ON UPDATE CASCADE ON DELETE SET NULL
Referenced by:
TABLE "tcit_entry" CONSTRAINT "tcit_entry_id_feed_fkey" FOREIGN KEY (id_feed) REFERENCES tcit_feed(id) ON UPDATE CASCADE ON DELETE CASCADE
PostgreSQL version : 9.6.1
PHP version : 7.0.14