Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

_mysql_exceptions.OperationalError: (1366, "Incorrect string value #55

Open
damionx7 opened this issue Sep 24, 2020 · 0 comments
Open

Comments

@damionx7
Copy link

Hey there, Thanks for this great app. I have been getting this error when I tried to setup my first feed. How can I resolve it ?

Downloader error: (1366, "Incorrect string value: '\\x96!a@\\xA0\\xBE...' for column 'md5sum' at row 1")
Traceback: Traceback (most recent call last):
  File "/home/damion/.pyenv/versions/pol_rss/lib/python2.7/site-packages/twisted/web/_newclient.py", line 1306, in _bodyDataFinished_CONNECTED
    self._bodyProtocol.connectionLost(reason)
  File "/var/www/pol_rss/pol/client.py", line 76, in connectionLost
    self.deferred.callback(b''.join(self.dataBuffer))
  File "/home/damion/.pyenv/versions/pol_rss/lib/python2.7/site-packages/twisted/internet/defer.py", line 460, in callback
    self._startRunCallbacks(result)
  File "/home/damion/.pyenv/versions/pol_rss/lib/python2.7/site-packages/twisted/internet/defer.py", line 568, in _startRunCallbacks
    self._runCallbacks()
--- <exception caught here> ---
  File "/home/damion/.pyenv/versions/pol_rss/lib/python2.7/site-packages/twisted/internet/defer.py", line 654, in _runCallbacks
    current.result = callback(current.result, *args, **kw)
  File "/var/www/pol_rss/pol/server.py", line 214, in downloadDone
    self.writeResponse(sresponse)
  File "/var/www/pol_rss/pol/server.py", line 225, in writeResponse
    response_str = self.prepare_response_str(sresponse.selector, sresponse.headers, sresponse.body_as_unicode(), sresponse.url, ip)
  File "/var/www/pol_rss/pol/server.py", line 244, in prepare_response_str
    [response_str, post_cnt, new_post_cnt] = self.feed.buildFeed(selector, page_unicode, self.feed_config)
  File "/var/www/pol_rss/pol/feed.py", line 129, in buildFeed
    new_post_cnt = self.fill_time(feed_config['id'], items)
  File "/var/www/pol_rss/pol/feed.py", line 81, in fill_time
    self.save_post(conn, cur_time, feed_id, item)
  File "/var/www/pol_rss/pol/feed.py", line 36, in save_post
    values (unhex(%s), %s, %s)""", (post_fields['md5'], created, feed_id))
  File "/home/damion/.pyenv/versions/pol_rss/lib/python2.7/site-packages/MySQLdb/cursors.py", line 226, in execute
    self.errorhandler(self, exc, value)
  File "/home/damion/.pyenv/versions/pol_rss/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorvalue
_mysql_exceptions.OperationalError: (1366, "Incorrect string value: '\\x96!a@\\xA0\\xBE...' for column 'md5sum' at row 1")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant