The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
7 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
11 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
35 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
22 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
13 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
7 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
16 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
12 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
17 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
14 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: ...
1
vote
0answers
36 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
48 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
5 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
38 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
14 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 ...
0
votes
0answers
11 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
34 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
11 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
25 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
33 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
27 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
38 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
16 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
14 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 ...
1
vote
3answers
336 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
20 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
43 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
50 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
69 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
58 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
31 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
38 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
96 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 ...
0
votes
0answers
17 views

All cartthrob options are deleted when I click submit after editing an entry

[UPDATE: A possible solution! - see end of post] I have a client with a product entry that has an option group with 42 options. Each option is a type of design for the plate face of an embosser. The ...
1
vote
1answer
16 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
57 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
35 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 ...
0
votes
3answers
840 views

Unable to connect to database using WAMP

I turned debugging on with my local installation, and find out that i cant get into database. A Database Error Occurred Unable to connect to your database server using the provided settings. ...
1
vote
1answer
53 views

How to use EE classes like DB,channel API from a php file

I have a requirement in one of my EE site wherein I need to insert some data in tables and make some channel entries using EE channel API,I am able to do this within a EE template using database class ...
0
votes
0answers
19 views

Database Environment Sync [duplicate]

We have a pretty simple setup for all of our expression engine websites, we have local, staging and live. We use Git for Version Control which makes pushing file based updates live incredible easy. ...
1
vote
1answer
73 views

Problem importing database - import hangs on exp_stash table

Here's a weird one. I need to set up a dev server, so I'm importing a DB from and existing production EE install. The import proceeds fine until it gets to the exp_stash table. Then I get MySQL error ...
1
vote
1answer
69 views

HTML entities in Title field

I can't figure out where expression engine is changing my title to html entities. This is specifically for the required title field Text like: "Test á Character" is being stored as "Test ...
2
votes
2answers
80 views

ExpressionEngine source control via git

Im trying use some form of source control with EE. I cannot clearly see a way to decouple the database from the templates and other structures, as would be the case in a most CMSes. Creating channels ...
2
votes
1answer
51 views

change category id manually

I would like to match both production and development versions to have identical category ID's without having to import the db every time. In this case it's only one Category which is out of Sync. ...
0
votes
0answers
58 views

Errors importing MySQL database

I'm having issues uploading the DB i've exported from MAMP (And also from a Dev server) in to inMotion Hosting. I've had a few of these errors pop up (Below) and I've fixed it by deleting the content ...
3
votes
3answers
91 views

Add-on - Building Queries w/ Field Names vs Field ID's

I have an add-on I've built to provide custom e-commerce reports for a client. It started as one of those 'we need this very specific thing' builds and of course has grown and grown as more needs ...
0
votes
1answer
60 views

{option_value} how to pull from database

I am very new to CartThrob and EE so excuse my ignorance. I am charged with pulling order data from the database so I can write that data in our business system. In the database we have stored, I ...
2
votes
1answer
59 views

Query a NON EE table in database?

I have a HTML table where a user can subscribe.I send an ajax call when the user clicks the subscribe button and store it in a non ee table.Next time when the user comes on the same page,I want to ...
4
votes
1answer
74 views

Collision Control for entries?

I am wondering if there is some sort of "data collision control" system available for EE. I am talking about a warning if a dataset is (about) being changed by two (or more users) at the same time, ...
1
vote
1answer
42 views

Structure Won't Appear in Control Panel Anymore

Made a rookie mistake and deleted Structure from the server before uninstalling it first from the EE CP. Now, after I've reuploaded it, it still won't appear. I've tried going into the config file and ...