Questions tagged [database]
The database tag has no usage guidance.
12
questions
4
votes
1
answer
315
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 ...
- 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
...
- 5,407
7
votes
2
answers
638
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/
- 169
7
votes
3
answers
467
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 ...
- 563
4
votes
1
answer
737
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?
- 12.6k
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 ...
- 127
2
votes
2
answers
558
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 ...
- 216
1
vote
1
answer
92
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.
- 588
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 ...
- 173
1
vote
1
answer
95
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 ...
- 501
1
vote
1
answer
174
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 ...
- 151
0
votes
1
answer
121
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(
...
- 225