Topics tagged database

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	12	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	12	May 3, 2026
How to reduce the database size after long-term use of a website? Administration sql , database , mysql	2	2229	May 3, 2026
How did I suppress the «Current version of RDBMS is not supported» error? How To setup:upgrade , mysql , upgrade , database , compatibility	1	45	August 25, 2024
How did I fix «Current version of RDBMS is not supported. Used Version: 10.5.25-MariaDB-deb11-log. Supported versions: MySQL-8, MySQL-5.7, MariaDB-(10.2-10.4)» on `bin/magento setup:upgrade`? Issues setup:upgrade , mysql , mariadb , upgrade , hosting , database , cloudways , compatibility	1	245	August 25, 2024
How did I fix «mysqldump: Got error: 145: Table 'catalogsearch_fulltext' is marked as crashed and should be repaired when using LOCK TABLES» in OpenMage 19.5.2? Magento 1 mysql , database , openmage , openmage-19 , full-text-search , indexing , search	1	12	August 18, 2024
How is the `sales_order_grid` table's structure defined in Magento < 2.3? Sales backend , sales , database , backend-order-grid	1	150	February 11, 2024
The `base_discount_amount` field has never been in the `sales_order_grid` table Sales discount , backend-order-grid , alphacommercehub , sales , backend , database , db_schema	1	176	February 11, 2024
How is the `sales_order_grid` table's structure defined? Sales backend , sales , database , backend-order-grid	2	133	February 11, 2024
Since which version Magento 2 started using `db_schema.xml` files? Database database , db_schema	1	123	February 11, 2024
How is the `sales_order_grid` table's structure defined in Magento ≥ 2.3.0? Sales backend , sales , database , backend-order-grid , db_schema	1	140	February 11, 2024
How to fix the «Base table or view not found: catalog_category_product_index_replica» Magento 2.2 bug? Issues database , bug , magento22 , indexing , bug-fix	2	14842	April 27, 2021
Deadlock occur during mass product import programatically Ask your questions magento22 , database , mysql	7	4665	September 15, 2020
How to fix the «Table `admin_user` doesn't exist» failure on `bin/magento admin:user:create` while using a database tables prefix? Issues database , command-line , bug-fix , bug	2	1993	December 1, 2018
How to execute the COUNT() SQL function Database database , sql , db-count	2	15671	December 1, 2018
How to dump a store's settings for convenient reading and comparison in tools like Araxis Merge? Administration mysql , command-line , debug , database	1	795	November 10, 2018
How to fix the «Invalid default value for 'updated_at'» MySQL 5.7 failire? Issues database , mysql	1	5556	July 30, 2018
How to get the database name programmatically Database database	1	3275	March 13, 2018
How to decrease the database size while using Mirasvit Cache Warmer? Third-party extensions third-party-extension , mirasvit , database	0	817	February 7, 2018
How to fix the «You do not have the SUPER privilege and binary logging is enabled» issue? Administration database , mysql	1	9889	August 14, 2017
How to fix the «Integrity constraint violation: Duplicate entry for key 'SALES_ORDER_INCREMENT_ID_STORE_ID'» failure? Issues database , sales-document , bug-fix , order-increment-id , bug	1	2025	July 15, 2017
How to fix the «Table "catalogrule_product_replica" does not exist» Magento 2.2 bug? Issues database , db-table , bug , magento22 , catalog-rule	1	1496	July 8, 2017
A code from the \Magento\Catalog\Model\ResourceModel\Category::_getMaxPosition() method can be simplified from 5 lines to 1 Issues improvement , database , code-quality	0	934	January 26, 2016
Naming inconsistency: identically named method addCommitCallback() is called BEFORE a commit in the \Magento\Framework\DB\Transaction class, but AFTER a commit in the \Magento\Framework\Model\ResourceModel\AbstractResource class Issues improvement , database , db-transaction , code-quality	0	1088	January 27, 2016
How is the «vault_payment_token» database table implemented and used? Customer vault , database , braintree , payment , customer , payment-token	1	2724	June 5, 2017
How to implement one-to-many with attributes implementation between custom model and catalog products? Ask your questions database , model , resource-model , product , backend	0	1295	May 5, 2017
How to create a translatable custom model? Ask your questions backend_model , database , module , model	0	688	April 12, 2017
How to implement a one-to-many relationship between a custom entity and products? Ask your questions backend_model , database , module , model	1	2655	April 7, 2017
app/etc/env.php — the place where Magento 2 stores the database credentials, backend URL, enabled cache types, etc Administration env.php , database , backend-url , app-etc	2	18654	April 1, 2017
How to detect the changed Magento 2 entities if they could be changed without updating the stantard «updated_at» field? Ask your questions database , import , export	2	1871	January 20, 2017