Gawker Site full content feeds with broken youtube embeds

nowotny
Bear Rating Trainee
Bear Rating Trainee
Posts: 5
Joined: 24 Oct 2015, 15:17

Re: Gawker Site full content feeds with broken youtube embeds

Postby nowotny » 24 Oct 2015, 19:29

Hello.

While we wait for the fix from Gawker themselves (which will not work anyway ;) ) I wrote a small plugin to fix the issue. You can find it here: https://github.com/nowotny/ttrss-fix_gawker_embeds

Currently it only works with YouTube and Vimeo embeds. There are also Twitter embeds in the articles but those aren't supported yet (if ever).

Hoodah
Bear Rating Trainee
Bear Rating Trainee
Posts: 3
Joined: 19 Jun 2014, 10:42

Re: Gawker Site full content feeds with broken youtube embeds

Postby Hoodah » 25 Oct 2015, 07:53

nowotny wrote:Hello.

While we wait for the fix from Gawker themselves (which will not work anyway ;) ) I wrote a small plugin to fix the issue. You can find it here: https://github.com/nowotny/ttrss-fix_gawker_embeds

Currently it only works with YouTube and Vimeo embeds. There are also Twitter embeds in the articles but those aren't supported yet (if ever).


Thank you very much!
I was unable to get the retroactive fix to work, probably user error. But the new items are embedding correctly so that is really nice.

nowotny
Bear Rating Trainee
Bear Rating Trainee
Posts: 5
Joined: 24 Oct 2015, 15:17

Re: Gawker Site full content feeds with broken youtube embeds

Postby nowotny » 26 Oct 2015, 21:34

For the Vimeo fix to work correctly you should update to the latest TT-RSS version where the Vimeo player was whitelisted.

J M L
Bear Rating Trainee
Bear Rating Trainee
Posts: 13
Joined: 20 May 2013, 18:23

Re: Gawker Site full content feeds with broken youtube embeds

Postby J M L » 29 Oct 2015, 23:21

This seems to be working for me for Youtube. The retroactive fix fails with the log messages:

Code: Select all

E_WARNING (2)   classes/db/pgsql.php:38   pg_query(): Query failed: ERROR: syntax error at or near "`" LINE 1: SELECT `id`, `link`, `content` FROM `ttrss_entries`, `ttrss_... ^   username   13:55

E_WARNING (2)   classes/db/pgsql.php:57   pg_num_rows() expects parameter 1 to be resource, boolean given   username   13:55

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query SELECT `id`, `link`, `content` FROM `ttrss_entries`, `ttrss_user_entries` WHERE `ref_id` = `id` AND `unread` = 1 AND `owner_uid` = 2 failed: ERROR: syntax error at or near "`" LINE 1: SELECT `id`, `link`, `content` FROM `ttrss_entries`, `ttrss_... ^   username   13:55


That might give some clues to the error, but I don't know enough (any!) php or sql to debug it.

https://instagram.com/developer/embedding/ might offer some clues for fixing Instagram embeds. It might be as simple as replacing

Code: Select all

"/ajax/inset/iframe?id=instagram-78mUe8mU_y&autosize=1"

with (for a jpeg)

Code: Select all

https://instagram.com/p/78mUe8mU_y/media/

or (to get the embed stuff)

Code: Select all

https://api.instagram.com/oembed/?url=https://instagram.com/p/78mUe8mU_y/


Perhaps it's far more difficult than that.

nowotny
Bear Rating Trainee
Bear Rating Trainee
Posts: 5
Joined: 24 Oct 2015, 15:17

Re: Gawker Site full content feeds with broken youtube embeds

Postby nowotny » 30 Oct 2015, 22:10

J M L wrote:This seems to be working for me for Youtube. The retroactive fix fails with the log messages:

Code: Select all

E_WARNING (2)   classes/db/pgsql.php:38   pg_query(): Query failed: ERROR: syntax error at or near "`" LINE 1: SELECT `id`, `link`, `content` FROM `ttrss_entries`, `ttrss_... ^   username   13:55

E_WARNING (2)   classes/db/pgsql.php:57   pg_num_rows() expects parameter 1 to be resource, boolean given   username   13:55

E_USER_ERROR (256)   classes/db/pgsql.php:46   Query SELECT `id`, `link`, `content` FROM `ttrss_entries`, `ttrss_user_entries` WHERE `ref_id` = `id` AND `unread` = 1 AND `owner_uid` = 2 failed: ERROR: syntax error at or near "`" LINE 1: SELECT `id`, `link`, `content` FROM `ttrss_entries`, `ttrss_... ^   username   13:55


That might give some clues to the error, but I don't know enough (any!) php or sql to debug it.


I see you're using PostgreSQL db. I only tested with MySQL. I'll try to rewrite the SQL query so it suits both DB engines.

J M L wrote:Perhaps it's far more difficult than that.

Unfortunately it is... For the plugin to work the embeds must be served via iframe (the Twitter and Instagram aren't) and the domain must be whitelisted by the TT-RSS (currently only YouTube and Vimeo). I'll see if I may be able to fix it on the fly when the article is displayed.

User avatar
Radioraheem
Bear Rating Trainee
Bear Rating Trainee
Posts: 20
Joined: 01 Apr 2013, 19:00

Re: Gawker Site full content feeds with broken youtube embeds

Postby Radioraheem » 20 Apr 2017, 18:20

Looks like Gawker changed something again in their VIP RSS feeds (images broken mostly). I've had to edit all of my gawker feeds (deadspin, kotaku, lifehacker, etc.) to drop the /vip from the end of the URL in order to get them working again. At this point I'm done trying to use the VIP feed URLs as they obviously aren't paying any attention to them any longer regardless of what their support people say.

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

Re: Gawker Site full content feeds with broken youtube embeds

Postby fox » 20 Apr 2017, 18:27

aren't they bankrupt lol

User avatar
Radioraheem
Bear Rating Trainee
Bear Rating Trainee
Posts: 20
Joined: 01 Apr 2013, 19:00

Re: Gawker Site full content feeds with broken youtube embeds

Postby Radioraheem » 20 Apr 2017, 18:46

Nope, just sold. Gawker.com itself as blog was shutdown but all their other site properties got sold to Univision.


Return to “Everything else”

Who is online

Users browsing this forum: No registered users and 2 guests