Scrapy: MySQL Pipeline -- Unexpected Errors Encountered -
i'm getting number of errors, depending upon being inserted/updated. here code processing item: def process_item(self, item, spider): try: if 'producer' in item: self.cursor.execute("""insert producers (title, producer) values (%s, %s)""", (item['title'], item['producer'])) elif 'actor' in item: self.cursor.execute("""insert actors (title, actor) values (%s, %s)""", (item['title'], item['actor'])) elif 'director' in item: self.cursor.execute("""insert directors (title, director) values (%s, %s)""", (item['title'], item['director'])) else: self.cursor.execute("""update example_movie set distributor=%s, rating=%s, genre=%s, budget=%s title=%s""", (item['distributor'], item['rating'], ite...