...happened while I wanted to change update interval from 2 to 1 minute...
http://img194.imagevenue.com/img.php?image=12238_bounds_122_584lo.JPG
...happened while I wanted to change update interval from 2 to 1 minute...
http://img194.imagevenue.com/img.php?image=12238_bounds_122_584lo.JPG
Edited a feed yesterday and feedreader made a copy of it that contained the changes insted of changing the original feed. The copy wasn't displayed in the the tree view only unter the "manage feeds" view.
Example for original:
http: // feed / "word1%20word2"%20-filterword1.rss
1st edit:
http: // feed / word1%20word2%20-filterword1.rss
-> Saved
2nd edit:
http: // feed / word1%20word2%20-filterword1%20-filterword2.rss
-> Saved (I think here it happened)
Duplicate feeds as result:
http: // feed / word1%20word2%20-filterword1.rss
and
http: // feed / word1%20word2%20-filterword1%20-filterword2.rss
(The filterwords in the feeds have nothing to do with feedreader, they are part of the site's rss search function.)
Does it happen with every feed edit and always? How can I reproduce it? Today I tried both ways : File > Edit feeds and tried to change the link. Everything normal. Also "Edit feed" from popup menu. Everything normal again.
Maybe you can give me some real url what I could subscribe and also tell me what steps have to be taken for this error to occur. You can also send feed link to my personal email in case you do not want to publish it publically.
Popupmenu problem is already fixed BTW.
Greetings
Toomas
I edited one of my feeds today and instead of just saving the edited feed, feedreader kept the old one and made a second feed witch contained the changes but didn't display both feeds in the tree view window.
I saw it later when I recieved a lot of duplicate articles.
Original feed was like this:
http://feed/"word1%20word2"%20-filterword1.rss
First edit:
http://feed/word1%20word2%20-filterword1.rss
Second edit: (I think here it happened)
http://http://feed/word1%20word2%20-filterword1%20-filterword2.rss
Well obviously mysql server 5.1 is using up less memory than 5.0 although I use the same settings in both versons. But 5.1 produces these "Transaction/protected section timeout" errors isn't there a way to stop this?
And tell me please will you add the function to open an article in the browser from the context menu again? I really don't get why you removed this.
PS: I know you read this but I really feel like talking to myself on this one.
Hello!
Can you please try the latest EXE from here : http://www.feedreader.com/releases/mysql/feedreader.exe
We have bought back the "open in new browser window" command. It was really a bug and we did not have intention to remove it.
Greetings
Toomas
Umm.. it adds more "Downloads" every time I click on a new article and it's too wide? You should make the wide fixed and only show the full name of a feed or download when you hover over it...imho..
http://img170.imageshack.us/img170/6031/4253521kn6.png
Greetings,
I've notified design team, in next week, there will be new release.
Thank you for finding this bug
Ingmar
------
FR dev
LOOOL OMG IT WAS JUST CUZ RATINGS WAS ENABLED!! I'M GLAD I MADE A BACKUP BEFORE I DELETED THE ARCHIVES. I REALLY CAN'T REMEMBER ENABELING IT!
PS: I tell you what if the title bar wouldn't forget it's sitze and take on a huge length I would have probably seen it earlier....
I don't want to spam around here but I was misstaken, feedreader seems to start making problems again as soon as the database gets filled with articles. Especially unstarring articles works extremely delayed.
Something in the archives was corrupted. I had to delete everything but now it's working again and the hangs are gone...like my whole archive *cry* :-((((
Today the smartfeed I've been using to search in my archive was changed to an archive itself or at least it got the icon of an archive and I couldn't access it anymore. Also Feedreader has started to hang once in a while and I get more of these Transaction/protected section timeout errors. I don't know if it has something to do with optimizing the tables or with the update yet I haven't had these errors before.
30.04.2008 20:40:53: addr (00560CC1) thrd: 7760 Transaction/protected section timeout
Updated to the download from the "Development updates". Did you remove the "open article in browser" from the context menu? It was pretty usefull?
20.04.2008 04:44:36: addr (0067701A) thrd: 8000 (processFeedData) "feed" # (-2147467259) [MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]Server does not support 4-byte encoded UTF8 characters.
http://mysql2.mirrors-r-us.net/doc/refman/5.1/en/charset-unicode.html
RFC 3629 describes encoding sequences that take from one to four bytes. Currently, MySQL support for UTF-8 does not include four-byte sequences.
So currently the problem lies in mysql server.
I haven't tested yet, there is MySQL 5.1 Community Edition - Release Candidate Development Release. Maybe there are 4 bytes utf-8 chars supported. In MySql 6.0 alpa it's supported for sure, but currently FR is not compatible with this version.
Ingmar
------
FR dev
Wohw, thx, 5.1 appears to be slower... gonna change back to 5.0.
Btw. has the query_cache_size any effect on feedreaders performance?
5.0.51a and ODBC 5.1.4 works fine except of that one feed but that isn't important.
Haven't tested newest MYSQL community edition...
I FR is little bit slow, then in MYSQL you could run from MYSQL console following commands.
optimize table feedreader.articles;
optimize table feedreader.feeds;
optimize table feedreader.enclosures;
optimize table feedreader.articles_customfields;
optimize table feedreader.article_keywords;
optimize table feedreader.articles_links;
optimize table feedreader.links;
Ingmar
------
FR dev
Greetings,
innodb_buffer_pool_size
has more effect on feedreader. Then more indexes are in mem. exec is faster.
query_cache_size - This is useful, when you run N times same query, feedreader doesn't exec very much of same queries.
But, you can test it.
My computer uses following settings on (my.ini) innodb
innodb_additional_mem_pool_size=20M
innodb_flush_log_at_trx_commit=0
innodb_buffer_pool_size=256M
innodb_lock_wait_timeout=55
Ingmar
------
FR dev
Ok feedreader has been working very stable since the last time I reported something here. I also updated to mysql-connector-odbc-5.1.3. Nevertheless this happened after a unread count refresh, after a second refresh the counts were displayed correctly again, though. No idea what has happened it also never happened before so I guess it was just an exception.
http://img182.imageshack.us/img182/8439/3142541323frk7.jpg
Does version 3.13 have some kind of memory bug? I can remember that webviewcount=500 has always worked in the earlier versions. Now it has sometimes even problems to load the webview (alt + 3) with the same amount of filter words, less unread articles and webviewcount=400.
31.03.2008 10:32:23: addr (00522543) thrd: 27024 --- QRY OBJ 0001AC36BEC(THRD )27024[CONN OBJ 00000F2AADC] # (-2147217900) [MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR (articles.title LIKE (CONVERT(unhex('2535333634373625') USING utf8) collate ' at line 40 select articles.feed_Id as feedId,articles.id as artID,articles.guid as artGuid,articles.created as artCreated,articles.modified as artModified,cast('hex:'||hex(case when articles.title='' then substring(articles.body,1,512)||'...' else articles.title end ) AS char(50000000) charset latin1) as artTitle,cast('hex:'||hex(articles.summary ) AS char(50000000) charset latin1) as artSummary,cast('hex:'||hex(articles.creator ) AS char(50000000) charset latin1) as artCreator,articles.link as artLink,articles.readstatus as artRState,articles.flag as artFlag,articles.rating as artRating,articles.articleMD5,cast('hex:'||hex(articles.body ) AS char(50000000) charset latin1) as artBody,cast('hex:'||hex(articles.keywordCache ) AS char(50000000) charset latin1) as artkwCache,(select count(*) from enclosures where enclosures.article_id=articles.id) as encnt,feeds.feed_Id,cast('hex:'||hex(feeds.title) AS char(50000000) charset latin1) as title,feeds.link,feeds.homepage,feeds.favIcon,feeds.image,feeds.feedmodified,feeds.eTag,feeds.feedMD5,feeds.page_lastmodified,feeds.httpGetTime,feeds.update_interval,cast('hex:'||hex(feeds.username_) AS char(50000000) charset latin1) as username_,feeds.password_,feeds.archivesize,feeds.feedrating,feeds.keywordSeparator,feeds.lastHTTPCode,feeds.rtlEnabled,cast('hex:'||hex(feeds.OPMLdescr) AS char(50000000) charset latin1) as OPMLdescr,feeds.type_,feeds.priority FROM articles inner join feeds on (feeds.feed_id=articles.feed_id) and (feeds.link not like 'DELMARKED:%') and feeds.type_ not in ('OPML','OSRCROOT') WHERE ( ((articles.title LIKE (CONVERT(unhex(?) USING utf8) collate utf8_unicode_ci ) OR articles.body LIKE (CONVERT(unhex(?) USING utf8) collate utf8_unicode_ci ) ) OR OR (articles.title LIKE (CONVERT(unhex(?) USING utf8) collate utf8_unicode_ci ) OR articles.body LIKE (CONVERT(unhex(?) USING utf8) collate utf8_unicode_ci ) )) ) AND articles.deleted=0 order by articles.created desc LIMIT 0,500 # obj-state:stateActive
Got a couple of those...
31.03.2008 10:32:23: addr (00522543) thrd: 27024 --- QRY OBJ 0001AC36BEC(THRD )27024[CONN OBJ 00000F2A6CC] # (-2147217900) [MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR (articles.title LIKE (CONVERT(unhex('2535333634373625') USING utf8) collate ' at line 3 select count(articles.id) as cnt FROM articles WHERE ( ((articles.title LIKE (CONVERT(unhex(?) USING utf8) collate utf8_unicode_ci ) OR articles.body LIKE (CONVERT(unhex(?) USING utf8) collate utf8_unicode_ci ) ) OR OR (articles.title LIKE (CONVERT(unhex(?) USING utf8) collate utf8_unicode_ci ) OR articles.body LIKE (CONVERT(unhex(?) USING utf8) collate utf8_unicode_ci ) )) ) AND articles.readstatus=0 AND articles.deleted=0 LIMIT 0,2147483647 # obj-state:stateActive
Is it possible that you were creating some smartfeed and "feed preview" was active? I think that you were doing something like this. If these conditions are true then in case of incomplete smartfeed (in smartfeed edit window) you will not see any preview articles. But internally we still trigger this wrong SQL query. This results in error message in error file but no error in user interface. So internally it's not good but from user perspective it's not a problem :).
If you could delete error log and then try to create some smartfeed with preview active and then look at this error file again do you see these errors there again?.
Greetings
Toomas
1. I don't use the feed preview at all. I made two new smartfeeds with feed preview enabled, changed the rule set, tried to define the filter incorrectly, moved the smartfeeds to different folders, restarted feedreader and tried everything again but I got no errors at all.
2. Yesterday I removed one of the BP Smartfeeds (see the preview in the post below with the filter class error) cause it was bothering me that it always jumped back into the folder. Today the second BP smartfeed just disappeared...
---------------------------
Error
---------------------------
A error occured in program
Access violation at address 0057A064 in module 'feedreader.exe'. Read of address 73206578
---------------------------
OK
---------------------------
Nevertheless I could trigger another error right now. I thought maybe it wasn't a problem with the smartfeeds but with the PB Folder. So I moved all feeds from this folder to a new one and now the Smartfeeds don't jump around anymore... so problem solved.
Before that the rules disappeared from a smartfeed...
http://img92.imageshack.us/img92/6134/qrwtrqrwpn3.jpg
I have one folder and two smartfeeds named like this example:
XY Folder
XY Sfeed
XY Sfeed2
Now what happens is, that feedreader moves the two smartfeeds into the folder without doing anything !!!! That's really strange... I can move them back out again but they spontaneously jump back into the folder... I wouldn't have told this if it hadn't had happened a couple of times now...
http://img239.imagevenue.com/img.php?image=87292_35242_122_355lo.JPG
Another screen shot that has maybe to do with the same problem.
http://img182.imageshack.us/img182/5050/45232ch8.jpg
The error is reproducible, I can delete the problematic smartfeed, and when I make a new one it also happens with the new one.
xxx
I couldn't write it down since the froum blocks me as spam and I have to change my IP to get back in... :-/
Here is the screenshot of the text:
http://img140.imageshack.us/img140/8233/565343kt9.png