Hi,
After running an import onto my site there are some issues with categories and URLs.
- I am unable to view category pages on the site the following error is given:
1 exception(s): Exception #0 (Magento\Framework\Exception\NoSuchEntityException): Requested store is not found
- I am unable to make any changes and save categories (Only seen on sub-sub-categories so far) I get the following message when trying to save: URL key for specified store already exists.
I will follow up with some other details in a private reply.
-
Joe Whitehead ⋅390.00 $tone October 24, 2016
There also seems to be an issue running step 8 of the migration process.Processing in step #8....PHP Error[8]: Undefined offset: 2 in file /var/www/vhosts/mcgowanrutherford.co.uk/htdocs/pub/ub-tool/protected/controllers/Step8Controller.php at line 748I am using V 3.0.1 and it hasn't migrated all the categories properly...
Joe Whitehead ⋅390.00 $tone
October 24, 2016
65 answers
Hi Joe Whitehead,
After migrated done with all steps with our tool, let’s try clean the Magento 2 cache by the command: php -f bin/magento cache:clean`
And let’s me know how it goes.
Regards,
Mall.
Hi Mall,
I have cleared my Cache and re-indexed my site multiple times after attempting to sort my data but it is still the same.
Hi Joe Whitehead,
Please re-confirm me the admin and SSH credentials vs web root folder path of your Magento 2 site in here (with a private reply).
I will check further and help you get out.
Regards,
Mall.
Hi Mall,
Can you confirm you are able to connect using the details I have provided? Any ideas what is going wrong here?
Hi Joe Whitehead,
Seem you have disabled the admin credentials you shared? I can’t login to back-end of your site with that: http://i.prntscr.com/d88f37799435464586f99a6bff9c5028.png
Regards,
Mall.
Apologies, I have activated this account.
Hi Joe Whitehead,
Seem you use whilelist ips in your server? I can’t connect via SSH you shared: http://i.prntscr.com/fd7d407b2397417ab1854d429d14e027.png
Also, what did you do with the default Store of the Magento, the store with store_id = 1? Some your data has settings with this store but now, i don’t see it in Stores list in back-end of your site.
Kindly provide me the phpmyadmin of your database in the Magento 2. I see you have some issues with the default store (store_id =1)
Before i can tell you a workaround to solve the issues as you mentioned, i need more time to directly check in database of your Magento 2.
Regards,
Mall.
Hi Mall,
Yes, I have previously whitelisted an IP for your office? If you send me your IP I can add you onto it and also provide access to the database for you.
Hi Joe Whitehead,
I need to make a backup of current database in your Magento 2. But i can’t do it with SSH credential you are shared me (Permission denied)
Requested store is not found
That because the third-party extension named `Plazathemes/Layerednavigation` fixed to calls the Store with store_id = 1;
You can see this: http://i.prntscr.com/dd1b1296bcd842879026ca00ad172321.png
And this: http://i.prntscr.com/f51b4706d7ce4ae8996b007f110d0708.png
But the store with store_id = 1 is not exists in your Stores list: http://i.prntscr.com/127beee6383c4393be4fafd37eaa0bc2.png
To solve that, let’s open the php file at the path:
app/code/Plazathemes/Layerednavigation/Block/Layerednavigation.php
and find to the code line:
$storeId = 1 ;
and replace it by code line:
$storeId = 2 ;
And let’s me know how it goes.
Regards,
Mall.
Hi Joe Whitehead,
I need a closer look to detect the root of issues. Can you provide me the phpmyadmin to access the databases of your Magento 1 and Magento 2 sites.
Regards,
Mall.
Hi Joe Whitehead,
Also, seem you have disabled the admin credentials of your site at http://gin2.miuk.com/ ?
I can’t access to it now: http://i.prntscr.com/1b25acc807694afa9d831cb635b96a6a.png
Regards,
Mall.
Hi Joe Whitehead,
I have checked the database you have migrated via SSH and i see some issues with categories you have migrated as this: http://i.prntscr.com/ea40430db7354c2daa2ef986c4855151.png
That issues come from you have some categories in Magento1’s database which has parent_id is category added after you added the children category. (maybe this come after you drag/drop in the categories tree after you added them in back-end)
And that is root of the issue as you mentioned with some categories you have migrated. To handle for this case, please re-download and upgrade to latest version our tool -- v3.0.2 (Pls: i can’t edit anything in your server with the ssh credentials you shared.)
After install upgrade successfully, kindly reset data migration in all steps from step #4 and re-start data migration from this point.
And let’s me know how it goes.
Regards,
Mall.
Hi Mall,
Apologies, I have re-instated your user account, This is because my colleague worked on the database but didn’t keep the account.
I have added you to the correct group on the server so you should be able to have a closer look. I will upgrade the tool and follow the steps you have suggested.
thanks,
Joe
Hi Joe Whitehead,
I will upgrade the tool and follow the steps you have suggested.
Yeah, kindly do it and tell me know how it goes!
Regards
Mall.
Hi Mall,
I am attempting to upgrade the tool, as suggested by one of your colleagues, but now it does not seem to be generating the “ub-tool” directory in the pub folder.
I am following all the steps in the readme and have tried a fresh install, could you please advise.
Regards,
Joe
Hi Joe Whitehead,
It seems you got issues with folders/files permission when upgrading our tool.
Let’s re-confirm me the admin and ssh credentials of your current site.
I will check more and help you get out.
Regards,
Mall.
Hi
I have reset your first installation with our tool. Now you can continue with steps of installation of our tool in the readme.txt.
The root credentials you shared was limited permission:
http://i.prntscr.com/ae1e03a852c34cecaad4946155386d65.png
Let’s continue with command `php -f bin/magento setup:upgrade` and tell me know how it goes.
Regards,
Mall.
Hi Joe,
My apology, I did reply to another ticket, yet submit it by mistake via this thread.
PS. I’ve just removed my reply here already. Just leave a message to avoid possible confusion.
Regards,
An Nguyen
No worries,
There seems to be some duplication with my migration tool…
http://prntscr.com/d5v34k
Regards,
Joe
Hi Joe Whitehead,
I have resolved that issue for you by simply way is run below sql in your database:
`DELETE FROM ub_migrate_step WHERE id > 8;`
You can see more: http://i.prntscr.com/26485e0536544db4adbfa9bf80f41656.png
Regards,
Mall.
Thanks,
Not sure if it is related, But I have just reset my data, to start the import again and I am now getting a redirect loop when I go to the Product > Categories page in the admin backend?
Regards,
Joe
Hi
Let’s re-confirm me the admin and root ssh credentials of your M2. I can’t access your M2 now:
http://i.prntscr.com/0d8f5dfd73ee41c6a01634d6998cf74c.png
Regards,
Mall.
Hi
I don’t know but let’s run below command in your Terminal:
`chmod 777 /var/www/vhosts/mcgowanrutherford.co.uk/htdocs/pub/ub-tool/protected/runtime`
and then continue with steps in our tool.
And tell me know how it goes.
Regards,
Mall.
Hi Mall,
It all seems to be working now, the only problem I have is it doesn’t seem to want to complete Step 8.
Regards,
Joe
Hi Joe Whitehead,
I have just re-check your M2 at http://gin2.miuk.com/miadmin and see this:
http://i.prntscr.com/ef5cfe7970744c4cb5f15a18acb8199e.png
Please have a look. Did you do as my suggesting at reply #29?
Regards,
Mall.
Hi Mall,
Yes I did, it was working earlier today, it keeps going back somehow…
It should work now.
Regards,
Joe
Hi Joe Whitehead,
Yeah, i see it working now. Let’s continue with step #8 now.
And tell me know how it goes.
Regards,
Mall.
Hi Mall,
That is the problem, I press run, it looks like it is running through it but it doesn’t seem to do anything, just keeps running forever.
Regards,
Joe
Hi Joe Whitehead,
Yeah, i see it got 500 error when try run the step #8: http://i.prntscr.com/2d082d3add1c4608ba4c819a0d33d0c2.png
But i don’t see any thing in the log of our tool at:
`/var/www/vhosts/mcgowanrutherford.co.uk/htdocs/pub/ub-tool/protected/runtime/ub_data_migration.log`
I need more time to detect the root of issue and rely you later.
Let’s help me run below command in your terminal:
`chmod -R 777 /var/www/vhosts/mcgowanrutherford.co.uk/htdocs/pub/ub-tool/protected/runtime`
And then run the step #8 again and we can see the root of issue in the log.
Regards,
Mall.
Hi Joe Whitehead,
The root issue comes from you have not selected all Stores in the step #2.
Let’s open the php file at the path:
`/var/www/vhosts/mcgowanrutherford.co.uk/htdocs/pub/ub-tool/protected/controllers/Step8Controller.php`
and find to the code line 748:
$reviewDetail2->store_id = $mappingStores[$reviewDetail->store_id];
And replace it by code line:
$reviewDetail2->store_id = isset($mappingStores[$reviewDetail->store_id]) ? $mappingStores[$reviewDetail->store_id] :0;
And then you can continue with data migration in the step #8.
And tell me know how it goes.
Regards,
Mall.
Hi Mall,
I am still experiencing the same issue.
There also seems to be another issue -- You cannot edit the prices of a product, there is a “prices” section in the attribute set but does not appear on the edit page for a product.
Product attribute options -- http://prnt.sc/d7hsx0
Attribute set -- http://prnt.sc/d7ht8y
Regards,
Joe
Hi Joe Whitehead,
Product attribute options — http://prnt.sc/d7hsx0
Attribute set — http://prnt.sc/d7ht8y
It seems you have to re-setting something for the related Attribute Sets after migrated with new rules of Magento 2.
Can you tell me more detail about that issue, what is the attribute set name and sku of the product with that issue?
Let’s try compare the Attribute Set you migrated with the Default Attribute Set of the Magento 2 with named `Default` to settings more needed Attribute Groups and Attributes as default rules of Magento 2.
Please have a look again!
Regards,
Mall.
Hi Mall,
I’m not sure what else I can say? I changed 1 of the products (SKU: L54) to use the default attribute set and all of the tabs appear, including the price, but now cannot change the attribute set back.
the ‘Mcgowan’ attribute set is the migrated one, and does not show prices.
Regards,
Joe
Hi Joe Whitehead,
the ‘Mcgowan’ attribute set is the migrated one, and does not show prices.
In back-end of your Magento 2, let’s open to compare structure of that attribute set with the default attribute set named ‘Default’
and then re-setting structure of `Mcgoman` to similar with structure of Default attribute set.
(You can rename, drag/drop attribute groups, attributes…)
And the issues as you said will be solved.
Regards,
Mall.
Hi Mall,
I’m not sure if here is the best place to write this or if I should start a new question, But I seem to be having some more problems with the extension. I have imported the customers across but when I make a change in the grid row (Like changing the customer group) it saves the information but then shows different customer information.
I then have to go into the customer and select the address as default shipping and billing address for it to show properly, It seems this action removes this setting and then shows information for a different customer for some reason. I have attached 2 screenshots to show this.
Before change: http://prnt.sc/dhdez5
After change: http://prnt.sc/dhdez6
Please advise on this issue.
Thanks,
Joe
Hi Joe Whitehead,
But I seem to be having some more problems with the extension. I have imported the customers across but when I make a change in the grid row (Like changing the customer group) it saves the information but then shows different customer information.
I then have to go into the customer and select the address as default shipping and billing address for it to show properly, It seems this action removes this setting and then shows information for a different customer for some reason.
I have checked and see that in your working. After you make a change in the grid row of customers, it was missing the default billing address settings before.
That is a strange issue. I have re-test that test case in my local and i don’t get the same result in your working and it is not related to our tool as you said.
I see you have used some third-party extensions which related to Customers data: http://i.prntscr.com/3455a815a71642019595e28aadbfea7a.png
I think the root of that issue maybe related to these third-party extensions. Le’s try disable all that extensions for testing and then re-check your issue. And tell me know how it goes.
Also, i don’t see our tool working normally in your working now!
http://i.prntscr.com/c9d6df09d5cb40bf87fc87bae2cd385c.png
That is a issue with folder/file permission. To solve that, let’s use below command:
`chmod 777 -R /var/www/vhosts/mcgowanrutherford.co.uk/htdocs/pub/ub-tool/protected/runtime`
Regards,
Mall.
Hi Mall,
I have tested this on a blank fresh install of Magento and it still gives me the same result with none of these modules in, this only occurs with imported data from my Magento 1 installation, so this a problem somewhere when importing it.
With the default address setting, I can set it to be default, make a change and then it is unset as default, the data returns to normal when I go back and set it. I don’t know if that helps you, but this issue only happens once I have imported customer data using your tool.
Regards,
Joe
Hi Joe Whitehead,
I have tested this on a blank fresh install of Magento and it still gives me the same result with none of these modules in, this only occurs with imported data from my Magento 1 installation, so this a problem somewhere when importing it.
That issue happened with all your Customers or some? Can you share me a back-up of your Magento1’s database. I will working more with your database in my local and will update you the result.
Regards,
Mall.
Hi Joe Whitehead,
I am downloading your file. Let’s tell me know the version of your Magento1 database.
Regards,
Mall.
Hi Joe Whitehead,
Let’s share me the phpmyadmin credentials of your database migrated now. I will check further and help you out.
Regards,
Mall.
Hi Joe Whitehead,
When I make a change to the customer, it now does not show other customers information, but it does go blank and it seems to reset the default billing/shipping address settings.
Yeah, to solve that let’s try do steps as below:
1- Backup current database of Magento2 in your working.
2- Run below sql directly in your database:
DELETE FROM customer_entity_int WHERE attribute_id IN (15, 16);
And reindex, clean cache of Magento2 and tell me know how it goes.
Regards,
Mall.
Hi Mall,
That has worked and it is now working as expected, thanks!
Regards
Joe
Hi Joe Whitehead,
Yeah, let’s me know if you need further assistance.
Regards,
Mall.
Hi Mall,
Trying to run another Data migration but seem to be having an issue with an SQL statement, the error I’m getting is:
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 'l Postage' AND store_id = 2 LIMIT 1' at line 1.
The SQL statement executed was: SELECT * FROM `sales_shipping_aggregated` `t` WHERE period = '2015-05-28' AND order_status = 'complete' AND shipping_description = 'eBay Shipping - Standard Int'l Postage' AND store_id = 2 LIMIT 1
It appears to be breaking because of the ‘ in the data, is there anywhere I can set so it escapes this character?
Thanks,
Joe
Hi Joe,
We have just sent you an email regarding your UB Data Migration Pro subscription. Kindly check.
Thanks,
Ubertheme team
