Tag: mysql

10 Field with huge amount of content 2012-11-24T13:55:17.357

7 What is the MySQL function for exp_members password column? 2013-01-06T02:10:40.773

5 Computing word, image, video and audio file counts in a scalable way? 2012-11-28T20:20:50.730

5 ExpressionEngine 1 Query Module and Ordering SQL UNION 2012-12-10T13:16:16.020

5 How to create a form and insert form data to database in ExpressionEngine? 2013-01-11T06:07:43.843

5 How to prevent CartThrob from making hundreds of SQL queries and running extremely slow? 2013-12-09T22:18:12.383

4 Reformat external Date-Format to unix-timestamp / ee-compatible format 2012-11-22T14:00:30.167

4 How to populate Relationships 2013-01-04T12:18:07.030

4 EE - move channel entries from one channel to another ( they share the same channel fields ) 2013-01-06T08:51:31.380

4 Long open/save for entries with 10-column Matrix fields 2013-01-10T17:44:13.583

4 Changing Member ID #s - possible? 2013-01-16T18:32:03.757

4 Assets errors with MySQL 5.7.X 2016-06-14T07:06:16.050

3 How to Batch Update Channel Preferences? 2012-12-04T17:57:20.637

3 How can I close comments on a mass scale? 2013-01-29T17:37:01.227

3 SQL Query Help Needed 2013-02-12T17:33:40.040

3 Expresso Store - Change order_id start point 2013-02-18T16:17:25.980

3 Entire site down - Seemingly random (and fatal) ExpressionEngine error 2013-09-12T14:32:40.770

3 Assign parent category to entries with child categories (EE1) 2013-10-24T17:11:25.160

3 Add-on - Building Queries w/ Field Names vs Field ID's 2014-02-21T16:23:20.137

3 Run plugin without affecting loading time (external) 2015-01-27T16:26:52.520

2 What is the maximum number of custom fields you can use in an installation? 2012-11-27T07:05:10.410

2 Correct syntax for inserting a channel entry with a playa field? 2013-01-29T00:15:01.233

2 How do I track down a bug with a custom field? 2013-01-29T16:57:12.353

2 Executing multiple SQL statements with Database class 2013-03-01T15:18:54.063

2 Assets Upgrade "duplicate" error 2013-08-29T08:11:31.020

2 Move categories from one group to another 2013-12-04T19:21:24.517

2 Very slow performance on production, not on local dev, doesn't seem to be the database 2013-12-13T22:28:43.807

2 Get all entries where expiration date is within last 12 months 2014-01-31T21:30:10.690

2 ExpressionEngine source control via git 2014-03-11T00:06:42.947

2 SQL Query to get entries with their categories 2014-09-23T09:56:39.670

1 Is this channel data query possible? 2013-02-01T16:37:38.993

1 Transferring data from one field to another 2013-02-02T14:13:39.363

1 MySQL channel table problem 2013-03-05T19:23:07.960

1 MySQL connection on a non-standard port 2013-03-17T14:39:47.877

1 performance issues - is it the database? 2013-03-21T17:03:51.373

1 Copy Data from exp_channel_titles Based on entry_id 2013-04-11T22:44:18.013

1 Help repairing ObjectiveHTML Entries addon 2013-04-23T00:44:09.673

1 MySQL: Update Rows Based on Specific Set of Entry IDs 2013-04-30T22:38:04.920

1 WHERE and JOIN in EE Add-on Dev 2013-05-12T19:06:33.250

1 Message: Undefined property: stdClass 2013-05-12T19:09:36.030

1 MySQL - Change Entry Category ID? 2013-05-20T22:31:41.177

1 Cannot create channel field 2013-05-28T14:12:04.083

1 Error 122 from Storage Engine 2013-08-01T12:10:37.337

1 SQL SELECT using custom field name (not ID) in WHERE 2013-08-05T03:47:02.050

1 changing the assigned template to Structure listing 2013-08-05T09:15:05.623

1 SQL query to count question marks in comment field? 2013-08-28T11:28:45.677

1 Errors when importing a MySQL database 2013-10-29T20:04:01.517

1 One alert when importing a production database 2013-10-30T20:55:45.490

1 Help with SQL to Export Channel entry status 2013-10-30T21:26:41.813

1 Optimizing performance when sorting through hundreds of entries 2013-11-16T18:45:38.090

1 ExpressionEngine with Percona Cluster? 2013-12-01T15:08:51.833

