Step #5 Error

Answered

Public

aswan asked January 4, 2019

[mtwotest@sip4-1134 html]$ php bin/ubdatamigration run --step=5
Processing in step #5…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………….
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AND attribute_id = 79 AND store_id = 0 LIMIT 1’ at line 1. The SQL statement executed was: SELECT * FROM `catalog_product_entity_datetime` `t` WHERE entity_id = AND attribute_id = 79 AND store_id = 0 LIMIT 1

UB Data Migration Pro

22 answers

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone January 5, 2019

Public

Hi there,

MySQL server version for the right syntax to use near ‘AND attribute_id = 79 AND store_id = 0 LIMIT 1’ at line 1. The SQL statement executed was: SELECT * FROM `catalog_product_entity_datetime` `t` WHERE entity_id = AND attribute_id = 79 AND store_id = 0 LIMIT 1

That issue because your M1 database has some bad records in table ‘catalog_product_super_link’.
To handle for that case, you could try with steps below:
+ Download the PHP file at here
+ Upload replace downloaded file to the file at path: pub/ub-tool/protected/controllers/Step5Controller.php
+ Once done, you could continue with data migration in the step #5 of our migration tool by run CLI command:
php -f bin/ubdatamigration run --step=5
Regards,
Mall.

Vote Up

Vote Down

aswan ⋅350.00 $tone January 7, 2019

Public

thank you that fixed it but I’m getting this error in Magento adimin
One or more indexers are invalid. Make sure your Magento cron job is running.
I didn’t have this error befor untill the migration is done?!
would you please help me fixing this issue.

Thank you,

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone January 7, 2019

Public

Hi there,

would you please help me fixing this issue.

That is Magento’s note only. Let’s index the data to clean that.
Also, please do full steps of data migration as indicated in the guide of our migration tool in readme.html
Regards,
Mall.

Vote Up

Vote Down

aswan ⋅350.00 $tone January 7, 2019

Public

I re-run full migration steps and clean the cache the reindex and here’s what i got

[mtwotest@sip4-1134 html]$ php -f bin/magento indexer:reindex
Design Config Grid index has been rebuilt successfully in 00:00:00
Customer Grid index has been rebuilt successfully in 00:00:01
Category Products index has been rebuilt successfully in 00:00:00
Product Categories index has been rebuilt successfully in 00:00:00
Catalog Rule Product index has been rebuilt successfully in 00:00:00
Product EAV index has been rebuilt successfully in 00:00:01
Stock index has been rebuilt successfully in 00:00:00
Inventory index has been rebuilt successfully in 00:00:00
Catalog Product Rule index has been rebuilt successfully in 00:00:00
No linked stock found
Catalog Search index has been rebuilt successfully in 00:00:00
[mtwotest@sip4-1134 html]$

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone January 7, 2019

Public

Hi there,

No linked stock found

That is strange. Let’s try reset indexers and reindex the data once more:
php -f bin/magento indexer:reset
php -f bin/magento indexer:reindex
Once done, run the command:
php -f bin/magento indexer:status
And provide me the captured screenshots of the result.
Regards,
Mall.

Vote Up

Vote Down

aswan ⋅350.00 $tone January 7, 2019

Public

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone January 7, 2019

Public

Hi there,

| Product Price | Reindex required | Schedule | idle (0 in backlog) | 2019-01-07 15:30:39 |

That is required to reindex. Let’s try reindex for that by run below command:
php -f bin/magento indexer:reindex catalog_product_price
Once done run the command: php -f bin/magento indexer:status
And provide me the captured screenshots of the result.
Regards,
Mall.

Vote Up

Vote Down

aswan ⋅350.00 $tone January 7, 2019

Public

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone January 7, 2019

Public

Hi there,
Let’s try change ‘Update On’ of the indexers to ‘Save’ and then reindex the data once more.
And tell me know how it goes.
Regards,
Mall

Vote Up

Vote Down

aswan ⋅350.00 $tone January 7, 2019

Public

I’m not sure how to do that.

#10

Vote Up

Vote Down

aswan ⋅350.00 $tone January 7, 2019

Public

#11

Vote Up

Vote Down

aswan ⋅350.00 $tone January 7, 2019

Public

any help please!

#12

Vote Up

Vote Down

aswan ⋅350.00 $tone January 7, 2019

Public

That is required to reindex. Let’s try reindex for that by run below command:
php -f bin/magento indexer:reindex catalog_product_price
Once done run the command: php -f bin/magento indexer:status
And provide me the captured screenshots of the result.

#13

Vote Up

Vote Down

aswan ⋅350.00 $tone January 7, 2019

Public

#14

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone January 8, 2019

Public

Hi there,

| Product Price | Reindex required | Save | | |

That is strange. Let’s provide me information about your instance:
+ Admin credentials and URL to back-end
+ SSH credentials and path to Magento folder
I will help to check further and get back you then.
Regards,
Mall.

#15

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone January 9, 2019

Public

Hi there,

I have connected to your server via SSH and saw the issue of Catalog Product Price indexer’s function:

No linked stock found

I debugged further and found the root issue that relates to the data in Magento’s core table named ‘inventory_stock_sales_channel’. You could see this screenshot: http://i.prntscr.com/BQEAhv0RQ96HKpLlfSRKcQ.png
As you see, your database has 4 frontend websites with the website codes: base, base_migrated, dsc_migrated, jt_migrated.
But there is only one data record for the website code ‘base’ in the table ‘inventory_stock_sales_channel’. And that is the root of Magento’s issue with the indexer function above.
These data records were automatically added by Magento’s function. I didn’t know why they were missing for other websites. To solve that issue, you must manually insert those records. And you could run the following SQLs in your M2 database to add the missing data records:

INSERT INTO `inventory_stock_sales_channel` (`type`, `code`, `stock_id`) VALUES ('website', 'base_migrated', '1');
INSERT INTO `inventory_stock_sales_channel` (`type`, `code`, `stock_id`) VALUES ('website', 'dsc_migrated', '1');
INSERT INTO `inventory_stock_sales_channel` (`type`, `code`, `stock_id`) VALUES ('website', 'jt_migrated', '1');

+ Once done, reindex the data at your end and let me know how it goes.

Regards,
Mall.

#19

Vote Up

Vote Down

ubdev ⋅ Staff ⋅98150.00 $tone January 9, 2019

Public

Hi there,
Beside the manual SQL Mall did suggeste above, you can select another alternative option.
You navigate to the store management, then simply open each website and click Save respectively, then the missing data records will be automatically added by Magento.
Regards,
Ubertheme team

#20

Vote Up

Vote Down

aswan ⋅350.00 $tone January 9, 2019

Public

I did the alternative option and that fixed the indexing issue.

thank you so much for the help!

a side question, do you guys have a service to install themes without reinstalling Magento and loos all the work we’ve done?

#21

Vote Up

Vote Down

ubdev ⋅ Staff ⋅98150.00 $tone January 9, 2019

Public

Hi there,
We’ve replied to you via email regarding the theme installation inquiry. Please check and follow up further with us there.
Regards,
Ubertheme team

#22