SQLSTATE[HY000]: General error: 1364 Field ‘group_id’ doesn’t have a default value.
How to solve this??
37 answers
Hi there,
Attributes error…
SQLSTATE[HY000]: General error: 1364 Field ‘group_id’ doesn’t have a default value.
That is a strange issue. When you got that issue? Please provide us more detailed information about that issue. We will get back to you then and help you out.
Regards,
Ubertheme team
Message: Mage2SalesQuoteItem: Original Custom Price is too long (maximum is 12 characters).
Hi there,
Message: Mage2SalesQuoteItem: Original Custom Price is too long (maximum is 12 characters).
That occurred because your M1 database had at least one data record which had bad data in the value of ‘sales_flat_quote_item.original_custom_price‘ field.
To handle that case, you can try with these steps:
1. Open the PHP file at: pub/ub-tool/protected/controllers/Step7Controller.php
and find the code line:
'row_total_incl_tax', 'base_row_total_incl_tax', 'qty', 'tax_amount', 'base_tax_amount')) AND strlen(trim($val)) > 12) {
and replace it with:
'row_total_incl_tax', 'base_row_total_incl_tax', 'qty', 'tax_amount', 'base_tax_amount', 'original_custom_price')) AND strlen(trim($val)) > 12) {
Please note that there are two lines in that PHP file you need to update as above.
2. Once done, you continue with the data migration in step #7.
Regards,
Mall.
Migration missing many Tier Prices… How we can do??
[Processing][run] Step #8 migration completed with 0 CatalogProductEntityTierPrice items;
Hi there,
Migration missing many Tier Prices… How we can do??
[Processing][run] Step #8 migration completed with 0 CatalogProductEntityTierPrice items;
That is strange. Could reset step #8 and re-perform data migration in this step?
Regards,
Mall.
Already done, same result.
Hi there,
Already done, same result.
So, it seems that your database had special cases. Please provide me information about your instance:
- URL and admin credentials of your M2 instance
- SSH credentials of your M2 instance
- Let me know the path to the M2 folder
I will help to check further and get back to you then.
PS. Please make sure you mark your reply private or simply switch this ticket to the private mode, then it’s safe to share your site info here. Only you and our technical team can access it.
Regards,
Mall.
Also all customers can’t login to the site!..how to fix?
Hi there,
I have checked in your instance and I saw that:
Our migration tool detects that your M1 has a total of 753 tier prices: https://prnt.sc/v75jzj
and in the migration log of our migration tool at path: pub/ub-tool/protected/runtime/ub_data_migration.log
I saw that our migration tool helps to migrate all of 753 tier prices in your M1 to M2: http://prntscr.com/v75soq
[Processing][run] Step #8 migration completed with 100 CatalogProductEntityTierPrice items;
2020/10/24 11:36:35 [info] [ub_data_migration]
[Processing][run] Step #8 migration completed with 100 CatalogProductEntityTierPrice items;
2020/10/24 11:36:35 [info] [ub_data_migration]
[Processing][run] Step #8 migration completed with 100 CatalogProductEntityTierPrice items;
2020/10/24 11:36:35 [info] [ub_data_migration]
[Processing][run] Step #8 migration completed with 100 CatalogProductEntityTierPrice items;
2020/10/24 11:36:36 [info] [ub_data_migration]
[Processing][run] Step #8 migration completed with 100 CatalogProductEntityTierPrice items;
2020/10/24 11:36:36 [info] [ub_data_migration]
[Processing][run] Step #8 migration completed with 100 CatalogProductEntityTierPrice items;
2020/10/24 11:36:36 [info] [ub_data_migration]
[Processing][run] Step #8 migration completed with 100 CatalogProductEntityTierPrice items;
2020/10/24 11:36:37 [info] [ub_data_migration]
[Processing][run] Step #8 migration completed with 53 CatalogProductEntityTierPrice items;
Please recheck again at your end.
Regards,
Mall.
Ok, i check, can u please help with customer login?
Hi there,
can u please help with customer login?
Please recheck your settings in M2 and make sure that the migrated customers belong to the current default website in your M2 instance.
Regards,
Mall.
Error opening customer from Magento BackOffice
1 exception(s): Exception #0 (Magento\Framework\Exception\RuntimeException): Type Error occurred when creating object: Magento\Eav\Model\Entity\Attribute\Source\Config Exception #0 (Magento\Framework\Exception\RuntimeException): Type Error occurred when creating object: Magento\Eav\Model\Entity\Attribute\Source\Config <pre>#1 Magento\Framework\ObjectManager\Factory\Compiled->create('Magento\Eav\Mode...', array()) called at [vendor/magento/framework/ObjectManager/ObjectManager.php:56] #2 Magento\Framework\ObjectManager\ObjectManager->create('Magento\Eav\Mode...', array()) called at [vendor/magento/framework/Validator/UniversalFactory.php:36] #3 Magento\Framework\Validator\UniversalFactory->create('Magento\Eav\Mode...') called at [vendor/magento/module-eav/Model/Entity/Attribute/AbstractAttribute.php:642] #4 Magento\Eav\Model\Entity\Attribute\AbstractAttribute->getSource() called at [generated/code/Magento/Customer/Model/Attribute/Interceptor.php:713] #5 Magento\Customer\Model\Attribute\Interceptor->getSource() called at [vendor/magento/module-customer/Model/AttributeMetadataResolver.php:133] #6 Magento\Customer\Model\AttributeMetadataResolver->getAttributesMeta(&Magento\Customer\Model\Attribute\Interceptor#0000000035a71937000000006428a828#, &Magento\Eav\Model\Entity\Type#0000000035a7119a000000006428a828#, true) called at [vendor/magento/module-customer/Model/Customer/DataProviderWithDefaultAddresses.php:191] #7 Magento\Customer\Model\Customer\DataProviderWithDefaultAddresses->getAttributesMeta(&Magento\Eav\Model\Entity\Type#0000000035a7119a000000006428a828#) called at [vendor/magento/module-customer/Model/Customer/DataProviderWithDefaultAddresses.php:105] #8 Magento\Customer\Model\Customer\DataProviderWithDefaultAddresses->__construct('customer_form_da...', 'entity_id', 'id', &Magento\Customer\Model\ResourceModel\Customer\CollectionFactory#0000000035a7117b000000006428a828#, &Magento\Eav\Model\Config\Interceptor#0000000035a711c3000000006428a828#, &Magento\Directory\Model\CountryFactory#0000000035a714ed000000006428a828#, &Magento\Backend\Model\Session\Interceptor#0000000035a716c0000000006428a828#, &Magento\Customer\Model\FileUploaderDataResolver#0000000035a7198a000000006428a828#, &Magento\Customer\Model\AttributeMetadataResolver#0000000035a71971000000006428a828#, true, array(), array('config' => array('submit_url' => 'https://magento-...', 'validate_url' => 'https://magento-...'))) called at [generated/code/Magento/Customer/Model/Customer/DataProviderWithDefaultAddresses/Interceptor.php:14] #9 Magento\Customer\Model\Customer\DataProviderWithDefaultAddresses\Interceptor->__construct('customer_form_da...', 'entity_id', 'id', &Magento\Customer\Model\ResourceModel\Customer\CollectionFactory#0000000035a7117b000000006428a828#, &Magento\Eav\Model\Config\Interceptor#0000000035a711c3000000006428a828#, &Magento\Directory\Model\CountryFactory#0000000035a714ed000000006428a828#, &Magento\Backend\Model\Session\Interceptor#0000000035a716c0000000006428a828#, &Magento\Customer\Model\FileUploaderDataResolver#0000000035a7198a000000006428a828#, &Magento\Customer\Model\AttributeMetadataResolver#0000000035a71971000000006428a828#, true, array(), array('config' => array('submit_url' => 'https://magento-...', 'validate_url' => 'https://magento-...'))) called at [vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:121] #10 Magento\Framework\ObjectManager\Factory\AbstractFactory->createObject('Magento\Customer...', array('customer_form_da...', 'entity_id', 'id', &Magento\Customer\Model\ResourceModel\Customer\CollectionFactory#0000000035a7117b000000006428a828#, &Magento\Eav\Model\Config\Interceptor#0000000035a711c3000000006428a828#, &Magento\Directory\Model\CountryFactory#0000000035a714ed000000006428a828#, &Magento\Backend\Model\Session\Interceptor#0000000035a716c0000000006428a828#, &Magento\Customer\Model\FileUploaderDataResolver#0000000035a7198a000000006428a828#, &Magento\Customer\Model\AttributeMetadataResolver#0000000035a71971000000006428a828#, true, array(), array('config' => array('submit_url' => 'https://magento-...', 'validate_url' => 'https://magento-...')))) called at [vendor/magento/framework/ObjectManager/Factory/Compiled.php:108]
Hi there,
1 exception(s):
Exception #0 (Magento\Framework\Exception\RuntimeException): Type Error occurred when creating object: Magento\Eav\Model\Entity\Attribute\Source\Config
I debugged your instance and saw that issue related to a bad setting of the custom customer attribute code ‘mailchimp_store_view’.
It had the `frontend_input = select’, but it had missing value of the ‘souce_model’. You can learn more about it via the following result in your M2 database:
MariaDB [mtbcckdveh]> Select attribute_code, frontend_input, source_model, is_user_defined From eav_attribute Where attribute_code In (‘mailchimp_store_view’);
+———————-+—————-+————--+—————--+
| attribute_code | frontend_input | source_model | is_user_defined |
+———————-+—————-+————--+—————--+
| mailchimp_store_view | select | NULL | 1 |
+———————-+—————-+————--+—————--+
1 row in set (0.001 sec)
MariaDB [mtbcckdveh]>
To solve that issue, you can change the ‘frontend_input’ of that attribute from ‘select‘ to ‘text‘. You can run the following SQL query in your M2 to change:
Update eav_attribute Set 'frontend_input' = 'text' Where attribute_code = 'mailchimp_store_view';
And then, you check the issue you mentioned again.
Regards,
Mall.
Hi there,
Our team has just noticed that you submitted a dispute on Paypal regarding the migration issue.
As explained to you via your other ticket here, our users also run across different issues (you can check at random via this helpdesk on those issues). That said, we want to clarify the fact that:
- There might be unexpected issues during the migration process (most of the issues associated with the database issue itself, not our module)
- And our team did help our users resolve all those issues successfully.
So, please move forward with the migration. If you get any issue, please pause at the point of time and provide us the detail of the issue, we will work closely to help you out.
PS1. We’d like to offer you 60 Days Money Back Guarantee (instead of our standard 7 Days Money Back Guarantee), so you’re completely safe to move forward with our module.
PS2. Please help to withdraw the claim via Paypal. If we could not help you complete the migration within the scope of data that we noted on our product page, then you can have the full purchase returned.
Regards,
Ubertheme team
Hi, ok but we need to solve this ( i hope ) last bug… User migrated can’t login! How to fix this?
I appreciate an urgent response, as we have thousands of users who cannot access the new site.
Thank you
Magento 2.3.5-p2
Hi there,
Hi, ok but we need to solve this ( i hope ) last bug… User migrated can’t login! How to fix this?
Please help to check and provide us the following info:
- Make sure you check and log in with corrected Customer credentials?
- Make sure the migrated customers belong to the current default website in the M2 instance (the instance that you are testing)
- Please us know your M1 version?
- And let us know the Customer’s password encryption was performed by which algorithms in your M1? This algorithm is applied automatically to all customers in M1 or not?
We will follow up on your case once knowing further details above.
PS. We could not provide instant or near real-time response, however, we will try our best to reply as soon as possible.
Regards,
Ubertheme team
1: Yes
2: Yes, Main_Website ( id = 2 )
3: 1.9.4.5
4: How can i know this info?
Hi there,
4: How can i know this info?
You can check it in the string value of some customer’s passwords in your M1 database. You can run the following SQL query in your M1 database to look for that information:
SELECT * FROM `customer_entity_varchar` WHERE `attribute_id` IN (SELECT `attribute_id` FROM `eav_attribute` WHERE `attribute_code` = 'password_hash');
3: 1.9.4.5
So, I guess that the customer’s passwords in your M1 database encryption was by the SHA256 algorithm. Please try with the steps below at your end:
1. Open the PHP file at: pub/ub-tool/protected/controllers/Step6Controller.php
and find the code lines:
if ($table == 'customer_entity_varchar' AND $attributeCode1 == 'password_hash') {
$customer2->$attributeCode1 .= ":0"; // In Magento2: 0 is HASH_VERSION_MD5
}
and replace it with:
if ($table == 'customer_entity_varchar' AND $attributeCode1 == 'password_hash') {
$customer2->$attributeCode1 .= ":1";
}
2. Next, run the following SQL query in your M2 database:
UPDATE `ub_migrate_map_step_6` SET `offset` = 0 Where entity_name = 'customer_entity';
3. And then you run the delta migration in step #6 by running the CLI command:
php -f bin/ubdatamigration run --step=6;
Once done, reindex the data and check the login function with some migrated customer credentials in M2.
And let me how it goes then.
Regards,
Mall.
Ok, now saving customer gives me this error:
The store view is not in the associated website.
Hi there,
now saving customer gives me this error:
The store view is not in the associated website.
That is a strange issue. Did you change any websites, stores, store views in the Store management after the first migration?
Did you reindex the data successfully after you finished the data migration in all steps of our module?
And did that issue happen with some customers or all migrated customers?
I saw you hadn’t checked to migrate all Store views: https://prnt.sc/vee5nj. This may relate to the issue you mentioned.
Regards,
Mall.
Get this error:
php bin/ubdatamigration run --step=7
[Processing][run] in step #7: ……………………………………………………………………………………………………………………………………………………………………………………….PHP Error[8]: Trying to get property ‘attributes’ of non-object
in file /home/4/public_html/pub/ub-tool/protected/controllers/Step7Controller.php at line 2018
#0 /home/4/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(1606): Step7Controller->_migrateSalesQuoteAddress()
#1 /home/4/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(1456): Step7Controller->_migrateSalesQuote()
#2 /home/4/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(254): Step7Controller->_migrateSalesOrders()
#3 /home/4/public_html/pub/ub-tool/protected/commands/RunCommand.php(74): Step7Controller->actionRun()
#4 /home/4/public_html/pub/ub-tool/protected/commands/RunCommand.php(33): RunCommand->_migrateData()
#5 unknown(0): RunCommand->actionIndex()
#6 /home/4/public_html/pub/ub-tool/yii-1.1.22/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs()
#7 /home/4/public_html/pub/ub-tool/yii-1.1.22/console/CConsoleCommandRunner.php(71): RunCommand->run()
#8 /home/4/public_html/pub/ub-tool/yii-1.1.22/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#9 /home/4/public_html/pub/ub-tool/yii-1.1.22/base/CApplication.php(185): CConsoleApplication->processRequest()
#10 /home/4/public_html/pub/ub-tool/yii-1.1.22/yiic.php(33): CConsoleApplication->run()
#11 /home/4/public_html/pub/ub-tool/protected/ubdatamigration_cli.php(5): require_once()
#12 /home/4/public_html/bin/ubdatamigration(4): require_once()
Get this error:
php bin/ubdatamigration run --step=7
[Processing][run] in step #7: ……………………………………………………………………………………………………………………………………………………………………………………….PHP Error[8]: Trying to get property ‘attributes’ of non-object
in file /home/4/public_html/pub/ub-tool/protected/controllers/Step7Controller.php at line 2018
#0 /home/4/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(1606): Step7Controller->_migrateSalesQuoteAddress()
#1 /home/4/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(1456): Step7Controller->_migrateSalesQuote()
#2 /home/4/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(254): Step7Controller->_migrateSalesOrders()
#3 /home/4/public_html/pub/ub-tool/protected/commands/RunCommand.php(74): Step7Controller->actionRun()
#4 /home/4/public_html/pub/ub-tool/protected/commands/RunCommand.php(33): RunCommand->_migrateData()
#5 unknown(0): RunCommand->actionIndex()
#6 /home/4/public_html/pub/ub-tool/yii-1.1.22/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs()
#7 /home/4/public_html/pub/ub-tool/yii-1.1.22/console/CConsoleCommandRunner.php(71): RunCommand->run()
#8 /home/4/public_html/pub/ub-tool/yii-1.1.22/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#9 /home/4/public_html/pub/ub-tool/yii-1.1.22/base/CApplication.php(185): CConsoleApplication->processRequest()
#10 /home/4/public_html/pub/ub-tool/yii-1.1.22/yiic.php(33): CConsoleApplication->run()
#11 /home/4/public_html/pub/ub-tool/protected/ubdatamigration_cli.php(5): require_once()
#12 /home/4/public_html/bin/ubdatamigration(4): require_once()
also, in magento sales order grid i see last order 27/10/2020, in ub_migrate_map_step_7_order table last order is 2020-11-07 16:28:39…
Hi there,
[Processing][run] in step #7: ……………………………………………………………………………………………………………………………………………………………………………………….PHP Error[8]: Trying to get property ‘attributes’ of non-object
You can try these steps:
1. Run the SQL queries below in your M2 database:
DELETE FROM ub_migrate_map_step_7 WHERE entity_name = 'salesrule' AND m2_id NOT IN (Select rule_id From salesrule);
DELETE FROM ub_migrate_map_step_7 WHERE entity_name = 'salesrule_coupon' AND m2_id NOT IN (Select coupon_id From salesrule_coupon);
DELETE FROM ub_migrate_map_step_7_order_item WHERE entity_name = 'sales_flat_order_item' AND m2_id NOT IN (Select item_id From sales_order_item);
DELETE FROM ub_migrate_map_step_7_order_address WHERE entity_name = 'sales_flat_order_address' AND m2_id NOT IN (Select entity_id From sales_order_address);
DELETE FROM ub_migrate_map_step_7_quote WHERE (entity_name = 'sales_flat_quote' OR entity_name = 'sales_flat_quote_active') AND m2_id NOT IN (Select entity_id From quote);
DELETE FROM ub_migrate_map_step_7_quote_item WHERE entity_name = 'sales_flat_quote_item' AND m2_id NOT IN (Select item_id From quote_item);
DELETE FROM ub_migrate_map_step_7_quote_address WHERE entity_name = 'sales_flat_quote_address' AND m2_id NOT IN (Select address_id From quote_address);
2. And then, you run the command to clean the cache of our module:
rm -rf pub/ub-tool/protected/runtime/cache/
3. Once done, continue with the data migration in step #7 as normal.
Regards,
Mall.
When I want to remove a product from a category I see this error:
The value specified in the URL Key field would generate a URL that already exists.
To resolve this conflict, you can either change the value of the URL Key field (located in the Search Engine Optimization section) to a unique value, or change the Request Path fields in all locations listed below:
….
….
Also after migration I have this error:
bin/magento ok:urlrewrites:regenerate --no-regen-url-key --store-id=2
Regenerating of URL rewrites:
—————————————————-
Please, support me on:
https://www.patreon.com/olegkoval
https://api.fondy.eu/s/aeOD4YCieqKE7U
—————————————————-
[Type: product, Store ID: 2, Store View code: it]:
[> ] 0% 1/6440
In NoSuchEntityException.php line 50:
No such entity with id = 54
Hi there,
To resolve this conflict, you can either change the value of the URL Key field (located in the Search Engine Optimization section) to a unique value, or change the Request Path fields in all locations listed below:
…
That issue occurred because your database had some duplicated values of URL Key on categories and associated products. And it came from the original settings of URL Key on categories and associated products in your M1 database.
And that caused the issues as you see with new working rules of M2 when M2 regenerated URL rewrites for the category and associated products.
To solve that issue, you have to edit the value of the URL Key on related categories and products as suggested by Magento.
Alternatively, you can try these steps:
1. Run the CLI command provided by our migration tool:
php -f bin/ubdatamigration fixduplicateurl
2. And then, you check the issue you mentioned again.
Regards,
Mall.
If I try to move category i get this error:
No such entity with id =XX
We can’t save or do anything with category entity after migration. Please HELP
we have empty results set:
SELECT * FROM url_rewrite WHERE entity_id = 323;
Hi there,
The issues you mentioned on the categories are strange. Actually, they related to Magento’s functions.
Also, I saw that you used a third-party extension to re-generate URL rewrites in your reply #27. It may affect the category’s data in M2.
Please try steps below to rerun data migration in step #4 of our migration tool. But, please note that all your changes on migrated categories in M2 will be overridden with category’s data in M1 after you run the following steps:
1. Run the SQL query below in your M2 database:
UPDATE `ub_migrate_map_step_4` SET `offset` = 0 Where entity_name = 'catalog_category_entity';
2. And then, you run data migration in step #4 using the CLI command:
php -f bin/ubdatamigration run --step=4
3. After you finished step #4, check the issues you mentioned again.
And let me know how it goes.
Regards,
Mall.
Solved. But now new issue:
I can’t see new product inserted on frontend…I have check all, reindex, cache…we still no see new products…this is happen after migration.
Help?
Hi there,
I can’t see new product inserted on frontend…I have check all, reindex, cache…we still no see new products…this is happen after migration.
Please check at your end again and make sure that:
- You did set the migrated root category as the Root Category of the current default Store in current default website in your M2 instance.
- Your products are in stocks and visible in the frontend.
- You have reindexed the data successfully.
Regards,
Mall.
Hi Mall, sure, I have check all these point.
But I can’t see new products. Can u please help?
Hi there,
But I can’t see new products. Can u please help?
Please try these steps:
1. Run the following SQL query in your M2 database:
UPDATE `ub_migrate_map_step_5` SET `offset` = 0 Where entity_name = 'catalog_product_entity';
2. You run data migration in step #5 using the CLI command:
php -f bin/ubdatamigration run --step=5;
3. And then, reindex the data and check the issue you mentioned again.
Regards,
Mall.