How to create a sitemap for Google to re-index 40,000 fake pages?

How to remove from the Google index pages of my site that were created by a virus Japanese keyword hack&?

It is necessary to remove from the Google index links to the pages of my site that were created by a virus – about 43 800 pages in Google index. The virus and the pages it created were removed from the site. A week ago, changes were made to the sitemap for reindexing. But so far the pages have not been deleted – moreover, new “garbage” pages appear in Google Webmaster. The site has no more than 100 “real” pages in the index. Everything else is non-existent links to garbage pages.

The main question we have now is how to remove this spam information from the Google index?


magento2 – 400 Bad Request when trying to reindex

I have a Magento 2 store running with Elasticsearch 7.x and Litemage.
I’m getting the following error when trying to run an index job on Magento 2:

Design Config Grid index has been rebuilt successfully in 00:00:00
Customer Grid index has been rebuilt successfully in 00:00:00
Category Products index LiteMage purged tags cat_c
has been rebuilt successfully in 00:00:02
Product Categories index has been rebuilt successfully in 00:00:00
Catalog Rule Product index LiteMage purged tags cat_p,BLOCK_HTML
has been rebuilt successfully in 00:00:01
Product EAV index has been rebuilt successfully in 00:00:07
Stock index has been rebuilt successfully in 00:00:01
Inventory index LiteMage purged tags cat_p_2791
<!DOCTYPE html>
<html style="height:100%">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" >
<title> 400 Bad Request
<body style="color: #444; margin:0;font: normal 14px/20px Arial, Helvetica, sans-serif; height:100%; background-color: #fff;">
<div style="height:auto; min-height:100%; ">     <div style="text-align: center; width:800px; margin-left: -400px; position:absolute; top: 30%; left:50%;">
        <h1 style="margin:0; font-size:150px; line-height:150px; font-weight:bold;">400</h1>
<h2 style="margin-top:20px;font-size: 30px;">Bad Request
<p>It is not a valid request!</p>
has been rebuilt successfully in 00:00:14
Catalog Product Rule index has been rebuilt successfully in 00:00:00
Product Price index has been rebuilt successfully in 00:00:01
Catalog Search index has been rebuilt successfully in 00:00:08
Order Attributes Grid by Amasty index has been rebuilt successfully in 00:00:00
Mageplaza Reward Catalog Rule index has been rebuilt successfully in 00:00:00
Mageplaza Reward Product Rule index has been rebuilt successfully in 00:00:00

The issue only started once I did a “Transfer Inventory To Source” on certain products (e.g transferred inventory quantities from one source to another).

I’ve tried to disable litespeed_litemage module; going back to built-in cache, running the command (which doesn’t give any errors) and then turning litemage back on (without success).

I’m stuck and need help.

Reindex or Analyze Tables on PostgreSQL after import

I used PostgreSQL 9.5 on a server and I ended up migrating the data to a new server using PosgreSQL 12.

Should I perform a REINDEX for all tables or just ANALYZE for all tables?

magento2 – Magento 2 Catalog rule can not applied after reindex automatic

I wrote the code for creating a Catalog rule in Magento 2.3.5 and after saving I have the code to re-index it automatically.

  /** @var MagentoCatalogRuleModelRule $model */
                $ruleRepository = $this->_objectManager->get(
                $catalogRule = $this->_objectManager->create(MagentoCatalogRuleModelRule::class);
                $ruleByBoRefId = $this->getRuleByBoRefId($boRefId);
                if (isset($ruleByBoRefId("rule_id")) && $ruleId = $ruleByBoRefId("rule_id")) {
                    $catalogRule = $ruleRepository->get($ruleId);


Code Reindex auto:

public function reindexCatalogRule($catalogRule){


    $collection = $this->_indexerCollectionFactory->create()->getAllIds();
    foreach ($collection as $id) {
        $indexer = $this->_indexerFactory->create()->load($id);

But after reindex the Rule still doesn’t apply to the product. However, after I go to the admin and edited the previously saved catalog rule => Click Save => Then I ran the Indexer: reindex command of magento, the rule applies normally. I don’t understand why like that. Please help me
How to apply rules to products automatically ?

magento2 – Invalid column data type when reindex Magento 2

I’m using Magento 2.3.4 for my website, when I try to reindex, the category flat was not reindex and appear error like this:

enter image description here

I search some post in here and try this solution:

magento 2.3.4 installation issue in localhost

But it’s still not work.

How I can fix this?

Thank you very much!

Magento 2.3 re-index failing for sales rule index

When I trying to re-index salesrule_rule index, It gives me bellow error and the sales rule grid is not loading in magento admin. Please advice.

Item (MagentoSalesRuleModelRuleInterceptor) with the same ID "165" already exists.

magento2 – I cant Reindex the ID catalogsearch_fulltext MAGENTO 2.4

do you know if this is a server error Catalog Search index exception: Could not ping search engine: No alive nodes found in your cluster, if I send the index command everything does it except for this ID php bin / magento indexer : reindex catalogsearch_fulltext my data is hosted on a server and I do it through SSH, the Magento version is the newest 2.4, it seems that it is a node error so I was checking, someone knows something about it, I would appreciate it

enter image description here

magento2.3 – Magento 2.3.4 – Reindex Catalog Search MySql Error

I am trying to reindex the Search however, I keep getting this error; any hint?

bash-4.2$ php bin/magento indexer:reindex catalogsearch_fulltext
Catalog Search indexer process unknown error:
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 ')) GROUP BY `product_id`' at line 1, query was: SELECT `catalog_category_product`.`product_id` FROM `catalog_category_product` WHERE (product_id IN (396)) AND (category_id != ('2')) AND (category_id IN ()) GROUP BY `product_id`

8 – How to programmatically reindex commerce products?

I am using Drupal 8 Commerce module.

I am using Elastic Search on AWS platform.

From the Admin whenever product is saved, those changes are directly applied on Elastic Search server, but when I try with $product->save() it is not working 100%.

So if I have to update 10 products in Elastic Search how to achieve that programatically?

Reindex programmatically in magento

I am new to magento. i have to indexer:reindex pragmatically and i looking for this solution. i found few source but there is no guide how and where i can use this code.

How to perform Reindexing Programmatically in Magento 2

can someone please guide me through?