Topics tagged database

Topic	Replies	Views	Activity
How is the `sales_order_grid` table's structure defined in Magento < 2.3? Sales backend , sales , database , backend-order-grid	1	99	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	104	February 11, 2024
How is the `sales_order_grid` table's structure defined? Sales backend , sales , database , backend-order-grid	2	69	February 11, 2024
Since which version Magento 2 started using `db_schema.xml` files? Database database , db_schema	1	68	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	64	February 11, 2024
How to decrease a Magento 2 database size after a long-term intensive usage? Administration sql , database	1	2121	January 13, 2022
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	14299	April 27, 2021
Deadlock occur during mass product import programatically Ask your questions magento22 , database , mysql	7	4355	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	1921	December 1, 2018
How to execute the COUNT() SQL function Database database , sql , db-count	2	15089	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	758	November 10, 2018
How to fix the «Invalid default value for 'updated_at'» MySQL 5.7 failire? Issues database , mysql	1	5432	July 30, 2018
How to get the database name programmatically Database database	1	3192	March 13, 2018
How to decrease the database size while using Mirasvit Cache Warmer? Third-party extensions third-party-extension , mirasvit , database	0	786	February 7, 2018
How to fix the «You do not have the SUPER privilege and binary logging is enabled» issue? Administration database , mysql	1	9624	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	1969	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	1455	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	908	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	1045	January 27, 2016
How is the «vault_payment_token» database table implemented and used? Customer vault , database , braintree , payment , customer , payment-token	1	2561	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	1224	May 5, 2017
How to create a translatable custom model? Ask your questions backend_model , database , module , model	0	660	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	2582	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	17822	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	1785	January 20, 2017
How to get the Magento 2 core problems solved by my requests? Ask your questions database , eav , bug-fix , product	1	1279	January 18, 2017
How to find the Magento 2 database credentials using the command line? Administration database , env.php , command-line , grep , credentials	1	1949	November 22, 2016
How to rename a database column? Database db-alter-table , db-column , database , db-table , sql	1	2923	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	21322	January 26, 2016
How to programmatically execute the «SHOW TABLE STATUS» SQL statement for a database table Database database , show-table-status , sql	1	2956	January 26, 2016