cancel
Showing results for 
Search instead for 
Did you mean: 

Error while creating order

Error while creating order

hi guys i installed Magento 2 with theme quick start and some tables was missing which show error while placing order and these tables are my store sequence tables such as sequence_order_12 , sequence_shipment_12 etc so I export the other store table and change it from sequence_order_2 to sequence_order_12 in SQL script after importing these tables the order place successfully but now the order id is not increment automatically due to which it shows error of duplication in db and not placing order the error is as below:

Order saving error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '000000000-12' for key 'SALES_ORDER_INCREMENT_ID_STORE_ID', query was: INSERT INTO `sales_order` (`state`, `status`, `protect_code`, `is_virtual`, `store_id`, `customer_id`, `base_discount_amount`, `base_grand_total`, `base_shipping_amount`, `base_shipping_tax_amount`, `base_subtotal`, `base_tax_amount`, `base_to_global_rate`, `base_to_order_rate`, `discount_amount`, `grand_total`, `shipping_amount`, `shipping_tax_amount`, `store_to_base_rate`, `store_to_order_rate`, `subtotal`, `tax_amount`, `total_qty_ordered`, `customer_is_guest`, `customer_note_notify`, `customer_group_id`, `quote_id`, `base_shipping_discount_amount`, `base_subtotal_incl_tax`, `base_total_due`, `shipping_discount_amount`, `subtotal_incl_tax`, `total_due`, `weight`, `increment_id`, `applied_rule_ids`, `base_currency_code`, `customer_email`, `customer_firstname`, `customer_lastname`, `customer_middlename`, `discount_description`, `global_currency_code`, `order_currency_code`, `store_currency_code`, `store_name`, `customer_note`, `total_item_count`, `customer_gender`, `discount_tax_compensation_amount`, `base_discount_tax_compensation_amount`, `shipping_discount_tax_compensation_amount`, `shipping_incl_tax`, `base_shipping_incl_tax`, `gift_message_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

and here is its screenshot below

FireShot Capture 006 - New Order _ Orders _ Operations _ Sal_ - http___demos.roundcomm.com_charcoa.png

so please help me to fix it. i will be very thankful to u for your great help

1 REPLY

Re: Error while creating order

did you check your table with sequence_value field have Auto Increment is set?

Just run indexing command and check again.

Thanks.

If Issue Solved, Click Kudos/Accept As solutions.