404 Error then File Not Found Server Configuration

Hi there,

After another NGINX reload I now get file not found inside admin on extension page. How can I fix this issue?

Please provide me information of your instance:

• URL and Admin credentials of your M2 site
• SSH credentials of your M2 instance with the root permission which allows me to check and update Nginx’s settings.
• And let me know the path to your M2 folder.

I will help to check further and get back to you then.
 
PS. Please 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.
 

Hi Jon,
 

Please give us a bit more time to follow up on your case. 
 
Since our team has a local festival event with two days off this week (Thursday and Friday), we’re sorry for a certain delay in responding to you. We have a team in charge of the support, however, it will take us a bit longer to follow up with you. 
 
Thanks for your patience and understanding. 

 
Regards,
Ubertheme team

Hi Jon, 
 
Since our technical team is 100% working remotely due to the Covid outbreak, the IP changes beyond our control (due to the dynamic IPs provided by our local Internet service provider). 
 
We wonder if it’s possible to share with us your Cpanel credentials where we can whitelist the IP based on the actual IP at the time our team debugs your instance. 
 
We know your concern about security and privacy, yet we guarantee to keep those credentials confidential for the purpose of technical support only. 
 
Thanks for your understanding. 
 
PS. When working in our office, the IPs are fixed. However, that’s not the case when we’re working from home during this Covid period. 
 
Regards,
Ubertheme team

Hi Jon, 
 
It seems that your server has a special setting. Please apply this tweak code:
+ Download the PHP file here
+ Then, upload that file and overwrite the same PHP file at pub/ub-tool/protected/components/UserMenu.php
 
Once done, you should be able to access the back-end of our module as normal.
 
Meanwhile, please strictly follow all steps required in the Readme manual that comes packed with your download package. 
 
PS. Our team is off during the weekend, so our apology for a certain delay in responding to you. 

 
Regards,
Ubertheme team

Hi Jon,

I’ve overwritten the file as requested and it still doesn’t work!

I have checked the backend of your site and I could access our module normally: http://prntscr.com/semgxu
Please check once again at your end. 

Regards,
Mall.

Hi there,

Ok I will try and reset browser caches and restart machine and will try again will let you know if I can get it to work.

Yes, please try again at your end and contact me if you need further assistance.
Regards,
Mall.

Hi Jon, 
Yes, in case you come across any issue, please pause the migration process and let us know the details of the issue here.
Regards,
Ubertheme team

Hi Jon,

. Is there anyway to stop the process within the GUI. What’s the next steps to resolve this issue?

You simply close the browser tab which was opening the backend dashboard of our module.
And then, you can continue with the data migration in step #5 by running the CLI command:
php -f bin/ubdatamigration run --step=5;

Regards,
Mall.

Hi there,

php bin/ubdatamigration run --step=6 --limit=200
Which finished without issue having checked the log it says 1 Customer Groups and 13733 Customers migrated yet when I go to Customers it’s empty. I tried reindexing and caching but nothing appears. But the numbers match between M1 and M2. Any idea why I’m not seeing any customers inside M2 admin?

Please check again and make sure that you have reindexed your data successfully after you finished data migration in step #6.

Regards,
Mall.

