Gawker Site full content feeds with broken youtube embeds

[nowotny]

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]

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]

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]

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]

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.

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.

[Radioraheem]

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.

[fox]

aren't they bankrupt lol

[Radioraheem]

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