The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
9 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
29 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
8 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
20 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
24 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
26 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
22 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
12 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
9 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 ...
0
votes
2answers
91 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
17 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 ...
0
votes
2answers
32 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
36 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
31 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
48 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
0answers
24 views

EE query contains every channel entry_id

I have an offending query that is bringing my site down the minute it receives any ammount of significant traffic. SELECT t.entry_id FROM exp_channel_titles AS t LEFT JOIN exp_channels ON ...
1
vote
1answer
27 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
34 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
78 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
15 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
53 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
34 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
389 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
37 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
18 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. ...
0
votes
1answer
47 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
55 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
73 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
47 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
52 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
86 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
57 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
53 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
69 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
40 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 ...
3
votes
1answer
72 views

Character encoding on export import

We have an existing site running on EE 1.6.8. We decided to start afresh, clean new site so we have an install of v2.7.1 running. We’ve built the site, finished the templates and are starting to ...
1
vote
1answer
36 views

cached relationship entries db error

I've been trying to clear the caches prior to running this EE upgrade but when I do I'm getting this error: A Database Error Occurred Error Number: 1054 Unknown column 'rel_data' in 'field list' ...
0
votes
0answers
22 views

Lag in Data Returned

I have a pretty simple template set up that has one image and a block of text, but for some reason the page takes 3 seconds to load at 37 queries. I have tag caching set so subsequent loads of the ...
1
vote
1answer
78 views

ExpressionEngine with Percona Cluster?

I've tried using Percona Cluster as a drop-in replacement for MySQL. However when templates are saved, each cluster node is updated with a different value for the primary key column template_id in ...
6
votes
1answer
101 views

How to Setup Redundant DB for ExpressionEngine?

Does anyone have an experience setting up ExpressionEngine with a redundant db architecture? Per corporate requirements, I must host the EE site within our corporate server structure. What is the ...
4
votes
2answers
86 views

Site Rebuild / Moving existing data

Any websites I have built before using Expression Engine have been from scratch. One of my existing clients would like their site rebuilt as its 4 years old. I am planning on using another domain to ...
1
vote
1answer
60 views

Site Error: Unable to Load Site Preferences

I'm getting this issue with a new MT GS Server and have yet to resolve the problem despite reading he various recommendations on EESE. My database.php file is set to point to my config.php file where ...
2
votes
4answers
140 views

{site_url} when updating on localhost and transfer to remote server

I'm a newbie upgrading an ExpressionEngine site from 1.6.8 to 2.7.2. I did this on my local server. Worked pretty well but I lucked out since I don't have any add-ons to upgrade. However, not ...
2
votes
2answers
47 views

Error Upgrading to 2.7.2

I tried to do an upgrade to 2.7.2 using Updater but found that the version of Updater was old. Hence, it didn't work! I know it's my fault and I should have checked first. Now when I try to login to ...
0
votes
0answers
12 views

Database error when logging on to Control Panel - Unknown column 'hash' in 'field list' [duplicate]

I just visited my control panel page and got this: A Database Error Occurred Error Number: 1054 Unknown column 'hash' in 'field list' SELECT hash, timestamp FROM (exp_developer_log) ...
1
vote
1answer
85 views

Super Search DB error with Matrix fields

I want to re-hash this issue: http://www.solspace.com/forums/viewthread/17419/ The error is: Error Number: 1052 Column 'field_id_90' in field list is ambiguous It seems there was never a proper ...
1
vote
1answer
115 views

One alert when importing a production database

I now have a local copy of a live EE site. Front and backend are working with no problems. However, when I imported the production database I got this one alert: [ERROR in query 912] You have an ...
1
vote
1answer
185 views

Errors when importing a MySQL database

Trying to make a local copy of a live ExpressionEngine site, my process stop when importing the live database. I'm using EE 2.5.5 and several key add-ons like Publisher, Playa, Matrix and CE Cache. I ...
2
votes
2answers
111 views

Git and Templates saved as file

I am playing around with Git together with an EE install and I think that I have almost nailed it (aka found my workflow). There is just one small unclarity remaining with Templates being saved as ...