magento2 – Table or base view not found: 1146 The table & # 39; magent7.catalog_url_rewrite_product_category & # 39; does not exist

I migrate from Magento open source 1.9 to 2.3.3
the initial migration has gone well, however, I'm trying to do a delta migration using the Magento migration tool.

Execution of the delta command for the migration tool gives me the error

Base table or view not found: 1146 Table
'magent7.catalog_url_rewrite_product_category' does not exist

Although the table exists, but I think the tool does not add the prefix of the database before forming the query.
Any help is appreciated.

Thank you

Broken image links, even if the links are correct and the images exist

I have recently migrated my site from BlueHost to Siteground. The download folder has not been migrated correctly. I had to manually transfer several folders. Most images now appear correctly, however, some still do not. For example on this post, most of the photos are not there. But there is one who is. However, when I go into my file manager, I see that the photo is there.

For example, the first broken photo contains links to "https://i0.wp.com/madhouseheaven.com/wp-content/uploads/2015/03/Santo-Antão-021-1024×579.jpg?resize=1024% 2C579 & ssl = 1 "

When I look inside the folder, the picture is there.
enter the description of the image here

windows 10 – Unrecoverable PHP error: Uncaught ReflectionException: Class configuration does not exist

Unrecoverable PHP error: Uncaught ReflectionException: Class configuration does not exist in C: Projects mqtt vendor laravel framework src Illuminate Container Container.php: 804
Trace of the pile:

Fatal error: Uncaught ReflectionException: The class configuration does not exist in C: Projects mqtt vendor laravel framework src Illuminate Container Container.php: 804
Trace of the pile:

5th dnd – How could one duplicate a limited amount of gasoline while such a "future technology" does not exist otherwise in this setting?

RAW has nothing that can be enough for your players.

I could not find anything that would easily duplicate gasoline, although there is one thing I could find that your players could use, an Alchemy Jug.

This article can produce a defined amount of a list of liquids once a day. Among this list is "oil". Given the inaccuracy of this phenomenon, your players could eventually produce this oil and refine it in gasoline, but there is a problem, there is only a quarter of a liter a day. At most, you get 3 / 4th of the amount of gasoline you have in the oil, so you can get up to 1.5 liters of gas for 1 liter of oil. 39; oil.

The big problem with this is that no reasonably level spell would allow you to magically refine the oil; you should therefore use conventional equipment to do it, even if you could use magic to produce the energy input for that material.

As far as spells are concerned, your players would have two options.

First of all, they could use Wish, but as creating a mass of liquid is not part of the standard options, there is a one in three chance of losing Wish, plus the danger inherent in unforeseen effects, which means that better choices are present if you use this spell.

Secondly, they could give up gasoline and use Animate Objects, but that requires a level 5 niche, a concentration, and only works for one minute at a time.

Your players have a chance however, YOU. You may decide that an alchemy jug can produce gasoline itself, or allow a product to reflect to produce it (such as the carafe of endless water). Assuming you want them to use the car a lot.

Is it possible that a malicious software completely cache a folder so that Windows thinks it does not exist?

Today, I have a firewall rule allowing incoming traffic for a program called kmss.exe in the Windows Firewall of one of my computers and I am 100% sure not to have added it. I have never asked this program to connect. to the Internet through the Windows Firewall.

So, the firewall rule says that the program should be in C: /Windows/Temp/Files/Bin/kmss.exe, but when I opened the C: / Windows / file explorer Temp / in, there was no directory named "Files". I've tried using the command prompt to find it, I've failed again. And my settings already allow the display of hidden folders in the file explorer.

So, I suspect that C: /Windows/Temp/Files/Bin/kmss.exe exists, but it has managed to modify or deceive Windows into believing that it is not. Is it possible? If so, what can I do to access and delete this file?

network – What types of attacks against the NAT of the home router exist?

NAT on home routers generally allows all outgoing connections initiated by the user from the local network. NAT is usually associated with UPnP to allow users / hosts / services to open the required outgoing ports as needed.

Generally, there is no restriction on initializing outgoing connections to make the connection as user-friendly as possible.

