Tag: sql

19 How to use setup scripts for your module? 2013-01-24T23:48:09.220

19 How to log all Magento SQL? 2014-06-26T11:40:06.033

16 Magento running on Percona Server with XtraDB 2013-01-26T12:42:45.607

15 SQL injections vulnerabilities when using SQL models of the Zend Framework 2015-06-09T15:44:22.310

8 How to create multi select attribute for customer using install script? 2014-07-01T10:48:10.867

8 Remove category attribute 2015-05-08T08:24:03.637

7 How to log SQL query of the collection? 2013-09-26T09:32:19.873

7 display a sql query being generated 2013-10-15T13:05:08.277

7 Geting Fatal error: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away 2014-11-01T05:34:18.120

7 Decrement value instead of setting it like `number = number - 1`. Is it possible in Magento? 2015-02-17T13:53:34.333

7 Magento 1 SQL Queries 2015-03-24T16:29:11.047

6 magento 1.7 : Cannot reindex product_flat_data 2013-03-22T15:15:55.243

6 How does magento create bundle option selections? 2013-11-08T17:18:33.067

6 How can I use UNION for 2 collections ? Or merge collections ? (for use in adminhtml grid) 2013-12-11T17:10:24.743

6 How to Load Model data joining 2 tables? 2014-07-08T11:47:32.413

6 Best sellers block from joining product collection with the monthly bestseller aggregation 2014-12-16T14:51:26.090

6 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shopstel_magento.core_store' doesn't exist 2015-03-02T19:02:38.790

6 Array of product ids for a given category (respecting is_anchor) 2015-08-13T13:52:39.273

6 Example of Code and Configuration Needed for a Simple Magento 2 CRUD Model? 2016-01-07T05:48:17.210

6 How to optimize the query: the product qty bought with each of the products 2016-06-29T15:41:28.537

5 Query to return customer order history? 2013-05-08T15:43:07.390

5 What is the 'data' folder in magento modules? 2013-09-26T16:46:28.950

5 Get full list of categories using sql 2014-06-05T15:06:43.893

5 How is Varien_Db_Adapter_Pdo_Mysql::orderRand() optimized? 2015-02-19T13:26:11.280

5 Add Field to Customer Registation Form Magento 2 2015-12-30T17:54:52.443

5 Can I use a .sql file in my Magento module installer? 2016-01-11T10:01:57.437

5 Magento getCollection , SQL injection 2016-07-27T16:03:21.030

5 Magento 2 - SQL Injection 2016-08-08T18:24:46.677

4 Manual eav join best way? 2013-10-11T16:53:55.787

4 grid joinTable alias problem in order by 2014-02-02T20:54:54.157

4 Updating stock causing foreign key constraint fail 2014-11-13T07:28:22.913

4 Rerun an extensions SQL files 2014-12-08T16:23:53.397

4 Unable to save custom order attribute 2015-01-30T19:11:12.803

4 Magento ORM not preventing concurrent db writes 2015-02-25T07:43:11.080

4 Magento 2 adding constraints in the install script 2015-03-30T12:57:01.020

4 How to join a calculated column from a table to collection 2015-07-03T07:10:01.593

4 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'CONCAT( REPEAT 2015-07-08T13:48:04.663

4 Subselect as main_table on magento collection 2015-11-03T19:43:05.130

4 SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction 2015-11-11T04:56:37.390

4 Configurable product super attribute Integrity constraint violation error 2015-12-16T19:04:28.460

4 Magento 2: How to delete all categories at once? 2016-02-25T18:35:47.153

4 run sql query and save result in csv 2016-03-07T22:14:43.690

4 "random" order clause added to my collection 2016-05-31T12:05:39.033

4 How do I specify unique constraint for multiple columns in InstallSchema.php? 2016-08-12T14:47:21.170

4 magento2 search_tmp join leads to empty results in category listing 2016-10-31T14:16:28.060

4 SQl is not working? 2017-03-02T11:42:40.633

4 Is there any way to get where condition from the collection? 2017-06-27T09:22:15.680

4 Magento Frontend suddenly very slow (Backend fast) issue MySQL related 2017-10-04T12:05:34.143

3 What's the reason for sql-updates being triggered multiple times? 2013-01-25T08:09:11.137

3 Magento Collection Loading Prematurely 2013-08-20T09:21:15.497

