Questions tagged [database]
The database tag has no summary.
215 questions
0
votes
1
answer
56
views
syntax error or access violation: 1118 row size too large
We're getting this error when trying to create new fields on a large site. One of the suggested fixes is to set innodb strict mode to off.
The hosting company say they can't do this for us and we don'...
- 493
0
votes
1
answer
108
views
What's the best, and fastest way, to remove large amounts of data from the database?
We need to remove large amounts of data (members, entries, etc) from the DB. What is the safest way to go about doing this? We're hoping we could run a delete query of sorts? Or that there is an ...
- 167
0
votes
0
answers
61
views
Too many database queries
My site no longer loads and I can no longer access the control panel. After some investigation, it seems there are requests that are taking too long to load or are stuck. When I try to log into ...
- 741
0
votes
2
answers
146
views
Define Database Error (Upgrading 2.10.1 to 3)
I apologize for a question that I know has been asked and answered. However, I don't have enough reputation to reply to the answer, just to provide another "answer", which I don't have. ...
0
votes
0
answers
47
views
Is there a way to disable CE Cache DB references?
We have a heavily trafficked site, where we keep running to bottleneck issues with cache trying to clear and that bogging things down.
The issue is the DATABASE is being taxed by CE Cache maintaining ...
- 167
0
votes
0
answers
98
views
How to use {exp:query} results in {exp:channel} parameter?
Since i can not retrieve {parents} from grid field, i am trying to find simplest workaround.
This works great:
{exp:channel:entries channel='channel-one' entry_id='
<?php
$...
- 11
0
votes
2
answers
558
views
How to use a remote database inside docker containers
I'm attempting to setup a docker container to run expression engine. Using best practices for Docker, it is recommended to separate the db from the web host and php containers. However, it seems there ...
- 21
0
votes
2
answers
725
views
Database connection issues upgrading to EE5
I recently upgrade from EE2 to EE5 locally on my laptop before moving to a remote location. When moving to a remote location, I get database errors.
SQLSTATE[HY000] [1045] Access denied for user '...
- 53
1
vote
1
answer
468
views
Where is the base_url in the database?
EE 5.3.0
I have a website that I built using a production domain (let's call it production.com) to replace an old site using the desired domain (let's call it domain.com).
I am concerned with the ...
- 317
0
votes
1
answer
233
views
Channel Entry Model how do I get file url in grid field?
This question follows this one
$entry = ee('Model')->get('ChannelEntry')
->filter('entry_id', $entry_id)
->first();
$entry->$field_id_5; // NULL
$field_id_5 is a grid field that stores ...
- 225
0
votes
1
answer
170
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
-1
votes
1
answer
62
views
Creating user datasets when logged in
Did any of you encounter a situation where the solution is as follows:
A logged in user able to do the following
To create datasets on the fly. For e.g. 2019 - June - Shopping list - Fruits - [Apples....
- 98
0
votes
1
answer
65
views
InnoDB or MyISAM - What's the "correct" database storage engine for EE4/EE5?
As I am looking into my database via phpMyAdmin I see that most of the tables are MyISAM, some are InnoDB (e.g. from plugins). As far as I read in the web InnoDB is known as "better", but I am no ...
- 470
1
vote
0
answers
125
views
Transfered EE site to cPanel and keep getting errors
Had this site on an ispManager server. Moved it over to cPanel and kept getting errors. Now down to this. Not sure why I can't get the site to pull up and just how to fix these errors.
A PHP Error ...
- 13
1
vote
1
answer
166
views
Database Insert is encoding data
So I have a custom plugin that inserts data from a csv. I build up the array of data and then issue the insert command.
Right before the insert I am dumping my array so I can see the values which ...
- 31