Errors in Preferences | System tab

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
Aldursil
Bear Rating Master
Bear Rating Master
Posts: 106
Joined: 18 Mar 2013, 03:11

Errors in Preferences | System tab

Postby Aldursil » 21 Jul 2015, 08:41

I'm getting the below plugin errors. Is there something I can do to fix this?

I checked in the Plugins section and did not see a 'af_sort_bayes_categories' plugin that I could enable.

I'm using the git version.

E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('UGLY', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('BAD', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('GOOD', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^
E_WARNING (2) classes/db/pgsql.php:57 pg_num_rows() expects parameter 1 to be resource, boolean given
E_USER_ERROR (256) classes/db/pgsql.php:46 Query SELECT id FROM ttrss_plugin_af_sort_bayes_categories WHERE owner_uid = 1 LIMIT 1 failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: SELECT id FROM ttrss_plugin_af_sort_bayes_categories WHERE o... ^
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_wordfreqs ( word varchar(100) NOT NULL DEFAULT '', category_id INTEGER NOT NULL REFERENCES ttrss_plugin_af_sort_bayes_categories(id) ON DELETE CASCADE, owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE, count BIGINT NOT NULL DEFAULT '0') failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_wordfr... ^
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_references ( id SERIAL NOT NULL PRIMARY KEY, document_id VARCHAR(255) NOT NULL, category_id INTEGER NOT NULL REFERENCES ttrss_plugin_af_sort_bayes_categories(id) ON DELETE CASCADE, owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE) failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_refere... ^
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_categories ( id SERIAL NOT NULL PRIMARY KEY, category varchar(100) NOT NULL DEFAULT '', probability DOUBLE PRECISION NOT NULL DEFAULT '0', owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE, word_count BIGINT NOT NULL DEFAULT '0') failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_catego... ^
E_WARNING (2) classes/db/pgsql.php:61

Aldursil
Bear Rating Master
Bear Rating Master
Posts: 106
Joined: 18 Mar 2013, 03:11

Re: Errors in Preferences | System tab

Postby Aldursil » 21 Jul 2015, 08:54

Hm, I looked at this a little further and I do have the 'af_sort_bayes' plugin but it is not enabled.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Errors in Preferences | System tab

Postby fox » 21 Jul 2015, 09:17

well maybe you should look further a few more times because it is rather unlikely for an unloaded plugin to execute sql queries

Aldursil
Bear Rating Master
Bear Rating Master
Posts: 106
Joined: 18 Mar 2013, 03:11

Re: Errors in Preferences | System tab

Postby Aldursil » 21 Jul 2015, 19:01

Ok. I enabled the plugin and then started getting even more errors. These errors appear every minute.

E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('UGLY', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('BAD', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('GOOD', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^ admin 8:56
E_WARNING (2) classes/db/pgsql.php:57 pg_num_rows() expects parameter 1 to be resource, boolean given admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query SELECT id FROM ttrss_plugin_af_sort_bayes_categories WHERE owner_uid = 1 LIMIT 1 failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: SELECT id FROM ttrss_plugin_af_sort_bayes_categories WHERE o... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_wordfreqs ( word varchar(100) NOT NULL DEFAULT '', category_id INTEGER NOT NULL REFERENCES ttrss_plugin_af_sort_bayes_categories(id) ON DELETE CASCADE, owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE, count BIGINT NOT NULL DEFAULT '0') failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_wordfr... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_references ( id SERIAL NOT NULL PRIMARY KEY, document_id VARCHAR(255) NOT NULL, category_id INTEGER NOT NULL REFERENCES ttrss_plugin_af_sort_bayes_categories(id) ON DELETE CASCADE, owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE) failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_refere... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_categories ( id SERIAL NOT NULL PRIMARY KEY, category varchar(100) NOT NULL DEFAULT '', probability DOUBLE PRECISION NOT NULL DEFAULT '0', owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE, word_count BIGINT NOT NULL DEFAULT '0') failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_catego... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('UGLY', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('BAD', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('GOOD', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^ admin 8:56
E_WARNING (2) classes/db/pgsql.php:57 pg_num_rows() expects parameter 1 to be resource, boolean given admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query SELECT id FROM ttrss_plugin_af_sort_bayes_categories WHERE owner_uid = 1 LIMIT 1 failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: SELECT id FROM ttrss_plugin_af_sort_bayes_categories WHERE o... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_wordfreqs ( word varchar(100) NOT NULL DEFAULT '', category_id INTEGER NOT NULL REFERENCES ttrss_plugin_af_sort_bayes_categories(id) ON DELETE CASCADE, owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE, count BIGINT NOT NULL DEFAULT '0') failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_wordfr... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_references ( id SERIAL NOT NULL PRIMARY KEY, document_id VARCHAR(255) NOT NULL, category_id INTEGER NOT NULL REFERENCES ttrss_plugin_af_sort_bayes_categories(id) ON DELETE CASCADE, owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE) failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_refere... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_categories ( id SERIAL NOT NULL PRIMARY KEY, category varchar(100) NOT NULL DEFAULT '', probability DOUBLE PRECISION NOT NULL DEFAULT '0', owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE, word_count BIGINT NOT NULL DEFAULT '0') failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_catego... ^ admin 8:56
E_WARNING (2) classes/db/pgsql.php:38 pg_query(): Query failed: ERROR: relation "ttrss_plugin_af_sort_bayes_references" does not exist LINE 2: ... te, ttrss_user_entries AS tu, ttrss_feeds AS tf, ttrss_plug... ^ admin 8:56
E_WARNING (2) classes/db/pgsql.php:52 pg_fetch_assoc() expects parameter 1 to be resource, boolean given admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query SELECT te.title, category, tf.title AS feed_title FROM ttrss_entries AS te, ttrss_user_entries AS tu, ttrss_feeds AS tf, ttrss_plugin_af_sort_bayes_references AS tr, ttrss_plugin_af_sort_bayes_categories AS tc WHERE tf.id = tu.feed_id AND tu.ref_id = te.id AND tc.id = tr.category_id AND tr.document_id = te.guid ORDER BY te.id DESC LIMIT 20 failed: ERROR: relation "ttrss_plugin_af_sort_bayes_references" does not exist LINE 2: ... te, ttrss_user_entries AS tu, ttrss_feeds AS tf, ttrss_plug... ^ admin 8:56
E_WARNING (2) classes/db/pgsql.php:52 pg_fetch_assoc() expects parameter 1 to be resource, boolean given admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query SELECT category, probability, word_count, (SELECT COUNT(id) FROM ttrss_plugin_af_sort_bayes_references WHERE category_id = ttrss_plugin_af_sort_bayes_categories.id) as doc_count FROM ttrss_plugin_af_sort_bayes_categories WHERE owner_uid = 1 failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 4: FROM ttrss_plugin_af_sort_bayes_categories WHERE owner_u... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('UGLY', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('BAD', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('GOOD', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('UGLY', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^ admin 8:56
E_WARNING (2) classes/db/pgsql.php:57 pg_num_rows() expects parameter 1 to be resource, boolean given admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query SELECT id FROM ttrss_plugin_af_sort_bayes_categories WHERE owner_uid = 1 LIMIT 1 failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: SELECT id FROM ttrss_plugin_af_sort_bayes_categories WHERE o... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('BAD', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('GOOD', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_wordfreqs ( word varchar(100) NOT NULL DEFAULT '', category_id INTEGER NOT NULL REFERENCES ttrss_plugin_af_sort_bayes_categories(id) ON DELETE CASCADE, owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE, count BIGINT NOT NULL DEFAULT '0') failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_wordfr... ^ admin 8:56
E_WARNING (2) classes/db/pgsql.php:57 pg_num_rows() expects parameter 1 to be resource, boolean given admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_references ( id SERIAL NOT NULL PRIMARY KEY, document_id VARCHAR(255) NOT NULL, category_id INTEGER NOT NULL REFERENCES ttrss_plugin_af_sort_bayes_categories(id) ON DELETE CASCADE, owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE) failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_refere... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query SELECT id FROM ttrss_plugin_af_sort_bayes_categories WHERE owner_uid = 1 LIMIT 1 failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: SELECT id FROM ttrss_plugin_af_sort_bayes_categories WHERE o... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_wordfreqs ( word varchar(100) NOT NULL DEFAULT '', category_id INTEGER NOT NULL REFERENCES ttrss_plugin_af_sort_bayes_categories(id) ON DELETE CASCADE, owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE, count BIGINT NOT NULL DEFAULT '0') failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_wordfr... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_references ( id SERIAL NOT NULL PRIMARY KEY, document_id VARCHAR(255) NOT NULL, category_id INTEGER NOT NULL REFERENCES ttrss_plugin_af_sort_bayes_categories(id) ON DELETE CASCADE, owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE) failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_refere... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_categories ( id SERIAL NOT NULL PRIMARY KEY, category varchar(100) NOT NULL DEFAULT '', probability DOUBLE PRECISION NOT NULL DEFAULT '0', owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE, word_count BIGINT NOT NULL DEFAULT '0') failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_catego... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_categories ( id SERIAL NOT NULL PRIMARY KEY, category varchar(100) NOT NULL DEFAULT '', probability DOUBLE PRECISION NOT NULL DEFAULT '0', owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE, word_count BIGINT NOT NULL DEFAULT '0') failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_catego... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('UGLY', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('BAD', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('GOOD', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^ admin 8:56
E_WARNING (2) classes/db/pgsql.php:57 pg_num_rows() expects parameter 1 to be resource, boolean given admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query SELECT id FROM ttrss_plugin_af_sort_bayes_categories WHERE owner_uid = 1 LIMIT 1 failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: SELECT id FROM ttrss_plugin_af_sort_bayes_categories WHERE o... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_wordfreqs ( word varchar(100) NOT NULL DEFAULT '', category_id INTEGER NOT NULL REFERENCES ttrss_plugin_af_sort_bayes_categories(id) ON DELETE CASCADE, owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE, count BIGINT NOT NULL DEFAULT '0') failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_wordfr... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_references ( id SERIAL NOT NULL PRIMARY KEY, document_id VARCHAR(255) NOT NULL, category_id INTEGER NOT NULL REFERENCES ttrss_plugin_af_sort_bayes_categories(id) ON DELETE CASCADE, owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE) failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_refere... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_categories ( id SERIAL NOT NULL PRIMARY KEY, category varchar(100) NOT NULL DEFAULT '', probability DOUBLE PRECISION NOT NULL DEFAULT '0', owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE, word_count BIGINT NOT NULL DEFAULT '0') failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_catego... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('UGLY', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('BAD', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query INSERT INTO ttrss_plugin_af_sort_bayes_categories (category, owner_uid) VALUES ('GOOD', 1) failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: INSERT INTO ttrss_plugin_af_sort_bayes_categories (category,... ^ admin 8:56
E_WARNING (2) classes/db/pgsql.php:57 pg_num_rows() expects parameter 1 to be resource, boolean given admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query SELECT id FROM ttrss_plugin_af_sort_bayes_categories WHERE owner_uid = 1 LIMIT 1 failed: ERROR: relation "ttrss_plugin_af_sort_bayes_categories" does not exist LINE 1: SELECT id FROM ttrss_plugin_af_sort_bayes_categories WHERE o... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_wordfreqs ( word varchar(100) NOT NULL DEFAULT '', category_id INTEGER NOT NULL REFERENCES ttrss_plugin_af_sort_bayes_categories(id) ON DELETE CASCADE, owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE, count BIGINT NOT NULL DEFAULT '0') failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_wordfr... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_references ( id SERIAL NOT NULL PRIMARY KEY, document_id VARCHAR(255) NOT NULL, category_id INTEGER NOT NULL REFERENCES ttrss_plugin_af_sort_bayes_categories(id) ON DELETE CASCADE, owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE) failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_refere... ^ admin 8:56
E_USER_ERROR (256) classes/db/pgsql.php:46 Query CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_categories ( id SERIAL NOT NULL PRIMARY KEY, category varchar(100) NOT NULL DEFAULT '', probability DOUBLE PRECISION NOT NULL DEFAULT '0', owner_uid INTEGER NOT NULL REFERENCES ttrss_users(id) ON DELETE CASCADE, word_count BIGINT NOT NULL DEFAULT '0') failed: ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS ttrss_plugin_af_sort_bayes_catego... ^ admin 8:56

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Errors in Preferences | System tab

Postby fox » 21 Jul 2015, 20:18

ok

e: please continue not posting any relevant information about your install or w/e

Aldursil
Bear Rating Master
Bear Rating Master
Posts: 106
Joined: 18 Mar 2013, 03:11

Re: Errors in Preferences | System tab

Postby Aldursil » 21 Jul 2015, 20:24

fox wrote:ok

e: please continue not posting any relevant information about your install or w/e


What would be relevant? I told you an error I was receiving when the plugin was disabled. I checked again and it was still disabled. Ok, I enabled it and then posted the errors when it was enabled. How is this not relevant?

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Errors in Preferences | System tab

Postby fox » 21 Jul 2015, 20:32

post your postgresql version

Aldursil
Bear Rating Master
Bear Rating Master
Posts: 106
Joined: 18 Mar 2013, 03:11

Re: Errors in Preferences | System tab

Postby Aldursil » 21 Jul 2015, 21:16

fox wrote:post your postgresql version


8.4.20

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Errors in Preferences | System tab

Postby fox » 21 Jul 2015, 22:11

you'll need 9.1 to use this plugin i'm afraid

which was released in 2011 i might add

Aldursil
Bear Rating Master
Bear Rating Master
Posts: 106
Joined: 18 Mar 2013, 03:11

Re: Errors in Preferences | System tab

Postby Aldursil » 21 Jul 2015, 22:48

fox wrote:you'll need 9.1 to use this plugin i'm afraid

which was released in 2011 i might add


Thanks for the response. I was not trying to use the plugin but find out why I was getting those errors even with the plugin disabled.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Errors in Preferences | System tab

Postby fox » 21 Jul 2015, 22:56

it is a mystery, it shouldn't try to do anything if it is disabled

Aldursil
Bear Rating Master
Bear Rating Master
Posts: 106
Joined: 18 Mar 2013, 03:11

Re: Errors in Preferences | System tab

Postby Aldursil » 21 Jul 2015, 22:58

fox wrote:it is a mystery, it shouldn't try to do anything if it is disabled


Thanks, I'll just ignore them.

Defined
Bear Rating Trainee
Bear Rating Trainee
Posts: 4
Joined: 08 Oct 2015, 16:03

Re: Errors in Preferences | System tab

Postby Defined » 08 Oct 2015, 16:14

I also had a fresh install execute bayes related queries. It was a pull from your new Git repository about a month or so ago though I am unsure of the revision. The plugin was not enabled by default nor was the plugin ever enabled manually. For the time being I removed the plugin completely to de-clutter the log messages. However, when doing an SQL dump, I received this error: "mysqldump: Couldn't execute 'show create table `ttrss_plugin_af_sort_bayes_categories`': Table 'me_tinytiny.ttrss_plugin_af_sort_bayes_categories' doesn't exist (1146)". Would this help you form an explanation and possibly a fix to normalize the database? Thanks!

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Errors in Preferences | System tab

Postby fox » 08 Oct 2015, 16:46

problems with mysqldump of all things are definitely out of scope for this forum

you broke your database, have fun fixing it i guess

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Errors in Preferences | System tab

Postby fox » 08 Oct 2015, 17:02

welp it took me a while but i figured out why plugins init() was called

it should be fixed now


Return to “Support”

Who is online

Users browsing this forum: No registered users and 10 guests