Questions tagged [database]
The database tag has no usage guidance.
215 questions
0
votes
1
answer
38
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
64
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
44
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
52
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
32
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
64
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
518
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
649
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
408
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
195
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
130
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
23
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
39
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
95
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
127
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
1
vote
1
answer
76
views
Database access from another server
What format is the database stored?
Can the database be accessed from a website on another server?
Thanks for your help
- 11
0
votes
1
answer
17
views
Settings in Admin get dropped, will save temporarily, hours later are reset/gone
I have a situation on my development site, where all of a sudden lately, some things I save in the admin, aren't "sticking" around.
Some of the settings that won't stay:
Template routes: I will set ...
- 167
1
vote
1
answer
20
views
Cannot access sql manager
I cannot access sql manager on a site which is running EE v 4.0.8
I've checked the file permissions and they look fine. This is the error message. Any suggestions of what to check next?
View file ...
- 325
0
votes
2
answers
57
views
Stash and database replication
We are running EE 2 and Stash, 2 DB's: 1 master, 1 slave. The master-slave relationship keeps breaking with the following error:
CRITICAL - Slave sql is not running. Last error: Could not execute
...
1
vote
0
answers
37
views
Possible to merge two databases?
We have a production and dev database. The dev database is typically only used to change core features, channel setup, add-ons, etc. Never content.
We’re in a situation where we need to pull some ...
- 800
0
votes
1
answer
92
views
How-to connect to secondary external DB in EE2
Im relatively experienced with PHP/HTML, however not so much with EE 2.4. Im working with a company using this set-up, so im on the learning curve at the moment. However, the first db 'expression' has ...
- 13
2
votes
1
answer
101
views
How to make EE ignore database table prefix when writing your own queries
I'm working on an ExpressionEngine 3.5.10 website. All my tables are prefixed with exp_
I've added 3 tables to my database to store some data relating to a custom written PHP ecommerce module. These ...
- 322
1
vote
1
answer
92
views
Has anyone set the database on a remote server while the controllers sit on local/hosted system
I host the MySQL server providing the database functions and the site itself on the same hosting platform (a semi-dedicated server).
I was wondering if I could improve expression engine performance ...
- 11
0
votes
1
answer
55
views
New EE3 installation and other SQL-base
Sorry for my bad English.
I have a website on EE1. I want EE3. There is a big problem with convert database (old PHP and MySQL on the server and can't converted via EE2, and if i update the PHP and ...
1
vote
1
answer
141
views
Preventing SQL Injections
In a EE plugin if I construct a sql statement based on passed in parameters and use a EE->db->query($sql) call does the query function prevent SQL Injections or do I need to change my code to use some ...
- 281
1
vote
1
answer
196
views
Generic error during install on DB config
I'm receiving the above error when attempting to install a new EE3 site. This is the first site we are attempting to stand up on a new WHM server running PHP7. Is there a mechanism to try and get a ...
- 121
0
votes
1
answer
345
views
Decrypt Password as string
We are using ExpressionEngine v2.10.1, we are going to import data from the database. We have created API that returns data as JOSN by using:
{exp:query sql="SELECT * FROM exp_member_data"}
But we ...
- 101
1
vote
0
answers
62
views
Database Error When Adding/Editing Pages With Structure
Whenever I attempt to add or edit a page in Structure, I get the following error:
A Database Error Occurred
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds ...
- 341
1
vote
1
answer
209
views
ExpressionEngine 3 module: create custom member field programmatically
I'm creating a custom member field programmatically. This works fine, except that I want the database column to be dynamic based on what's already in the database.
In my code below, the ...
- 125
1
vote
0
answers
56
views
Is EE able to handle this db/site ok?
It's quite a "general" question.
Our site has 60k posts.
Each post has 10-15 relations and almost 50 custom fields and several categories options. Mostly focused in one channel.
One category group ...
- 55
2
votes
1
answer
133
views
Database error 1054 after upgrade to ee 2.11.6
A Database Error Occurred
Error Number: 1054
Unknown column 'fingerprint' in 'field list'
SELECT member_id, admin_sess, fingerprint, sess_start, login_state, last_activity FROM (exp_sessions) WHERE ...
- 23
0
votes
1
answer
226
views
Table doesn't exist after upgrade
I upgraded from EE 2.9.2 to 2.11.5
Everything is working good, except I get this error when I view a News entry at domain.com/news/news-entry-title:
Error Number: 1146
Table 'db_name....
- 388
0
votes
2
answers
170
views
Export and import of Cartthrob/EE data?
I need to export some CT order/customer data from a live site to a staging site (updated EE and add-ons), is there a reliable way to do this?
Live site running EE v2.9.3 and CT v2.70
Staging site ...
- 411
0
votes
1
answer
52
views
Where does EE2 get the latest member_id from?
I've deleted a bunch of members (on purpose), so that I only have member_id '1' left. Now if I create a new member... The newest member_id is '176' and then increments as I add more… If the members ...
- 254
0
votes
1
answer
89
views
Passing a GET variable back in a query while using mysqli_real_escape_string()
I'm trying to take a variable that's passed in a query string (GET) and then use that variable to do a SELECT based on it...
// Assign query string to a variable while sanitizing it against XSS
$...
- 1,079
0
votes
1
answer
223
views
How to proceed after upgrade error ee2 to 3?
I am upgrading from Expression Engine 2 to 3. The upgrade was stopped and the following is the message I received:
Error While Installing 3.4.1 Stopped
Oops, there was an error
ExpressionEngine ...
0
votes
1
answer
130
views
Cannot convert exp_channel_data to INNODB
I’m currently coming against an issue with a large EE2 site that I’ve recently moved to EC2/RDS. To take advantage of the RDS snapshots and not risk data-integrity issues (as per Amazon Recommendation)...
- 1,986
1
vote
1
answer
376
views
EE3 --> Multiple Concurrent Database Connections via config files
we converted to 3.3.3 from 2.5.5.
a concurrent connection to a secondary database (set up using Focus Lab Master Config in both versions) works in 2.5.5 but i get warnings in 3.3.3 with message ...
- 11
0
votes
1
answer
25
views
Load data from "File System" rather than "Database"? Modify template file is not working
I am migrating an EE application to a new server. However, it shows the previous version. And if I modify the template file, it's not showing on the site.
Someone said it's because it's loaded from ...
0
votes
2
answers
215
views
EE3 Multiple database settings without core 'hack'
SO I am trying to build out a master config file to use with deployment similar to that in EE2 for EE3. In the include, I have the following:
$config['database'] = array (
'expressionengine' =>...
- 1,610
0
votes
1
answer
60
views
Database rollback
Working on a site with a staging environment. a quick question, is there a way to roll back a database change to previous import for testing purposes.
eg. i test something on local which alters the ...
- 75
0
votes
1
answer
119
views
Optimising structure of exp_channel_data table
I have a site with around 800 columns on exp_channel_data table. I would like to know if I can go ahead and optimise the structure of this table by doing the following
1) changing field from text to ...
0
votes
2
answers
74
views
Expression Engine Database Load
We are running a high traffic site in expression engine 2.10.1.This has a page-views of 150k daily.The server is load balanced and is running fine.
Recently we have strange issue of some pages being ...
2
votes
2
answers
120
views
best setup for a 1M entries EE site?
I have a EE site that has 62k entries. It's a directory site using open data sets. We are expanding to more countries and we expect at least 500k entries to be added in the next year and 400k plus on ...
- 55
0
votes
2
answers
97
views
Entries can't be updated - 404
I'm having a problem with EE; when updating or creating an entry I get redirected to the 404 page. I've researched a lot because this is getting annoying. I've tried checking the .htaccess as a common ...
0
votes
1
answer
32
views
SuperSearch Module Install Creates 1044 Error
I've just attempted to install SuperSearch 2.2.3 on EE 2.9.2 and receive a a database 1044 error:
Access denied for user 'db######'@'%' to database 'db202322_##########'
It then goes on to list the ...
0
votes
1
answer
92
views
Multi-Site Manager Limits
I'm about to rollout a product that could potentially need hundreds of connected EE sites. What is the limits to MSM? I can easily see a few hundred sites but it could be as big as a few thousand.
I ...
- 1
0
votes
1
answer
44
views
Cartthrob and cart update queries
I'm really struggling to reduce the number of database queries on a Cartthrob install.
As I look at the EE output profiler, I see that most of the queries are
UPDATE `exp_cartthrob_cart` SET `cart` ...
- 660
1
vote
1
answer
35
views
Use Expresso tags to show stock sold on front end
A specific user group on my website has the ability to create products on my website. This is all done using Channel Form tags. Unregistered guests may purchase these products.
For the user group ...
- 201
0
votes
1
answer
205
views
Snippet Changes Not Being Saved
I'm working on a site in ExpressionEngine which has been causing all sorts of problems, and we thought we had solved most of them, but now have run into a completely new issue which I can't seem to ...
- 5