MySQL error 256 when rss item with inner image

If you run tt-rss on an officially unsupported platform (shared hosting, Windows, etc.) post here
AK666
Bear Rating Trainee
Bear Rating Trainee
Posts: 7
Joined: 01 Dec 2015, 20:09

MySQL error 256 when rss item with inner image

Postby AK666 » 01 Dec 2015, 20:22


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

Re: MySQL error 256 when rss item with inner image

Postby fox » 03 Dec 2015, 16:07

hmm imported fine here on postgres

e: also on mysql

strange issues w/ escaping somehow failing were reported before, i think, but so far nobody figured out why this happens to some people

another possibility is some weird unicode stuff going on with this mysql database

AK666
Bear Rating Trainee
Bear Rating Trainee
Posts: 7
Joined: 01 Dec 2015, 20:09

Re: MySQL error 256 when rss item with inner image

Postby AK666 » 22 Dec 2015, 05:24

same error on another rss

the XML <item></item> size is 3.2 Mb

I think this error when data more then [WHAT] ?

Can truncate "content" value when parsing xml and before post to the server ?
Or what I can change in php or mysql settings to put big data ?
Last edited by AK666 on 22 Dec 2015, 05:27, edited 2 times in total.

AK666
Bear Rating Trainee
Bear Rating Trainee
Posts: 7
Joined: 01 Dec 2015, 20:09

Re: MySQL error 256 when rss item with inner image

Postby AK666 » 22 Dec 2015, 05:25

I cant attach file with Item to forum. "File size to big"

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

Re: MySQL error 256 when rss item with inner image

Postby fox » 22 Dec 2015, 09:03

while it is obvious that your system is misconfigured or limited somehow this is not a general support forum so we can't really help you here

to me it looks like shared hosting issues, so even your posting in Support is questionable

AK666
Bear Rating Trainee
Bear Rating Trainee
Posts: 7
Joined: 01 Dec 2015, 20:09

Re: MySQL error 256 when rss item with inner image

Postby AK666 » 22 Dec 2015, 15:38

ok, thnx.

AK666
Bear Rating Trainee
Bear Rating Trainee
Posts: 7
Joined: 01 Dec 2015, 20:09

Re: MySQL error 256 when rss item with inner image

Postby AK666 » 22 Dec 2015, 16:18


JustAMacUser
Bear Rating Overlord
Bear Rating Overlord
Posts: 373
Joined: 20 Aug 2013, 23:13

Re: MySQL error 256 when rss item with inner image

Postby JustAMacUser » 22 Dec 2015, 19:36

Wouldn't it be easier to use a plugin that filters each article? You could find img tags whose src attribute starts with data: and remove the tag, replace the src value, or even save the image locally and change the src attribute to the new location.

e: The real solution is to find out why your MySQL install is broken. But the plugin is a much better workaround than hacking the core to arbitrarily limit the content.

AK666
Bear Rating Trainee
Bear Rating Trainee
Posts: 7
Joined: 01 Dec 2015, 20:09

Re: MySQL error 256 when rss item with inner image

Postby AK666 » 23 Dec 2015, 09:56

Hi

I dont know how write|create plugin for tt-rss, but this changes is quickly for me.

If this plugin exist prompt it name please

JustAMacUser
Bear Rating Overlord
Bear Rating Overlord
Posts: 373
Joined: 20 Aug 2013, 23:13

Re: MySQL error 256 when rss item with inner image

Postby JustAMacUser » 23 Dec 2015, 11:45

Umm, doesn't exist. It's just a better approach than modifying the core, which is going to be difficult to maintain during updates and creates the potential to break your install of TT-RSS down the road.

Plus, there's literally a hook that lets you modify an article's content right before inserting it into the database--it even passes a DOMDocument object for your convenience. Doesn't get better than that!

Anyway, I'm on my phone at the moment so I'm not going to be coding, but if I remember later it would be easy enough to do.

AK666
Bear Rating Trainee
Bear Rating Trainee
Posts: 7
Joined: 01 Dec 2015, 20:09

Re: MySQL error 256 when rss item with inner image

Postby AK666 » 23 Dec 2015, 13:27


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

Re: MySQL error 256 when rss item with inner image

Postby fox » 23 Dec 2015, 13:44

since this thread is now about your obviously broken system, i'm moving it to unsupported subforum

JustAMacUser
Bear Rating Overlord
Bear Rating Overlord
Posts: 373
Joined: 20 Aug 2013, 23:13

Re: MySQL error 256 when rss item with inner image

Postby JustAMacUser » 23 Dec 2015, 20:45



Return to “Unsupported platforms”

Who is online

Users browsing this forum: No registered users and 2 guests