If you consider the following factors common to home router deployments:

  • lack of supervision
  • wrong configuration or default configuration (default passwords)
  • users (even technical users will click on
  • insufficient host security on the local network (A / V, correction)

An attack that exploits the way NAT works on home routers, rather than a direct attack on the NAT itself, is simply a phishing attack (spear) against a LAN user.

Example: A condensed PDF file that the user is likely to click on, then running the code to call home, will be able to establish an outbound connection allowing the attacker to use the reverse channel to exploit more. LAN host, if necessary.

Note: This comes from my experience with home routers (billions, Linksys) running default firmware. If a home user deploys a Cisco 877 or Linksys running custom firmware, additional security checks may be applied.

The Google Search Console creates URLs that do not exist in my Sitemap, and complains about the error in these pages.

You have a misconception of what a sitemap is.

The sitemap is used to audit the crawling of the site by the bot search engine. The site plan and the exploration of a site are two different and independent things. Google will continue to explore your site regardless of any site map. The sitemap will be used to check / see if Google is able to correctly analyze your site. For example, if pages are in your sitemap and Google has not seen the page, Google can add the page to the recovery queue to include.

The opposite is not true. If a page is not in the sitemap, Google will not remove it from its index. Why? Because Google found it while exploring the site.

What you seem to believe is that the sitemap is the only authority used by Google to know which pages exist on a given site. This is not the case. The crawl is. The site map only allows Google to know if they can properly analyze your site and, if not, the missing pages in Google that need to be added to the recovery queue.

Your Google expectations no longer try to access pages because these pages no longer appear in your sitemap are incorrect. Sitemaps are cached and checked only periodically. Why? Because it is an audit process.

You have a real problem to solve.

You return a 500 error for pages not found. It's bad. Your website should return a 404 Not Found error. The error 500 is a system error and Google will treat the condition as temporary. If your site returned a 404 error, Google will continue to try the page several times over a period of time until it decides that the page does not exist anymore. If possible, you want to issue a Deleted 410 error for the pages you have deleted. If this is too much work or it is not possible, the 404 will be the same over time.

You must correct your 500 error.

mysql – If a table alias does not exist in another subquery, what is the point of creating them?

I have a table flight and I need to write a SQL query in mysql that returns the cheapest flight between two specific cities.

I tried the following code

SELECT * 
FROM (SELECT * 
   FROM flight
   WHERE departure_airport = 'AMS' AND arrival_airport = 'JFK') AS subset
WHERE fare = (SELECT MIN(fare) FROM subset)

But that produced the following error.

The table AIRLINE.subset & # 39; does not exist

After going through the solutions, I realized that the aliases were no longer available in the following subqueries, and I managed to execute the code by modifying it:

SELECT *
FROM flight
WHERE departure_airport = 'AMS' AND arrival_airport = 'JSK'
ORDER BY fare ASC
LIMIT 1

It works.
But I want to know how can I execute the query using the previous method. Is it impossible to reuse a derived table? And if so, what is the point of forcing us to name an alias if we can not use it?

The Google Search Console creates URLs that do not exist in my sitemap, and complains about the error in these pages.

You have a misconception of what a sitemap is.

The sitemap is used to audit the crawling of the site by the bot search engine. The site plan and the exploration of a site are two different and independent things. Google will continue to explore your site regardless of any site map. The sitemap will be used to check / see if Google is able to correctly analyze your site. For example, if pages are in your sitemap and Google has not seen the page, Google can add the page to the recovery queue to include.

The opposite is not true. If a page is not in the sitemap, Google will not remove it from its index. Why? Because Google found it while exploring the site.

What you seem to believe is that the sitemap is the only authority used by Google to know which pages exist on a given site. This is not the case. The crawl is. The site map only allows Google to know if they can properly analyze your site and, if not, the missing pages in Google that need to be added to the recovery queue.

Your Google expectations no longer try to access pages because these pages no longer appear in your sitemap are incorrect. Sitemaps are cached and checked only periodically. Why? Because it is an audit process.

You have a real problem to solve.

You return a 500 error for pages not found. It's bad. Your website should return a 404 Not Found error. The error 500 is a system error and Google will treat the condition as temporary. If your site returned a 404 error, Google will continue to try the page several times over a period of time until it decides that the page does not exist anymore. If possible, you want to issue a Deleted 410 error for the pages you have deleted. If this is too much work or it is not possible, the 404 will be the same over time.

You must correct your 500 error.

google forms – How to check if the values ​​of two cells exist in two columns of another sheet

I try to make a classroom attendance system where the student saves by submitting her name in Google forms. The final result will be displayed in Google sheets by ticking a box after the name of each student.

So, in Google Sheets, in cell B3 of sheet 2, I would like to write a formula that checks if the text of B2 of sheet 2 (2019-10-20) matches column A of sheet1 where the text contains additional characters (2019-10- 20 04:15:25) AND if the text in A3 of sheet 2 (Robin) exists in column B among the results that have just been matched. If it does – returns TRUE, otherwise returns FALSE.

Example