3 How do I get the MySQL (updated) affected rows when using the Magento resource? 2013-12-24T07:17:56.253

3 Group Price Report 2014-01-14T16:08:26.933

3 How to edit SQL error generated by PDO.php? 2014-02-20T16:07:57.050

3 Query only completed orders 2014-07-31T20:55:16.610

3 getTableName not adding table prefix (for 1 table only) 2014-10-26T19:28:40.687

3 Bulk updating Magento special to & from date as well as special price using SQL (Magento 1.7) 2015-01-26T20:16:51.057

3 New magento website + old database 2015-03-12T08:48:59.033

3 Convert SQL Select to Magento getCollection statement 2015-03-13T11:50:04.153

3 MD5 passwords from MS SQL to MySQL 2015-04-24T04:21:47.870

3 Module Database setData() makes UPDATE Query instead of INSERT? 2015-06-18T11:46:54.720

3 How to remove telephone number as required field in billing and shipping on admin side? 2015-06-26T14:34:46.277

3 Why is my product collection on my staging site different than my live site? 2015-08-04T16:30:01.120

3 how to get product specific attribute codes & values using raw sql query? 2015-12-15T09:16:48.570

3 How to get attribute_id from “eav_attribute” table in Magento 2016-02-11T09:01:36.157

3 Report showing the days with the most orders per day 2016-06-14T14:01:15.047

3 Magento 2: How to get product name by sql query using product ID 2016-12-21T11:26:59.697

3 I would like to pull all attribute data from a specific category, using SQL or a PHP script 2017-02-23T20:20:08.190

3 How to save two entries in one table row in Magento 1.9? 2017-03-21T06:42:54.487

3 How to convert raw PHP Join Query into Magento Join Query 2017-06-23T12:09:27.030

3 how to append variable in LIKE in SQL Query 2017-08-18T06:09:36.310

2 How to Set Product attribute to 'Use Default' by SQL 2013-03-07T09:31:44.993

2 Subquery Using Magento's DB Functions 2013-07-01T19:47:42.597

2 Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) 2013-07-17T07:00:51.470

2 How can I write this sql query following the Magento Way? 2013-10-09T16:41:48.033

2 admin/catalog_category/index very slow, large catalog of 20,000 skus 2014-02-03T18:11:10.343

2 Get sales of products by week wise as week1,week2, week3, week4 2014-03-12T13:47:15.970

2 Which way do you reset magento orders? 2014-08-06T04:20:24.233

2 Export database through mysqldump, or Magento admin? 2014-08-18T20:26:24.087

2 Help with reindexing the 'category_product_attribute' index. (SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry) 2014-09-16T20:04:24.243

2 Checkout Error when confirming new order [MySQL server has gone away] 2014-10-13T16:52:40.867

2 Change order status with direct raw sql 2014-10-15T07:23:33.037

2 Remove old attribute code 2014-10-16T17:32:21.767

2 Execute direct SQL 2014-12-09T04:36:51.030

2 Error while fetch data from db 2014-12-18T20:18:43.577

2 Need sql query to get price by sku in magento 2015-01-01T09:44:56.630

2 how many custom attributes type in magento 2015-01-06T10:25:58.843

2 Help building an SQL query for products with custom options 2015-01-14T20:19:15.503

2 Export/Import Url Rewrite Rules 2015-02-19T18:51:08.807

2 Creating custom sql code to update qty of a certain attribute not found in csv file during import 2015-02-19T23:13:31.017

2 How do I run a SQL query to extract a specific product range? 2015-02-23T12:38:45.863

2 Product ID Conflicts - SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 2015-03-13T10:01:19.387

2 How to Delete data From eav database? 2015-03-25T11:19:16.157

2 collection condition filter = ((condition AND condition) OR (condition AND condition)) 2015-04-23T14:52:13.243

2 Magento Direct SQL New vs Existing Customers 2015-05-01T13:30:37.653

2 increasing magento efficiency by loading outside of looping strctures 2015-05-29T20:01:32.300

2 Get flat product table name 2015-06-18T11:20:02.237

2 Database Error: Integrity constraint violation: 1062 Duplicate entry 2015-07-07T14:43:59.903

2 Copy Reviews from website_id 1 to website_id 2 2015-07-07T16:12:39.980

2 SQLSTATE[42000]: Syntax error or access violation: 1064 When using Magento Search 2015-08-06T11:13:43.977