Topics tagged database

Topic	Replies	Views	Activity
How to decrease a Magento 2 database size after a long-term intensive usage? Administration sql , database	1	1887	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	13819	April 27, 2021
Deadlock occur during mass product import programatically Ask your questions magento22 , database , mysql	7	3967	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	1797	December 1, 2018
How to execute the COUNT() SQL function Database database , sql , db-count	2	14271	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	665	November 10, 2018
How to fix the «Invalid default value for 'updated_at'» MySQL 5.7 failire? Issues database , mysql	1	5240	July 30, 2018
How to get the database name programmatically Database database	1	3048	March 13, 2018
How to decrease the database size while using Mirasvit Cache Warmer? Third-party extensions third-party-extension , mirasvit , database	0	733	February 7, 2018
How to fix the «You do not have the SUPER privilege and binary logging is enabled» issue? Administration database , mysql	1	9267	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	1875	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	1371	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	851	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	954	January 27, 2016
How is the «vault_payment_token» database table implemented and used? Customer vault , database , braintree , payment , customer , payment-token	1	2373	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	1035	May 5, 2017
How to create a translatable custom model? Ask your questions backend_model , database , module , model	0	601	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	2479	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	16784	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	1662	January 20, 2017
How to get the Magento 2 core problems solved by my requests? Ask your questions database , eav , bug-fix , product	1	1170	January 18, 2017
How to find the Magento 2 database credentials using the command line? Administration database , env.php , command-line , grep , credentials	1	1749	November 22, 2016
How to rename a database column? Database db-alter-table , db-column , database , db-table , sql	1	2798	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	20860	January 26, 2016
How to programmatically execute the «SHOW TABLE STATUS» SQL statement for a database table Database database , show-table-status , sql	1	2780	January 26, 2016
How to alter a database table? Database database , sql , db-table , db-alter-table	1	3069	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	4904	January 26, 2016
How to add a foreign key to a database table Database database , sql , db-table , db-alter-table , foreign-key	1	11030	January 26, 2016
How to delete (drop) an index from a database table Database database , sql , db-table , db-alter-table , db-index	1	7169	January 26, 2016
How to add an index to a database table Database database , sql , db-table , db-alter-table , db-index	1	12183	January 26, 2016