RSS wont start, error message in terminal on run

[r00tz1]

Error in rss setup procedure: 'NoneType' object has no attribute 'cursor' (modules/rss.py:38)

Linux Mint is OS

Can anyone tell what I should do?

[embolalia]

What version of Willie are you using? (You can determine this by giving it the .version command.) Have you set up a database (from the configuration wizard or in your config file)? Which database type are you using (mysql or sqlite)?

[r00tz1]

afair i used the config wizzard and i chose sqlite. ~/.willie/ has a default.config with [core] and [admin] sections and no line mentions any db. Is that where to look? Version is commit db31cb4147baec01b20089e8e30a8f0cf13750f6
Merge: b5e8686 f322696

[brantje]

I've got an other error:
Error in rss setup procedure: (1170, "BLOB/TEXT column 'channel' used in key specification without a key length") (../../../../../lib/python2.7/dist-packages/MySQLdb/connections.py:36)
brantje: Willie v. 4.0.1-git

[brantje]

Solved by
except StandardError:
c.execute('''
CREATE TABLE IF NOT EXISTS rss_feeds
(channel TEXT, feed_name TEXT, feed_url TEXT, fg TINYINT, bg TINYINT,
enabled BOOL DEFAULT 1, article_title TEXT, article_url TEXT,
published TEXT, etag TEXT, modified TEXT, PRIMARY KEY (channel(255), feed_name(255)))
''')

[embolalia]

@r00tz1, I can't find that commit anywhere in our tree; I'm not sure where that came from. Try updating to the latest and then try to reproduce your error. Also, do you have a [db] section in your config? If not, that'd be the problem. You may need to run the setup wizard again, or just do it manually.

@brantje, where did you add that code? And how recently did you clone (i.e, what's the latest commit you have from us)? I think we had a problem like that, which we fixed a while ago.

[r00tz1]

Did git pull origin and also did again wizzard to choose database, now works. Anywhere can find more details on RSS usage, e.g. how to set the [fg] [bg] options and any other info on the RSS feature?

[brantje]

I've setup an rss feed, but the bot doesn't show new posts.

[embolalia]

@brantje Has this been fixed since you updated?

[brantje]

Nope

xbian@xbian ~ $ Traceback (most recent call last):
File "/home/xbian/ircbot/willie/bot.py", line 184, in _call
func(self.bot)
File "/home/xbian/ircbot/willie/modules/rss.py", line 368, in read_feeds
if fp.status == 301: # MOVED_PERMANENTLY
File "/usr/local/lib/python2.7/dist-packages/feedparser-5.1.3-py2.7.egg/feedparser.py", line 416, in getattr
raise AttributeError, "object has no attribute '%s'" % key
AttributeError: object has no attribute 'status'

[embolalia]

Are you fetching the RSS feed from a local file, rather than a web server? This page suggests that might be the culprit. (If so, we'll find a way to change that appropriately.)

[tyrope]

Might be fixed by 0d96c47 @r00tz1 please confirm.

[embolalia]

Looks like this was probably solved.