Interfaceerror:(sqlte3.interfaceerror)error Binding Parameter 0

Recently, I used Python and Scrapy to crawl article information like 'title' from a blog. Without using a database, the results are fine / as expected. However, when I use SQLalch

Solution 1:

The problem that you're experiencing is that SQLite3 wants a datatype of "String", and you're passing in a list with a unicode string in it.

change: item['title'] = sel.xpath('//*[@class="link_title"]/a/text()').extract() to item['title'] = sel.xpath('//*[@class="link_title"]/a/text()').extract()[0].

You'll be left with a string to be inserted, and your SQLite3 errors should go away. Warning, though, if your ever wanting to deal with more than just one title, this will limit you to the first. You can use whatever method you want to persuade those into being a string, though.