Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
4 votes
1 answer
306 views

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 ...
user avatar
  • 836
6 votes
2 answers
1k views

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 ...
user avatar
  • 5,407
4 votes
3 answers
4k views

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 ...
user avatar
4 votes
1 answer
731 views

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?
user avatar
  • 12.6k
7 votes
3 answers
466 views

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 ...
user avatar
  • 563
2 votes
2 answers
551 views

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 ...
user avatar
7 votes
2 answers
633 views

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? https://mariadb.org/
user avatar
  • 169
1 vote
2 answers
196 views

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 ...
user avatar
  • 173
1 vote
1 answer
91 views

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.
user avatar
1 vote
1 answer
94 views

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 ...
user avatar
1 vote
1 answer
173 views

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 ...
user avatar
0 votes
1 answer
105 views

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( ...
user avatar
  • 225