· 8 years ago · Apr 15, 2018, 02:58 PM
1pymysql.err.InternalError: (1292, "Incorrect datetime value: 'row[3]' for column 'date_added' at row 1")
2
3import csv
4 import re
5 import pymysql
6 import sys
7 import os
8 import requests
9 from PIL import Image
10
11 def insert_articles2(rows):
12 rowcount = 0
13 for row in rows:
14 if rowcount !=0:
15 sql = "INSERT INTO articles2 (country, event_name, md5, date_added, profile_image, banner, sDate, eDate, address_line1, address_line2, pincode, state, city, locality, full_address, latitude, longitude, start_time, end_time, description, website, fb_page, fb_event_page, event_hashtag, source_name, source_url, email_id_organizer, ticket_url) VALUES ('row[0]', 'row[1]', 'row[2]', 'row[3]', 'row[4]', 'row[5]', 'row[6]', 'row[7]', 'row[8]', 'row[9]', 'row[10]', 'row[11]', 'row[12]', 'row[13]', 'row[14]', 'row[15]', 'row[16]', 'row[17]', 'row[18]', 'row[19]', 'row[20]', 'row[21]', 'row[22]', 'row[23]', 'row[24]', 'row[25]', 'row[26]', 'row[27]')"
16 cursor.execute(sql)
17 connection.commit()
18 rowcount+=1
19
20
21rows = csv.reader(open("items.csv", "r"))
22insert_articles2(rows)
23
24CREATE TABLE IF NOT EXISTS `articles2` (
25 `id` int(6) NOT NULL AUTO_INCREMENT,
26 `country` varchar(45) NOT NULL,
27 `event_name` varchar(200) NOT NULL,
28 `md5` varchar(35) NOT NULL,
29 `date_added` timestamp NULL DEFAULT NULL,
30 `profile_image` varchar(350) NOT NULL,
31 `banner` varchar(350) NOT NULL,
32 `sDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
33 `eDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
34 `address_line1` mediumtext,
35 `address_line2` mediumtext,
36 `pincode` int(7) NOT NULL,
37 `state` varchar(30) NOT NULL,
38 `city` text NOT NULL,
39 `locality` varchar(50) NOT NULL,
40 `full_address` varchar(350) NOT NULL,
41 `latitude` varchar(15) NOT NULL,
42 `longitude` varchar(15) NOT NULL,
43 `start_time` time NOT NULL,
44 `end_time` time NOT NULL,
45 `description` longtext CHARACTER SET utf16 NOT NULL,
46 `website` varchar(50) DEFAULT NULL,
47 `fb_page` varchar(200) DEFAULT NULL,
48 `fb_event_page` varchar(200) DEFAULT NULL,
49 `event_hashtag` varchar(30) DEFAULT NULL,
50 `source_name` varchar(30) NOT NULL,
51 `source_url` varchar(350) NOT NULL,
52 `email_id_organizer` varchar(100) NOT NULL,
53 `ticket_url` mediumtext NOT NULL,
54 PRIMARY KEY (`id`),
55 KEY `full_address` (`full_address`),
56 KEY `full_address_2` (`full_address`),
57 KEY `id` (`id`),
58 KEY `event_name` (`event_name`),
59 KEY `sDate` (`sDate`),
60 KEY `eDate` (`eDate`),
61 KEY `id_2` (`id`),
62 KEY `country` (`country`),
63 KEY `event_name_2` (`event_name`),
64 KEY `sDate_2` (`sDate`),
65 KEY `eDate_2` (`eDate`),
66 KEY `state` (`state`),
67 KEY `locality` (`locality`),
68 KEY `start_time` (`start_time`),
69 KEY `start_time_2` (`start_time`),
70 KEY `end_time` (`end_time`),
71 KEY `id_3` (`id`),
72 KEY `id_4` (`id`),
73 KEY `event_name_3` (`event_name`),
74 KEY `md5` (`md5`),
75 KEY `sDate_3` (`sDate`),
76 KEY `eDate_3` (`eDate`),
77 KEY `latitude` (`latitude`),
78 KEY `longitude` (`longitude`),
79 KEY `start_time_3` (`start_time`),
80 KEY `end_time_2` (`end_time`)
81) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4182 ;