Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
28 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 ...
0
votes
2answers
34 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
0answers
28 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 ...
0
votes
0answers
26 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 $...
0
votes
1answer
52 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 ...
0
votes
2answers
87 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 '...
1
vote
1answer
89 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 ...
0
votes
1answer
86 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 ...
0
votes
1answer
48 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( ...
-1
votes
1answer
22 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....
0
votes
1answer
30 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 ...
1
vote
0answers
59 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 ...
1
vote
1answer
48 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 ...
1
vote
1answer
60 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
0
votes
1answer
16 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 ...
1
vote
1answer
19 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 ...
0
votes
2answers
47 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
0answers
30 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 ...
0
votes
1answer
70 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 ...
2
votes
1answer
79 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 ...
1
vote
1answer
75 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 ...
0
votes
1answer
50 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
1answer
117 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 ...
1
vote
1answer
190 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 ...
0
votes
1answer
297 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 ...
1
vote
0answers
55 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 ...
1
vote
1answer
198 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 ...
1
vote
0answers
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 ...
2
votes
1answer
128 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 ...
0
votes
1answer
195 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....
0
votes
2answers
120 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 ...
0
votes
1answer
51 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 ...
0
votes
1answer
76 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 $...
0
votes
1answer
171 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
1answer
115 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
vote
1answer
296 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 ...
0
votes
1answer
23 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
2answers
209 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' =>...
0
votes
1answer
55 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 ...
0
votes
1answer
101 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
2answers
70 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
2answers
115 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 ...
0
votes
2answers
87 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
1answer
29 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
1answer
83 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 ...
0
votes
1answer
42 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` ...
1
vote
1answer
31 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 ...
0
votes
1answer
194 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 ...
0
votes
2answers
316 views

How to access a custom table name that isn't prefixed with exp_

I'm developing an EE module that needs to access a non EE database table that isn't prefixed with 'exp_'. How would I go about doing this? In Codeigniter I can use set_dbprefix, but that doesn't ...
0
votes
2answers
30 views

Adding new functionality to Live site while keep members

I have a live(Production) site, in which new users are signing up every day. Meanwhile, I have a local version of this site on which I've built lots of new functionality. If I were to push the local ...

1
2 3 4 5