TypeError: not all arguments converted during string formatting

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)

Galiba çok sayıda veriyi Ìnsert etmeye çalıştığınız için bu hatayı alıyorsunuz.

Burada sizin sorununuzun bir benzeri solurmuş:

Değişkenler ve %s’ lerin sayısının farklı olmasından kaynaklıymış çözdüm, teşekkür ederim.

1 Beğeni

Rica ederim :slight_smile: