Topics tagged sql

Topic	Replies	Views	Activity
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`? Upgrade sql , foreign-key , mysql , upgrade , database , setup:upgrade	1	28	May 7, 2026
How to avoid dumping data from big tables (like `report_viewed_product_index`) using MariaDB? How To mysql , mariadb , sql , database	2	16	May 3, 2026
How to reduce the database size after long-term use of a website? Administration sql , database , mysql	2	2231	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? Magento 1 bug , bug-fix , magento1 , mysql , sql , product-comparison	1	250	March 18, 2024
How to replace all sales emails «Copy To» addresses in Magento 1 via a single SQL command? Magento 1 order-confirmation-email , transactional-email , email , sql , magento1	1	153	March 3, 2024
How to check the last usage of every payment method in Magento 1? Magento 1 magento1 , sql , payment	1	117	December 16, 2023
How to set a password to a customer via SQL? Administration customer-password , sql , customer , password	0	363	November 29, 2022
How to get a product's custom option's value in a particular order via SQL? Administration sql , product-option-value , product-option	0	605	August 22, 2021
How to find out the most active wishlist users in your store? Administration wishlist , customer , report , sql	1	580	October 23, 2020
How to find out how much customers uses the product comparison feature? Administration product-comparison , sql , report	1	553	October 23, 2020
How to find out how much customers uses wishlists? Administration wishlist , customer , sql , report	1	639	October 23, 2020
How to execute the COUNT() SQL function Database database , sql , db-count	2	15672	December 1, 2018
How to change the root URL (move Magento 2 to another domain)? Administration sql , url , env.php , app-etc , base-url	4	37494	January 3, 2017
How to programmatically check whether a database table contains a specified column? Database db-column , db-table , sql	1	1971	November 4, 2016
How to rename a database column? Database db-alter-table , db-column , database , db-table , sql	1	3003	November 4, 2016
How to change (modify) a column definition for a database table Database database , sql , db-table , db-alter-table , db-column	1	21666	January 26, 2016
How to programmatically execute the «SHOW TABLE STATUS» SQL statement for a database table Database database , show-table-status , sql	1	3043	January 26, 2016
How to alter a database table? Database database , sql , db-table , db-alter-table	1	3277	January 26, 2016
How to delete (drop) a foreign key from a database table Database database , sql , db-table , db-alter-table , foreign-key	1	5351	January 26, 2016
How to add a foreign key to a database table Database database , sql , db-table , db-alter-table , foreign-key	1	11413	January 26, 2016
How to delete (drop) an index from a database table Database database , sql , db-table , db-alter-table , db-index	1	7829	January 26, 2016
How to add an index to a database table Database database , sql , db-table , db-alter-table , db-index	1	12891	January 26, 2016
How to rename a database table Database database , sql , db-table , db-alter-table	1	3432	January 26, 2016
How to delete (drop) a column from a database table? Database database , sql , db-table , db-alter-table , db-column	2	7232	November 4, 2016
How to add a column to a database table? Database database , sql , db-table , db-alter-table , db-column	2	10968	November 4, 2016
How to reset the «Secure Base URL for Static View Files» option value by an SQL query? Administration static-content , base-url , url , configuration , sql , secure-url , https , ssl , security	1	5248	March 25, 2016
How to reset the «Secure Base URL for User Media Files» option value by an SQL query? Administration media , base-url , url , configuration , sql , secure-url , https , ssl , security	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) Issues sql , widget , bug , attribute , product-attribute , attribute-category_ids , bug-fix , rendering	4	5294	May 16, 2016
How to programmatically check whether a customer is new or returning? Customer sales , customer , db-select , database , sql , order-state , order-state-complete , order-state-processing	0	1247	May 13, 2016
How does \Magento\Framework\DB\Adapter\Pdo\Mysql::getCheckSql() work? Database database , sql	0	2297	April 29, 2016