Unable to save/view categories

Hi,
After running an import onto my site there are some issues with categories and URLs. 
 

  1. 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
  2. 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.

  1. 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...

65 answers

Profile photo of Mall Staff 184060.00 $tone October 24, 2016
Public

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.

#2
Profile photo of Mall Staff 184060.00 $tone October 24, 2016
Public

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.

#4
Profile photo of Mall Staff 184060.00 $tone October 24, 2016
Public

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.

#7
Profile photo of Mall Staff 184060.00 $tone October 24, 2016
Public

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.

#9
Profile photo of Mall Staff 184060.00 $tone October 25, 2016
Public

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.
 

#12
Profile photo of Mall Staff 184060.00 $tone October 26, 2016
Public

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.
 

#14
Profile photo of Mall Staff 184060.00 $tone October 26, 2016
Public

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.
 

#15
Profile photo of Mall Staff 184060.00 $tone October 26, 2016
Public

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.
 

#16
Profile photo of Joe Whitehead 390.00 $tone October 26, 2016
Public

 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

#17
Profile photo of Joe Whitehead 390.00 $tone November 10, 2016
Public

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

#19
Profile photo of Mall Staff 184060.00 $tone November 10, 2016
Public

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.

#20
Profile photo of Admin Staff -30640.00 $tone November 11, 2016
Public

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

#23
Profile photo of Joe Whitehead 390.00 $tone November 11, 2016
Public

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

#26
Profile photo of Mall Staff 184060.00 $tone November 11, 2016
Public

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.

#29
Profile photo of Mall Staff 184060.00 $tone November 14, 2016
Public

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.
 
 

#35
Profile photo of Mall Staff 184060.00 $tone November 14, 2016
Public

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.

#36
Profile photo of Mall Staff 184060.00 $tone November 15, 2016
Public

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.

#38
Profile photo of Joe Whitehead 390.00 $tone November 15, 2016
Public

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

#39
Profile photo of Mall Staff 184060.00 $tone November 15, 2016
Public

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.

#40
Profile photo of Joe Whitehead 390.00 $tone December 13, 2016
Public

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

#41
Profile photo of Mall Staff 184060.00 $tone December 14, 2016
Public

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.

#43
Profile photo of Joe Whitehead 390.00 $tone December 14, 2016
Public

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

#44
Profile photo of Mall Staff 184060.00 $tone December 14, 2016
Public

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.
 

#45
Profile photo of Mall Staff 184060.00 $tone December 20, 2016
Public

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.

#61
Profile photo of Joe Whitehead 390.00 $tone March 7, 2017
Public

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

#64
Profile photo of ubdev Staff 98030.00 $tone March 8, 2017
Public

Hi Joe, 
We have just sent you an email regarding your UB Data Migration Pro subscription. Kindly check. 
Thanks,
Ubertheme team

#65

Please login or Register to Submit Answer

Written By

Comments