The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
5 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
26 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
15 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
17 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
0answers
17 views

Update database from the front end?

Is it possible with a native, third party or even the expresso store module itself to update a Database row from the front end? We are using Expresso Store for internal orders, and want to be able to ...
0
votes
1answer
32 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
36 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
81 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
20 views

entries cant be updated 404

Im having a problem with ee, when updating or creating an entry i get redirected to the 404 page, ive researched a lot because this is getting annoying, I've tried checking the .htaccess as a common ...
0
votes
0answers
27 views

set default database character set to utf-8

Am building a multi language website. Initially arabic entries are inserted into db as question marks. On noticing that db character set is latin1_swedish_ci, I altered that field collation to ...
0
votes
1answer
17 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
46 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
21 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
22 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
38 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
70 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
27 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 ...
0
votes
0answers
16 views

Delete Structure entries older than date ideally via an automated cron job

I am working on an EE install that makes use of Structure to mange page entries. The site is used by our marketing department to create temporary marketing pages (1-18 months perhaps). The problem is ...
1
vote
2answers
37 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
0answers
28 views

Relationship field issue

So I've got this relationship field that links speakers to a certain event. This could be 2, 3 or whatever number of speakers. An example: I add 6 of them to my event and save them. I visit the page ...
0
votes
1answer
24 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
48 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
42 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
93 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
67 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
35 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
96 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 ...
0
votes
1answer
149 views

Switching default database engine to InnoDB

We recently altered our EE tables to use InnoDB as the database engine instead of MyISAM. All is good. INNODB is also set as the default engine in MySQL's preferences. I just noticed that when ...
1
vote
0answers
38 views

Calendar entries not saving event dates

I have a channel form that users can enter their own calendar events into from behind a login. Randomly, some of the event dates do not get entered into the database. Looking at the tables, it appears ...
1
vote
1answer
119 views

Is it possible to have multiple database connections for ExpressionEngine?

When setting up the database settings of a project I know that there is the default active group "expressionengine" found in the database.php file and you can add more than one group, I was just ...
0
votes
1answer
44 views

Duplicate order numbers in Cart Throb

We've got quite high traffic cart throb site which occasionally gets duplicate order numbers. The most recent one was when 2 orders were placed at exactly the same time (to the second). Both orders ...
1
vote
3answers
105 views

Can you tell which version EE is just from the database?

I have a site that had all its files erased and there are no backups, but I still have the database. Is it possible to determine which specific version of EE it is, just by looking at the database? (...
0
votes
1answer
25 views

Convert a row's site_pages cell (inside exp_sites) into a key-value array

For the purpose of using PHP to automate the creation of custom URLs that will be placed in the Pages Module, I'm first retrieving and decoding the whole block of encoded, serialized data in the ...
0
votes
0answers
32 views

Adding 10+ Sites to MSM - Does this workaround sound crazy?

Here's the situation. I tried to add a 10th site to my MSM and I got an SQL error that effectively says, you can't add another column to the exp_weblog_data table. Description: Can't create table '...
1
vote
1answer
33 views

Variables overwritten by database

Question, then background behind the question: We use Low Variables. When would the database overwrite our variable files on the server instead of the files overwriting what's in the database? ...
0
votes
1answer
54 views

How can I import a Filemaker database into EE?

I have a client who has their organization's membership info in a Filemaker database. Can anyone provide guidance as to how I can bring that database into EE? Ideally, I'd like to move the membership ...
4
votes
1answer
83 views

Workflows for developing with a team regarding the database [duplicate]

Short story: What are some of workflows regarding the database teams are using to develop locally and then push to a central dev site. When each dev is creating their own templates and variables (not ...
1
vote
2answers
72 views

unable to update the site_pages field

I'm having an issue that seems to originate in the site_pages field in the exp_sites table of my database. somehow an entry title made it's way into that array. So, i copied the contents of the field, ...
3
votes
2answers
109 views

Run plugin without affecting loading time (external)

I have a plugin which doesn't actually integrate with the website. It's purpose is to grab a column of the channel entries table and manipulate it every 24 hours. The plugin will only run each time a ...
0
votes
0answers
65 views

exp_cartthrob_cart is marked as crashed and should be repaired

On two separate websites in the past few months (one with EE 2.8.1 and CartThrob 2.6, and another with EE 2.5.5 and CartThrob 2.3.6), we've had an EE website break due to a corrupted CartThrob table (...
1
vote
0answers
29 views

profile:edit on EE 2.7.2 and mySQL 5.6 can't install

Tried to contact mightybigrobot a few times but impossible to get a hold after buying their plugin profile:edit. It trows an error when I'm tryign to install the default templates. EE 2.7.2 , mySQL ...
0
votes
1answer
20 views

All new items have same ID# 0

I just updated a site from 2.6 to 2.9.2. It's been very buggy since and nothing seems to work. I think I found the problem but I don't know where to fix. All new entries have the same ID of 0 ...
0
votes
0answers
119 views

Large Database Error - Upgrading EE 1.x to 2.9.2

I’m trying to upgrade an installation of EE 1.6.8 to 2.9.2 and have come unstuck on the “Database too large” error in the upgrade wizard. Specifically: The following error occurred: An unexpected ...
1
vote
1answer
74 views

Relationship field lookup in an EE plugin?

I'm in the unfortunate position of needing to fix a third-party plugin that was created under contract; the original developers are not available to fix it. From within the plugin, I'll need to look ...
0
votes
1answer
26 views

How to filter by status in a Plugin?

In a plugin, I have this as part of the SQL's WHERE clause: $where_sql = "`store_table`.`channel_id` = {$this->channel_ids->stores} AND `regions`.{$this->field_column_names-&...
0
votes
1answer
23 views

Relate EE Entries with Location (Region/City/Place)

What is best way to relate EE Entries with location (Region/City/Place) example 1. Entry of Simba National Park, 2. Then i choose park category (Game Park, Beach Park, Cultural Park, Mountain Park) ...
1
vote
1answer
43 views

Edit History For A Channel Entry?

Is there a way to see what the edit history is of channel entry? I'm happy to look into the database, if needed.
1
vote
1answer
15 views

Date When A Channel Field Was Added

Looking at the database, is there anyway to find out when a particular Channel field was added to EE?
1
vote
1answer
69 views

Where are relationship field data stored?

In the EE database, I see that exp_channel_fields.field_id = 4 refers to a relationship in my Channel-A (channel_id = 1). I assume that channel data for that field should be stored in my ...
0
votes
0answers
19 views

I need help tagging articles in a way that doesn't slow down the database

I have an article-based site that runs slowly, and I would like to change that. First, each article has 3 options for tags in the backend (we use this add-on: http://www.solspace.com/software/detail/...