The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
0answers
19 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
0answers
25 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
22 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
52 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
9 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
19 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 ...
0
votes
1answer
22 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
30 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
59 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
46 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, ...
0
votes
0answers
8 views

Change CartThrob price modifier option label character length?

When using the CT Price Modifiers field type, is there a way to increase the character limit for the option label. For example the option might be 'Red' or 'Blue', but can it be made to allow for ...
3
votes
2answers
96 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
33 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 ...
0
votes
0answers
13 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
79 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 ...
0
votes
1answer
55 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
21 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 ...
0
votes
1answer
17 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) ...
0
votes
1answer
21 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
14 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
27 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
18 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: ...
2
votes
1answer
71 views

ExpressionEngine database redundency

I've been looking to see if it was possible to use ExpressionEngine with an Percona XtraDB cluster, I have yet to find a verdict, the closest thing was the post below but there does not seem to be ...
3
votes
2answers
93 views

$db['expressionengine']['cachedir'] - what does it do?

I have searched Ellis Labs docs, but I can't find any details about the $db['expressionengine']['cachedir'] setting in the database.php config file. I recently 'fixed' this value (it was pointing to ...
3
votes
3answers
65 views

Keeping Expression Engine DB's In Sync

We have a very large EE installtion for one of our clients. Our server set up / workflow is Local >> Staging >> LIve We need to carry out some work for the client. So we pull the database and files ...
0
votes
0answers
9 views

Database Error when editing channel Group Assignments

When I make a channel and try to "Edit Group Preferences" I get a white page with a Database error. A Database Error Occurred Error Number: 1054 Unknown column '0' in 'where clause' ...
0
votes
0answers
78 views

Catch database insert error with mysql strict mode

I am trying to insert some data in to a MySQL table. The MySQL server is running with "STRICT_ALL_TABLES" mode. This means a NULL insert into a column flagged as NOT NULL produces an error instead of ...
0
votes
3answers
22 views

Setting up redirects

I am currently working on a big project for a client where we are importing all of their content into ExpressionEngine. I written a script to do this which is fine, however, all of the URLS are going ...
1
vote
0answers
20 views

Liquibase A Good Replacement for Krasimir Method of Database Syncing?

Like everyone, a major headache for us has been keeping databases between development and production servers in sync. We had implemented Krasimir's method to great success. ...
0
votes
2answers
49 views

What's wrong with this SQL query?

I have an SQL query which I'm adding to a small search plugin, however when I run the SQL in MySQL it works and results are found, however no rows are being returned when running the code in the ...
0
votes
0answers
20 views

Change EE Member Group on Action

I'm working on a site wherein we want users that are in the Members group transferred to another group, after making a purchase. Which group they are moved into depends upon the purchase they make. A ...
0
votes
1answer
38 views

How To Manipulate Database In Custom Expresso Store Payment Gateway

Is it possible to use EE-standard database queries in a custom payment gateway written using Omnipay format to manipulate data in the database? I.E. use $query = ee()->db->select('title, ...
0
votes
1answer
53 views

How can I retrieve the site name from a channel entry as a query?

I have a plugin that I am editing at the moment and I am looking to do a query that takes the site_id from a channel(not a channel entry) and then grabs the id and passes that through a function that ...
1
vote
1answer
29 views

How to clear member accounts with no entries after 6 months

I had asked a similar question a while back: How to delete all member accounts with no channel entries Need a slightly different twist. I need to remove member accounts that have authored no channel ...
0
votes
0answers
68 views

DataGrab Import DB Error (Error Number: 1118 Row size too large)

ExpressionEngine 2.8.1 DataGrab 1.8.0 Matrix 2.6 So I have a seemingly small (but maybe large) import using DataGrab to text input, text area, and matrix field types. XML Example: ...
0
votes
0answers
21 views

(Last) Edit Date malformatted

This problem surfaced a couple of weeks ago and I cannot really tie it to an event (eg. new or updated Module): The "last edit date" of Channel Entries will get malformed if a sync to an external ...
0
votes
0answers
27 views

Blank Screen After Migration to New Server

I have just migrated my site to the live server and I have a blank screen for both the site and the control panel. I have added the dbtest.php file to my root and there is no error. I have turned on ...
3
votes
3answers
598 views

Upgrade error: Unknown column ‘protect_javascript’ in ‘field list’

I’m attempting to upgrade from 2.1.3 to 2.9 (I realize this should have been done before now; just took over this site recently). The upgrade fails at 2.5.5 with the following error: Error Number: ...
0
votes
1answer
27 views

How does exp_channel_data table allocate it's primary key?

I am working on a site with EE where the client is having some of the data pushed into to the MySQL database from a external FilemakerPro database. I'm working with an external company who handle the ...
1
vote
2answers
129 views

is it healthy to built a web services or a web app using EE?

we are growing company and we support and use EE for more than 4 years and continues, because we believe in it, and it is our choice ever. Any ways, I was in interesting discussion with a developer ...
1
vote
1answer
57 views

MSM Limitations

We have a totally 20 Websites. Right Now, We are running 5 websites all in MSM under single database. our requirements is member can access all websites in any one of web site login. All are portal ...
1
vote
1answer
102 views

Database corruption due to InnoDB?

We had some weird situation last night where a EE site we manage fell over of it's own accord and is this morning reporting SQL errors: Error Number: 1286 Unknown storage engine 'InnoDB' Closer ...
0
votes
2answers
74 views

EE Version Number Error on version 2.4

I downloaded a current copy of my production database into my development environment. Both the production and development environments are EE v2.4.0. When I logged on to the control panel I received ...
1
vote
1answer
45 views

Different values of checkbox for different members?

I'm trying to make a 'learning' site, something similar to Codecademy but for a small company. The setup at the moment is that I have a Training channel, with description and courses channel fields. ...
1
vote
1answer
45 views

Is it possible to use ExpressionEngine with an Oracle database?

I don't want to be forced to use Drupal. I would appreciate it if someone could shed some light.
0
votes
1answer
120 views

Transfer EE site to GoDaddy

First off, I need to start with the fact that I cannot STAND GoDaddy... However, I had an old hosted account from 2002 on there and decided to use it as a dev playground to try some stuff out. I had a ...
1
vote
1answer
19 views

Expresso Store changed column name in database

We've built a custom report-system for a client, fetching data from the "exp_store_orders"-table and displaying them to admins. Yesterday I updated the site to EE 2.8.1 and Store 2.3.1. After ironing ...
2
votes
3answers
60 views

New to EE - looking for some insight

new to EE (version 2.6.1) although I have used a handful of CMS's like WP, Joomla and Teamsite. I was tasked today with something I could use help with. I need to create a submission form, that will ...
1
vote
1answer
37 views

Disabling Cartthrob via database - How to?

I have large scale website with cart throb added version 2.00xx. I have updated the EE from 2.1.3 to the latest 2.8.1 and I've got a lot of errors, but at least I had cp available. Under extensions ...