Page 1 of 1

Errors in Preferences | System tab

Posted: 21 Jul 2015, 08:41
by Aldursil
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

Re: Errors in Preferences | System tab

Posted: 21 Jul 2015, 08:54
by Aldursil
Hm, I looked at this a little further and I do have the 'af_sort_bayes' plugin but it is not enabled.

Re: Errors in Preferences | System tab

Posted: 21 Jul 2015, 09:17
by fox
well maybe you should look further a few more times because it is rather unlikely for an unloaded plugin to execute sql queries

Re: Errors in Preferences | System tab

Posted: 21 Jul 2015, 19:01
by Aldursil
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

Re: Errors in Preferences | System tab

Posted: 21 Jul 2015, 20:18
by fox
ok

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

Re: Errors in Preferences | System tab

Posted: 21 Jul 2015, 20:24
by Aldursil
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?

Re: Errors in Preferences | System tab

Posted: 21 Jul 2015, 20:32
by fox
post your postgresql version

Re: Errors in Preferences | System tab

Posted: 21 Jul 2015, 21:16
by Aldursil
fox wrote:post your postgresql version


8.4.20

Re: Errors in Preferences | System tab

Posted: 21 Jul 2015, 22:11
by fox
you'll need 9.1 to use this plugin i'm afraid

which was released in 2011 i might add

Re: Errors in Preferences | System tab

Posted: 21 Jul 2015, 22:48
by Aldursil
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.

Re: Errors in Preferences | System tab

Posted: 21 Jul 2015, 22:56
by fox
it is a mystery, it shouldn't try to do anything if it is disabled

Re: Errors in Preferences | System tab

Posted: 21 Jul 2015, 22:58
by Aldursil
fox wrote:it is a mystery, it shouldn't try to do anything if it is disabled


Thanks, I'll just ignore them.

Re: Errors in Preferences | System tab

Posted: 08 Oct 2015, 16:14
by Defined
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!

Re: Errors in Preferences | System tab

Posted: 08 Oct 2015, 16:46
by fox
problems with mysqldump of all things are definitely out of scope for this forum

you broke your database, have fun fixing it i guess

Re: Errors in Preferences | System tab

Posted: 08 Oct 2015, 17:02
by fox
welp it took me a while but i figured out why plugins init() was called

it should be fixed now