Merhabalar, veri çekmeye çalışırken böyle bir hata alıyorum.
TypeError: not all arguments converted during string formatting
Veritabanında ilgili işlemi yaptığım kodları da sizlerle paylaşayım.
sql = CREATE TABLE CARS(
brand_and_model VARCHAR(32),
model_version VARCHAR(64),
location VARCHAR(64),
price INT(32),
dealer VARCHAR(32),
contact_name VARCHAR(32),
tel_number INT(32),
mileage INT(32),
gearbox VARCHAR(32),
first_registration DATETIME(6),
hu VARCHAR(7),
fuel VARCHAR(64),
power VARCHAR(16),
seller VARCHAR(16),
vehicle_condition VARCHAR(32),
category VARCHAR(32),
seats VARCHAR(8),
doors VARCHAR(8),
country_version VARCHAR(32),
sliding_door VARCHAR(32),
vehicle_number VARCHAR(16),
previous_owners VARCHAR(8),
cubic_capacity VARCHAR(16),
fuel_consumption VARCHAR(64),
CO2_emissions VARCHAR(32),
energy_efficiency_class VARCHAR(8),
CO2_efficiency VARCHAR(80),
emission_class VARCHAR(16),
emissions_sticker VARCHAR(16),
number_of_vehicle_owners VARCHAR(16),
climatisation VARCHAR(16),
airbags VARCHAR(32),
colour VARCHAR(16),
manufacturer_colour VARCHAR(16),
interior_design VARCHAR(16),
parking_sensors VARCHAR(16),
features VARCHAR(2048),
vehicle_description VARCHAR(4096),
car_picture_link VARCHAR(256),
ad_link VARCHAR(256),
download_date_time DATETIME(6)
)
if control == "true":
mySql_insert_query = "INSERT INTO CARS (brand_and_model,location,price,dealer,tel_number,contact_name,mileage,first_registration,hu,power,gearbox,previous_owners,fuel,seller,vehicle_condition,category,seats,doors,country_version,sliding_door,vehicle_number,cubic_capacity,fuel_consumption,CO2_emissions,energy_efficiency_class,CO2_efficiency,emission_class,emissions_sticker,number_of_vehicle_owners,climatisation,parking_sensors,airbags,colour,manufacturer_colour,interior_design,features,car_picture_link,ad_link,download_date_time) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)"
val = (
brand_and_model, location, price, dealer, tel_number, contact_name, mileage, first_registration,
hu, power, gearbox, previous_owners, fuel, seller, vehicle_condition, category, seats, doors,
country_version,
sliding_door, vehicle_number, cubic_capacity, fuel_consumption, CO2_emissions, energy_efficiency_class,
CO2_efficiency, emission_class, emissions_sticker, number_of_vehicle_owners, climatisation, parking_sensors,
airbags, colour, manufacturer_colour, interior_design, features, car_picture_link, ad_link,
download_date_time)
