The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
2 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
12 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
16 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
17 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
28 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
49 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 ...
1
vote
1answer
27 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
34 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
68 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
38 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
41 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
60 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
35 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
64 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
31 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
18 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
55 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
87 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
77 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
50 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
108 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
41 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
0answers
48 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
93 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
107 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
1answer
88 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 ...
0
votes
1answer
428 views

Database Error Occurred Error Number: 1146

I’m working on a new site, using a fresh install of 2.7.2. Everything’s been going swimmingly (sort of), until now I went to edit some custom fields. When I click on a field name to do an edit, I get ...
0
votes
1answer
44 views

Input Range type - Low Search

I am working on an online directory that will allow users to use the input range type element(a slider) to search for prices. Can this be used with low search this element, or would anyone recommend ...
1
vote
0answers
144 views

Why is my site giving me a relationship field error?

I pushed an update to my ee site recently and came across a very strange error where none of my pages work in the site properly and I get a relationship field error on the homepage which was never ...
3
votes
2answers
93 views

Why do I get database error when I log into my updated ee site

I wondered if you could help. I updated my local site to new ee 2.7 and that went swell. I pushed up my files to the server and I can get the /admin.php login page but when I press login i get this ...
0
votes
0answers
123 views

Database error 1054 following update to 2.7.0

I've just updated a staging instance of EE to 2.7.0 from 2.5.2 following a successful update of a development instance and the live production instance. The reason for update was because we have MSM ...
1
vote
2answers
44 views

Table 'exp_accessories' already exists

I try to import a ee db into my local environement and I get this Error: SQL-Befehl: -- -------------------------------------------------------- -- Tabellenstruktur für Tabelle ...
1
vote
1answer
23 views

Database error number 5

I had a problem with my Expression Engine. Today login for my system and i have a error off database number 5. can someone help me?
1
vote
0answers
35 views

Channel Field Group gone

I have an odd one where it appears that 1 of my custom field groups has disappeared. I don;t when, there is no backup (even if there was I can't tell wether it disappeared yesterday or last year). It ...
3
votes
2answers
143 views

Assets 2.1.4 strange behaviour: “Could not upload the file … ”

Assets is the only thirdparty module/filedtype installed. Native cache folder are 777. File upload directory is working and uploads images correctly. Assets shows no folder at all. But if I upload ...
1
vote
2answers
45 views

Database settings cached?

Working on my first EE site (but have worked with several other CMSs) and I'm having issues with the database connection. I've pulled down files from a live site to set up a development version ...
1
vote
1answer
96 views

Database connectivity error with EE on Network Solutions

I'm setting up a staging server on a Network Solutions site before preparing it to go live next week. I created a new subdomain pointing to /htdocs/staging/html so I can move system above root (plan ...
0
votes
1answer
82 views

Converting standard file field to an Assets field with a remote source [duplicate]

I have about 250 blog entries, each with a standard EE file field that points to a file on the same local server EE is running on. I've installed the Assets add-on and set up an external source (an ...
2
votes
1answer
120 views

How do I decode columns in the exp_sites table?

I need to look at the contents of the site_system_preferences column in the exp_sites table. How do I decode this data?
2
votes
1answer
89 views

Control Panel locking me out after uploads and template changes - says no data

Prolem: I am using ExpressionEngine Core 2.6.1. After I click around the control panel for a bit, sometimes updating templates and sometimes uploading images, I get kicked out. When I get kicked out, ...
2
votes
1answer
68 views

How to bulk import multi-language data to channel entries?

I'm trying to import a data base that has multi-language entries to EE and thought of using DataGrab. I'm using Publisher plugin to relate multi-language entries. Is there a way that I can import the ...
1
vote
1answer
94 views

Automatically removing old entries

I have a channel which is growing large through automatic daily imports. Is there any way to automatically remove (prune) entries older than X days? I've looked through the extension space without ...
0
votes
0answers
17 views

Assets/File Manager throws a DB error 1364 whilst uploading

The assets file manager uploads the file but before giving a summary of the upload it gives this error: http://s16.postimg.org/7q1ezrcnp/Capture.png After I close this the file is uploaded anyway, ...
0
votes
1answer
53 views

Can upload image with Assets, but image does not “stick” to entry

I can upload an image to my Asset field(s) and publish the entry. However, here are the weird issues I'm experiencing: The Asset field is blank when re-editing the published entry, (but...) The ...
4
votes
1answer
98 views

Redirect to static page if EE database is down

We have a client that would like to see a branded, non-EE error message if there is a problem with the EE database connection. Their database is hosted on a different server and has, on one or two ...
1
vote
1answer
54 views

Adding new channel fields takes 5 minutes

I work with an EE website that has 293 custom fields, and 125k entries. Nowadays, whenever I am adding a new channel field, it takes between 4 and 5 minutes to complete the task! Also, it can take up ...
1
vote
1answer
184 views

DB Connection Error

My site was pointed to an IP without an attached domain. Now that the domain is pointed there, the pages stopped resolving and I get an error 500 message. After some trouble shooting I found: A ...
0
votes
1answer
28 views

add new channel fields for existing site

I´ve a site with a channel, this channel has a channel field group with 2 fields. So far, so standard. My problem: I know exactly, that after some time when the site evolves I´ll ned more channel ...
0
votes
1answer
486 views

SQL query getting entries from current day

I am trying to use this script that I have put together, forgive me I am a bit of a newbie with sql. When I run the script it is outputting an empty csv file, only showing column titles, no data. ...