Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

The tag has no usage guidance.

0
votes
1answer
10 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 ...
0
votes
0answers
38 views

How to add CURRENT_TIMESTAMP with dbforge as a default 'datetime'

I need to use 'DEFAULT_TIMESTAMP' as a default value in a table I'm creating in a module, but I keep getting a notice and exception. Notice: Use of undefined constant CURRENT_TIMESTAMP Exception: ...
0
votes
0answers
58 views

Exception Caught: No such property: 'cp' on EllisLab\ExpressionEngine\Legacy\Facade

I switched from one database to another and a handful of the pages on this website now come back with this exception. Thank you. http://dev-prosolutions.net.s215353.gridserver.com/about/our_clients ...
1
vote
1answer
14 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
0answers
32 views

What might cause my freshly-upgraded EE4 site to be missing the status_id column?

This site is extremely bare-bones; 1 channel, half a dozen entries, simple fields, no add-ons at all. It was created in EE3 and upgraded to EE4. Immediately prior to the upgrade it worked fine. ...
0
votes
2answers
40 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
23 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
0answers
11 views

Return Query Results From Ext Database

Using the following: http://360adaptive.com/connecting-to-multiple-databases-in-expressionengine/ I created a second database, and a template (php on>input), but when trying to establish and echo ...
0
votes
1answer
28 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
32 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
39 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
36 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
84 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
120 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
166 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 ...
2
votes
0answers
39 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 ...
2
votes
1answer
107 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
53 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
82 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
121 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
94 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
35 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
0answers
27 views

Connect a an ee2 db to new EE3 db

Is it possible to connect an ee2 website DB to a new website I have on ee3? I would love to be able to pull/utilise some data on the ee2 website on the new ee3 one, I have no idea how to though.
0
votes
1answer
50 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
80 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
70 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
148 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
19 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
152 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
0answers
21 views

Database migration causing entry_id mismatch: URL, hardcode and display all different

I have an EE site with Expresso Store installed and working for several of the channels. However, I pulled information from an archaic eCommerce store for this client, pulled their products from the ...
0
votes
1answer
36 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
69 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
61 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 ...
3
votes
2answers
102 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
56 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
25 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
70 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
30 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
28 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
150 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
223 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
vote
2answers
54 views

Playa related entries count

We are running reports and need a query - we're using playa and I want to get the total number of child_entries where channel_id = 16 and where the 'parent_field_id' = 68. My current query is: ...
0
votes
1answer
50 views

Total entry views for all entries in a given category

We have a basic query, which get us; cat_id, parent_id, cat_name and the total entry_count which is then displayed in the form of a report... the current query is: SELECT c.cat_id, c.parent_id, c....
0
votes
1answer
154 views

Custom Field Type - Data is not being saved

I'm creating a custom field type. But the data isn't being saved to the database. There are several values that are being combined into a string, divided by a pipe character. I've checked the save() ...
0
votes
1answer
57 views

Getting images out of the system

I updated ee to v2.10.1 I have an image with umlauts in the filename which I'm unable to remove. The .jpg file is not present, but still in the filemanager Synchronizing the upload folder doesn't ...
0
votes
2answers
162 views

EE DB Class question

I've got this code: $res = $this->EE->db->where(array('EventCode' =>$r["eventcode"])) ->limit(1) ->get('exp_course_events'); $course_date = $res->row('FormalDate'); ...
0
votes
1answer
97 views

ExpressionEngine v.s. Database.Mangement System

I'm really confused! I've been trying non stop to connect to an Oracle database through ExpressionEngine throughout the last two weeks. I've finally given up when I saw a previous post(Is it possible ...
0
votes
1answer
62 views

Set Entry ID & Member ID's higher

Hoping this is possible. I want to set my entry_id and member_id numbers higher. Meaning when the next entry is entered or a member joins it goes to the new higher # I set. Right now my entry ID is ...
1
vote
1answer
174 views

Pulling data from external database

Need to pull member information and custom fields from an external SQL (not mySQL) database into EE. The database is too big to export to csv (9gb) and import using Datagrab/Importer. Would JSON be ...