
Description
Using the CLI instruction
php dev/tools/Magento/Tools/SampleData/install.php --admin_user=Admin
to load the data for 0.74.0-beta10, I am receiving the following error when it begins to load Orders:
Installing orders:
.exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '000000001-1' for key 'UNQ_SALES_ORDER_INCREMENT_ID_STORE_ID'' in /Library/WebServer/Documents/magento2/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228
Stack trace looks like:
Stack trace:
#0 /Library/WebServer/Documents/magento2/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /Library/WebServer/Documents/magento2/lib/internal/Magento/Framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)
#2 /Library/WebServer/Documents/magento2/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#3 /Library/WebServer/Documents/magento2/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#4 /Library/WebServer/Documents/magento2/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO sa...', Array) #5 /Library/WebServer/Documents/magento2/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO
sa...', Array)
#6 /Library/WebServer/Documents/magento2/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(576): Magento\Framework\DB\Adapter\Pdo\Mysql->query('INSERT INTO `sa...', Array)
#7 /Library/WebServer/Documents/magento2/app/code/Magento/Sales/Model/Resource/EntityAbstract.php(240): Zend_Db_Adapter_Abstract->insert('sales_order', Array)
#8 /Library/WebServer/Documents/magento2/var/generation/Magento/Sales/Model/Resource/Order/Interceptor.php(148): Magento\Sales\Model\Resource\EntityAbstract->save(Object(Magento\Sales\Model\Order))
#9 /Library/WebServer/Documents/magento2/var/generation/Magento/Sales/Api/Data/OrderInterfacePersistor.php(146): Magento\Sales\Model\Resource\Order\Interceptor->save(Object(Magento\Sales\Model\Order))
#10 /Library/WebServer/Documents/magento2/var/generation/Magento/Sales/Api/Data/OrderInterfacePersistor.php(180): Magento\Sales\Api\Data\OrderInterfacePersistor->doPersist(1)
#11 /Library/WebServer/Documents/magento2/var/generation/Magento/Sales/Api/Data/Order/Repository.php(162): Magento\Sales\Api\Data\OrderInterfacePersistor->doPersistEntity(Object(Magento\Sales\Model\Order))
#12 [internal function]: Magento\Sales\Api\Data\Order\Repository->save(Object(Magento\Sales\Model\Order))
#13 /Library/WebServer/Documents/magento2/var/generation/Magento/Sales/Api/Data/Order/Repository/Interceptor.php(56): call_user_func_array(Array, Array)
#14 /Library/WebServer/Documents/magento2/lib/internal/Magento/Framework/Interception/Chain/Chain.php(65): Magento\Sales\Api\Data\Order\Repository\Interceptor->___callParent('save', Array)
#15 /Library/WebServer/Documents/magento2/var/generation/Magento/Sales/Api/Data/Order/Repository/Interceptor.php(95): Magento\Framework\Interception\Chain\Chain->invokeNext('Magento\Sales\A...', 'save', Object(Magento\Sales\Api\Data\Order\Repository\Interceptor), Array, 'save_gift_messa...')
#16 /Library/WebServer/Documents/magento2/app/code/Magento/GiftMessage/Model/Plugin/OrderSave.php(49): Magento\Sales\Api\Data\Order\Repository\Interceptor->Magento\Sales\Api\Data\Order\Repository{closure}(Object(Magento\Sales\Model\Order))
#17 [internal function]: Magento\GiftMessage\Model\Plugin\OrderSave->aroundSave(Object(Magento\Sales\Api\Data\Order\Repository\Interceptor), Object(Closure), Object(Magento\Sales\Model\Order))
#18 /Library/WebServer/Documents/magento2/var/generation/Magento/Sales/Api/Data/Order/Repository/Interceptor.php(100): call_user_func_array(Array, Array)
#19 /Library/WebServer/Documents/magento2/var/generation/Magento/Sales/Api/Data/Order/Repository/Interceptor.php(228): Magento\Sales\Api\Data\Order\Repository\Interceptor->___callPlugins('save', Array, Array)
#20 /Library/WebServer/Documents/magento2/app/code/Magento/Sales/Model/Service/OrderService.php(160): Magento\Sales\Api\Data\Order\Repository\Interceptor->save(Object(Magento\Sales\Model\Order))
#21 /Library/WebServer/Documents/magento2/app/code/Magento/Quote/Model/QuoteManagement.php(468): Magento\Sales\Model\Service\OrderService->place(Object(Magento\Sales\Model\Order))
#22 /Library/WebServer/Documents/magento2/app/code/Magento/Quote/Model/QuoteManagement.php(368): Magento\Quote\Model\QuoteManagement->submitQuote(Object(Magento\Quote\Model\Quote), Array)
#23 /Library/WebServer/Documents/magento2/app/code/Magento/Sales/Model/AdminOrder/Create.php(1855): Magento\Quote\Model\QuoteManagement->submit(Object(Magento\Quote\Model\Quote), Array)
#24 /Library/WebServer/Documents/magento2/dev/tools/Magento/Tools/SampleData/Module/Sales/Setup/Order/Processor.php(136): Magento\Sales\Model\AdminOrder\Create->createOrder()
#25 /Library/WebServer/Documents/magento2/dev/tools/Magento/Tools/SampleData/Module/Sales/Setup/Order.php(77): Magento\Tools\SampleData\Module\Sales\Setup\Order\Processor->createOrder(Array)
#26 /Library/WebServer/Documents/magento2/dev/tools/Magento/Tools/SampleData/Helper/PostInstaller.php(86): Magento\Tools\SampleData\Module\Sales\Setup\Order->run()
#27 /Library/WebServer/Documents/magento2/dev/tools/Magento/Tools/SampleData/Installer.php(99): Magento\Tools\SampleData\Helper\PostInstaller->run()
#28 /Library/WebServer/Documents/magento2/dev/tools/Magento/Tools/SampleData/ConsoleInstaller.php(78): Magento\Tools\SampleData\Installer->run('Admin', Array)
#29 /Library/WebServer/Documents/magento2/lib/internal/Magento/Framework/App/Bootstrap.php(257): Magento\Tools\SampleData\ConsoleInstaller->launch()
#30 /Library/WebServer/Documents/magento2/dev/tools/Magento/Tools/SampleData/install.php(31): Magento\Framework\App\Bootstrap->run(Object(Magento\Tools\SampleData\ConsoleInstaller))
#31 {main}
Which is immediately followed by another error:
Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '000000001-1' for key 'UNQ_SALES_ORDER_INCREMENT_ID_STORE_ID', query was: INSERT INTO sales_order
(state
, status
, coupon_code
, protect_code
, shipping_description
, is_virtual
, store_id
, customer_id
, base_discount_amount
, base_discount_canceled
, base_discount_invoiced
, base_discount_refunded
, base_grand_total
, base_shipping_amount
, base_shipping_canceled
, base_shipping_invoiced
, base_shipping_refunded
, base_shipping_tax_amount
, base_shipping_tax_refunded
, base_subtotal
, base_subtotal_canceled
, base_subtotal_invoiced
, base_subtotal_refunded
, base_tax_amount
, base_tax_canceled
, base_tax_invoiced
, base_tax_refunded
, base_to_global_rate
, base_to_order_rate
, base_total_canceled
, base_total_invoiced
, base_total_invoiced_cost
, base_total_offline_refunded
, base_total_online_refunded
, base_total_paid
, base_total_qty_ordered
, base_total_refunded
, discount_amount
, discount_canceled
, discount_invoiced
, discount_refunded
, grand_total
, shipping_amount
, shipping_canceled
, shipping_invoiced
, shipping_refunded
, shipping_tax_amount
, shipping_tax_refunded
, store_to_base_rate
, store_to_order_rate
, subtotal
, subtotal_canceled
, subtotal_invoiced
, subtotal_refunded
, tax_amount
, tax_canceled
, tax_invoiced
, tax_refunded
, total_canceled
, total_invoiced
, total_offline_refunded
, total_online_refunded
, total_paid
, total_qty_ordered
, total_refunded
, can_ship_partially
, can_ship_partially_item
, customer_is_guest
, customer_note_notify
, billing_address_id
, customer_group_id
, edit_increment
, email_sent
, forced_shipment_with_invoice
, payment_auth_expiration
, quote_address_id
, quote_id
, shipping_address_id
, adjustment_negative
, adjustment_positive
, base_adjustment_negative
, base_adjustment_positive
, base_shipping_discount_amount
, base_subtotal_incl_tax
, base_total_due
, payment_authorization_amount
, shipping_discount_amount
, subtotal_incl_tax
, total_due
, weight
, customer_dob
, increment_id
, applied_rule_ids
, base_currency_code
, customer_email
, customer_firstname
, customer_lastname
, customer_middlename
, customer_prefix
, customer_suffix
, customer_taxvat
, discount_description
, ext_customer_id
, ext_order_id
, global_currency_code
, hold_before_state
, hold_before_status
, order_currency_code
, original_increment_id
, relation_child_id
, relation_child_real_id
, relation_parent_id
, relation_parent_real_id
, remote_ip
, shipping_method
, store_currency_code
, store_name
, x_forwarded_for
, customer_note
, updated_at
, total_item_count
, customer_gender
, hidden_tax_amount
, base_hidden_tax_amount
, shipping_hidden_tax_amount
, base_shipping_hidden_tax_amnt
, hidden_tax_invoiced
, base_hidden_tax_invoiced
, hidden_tax_refunded
, base_hidden_tax_refunded
, shipping_incl_tax
, base_shipping_incl_tax
, gift_message_id
) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NULL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' in /Library/WebServer/Documents/magento2/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:235
And its stack trace:
Stack trace:
#0 /Library/WebServer/Documents/magento2/lib/internal/Magento/Framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)
#1 /Library/WebServer/Documents/magento2/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#2 /Library/WebServer/Documents/magento2/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /Library/WebServer/Documents/magento2/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO sa...', Array) #4 /Library/WebServer/Documents/magento2/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO
sa...', Array)
#5 /Library/WebServer/Documents/magento2/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(576): Magento\Framework\DB\Adapter\Pdo\Mysql->query('INSERT INTO `sa...', Array)
#6 /Library/WebServer/Documents/magento2/app/code/Magento/Sales/Model/Resource/EntityAbstract.php(240): Zend_Db_Adapter_Abstract->insert('sales_order', Array)
#7 /Library/WebServer/Documents/magento2/var/generation/Magento/Sales/Model/Resource/Order/Interceptor.php(148): Magento\Sales\Model\Resource\EntityAbstract->save(Object(Magento\Sales\Model\Order))
#8 /Library/WebServer/Documents/magento2/var/generation/Magento/Sales/Api/Data/OrderInterfacePersistor.php(146): Magento\Sales\Model\Resource\Order\Interceptor->save(Object(Magento\Sales\Model\Order))
#9 /Library/WebServer/Documents/magento2/var/generation/Magento/Sales/Api/Data/OrderInterfacePersistor.php(180): Magento\Sales\Api\Data\OrderInterfacePersistor->doPersist(1)
#10 /Library/WebServer/Documents/magento2/var/generation/Magento/Sales/Api/Data/Order/Repository.php(162): Magento\Sales\Api\Data\OrderInterfacePersistor->doPersistEntity(Object(Magento\Sales\Model\Order))
#11 [internal function]: Magento\Sales\Api\Data\Order\Repository->save(Object(Magento\Sales\Model\Order))
#12 /Library/WebServer/Documents/magento2/var/generation/Magento/Sales/Api/Data/Order/Repository/Interceptor.php(56): call_user_func_array(Array, Array)
#13 /Library/WebServer/Documents/magento2/lib/internal/Magento/Framework/Interception/Chain/Chain.php(65): Magento\Sales\Api\Data\Order\Repository\Interceptor->___callParent('save', Array)
#14 /Library/WebServer/Documents/magento2/var/generation/Magento/Sales/Api/Data/Order/Repository/Interceptor.php(95): Magento\Framework\Interception\Chain\Chain->invokeNext('Magento\Sales\A...', 'save', Object(Magento\Sales\Api\Data\Order\Repository\Interceptor), Array, 'save_gift_messa...')
#15 /Library/WebServer/Documents/magento2/app/code/Magento/GiftMessage/Model/Plugin/OrderSave.php(49): Magento\Sales\Api\Data\Order\Repository\Interceptor->Magento\Sales\Api\Data\Order\Repository{closure}(Object(Magento\Sales\Model\Order))
#16 [internal function]: Magento\GiftMessage\Model\Plugin\OrderSave->aroundSave(Object(Magento\Sales\Api\Data\Order\Repository\Interceptor), Object(Closure), Object(Magento\Sales\Model\Order))
#17 /Library/WebServer/Documents/magento2/var/generation/Magento/Sales/Api/Data/Order/Repository/Interceptor.php(100): call_user_func_array(Array, Array)
#18 /Library/WebServer/Documents/magento2/var/generation/Magento/Sales/Api/Data/Order/Repository/Interceptor.php(228): Magento\Sales\Api\Data\Order\Repository\Interceptor->___callPlugins('save', Array, Array)
#19 /Library/WebServer/Documents/magento2/app/code/Magento/Sales/Model/Service/OrderService.php(160): Magento\Sales\Api\Data\Order\Repository\Interceptor->save(Object(Magento\Sales\Model\Order))
#20 /Library/WebServer/Documents/magento2/app/code/Magento/Quote/Model/QuoteManagement.php(468): Magento\Sales\Model\Service\OrderService->place(Object(Magento\Sales\Model\Order))
#21 /Library/WebServer/Documents/magento2/app/code/Magento/Quote/Model/QuoteManagement.php(368): Magento\Quote\Model\QuoteManagement->submitQuote(Object(Magento\Quote\Model\Quote), Array)
#22 /Library/WebServer/Documents/magento2/app/code/Magento/Sales/Model/AdminOrder/Create.php(1855): Magento\Quote\Model\QuoteManagement->submit(Object(Magento\Quote\Model\Quote), Array)
#23 /Library/WebServer/Documents/magento2/dev/tools/Magento/Tools/SampleData/Module/Sales/Setup/Order/Processor.php(136): Magento\Sales\Model\AdminOrder\Create->createOrder()
#24 /Library/WebServer/Documents/magento2/dev/tools/Magento/Tools/SampleData/Module/Sales/Setup/Order.php(77): Magento\Tools\SampleData\Module\Sales\Setup\Order\Processor->createOrder(Array)
#25 /Library/WebServer/Documents/magento2/dev/tools/Magento/Tools/SampleData/Helper/PostInstaller.php(86): Magento\Tools\SampleData\Module\Sales\Setup\Order->run()
#26 /Library/WebServer/Documents/magento2/dev/tools/Magento/Tools/SampleData/Installer.php(99): Magento\Tools\SampleData\Helper\PostInstaller->run()
#27 /Library/WebServer/Documents/magento2/dev/tools/Magento/Tools/SampleData/ConsoleInstaller.php(78): Magento\Tools\SampleData\Installer->run('Admin', Array)
#28 /Library/WebServer/Documents/magento2/lib/internal/Magento/Framework/App/Bootstrap.php(257): Magento\Tools\SampleData\ConsoleInstaller->launch()
#29 /Library/WebServer/Documents/magento2/dev/tools/Magento/Tools/SampleData/install.php(31): Magento\Framework\App\Bootstrap->run(Object(Magento\Tools\SampleData\ConsoleInstaller))
#30 {main}Daves-MacBook-Pro:magento2 dave$
[Restored]