# SQLSTATE\[HY000\]: General error: 1449 The user specified as a definer ('\*\*\*\*\*\*\_import'@'localhost') does not exist **URL:** \ **Category:** Shopware 6 (English)\ **Tags:** general, administration, programming\ **Created:** [17. März 2022 um 21:01 UTC](https://forum.shopware.com/t/sqlstate-hy000-general-error-1449-the-user-specified-as-a-definer-import-localhost-does-not-exist/93532 "2022-03-17T21:01:49Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![shopwarer1638](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@shopwarer1638](https://forum.shopware.com/u/shopwarer1638)\ **Post date:** [17. März 2022 um 21:01 UTC](https://forum.shopware.com/t/sqlstate-hy000-general-error-1449-the-user-specified-as-a-definer-import-localhost-does-not-exist/93532/1 "2022-03-17T21:01:49Z")
Recently this errors appeared in the store on checkout. Data was migrated from Shopware 5 to Shopware 6, but checkout was tested and worked before. Now after some time it doesn’t work: "Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing ‚INSERT INTO `order` (`id`, `version_id`, `billing_address_id`, `billing_address_version_id`, `currency_id`, `language_id`, `sales_channel_id`, `state_id`, `order_number`, `order_date_time`, `price`, `shipping_costs`, `currency_factor`, `deep_link_code`, `affiliate_code`, `campaign_code`, `customer_comment`, `rule_ids`, `item_rounding`, `total_rounding`, `created_at`) VALUES (‘-���D���dqU�b�’,‚���jK¾K��u,4%‘,‚L��nYGӃ���t���‘,‚���jK¾K��u,4%‘,‚��UK�G͂����‘,‚/�\_��Mp�XT�|��‚,‚��5dA㶦��s���‘,‚�v�;dzL�U]���n‘,‚SW29429‘,‚2022-03-17 14:47:42.530‘,‘{"netPrice":28.25,"totalPrice":33.9,"calculatedTaxes":[{"tax":5.65,"taxRate":20.0,"price":33.9,"extensions":}],"taxRules":[{"taxRate":20.0,"percentage":100.0,"extensions":}],"positionPrice":29.95,"rawTotal":33.9,"taxStatus":"gross"}‘,‚{"unitPrice":3.95,"totalPrice":3.95,"quantity":1,"calculatedTaxes":[{"tax":0.66,"taxRate":20.0,"price":3.95,"extensions":}],"taxRules":[{"taxRate":20.0,"percentage":100.0,"extensions":}],"referencePrice":null,"listPrice":null}‘,‚1‘,‚Ya4yxHfIMDXmgFO4cV-F\_N4-fDr3QH3S‘,NULL,NULL,NULL,‚["ab54ab6b655a4188a19b19a697893802","59d088c7335a4732907f032f825c2c4b","36d7783e60574e1e8bd471f13f9ca911","8e09125bee39434e9df5a024808ca1bc","a45ae22bfea145309284e7907efc9307","c95c258f549d42ff8a747b15d2e4367e","b0420a77cd1b40019d3aa18622f36e31","ea90c1a2a5d14cddb08aa0aa922b475f","2c96101941f24364b9ad35278ac03873","29ae4f17c744491d9a3e6800e18580a3","02e267e6b53f4b7c978f23ea07112202","747722c4b7974b67be7e4664cc01559f","79a294c5ea1549c58799017f749649c5","8781ae8a7d954d0bb84565b6da0071c8"]‘,‚{"decimals":2,"interval":0.01,"roundForNet":1}‘,‚{"decimals":2,"interval":0.01,"roundForNet":1}‘,‚2022-03-17 14:47:42.631‘);': SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('_**\_import’@‚localhost‘) does not exist" at /chroot/home/devoneon/**_.de/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {" I found information in this topic but can’t figure out the way to apply it to the problem: > [@Kunde anlegen nutzt falsche Datenbank connection](https://forum.shopware.com/t/kunde-anlegen-nutzt-falsche-datenbank-connection/88489): > > Hallo, Ich versuche gerade in meiner Shopware Testinstanz (6.4.1.1) einen neuen Kunden anzulegen. Dabei bekomme ich allerdings immer einen Datenbankfehler: # An exception occurred while executing 'INSERT INTO `customer_address` (`id`, `customer_id`, `country_id`, `salutation_id`, `first_name`, `last_name`, `zipcode`, `city`, `street`, `created_at`) VALUES ('\\�ό\_@N[��|E{�','+ݟ\*�BA��#-��','(8W��A�����-��','Jal�\\HNN�:�\Z�.','wef','wef','wef','wef','wef','2021-06-21 12:50:25.307');': SQLSTATE[… Have anyone the idea maybe? ---
**Author:** ![SCOOPEX](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/scoopex/32/18328_2.png) [@SCOOPEX](https://forum.shopware.com/u/SCOOPEX)\ **Post date:** [17. März 2022 um 22:08 UTC](https://forum.shopware.com/t/sqlstate-hy000-general-error-1449-the-user-specified-as-a-definer-import-localhost-does-not-exist/93532/2 "2022-03-17T22:08:25Z")
See error message " The user specified as a definer (’ _**\_import’@‚localhost‘) does not exist**_" Regards ---
**Author:** ![derbeutenbauer](https://avatars.discourse-cdn.com/v4/letter/d/e8c25b/32.png) [@derbeutenbauer](https://forum.shopware.com/u/derbeutenbauer)\ **Post date:** [12. Juni 2023 um 18:10 UTC](https://forum.shopware.com/t/sqlstate-hy000-general-error-1449-the-user-specified-as-a-definer-import-localhost-does-not-exist/93532/3 "2023-06-12T18:10:11Z")
What is to do, if this is happening? ---
**Author:** ![shopwarer1638](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@shopwarer1638](https://forum.shopware.com/u/shopwarer1638)\ **Post date:** [12. Juni 2023 um 21:10 UTC](https://forum.shopware.com/t/sqlstate-hy000-general-error-1449-the-user-specified-as-a-definer-import-localhost-does-not-exist/93532/4 "2023-06-12T21:10:16Z")
As I remember, I fixed this using `DEFINER` statements