Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
4 votes
1 answer

Migrating/duplicating Content/Members from a Production site to Development

(I don't feel this is a duplicate of "Migrating between Development, Staging and Production for a pre-existing ExpressionEngine site" as I'm hoping it's much simpler/specific. Maybe it is a duplicate ...
  • 836
6 votes
2 answers

DB Error on Upgrade from 2.5.3 to 2.5.5

I've just run through the upgrade process from EE 2.5.3 to 2.5.5 but when attempting to visit the control panel the following error is returned: A Database Error Occurred Error Number: 1054 ...
  • 5,407
7 votes
2 answers

Compatibility / Performance Gains from using MariaDB?

My hosting company is now offering MariaDB as an alternative to MySQL. Does anybody know if EE is compatible with MariaDB and if it offers any performance benefits?
  • 169
7 votes
3 answers

Database Queries in Output Profiler Won't Display

With template debugging enabled, clicking the "show" link to display the database queries isn't working. I suspect this is related to the fact that on all pages of this site there are 7 chunks of ...
  • 563
4 votes
1 answer

How do I decode columns in the exp_sites table?

I need to look at the contents of the site_system_preferences column in the exp_sites table. How do I decode this data?
  • 12.6k
4 votes
3 answers

Move ExpressionEngine from development to live (same server)

I'm 95% of the way through a project just now and soon I am going to have to move EE from the 'development' folder to the 'live' folder. My questions before I do this are: Can I just copy all the EE ...
2 votes
2 answers

Automatically removing old entries

I have a channel which is growing large through automatic daily imports. Is there any way to automatically remove (prune) entries older than X days? I've looked through the extension space without ...
1 vote
1 answer

Is it possible to use ExpressionEngine with an Oracle database?

I don't want to be forced to use Drupal. I would appreciate it if someone could shed some light.
1 vote
2 answers

Managing database for single site across multiple servers?

Does anyone have any advice on how to deal with separate databases (local, staging, live) for the same EE site on different servers? The client changes things on live, but I obviously do any site ...
  • 173
1 vote
1 answer

Database errors when deleting channel fields and second site with Multisite Manager

I'm using ExpressionEngine 2.5.2. I recently added a second site using Multisite Manager on my local environment, staging environment, and production environment. The installation is complete and I ...
1 vote
1 answer

ExpressionEngine with Percona Cluster?

I've tried using Percona Cluster as a drop-in replacement for MySQL. However when templates are saved, each cluster node is updated with a different value for the primary key column template_id in ...
0 votes
1 answer

Help with ChannelEntry Model Service to get/set data directly in the database

To retrieve data from a specific custom_field in a channel entry I used to do the following: $data = ee()->db->select('field_id_2') ->from('exp_channel_data') ->where(array( ...
  • 225