回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我目前正在用python开发一个scraper,它从RSS提要中收集紧急服务通告。在我想向MySQL数据库添加公告的时候,我遇到了一个奇怪的错误。我找不到任何关于它的东西。关于这一部分:</p>
<pre><code> sql = "INSERT INTO meldingen(melding_title, melding_description, melding_category, melding_region, melding_location, melding_zipcode, melding_emergency, melding_date) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')"
uniqueRows.<a href="https://www.cnpython.com/list/append" class="inner-link">append</a>(hash)
#print uniqueRows
# Execute the SQL command
cursor.execute(sql,(str(title), str(description), str(category), str(region), str(location), str(zipcode), str(emergency), date.strftime('%Y-%m-%d %H:%M:%S')))
# Commit your changes in the database
conn.commit()
</code></pre>
<p>我得到了以下错误:</p>
<blockquote>
<p>Traceback (most recent call last):
File "C:/Users/Nicky/Documents/alarmeringen/P2000Scraper.py", line 83, in
cursor.execute(sql,(str(title), str(description), str(category), str(region), str(location), str(zipcode), str(emergency), date.strftime('%Y-%m-%d %H:%M:%S')))
File "C:\Python27\lib\site-packages\MySQLdb\cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 36, in defaulterrorhandler
raise errorvalue
_mysql_exceptions.ProgrammingError: (1064, "Erreur de syntaxe pr\xe8s de 'p 2 stank soort lucht: koolmonoxide/co vk: 6 troelstrakade dhg 7630'', ''Brandwe' \xe0 la ligne 1")</p>
</blockquote>
<p>我不明白这个错误。如果有人能帮忙那就太好了。
谢谢。在</p>