404 Error then File Not Found Server Configuration

Hi there,
I have installed the extension and got to 4. Server Configuration. Initially I included the config file for ub-tool but on NGINX reload it gave me this error and 404 page on the extension page in the admin:
nginx: [emerg] “fastcgi_pass” directive is duplicate in /etc/nginx/fastcgi_params:71
nginx: configuration file /etc/nginx/nginx.conf test failed
I spoke to web host and they said the fastcgi_pass is already set in global configuration. So I went to your configuration file and commented out on line 26 this line like so #fastcgi_pass 127.0.0.1:9000;
After another NGINX reload I now get file not found inside admin on extension page. How can I fix this issue?
Kind regards, Jon

54 answers

Profile photo of Mall Staff 184060.00 $tone April 28, 2020
Public

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.
 

#1
Profile photo of ubdev Staff 98130.00 $tone April 30, 2020
Public

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

#10
Profile photo of ubdev Staff 98130.00 $tone May 1, 2020
Public

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

#11
Profile photo of ubdev Staff 98130.00 $tone May 8, 2020
Public

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

#21
Profile photo of Mall Staff 184060.00 $tone May 11, 2020
Public

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.

#23
Profile photo of Mall Staff 184060.00 $tone May 12, 2020
Public

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.

#25
Profile photo of ubdev Staff 98130.00 $tone May 12, 2020
Public

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

#27
Profile photo of Mall Staff 184060.00 $tone May 14, 2020
Public

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.

#31
Profile photo of Mall Staff 184060.00 $tone May 15, 2020
Public

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.

#33
Profile photo of Mall Staff 184060.00 $tone May 15, 2020
Public

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.

#35
Profile photo of Mall Staff 184060.00 $tone May 21, 2020
Public

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.

#37
Profile photo of orgnat 110.00 $tone May 22, 2020
Public

Hi Mall,
Ok thanks for this I’ll give that a try and see what we can find. Also we continued as a test to do step 7 and 8 which seemed to have worked fine. We’re just testing the store will then try the delta and if all goes well this issue with customers should be the last issue and we can perform this again for real.
Back to you soon!
Cheers, Jon

#38
Profile photo of ubdev Staff 98130.00 $tone May 22, 2020
Public

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

#39
Profile photo of orgnat 110.00 $tone May 27, 2020
Public

Hi Mall,
Whilst waiting for the issue above I’ve moved onto the next step. I wanted to test delta migrations so I’ve started with customers and sales. I’ve migrated step6 customers which seems to have worked fine. I then tried to do step7 sales data and I got the following error just after:
[Processing][delta] Step #7 migration completed with 15 Sales Order Statuses;
Status: fail
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` (`store_id`, `is_active`, `is_virtual`, `is_multi_shipping`, `items_count`, `items_qty`, `orig_order_id`, `store_to_base_rate`, `store_to_quote_rate`, `grand_total`, `base_grand_total`, `customer_group_id`, `customer_note_notify`, `customer_is_guest`, `trigger_recollect`, `is_persistent`, `entity_id`, `created_at`, `updated_at`, `base_currency_code`, `store_currency_code`, `quote_currency_code`, `customer_id`, `customer_tax_class_id`, `customer_email`, `customer_firstname`, `customer_lastname`, `remote_ip`, `reserved_order_id`, `global_currency_code`, `base_to_global_rate`, `base_to_quote_rate`, `subtotal`, `base_subtotal`, `subtotal_with_discount`, `base_subtotal_with_discount`, `is_changed`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16, :yp17, :yp18, :yp19, :yp20, :yp21, :yp22, :yp23, :yp24, :yp25, :yp26, :yp27, :yp28, :yp29, :yp30, :yp31, :yp32, :yp33, :yp34, :yp35, :yp36)
Any idea what the issue is here?
Cheers, Jon

#43
Profile photo of Mall Staff 184060.00 $tone May 28, 2020
Public

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.

#45
Profile photo of Mall Staff 184060.00 $tone June 4, 2020
Public

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.

#47
Profile photo of orgnat 110.00 $tone June 5, 2020
Public

Hi Mall,
I ran those queries. The query below:

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');

Returned the error ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
Is this line correct?
 
All other queries ran ok with 0 rows affected. 
Cheers, Jon
 

#48
Profile photo of Mall Staff 184060.00 $tone June 8, 2020
Public

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.

#49
Profile photo of ubdev Staff 98130.00 $tone July 27, 2020
Public

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

#51
Profile photo of orgnat 110.00 $tone June 16, 2021
Public

Hi Mall,
I’ve managed to get abit further with a fresh Magento install. 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. I had this problem last time but it seemed to work after sometime. I’ve tried incognito mode on Chrome and Private browsing on Firefox without success. I’ve also deleted cookies and cache but no luck. I used the updated UserMenu.php as mentioned before but still no luck accessing the UB DATA MIGRATION admin screens.
If I can get past this I’ll be able to complete the migration. Any help greatly appreciated.
Cheers, Jon

#53
Profile photo of Mall Staff 184060.00 $tone June 17, 2021
Public

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.

#54

Please login or Register to Submit Answer

Written By

Comments