taroved / pol

RSS generator website
MIT License
381 stars 88 forks source link

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

Open damionx7 opened 4 years ago

damionx7 commented 4 years ago

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")