Errors With Foreign Characters In Some Feeds

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
User avatar
epyon_avenger
Bear Rating Trainee
Bear Rating Trainee
Posts: 21
Joined: 27 Mar 2013, 12:49
Location: A little place I like to call Earth.
Contact:

Errors With Foreign Characters In Some Feeds

Postby epyon_avenger » 05 Mar 2014, 13:51

At least, that's what I assume the trouble to be?

There have been a few Japanese, Korean, or Chinese language blogs I tried to add, but once I do after the initial population of the feed it seems to throw a bunch of errors and/or not update.

Initially, I just thought it was bad feeds as they were blog networks I wasn't really familiar with.

However, I just added one that was on tumblr, which is normally very reliable.

The feed is here: http://dakkun39.tumblr.com/rss

The errors I see are as follows.

Code: Select all

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      1:20

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 09:20', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      1:20

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      0:49

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 08:49', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      0:49

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      0:19

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 08:19', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      0:19

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 23:49

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 07:49', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 23:49

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 23:18

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 07:18', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 23:18

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 22:48

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 06:48', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 22:48

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 22:18

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 06:18', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 22:18

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 21:48

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 05:48', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 21:48

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 21:17

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 05:17', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 21:17

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 20:47

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 04:47', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 20:47

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 20:17

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 04:17', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 20:17

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 19:47

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 03:47', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 19:47

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 19:16

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 03:16', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 19:16

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 18:46

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 02:46', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 18:46

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 18:16

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 02:16', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 18:16

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 17:45

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 01:45', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 17:45

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 17:15

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 01:15', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 17:15

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 16:45

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 00:45', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 16:45

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 16:15

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-05 00:15', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 16:15

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 15:44

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-04 23:44', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 15:44

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 15:14

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-04 23:14', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 15:14

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 14:44

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-04 22:44', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 14:44

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 14:13

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-04 22:13', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 14:13

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 13:43

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-04 21:43', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 13:43

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 13:13

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-04 21:13', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 13:13

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 12:42

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-04 20:42', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      Mar 04, 12:42

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('1','=dragon age2=', '0') failed: ERROR: insert or update on table "ttrss_tags" violates foreign key constraint "ttrss_tags_post_int_id_fkey" DETAIL: Key (post_int_id)=(0) is not present in table "ttrss_user_entries".      Mar 04, 12:12

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('2013-12-12 15:36:24', 'SHA1:b3f6de67d98c9c8bbf24f9c1cd0d079cef1612e7', 'http://dakkun39.tumblr.com/post/69790846467', '2013/12/12 15:36:24', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', false, NOW(), '2014-03-04 20:12', '', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)

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

Re: Errors With Foreign Characters In Some Feeds

Postby fox » 05 Mar 2014, 14:21

Your horrible anime mass effect feed works fine here.

User avatar
epyon_avenger
Bear Rating Trainee
Bear Rating Trainee
Posts: 21
Joined: 27 Mar 2013, 12:49
Location: A little place I like to call Earth.
Contact:

Re: Errors With Foreign Characters In Some Feeds

Postby epyon_avenger » 05 Mar 2014, 21:09

Yes, it works fine on the initial follow and population of the feed, it's subsequent updates that seem to be the issue.

Though if that's also working for you, I'm not entirely sure which avenue I ought to take to run down the problem.

Do you have any suggestions on troubleshooting steps to take?

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

Re: Errors With Foreign Characters In Some Feeds

Postby fox » 05 Mar 2014, 21:59

I'll keep it subscribed until it updates then. You seem to have other database-related issues, e.g.

Code: Select all

'', '0', '', 'Array', '') failed: ERROR: value too long for type character varying(2)      0:49


This is some strange bullshit. It happened to other people but I was unable to replicate it.

User avatar
epyon_avenger
Bear Rating Trainee
Bear Rating Trainee
Posts: 21
Joined: 27 Mar 2013, 12:49
Location: A little place I like to call Earth.
Contact:

Re: Errors With Foreign Characters In Some Feeds

Postby epyon_avenger » 05 Mar 2014, 22:09

Yes, I'm not sure why that crops up, but if I remove the feed all those errors go away.

I can swap in any of the other feeds I've had the same issue with and it crops up again.

So far as the DB goes, I've been using the default options in PostgreSQL on Ubuntu, nothing fancy.

Do you have any language/character-set/other things on yours that might make the difference?

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

Re: Errors With Foreign Characters In Some Feeds

Postby fox » 05 Mar 2014, 22:18

Try disabling language detection in config.php. Maybe the library craps out somehow.

>Do you have any language/character-set/other things on yours that might make the difference?

Nah, it's en_US locale and tt-rss is using utf-8 anyway.

User avatar
epyon_avenger
Bear Rating Trainee
Bear Rating Trainee
Posts: 21
Joined: 27 Mar 2013, 12:49
Location: A little place I like to call Earth.
Contact:

Re: Errors With Foreign Characters In Some Feeds

Postby epyon_avenger » 05 Mar 2014, 22:20

I've already got the language detection disabled, but I'll double-check I'm all en_US/UTF-8 on the rest of the system just in case.

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

Re: Errors With Foreign Characters In Some Feeds

Postby fox » 05 Mar 2014, 22:51

If you have that disabled, I have no idea how that variable could be set to array. Either I'm not getting something or your php is malfunctioning.

e: post f D logs for that feed.

User avatar
epyon_avenger
Bear Rating Trainee
Bear Rating Trainee
Posts: 21
Joined: 27 Mar 2013, 12:49
Location: A little place I like to call Earth.
Contact:

Re: Errors With Foreign Characters In Some Feeds

Postby epyon_avenger » 05 Mar 2014, 22:53

I'll nuke my php/tt-rss and do a fresh install with the same db, see if it changes behavior and report back.

tob
Bear Rating Trainee
Bear Rating Trainee
Posts: 30
Joined: 08 Feb 2014, 20:35

Re: Errors With Foreign Characters In Some Feeds

Postby tob » 06 Mar 2014, 03:17

Not related to the database, just bad code. Never re-use variables, especially with other types.

When $lang->detect fails, the if block is skipped, and that empty array converted to a string for the database.

Hot fix:

Code: Select all

--- a/include/rssfuncs.php
+++ b/include/rssfuncs.php
@@ -610,6 +610,8 @@
          $entry_language = db_escape_string(substr($entry_language[0], 0, 2));
 
       _debug("detected language: $entry_language", $debug_enabled);
+   } else {
+      $entry_language = "";
    }
 }

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

Re: Errors With Foreign Characters In Some Feeds

Postby fox » 06 Mar 2014, 09:00

Ah right, it can return an empty array, I guess. My bad.

e: otoh it doesn't explain why is he getting this problem with language detect disabled.

tob
Bear Rating Trainee
Bear Rating Trainee
Posts: 30
Joined: 08 Feb 2014, 20:35

Re: Errors With Foreign Characters In Some Feeds

Postby tob » 06 Mar 2014, 11:19

Maybe he didn't restart the update daemon after changing config.php or something

User avatar
epyon_avenger
Bear Rating Trainee
Bear Rating Trainee
Posts: 21
Joined: 27 Mar 2013, 12:49
Location: A little place I like to call Earth.
Contact:

Re: Errors With Foreign Characters In Some Feeds

Postby epyon_avenger » 06 Mar 2014, 12:13

I did, actually.

I also tried running the update daemon interactively as opposed to a service, just for funs.

In any case, after nuking PHP + TT-RSS and redoing them both, I haven't seen it crop up again.

I'll let it sit for a while and add some of the other feeds that exhibited the same behavior to see if it crops up.

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

Re: Errors With Foreign Characters In Some Feeds

Postby fox » 06 Mar 2014, 12:32

You don't need to restart the daemon, each new update task is run with new parameters. Unless something within the master process changes, which is extremely rare.

tob
Bear Rating Trainee
Bear Rating Trainee
Posts: 30
Joined: 08 Feb 2014, 20:35

Re: Errors With Foreign Characters In Some Feeds

Postby tob » 06 Mar 2014, 13:07

Ah, passthru --daemon-loop, good to know


Return to “Support”

Who is online

Users browsing this forum: No registered users and 5 guests