|
How did I solve «Failed to add the foreign key constraint 'SEARCH_QUERY_STORE_ID_STORE_STORE_ID' to system tables» on `bin/magento setup:upgrade`?
|
|
1
|
9
|
May 7, 2026
|
|
How to avoid dumping data from big tables (like `report_viewed_product_index`) using MariaDB?
|
|
2
|
10
|
May 3, 2026
|
|
How to reduce the database size after long-term use of a website?
|
|
2
|
2229
|
May 3, 2026
|
|
How did I fix «Item (Mage_Catalog_Model_Product) with the same id "…" already exist» on loading `Mage_Catalog_Model_Resource_Product_Compare_Item_Collection` in Magento 1?
|
|
1
|
250
|
March 18, 2024
|
|
How to replace all sales emails «Copy To» addresses in Magento 1 via a single SQL command?
|
|
1
|
150
|
March 3, 2024
|
|
How to check the last usage of every payment method in Magento 1?
|
|
1
|
114
|
December 16, 2023
|
|
How to set a password to a customer via SQL?
|
|
0
|
363
|
November 29, 2022
|
|
How to get a product's custom option's value in a particular order via SQL?
|
|
0
|
605
|
August 22, 2021
|
|
How to find out the most active wishlist users in your store?
|
|
1
|
580
|
October 23, 2020
|
|
How to find out how much customers uses the product comparison feature?
|
|
1
|
553
|
October 23, 2020
|
|
How to find out how much customers uses wishlists?
|
|
1
|
639
|
October 23, 2020
|
|
How to execute the COUNT() SQL function
|
|
2
|
15671
|
December 1, 2018
|
|
How to change the root URL (move Magento 2 to another domain)?
|
|
4
|
37466
|
January 3, 2017
|
|
How to programmatically check whether a database table contains a specified column?
|
|
1
|
1970
|
November 4, 2016
|
|
How to rename a database column?
|
|
1
|
2999
|
November 4, 2016
|
|
How to change (modify) a column definition for a database table
|
|
1
|
21639
|
January 26, 2016
|
|
How to programmatically execute the «SHOW TABLE STATUS» SQL statement for a database table
|
|
1
|
3043
|
January 26, 2016
|
|
How to alter a database table?
|
|
1
|
3277
|
January 26, 2016
|
|
How to delete (drop) a foreign key from a database table
|
|
1
|
5351
|
January 26, 2016
|
|
How to add a foreign key to a database table
|
|
1
|
11413
|
January 26, 2016
|
|
How to delete (drop) an index from a database table
|
|
1
|
7822
|
January 26, 2016
|
|
How to add an index to a database table
|
|
1
|
12888
|
January 26, 2016
|
|
How to rename a database table
|
|
1
|
3431
|
January 26, 2016
|
|
How to delete (drop) a column from a database table?
|
|
2
|
7232
|
November 4, 2016
|
|
How to add a column to a database table?
|
|
2
|
10967
|
November 4, 2016
|
|
How to reset the «Secure Base URL for Static View Files» option value by an SQL query?
|
|
1
|
5246
|
March 25, 2016
|
|
How to reset the «Secure Base URL for User Media Files» option value by an SQL query?
|
|
1
|
2606
|
March 25, 2016
|
|
A product list CMS widget rendering failed: «Error filtering template: Unknown column 'e.category_ids' in 'where clause'» (and my fix)
|
|
4
|
5294
|
May 16, 2016
|
|
How to programmatically check whether a customer is new or returning?
|
|
0
|
1247
|
May 13, 2016
|
|
How does \Magento\Framework\DB\Adapter\Pdo\Mysql::getCheckSql() work?
|
|
0
|
2297
|
April 29, 2016
|