Bikers-Zubehör
15.02.2017, 16:30
hi
ein Kunde wies mich daraufhin das wir einen Fehler am Ende des Bestellvorgangs haben. Bei einer Testbestellung kam wirklich am Ende folgendes:
Query error: Duplicate entry '2147483647' for key 'PRIMARY' - Invalid query: INSERT INTO `orders` (`customers_id`, `orders_status`, `customers_cid`, `customers_vat_id`, `customers_status`, `customers_status_name`, `customers_status_image`, `customers_status_discount`, `account_type`, `payment_method`, `payment_class`, `shipping_method`, `shipping_class`, `comments`, `date_purchased`, `last_modified`, `language`, `order_total_weight`, `currency`, `currency_value`, `customers_telephone`, `customers_email_address`, `customers_name`, `customers_firstname`, `customers_lastname`, `customers_gender`, `customers_company`, `customers_street_address`, `customers_house_number`, `customers_additional_info`, `customers_suburb`, `customers_city`, `customers_postcode`, `customers_state`, `customers_country`, `customers_address_format_id`, `delivery_name`, `delivery_firstname`, `delivery_lastname`, `delivery_gender`, `delivery_company`, `delivery_street_address`, `delivery_house_number`, `delivery_additional_info`, `delivery_suburb`, `delivery_city`, `delivery_postcode`, `delivery_state`, `delivery_country`, `delivery_address_format_id`, `delivery_country_iso_code_2`, `billing_name`, `billing_firstname`, `billing_lastname`, `billing_gender`, `billing_company`, `billing_street_address`, `billing_house_number`, `billing_additional_info`, `billing_suburb`, `billing_city`, `billing_postcode`, `billing_state`, `billing_country`, `billing_address_format_id`, `billing_country_iso_code_2`, `orders_hash`) VALUES (0, 0, '', '', 1, '', '', 0, 1, '', '', '', '', '', '2017-02-15 17:27:14', '2017-02-15 17:27:14', '', 0, '', 0, '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', 1, ' ', '', '', '', '', '', '', '', '', '', '', '', '', 1, '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', 1, '', 2080742236)
USER ERROR(256): "SQL Error"
Was ist passiert bzw. was muß ich ändern?
ein Kunde wies mich daraufhin das wir einen Fehler am Ende des Bestellvorgangs haben. Bei einer Testbestellung kam wirklich am Ende folgendes:
Query error: Duplicate entry '2147483647' for key 'PRIMARY' - Invalid query: INSERT INTO `orders` (`customers_id`, `orders_status`, `customers_cid`, `customers_vat_id`, `customers_status`, `customers_status_name`, `customers_status_image`, `customers_status_discount`, `account_type`, `payment_method`, `payment_class`, `shipping_method`, `shipping_class`, `comments`, `date_purchased`, `last_modified`, `language`, `order_total_weight`, `currency`, `currency_value`, `customers_telephone`, `customers_email_address`, `customers_name`, `customers_firstname`, `customers_lastname`, `customers_gender`, `customers_company`, `customers_street_address`, `customers_house_number`, `customers_additional_info`, `customers_suburb`, `customers_city`, `customers_postcode`, `customers_state`, `customers_country`, `customers_address_format_id`, `delivery_name`, `delivery_firstname`, `delivery_lastname`, `delivery_gender`, `delivery_company`, `delivery_street_address`, `delivery_house_number`, `delivery_additional_info`, `delivery_suburb`, `delivery_city`, `delivery_postcode`, `delivery_state`, `delivery_country`, `delivery_address_format_id`, `delivery_country_iso_code_2`, `billing_name`, `billing_firstname`, `billing_lastname`, `billing_gender`, `billing_company`, `billing_street_address`, `billing_house_number`, `billing_additional_info`, `billing_suburb`, `billing_city`, `billing_postcode`, `billing_state`, `billing_country`, `billing_address_format_id`, `billing_country_iso_code_2`, `orders_hash`) VALUES (0, 0, '', '', 1, '', '', 0, 1, '', '', '', '', '', '2017-02-15 17:27:14', '2017-02-15 17:27:14', '', 0, '', 0, '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', 1, ' ', '', '', '', '', '', '', '', '', '', '', '', '', 1, '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', 1, '', 2080742236)
USER ERROR(256): "SQL Error"
Was ist passiert bzw. was muß ich ändern?