database

Topic Replies Created
Deadlock occur during mass product import programatically 7 January 23, 2019
How to fix the «Table `admin_user` doesn't exist» failure on `bin/magento admin:user:create` while using a database tables prefix? 3 December 1, 2018
How to execute the COUNT() SQL function 3 March 15, 2016
How to dump a store's settings for convenient reading and comparison in tools like Araxis Merge? 2 October 30, 2018
How to fix the «Invalid default value for 'updated_at'» MySQL 5.7 failire? 2 July 30, 2018
How to get the database name programmatically 2 October 12, 2015
How to decrease the database size while using Mirasvit Cache Warmer? 1 February 7, 2018
How to fix the «You do not have the SUPER privilege and binary logging is enabled» issue? 2 April 13, 2016
How to fix the «Integrity constraint violation: Duplicate entry for key 'SALES_ORDER_INCREMENT_ID_STORE_ID'» failure? 2 July 15, 2017
How to fix the «Table "catalogrule_product_replica" does not exist» Magento 2.2 bug? 2 July 7, 2017
A code from the \Magento\Catalog\Model\ResourceModel\Category::_getMaxPosition() method can be simplified from 5 lines to 1 1 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 1 January 27, 2016
How is the «vault_payment_token» database table implemented and used? 2 June 5, 2017
How to implement one-to-many with attributes implementation between custom model and catalog products? 1 May 5, 2017
How to create a translatable custom model? 1 April 12, 2017
How to fix the «Base table or view not found: catalog_category_product_index_replica» Magento 2.2 bug? 2 April 11, 2017
How to implement a one-to-many relationship between a custom entity and products? 2 April 7, 2017
app/etc/env.php — the place where Magento 2 stores the database credentials, backend URL, enabled cache types, etc 3 December 24, 2015
How to detect the changed Magento 2 entities if they could be changed without updating the stantard «updated_at» field? 3 January 20, 2017
How to get the Magento 2 core problems solved by my requests? 2 January 18, 2017
How to find the Magento 2 database credentials using the command line? 2 November 22, 2016
How to rename a database column? 2 November 4, 2016
How to change (modify) a column definition for a database table 2 January 26, 2016
How to programmatically execute the «SHOW TABLE STATUS» SQL statement for a database table 2 January 11, 2016
How to alter a database table? 2 January 26, 2016
How to delete (drop) a foreign key from a database table 2 January 26, 2016
How to add a foreign key to a database table 2 January 26, 2016
How to delete (drop) an index from a database table 2 January 26, 2016
How to add an index to a database table 2 January 26, 2016
How to rename a database table 2 January 26, 2016