Hi Jon,

 {“0″:”Missing required argument $options of…

That issue occurred because your database had at least one custom customer attribute or custom customer address attribute that had the value of ‘frontend_input’ type as ‘select/multiselect’, however, the Backend model or source model for that attribute wasn’t ready in your M2.

To solve that issue, you have to look for that attributes in the ‘eav_attribute’ table in your M2 database and then change the value of the ‘frontend_input‘ field from ‘select/multiselect‘ to ‘text‘.
 
PS. Our team is off on the weekend, so our apology for a certain delay if you reach out to us during this time.  
Regards,
Mall.

Hi there,

 I can’t see any field type of select/multiselect only one or the other.

Let’s run following SQL in your M2 database to looking for that attributes:

Select * From eav_attribute Where (frontend_input = 'select' OR frontend_input = 'multiselect') AND (source_model IS NULL OR source_model = '');

+ And then, you must update value of ‘frontend_input’ field to ‘text‘ on data records found.
Regads,
Mall.

Hi Jon, 
Please move forward with the process at your end as Mall’s suggestion. If you come across any other issues, please get back to us here. 
 
PS. Since we’re off during the weekend, our apology for a certain delay in following up with you if you reach out to us this time. 

Regards,
Ubertheme team

Hi Jon,

https://www.dropbox.com/s/q77caeq23gqg6gq/eav_attribute_query_from_m1_database.txt?dl=0
Are you suggesting we make this change on the M1 database before migrating to M2?

My apology, please look for that data in your M2 database (I have just edited my reply #37 above). 

Regards,
Mall.

Hi there,

Thanks for getting back to me! I’ve run the query on the M2 database (result query linked below).
https://www.dropbox.com/s/5lvvgvknp40gcun/eav_attribute_query_from_m2_database.txt?dl=0
As you can see there are 7 rows with the following attributes either select or multiselect.

For those attributes, you need to change only the following attributes:
meta_robots, canonical_url, canonical_cross_domain, mailchimp_store_view

Please change the value of the ‘frontend_input’ from ‘select’ to ‘text’ (because the related source model or backed model for such attributes was missing).

Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘218003’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `quote`

That was because you checked the ‘KEEP ORIGINAL IDs’ settings in step #7 while your M2 had sample or testing data in the sales data section. To continue the data migration in step #7, you have to delete all sales data added in M2 (which weren’t migrated by our migration tool)

If it helps it looks like the last step7 failed but imported one sales order record if I go into it from the admin I get the following error:
Fatal error: Uncaught Error: Call to a member function getAdditionalInformation() on null in /domains/m2data.natureshealthbox.co.uk/http/vendor/magento/module-sales/Model/OrderRepository.php:183 Stack trace: #0

Please solve the issue on data migration in step #7 first. And then, you check this issue.

Regards,
Mall.

Hi Jon,

That was because you checked the ‘KEEP ORIGINAL IDs’ settings in step #7 while your M2 had sample or testing data in the sales data section. To continue the data migration in step #7, you have to delete all sales data added in M2 (which weren’t migrated by our migration tool)

Please try with the steps below:

+ Run the following SQL queries in your M2 database to delete all sample/testing sales data added in M2 (which wasn’t migrated by our migration tool):

Delete From salesrule Where rule_id NOT IN (Select m2_id From ub_migrate_map_step_7 where entity_name = 'salesrule');
Delete From quote Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_7_quote where entity_name = 'sales_flat_quote' OR entity_name = 'sales_flat_quote_active');
Delete From quote_item Where item_id NOT IN (Select m2_id From ub_migrate_map_step_7_quote_item where entity_name = 'sales_flat_quote_item');
Delete From quote_address Where address_id NOT IN (Select m2_id From ub_migrate_map_step_7_quote_address where entity_name = 'sales_flat_quote_address');
Delete From sales_order Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_7_order where entity_name = 'sales_flat_order');
Delete From sales_order_item Where item_id NOT IN (Select m2_id From ub_migrate_map_step_7_order_item where entity_name = 'sales_flat_order_item');
Delete From sales_order_address Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_7_order_address where entity_name = 'sales_flat_order_address');
Delete From sales_invoice Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_7_invoice where entity_name = 'sales_flat_invoice');
Delete From sales_invoice_item Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_7_invoice_item where entity_name = 'sales_flat_invoice_item');

+ Once done, you continue with the delta migration in step #7.

Regards,
Mall.

Hi Jon, 
I am sorry for replying to you this late as we’ve just been back from our weekend.

Returned the error ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
Is this line correct?

That referred to a MySQL’s sever issue at that time only, please try again.

Regards,
Mall.

Hi Stevo1, 
Please help to submit a separate ticket and provide us the specific issue that you mentioned, we will follow up with you then. 
Regards,
Ubertheme team

Hi Jon,

… I’ve managed to get to the login screen where it says Authentication is Required. I’ve put in the M2 admin username/password but it’s not working…

It seems that your server has a special setting case. You can try the following steps to disable that authentication:

1. Open the PHP file at: pub/ub-tool/protected/components/UserMenu.php
and find the code lines:

if (!isset($_SERVER['PHP_AUTH_USER'])) {
    header('WWW-Authenticate:Basic realm="'.$msg1.'"');
    header('HTTP/1.0 401 Unauthorized');
    echo $msg2;
    //throw new CHttpException(401, $msg2);
    Yii::app()->end();
} else {
    if (!UserMenu::authenticate($_SERVER['PHP_AUTH_USER'], $_SERVER['PHP_AUTH_PW'])) {
        header('WWW-Authenticate:Basic realm="'.$msg1.'"');
        header('HTTP/1.0 401 Unauthorized');
        echo $msg2;
        //throw new CHttpException(401, $msg2);
        Yii::app()->end();
    }
}

and replace it with:

/* if (!isset($_SERVER['PHP_AUTH_USER'])) {
    header('WWW-Authenticate:Basic realm="'.$msg1.'"');
    header('HTTP/1.0 401 Unauthorized');
    echo $msg2;
    //throw new CHttpException(401, $msg2);
    Yii::app()->end();
} else {
    if (!UserMenu::authenticate($_SERVER['PHP_AUTH_USER'], $_SERVER['PHP_AUTH_PW'])) {
        header('WWW-Authenticate:Basic realm="'.$msg1.'"');
        header('HTTP/1.0 401 Unauthorized');
        echo $msg2;
        //throw new CHttpException(401, $msg2);
        Yii::app()->end();
    }
} */

2. And then, you check the issue you mentioned again.

Regards,
Mall.