1 table is marked as crashed and should be repaired 2013-12-30T18:39:20.053

1 All channel entries have had their statuses changed to 'closed' 2014-01-17T10:12:36.340

1 Solspace Freeform not updating, mySQL error? 2014-02-04T20:38:58.540

1 Problem importing database - import hangs on exp_stash table 2014-04-05T02:19:26.310

1 Expresso Checkout conditional (use hook?) 2014-04-10T16:42:21.180

1 How does exp_channel_data table allocate it's primary key? 2014-07-17T09:53:20.100

1 Highest version of mySQL and PHP for EE 1.7.3 2014-08-05T19:12:49.487

1 mySQL script to update non-unique URL titles 2014-11-02T21:36:53.703

1 profile:edit on EE 2.7.2 and mySQL 5.6 can't install 2014-11-25T15:28:09.520

1 Quick and simple way to determine which templates are used on an EE site and where 2015-01-15T00:34:28.263

1 Slow queries from ExpressionEngine 2015-01-20T19:57:06.610

1 Is it safe to change the MySQL storage engine on a live site? 2015-06-22T14:29:15.643

1 Use Expresso tags to show stock sold on front end 2015-11-10T21:49:20.133

1 Can I preserve my mediumtext fields when upgrading from 2 to 3? 2016-10-30T14:36:16.337

1 Has anyone set the database on a remote server while the controllers sit on local/hosted system 2017-06-27T19:51:14.390

1 Is ExpressionEngine compatible with MariaDB? 2017-07-06T11:51:34.207

1 General error when trying to access templates 2018-01-04T16:16:18.937

1 MySQL ERROR: Error Number: 1364 Description: Field 'whatever' doesn't have a default value 2018-04-10T10:14:17.553

0 EE 1, adding another server 2013-03-06T01:33:40.087

0 Error Number: 1364 on insert to exp_member_data 2013-04-11T19:32:57.460

0 Logging custom data to the DB 2013-06-16T19:06:13.283

0 Solspace Calendar and Importer 2013-09-09T15:46:26.723

0 Weird text-formatting after upgrade to 2.7.0 2013-09-13T13:32:31.393

0 Store Data in Channel Tag Variable 2013-10-14T16:29:02.160

0 Error Number: 1062 Duplicate entry '465628' for key 'PRIMARY' 2013-11-20T13:17:44.660

0 Categories of a category_group won’t show 2014-04-24T06:33:34.463

0 Getting To Know The EE Database Structure 2014-06-03T14:09:55.003

0 Displaying Category Name and Channel Entry Data with Query Module 2014-06-30T22:56:31.293

0 Trying to login via database 2014-07-10T16:53:53.217

0 MySQL strict mode: disable on a session basis? 2014-08-06T22:27:16.373

0 What's wrong with this SQL query? 2014-08-22T13:50:38.867

0 MySQL query to output variables grouped by entry status 2014-09-03T00:15:00.413

0 MySQL Script to identify old accounts 2014-09-24T17:05:42.817

0 Super Search Query Overloads DB and Brings Down Websites 2014-11-12T22:34:44.417

0 Error Number: 1153, Exrpression Engine 2.7.3 2014-11-13T02:54:58.250

0 Should I run the EE Install & Update Wizard after updating mySQL 2014-12-01T19:51:39.940

0 ExpressionEngine 2.7.3 How do I directly execute a query against the database? 2014-12-30T17:39:12.970

0 exp_cartthrob_cart is marked as crashed and should be repaired 2015-01-05T11:36:12.380

0 Convert a row's site_pages cell (inside exp_sites) into a key-value array 2015-03-03T05:34:15.843

0 SQL query issue while trying to count the entry (row) 2015-04-29T11:46:26.960

0 Reassign uncategorised entries 2015-05-14T11:55:28.183

0 MYSQL Error Importing Database 2015-05-28T22:44:41.327

0 ExpressionEngine versions and MYSQL support 2015-06-22T08:42:42.210

0 ExpressionEngine v.s. Database.Mangement System 2015-06-25T01:17:54.310

0 How can I restore a revision through the MySQL DB? 2015-09-10T20:43:45.220

0 A Database Error Occurred Error Number: 1064 when Trying to delete an entry.. 2015-10-27T13:41:52.200

0 Error importing EXP_MEMBERS 2015-11-03T19:17:36.407

0 Query works in Database Query Form but not in exp:query 2015-12-04T22:27:27.690