The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
21 views

Performance suffering with around 100 concurrent users

I'm running a VPS with 4 CPU cores and 4GB RAM. My EE site is unexpectedly (a 'Reddit hug of death') seeing an average of 100 concurrent users and the whole thing is grinding to a halt; this seems ...
0
votes
1answer
30 views

Reassign uncategorised entries

I need to reassign all uncategorised entries into a certain category, I've managed to create an SQL query which selects all the entries for that channel which aren't assigned to any categories, but ...
0
votes
1answer
19 views

SQL query issue while trying to count the entry (row)

Trying to produce a current entry count / total entries within a channel_entry tag by using a SQL query. {exp:channel:entries channel="{channel}" limit="1" require_entry="yes" status="open" ...
0
votes
0answers
5 views

Error while importing DevDemons-Updater-Backup into PHPMyAdmin

i just tried to import one of my several ee-backups, which where saved by devdemons great updater-module into the default site_backup-directory, into an empty mysql-database (just the .sql-file of ...
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 ...
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 ...
1
vote
0answers
25 views

Slow queries from ExpressionEngine

I need help with the following query. I'm not sure where it comes from in ExpressionEngine. Any insight or pointers would be helpful. SELECT DISTINCT `L0`.`field_id` as L0_field, ...
1
vote
2answers
52 views

Quick and simple way to determine which templates are used on an EE site and where

I have inherited a large EE site (upgraded to 2.9.2) that is, frankly, a mess on the backend (EE CP). There are many template groups and templates that appear to have been left behind from multiple ...
0
votes
0answers
12 views

Weird problem with disappearing EE Module tables - Error #1146

We're getting an error in the EE CP (EE version 2.8.1) when clicking an entry to edit it. A Database Error Occurred Error Number: 1146 Table 'xxxxxx.exp_user_preferences' doesn't exist SELECT ...
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
1answer
34 views

ExpressionEngine 2.7.3 How do I directly execute a query against the database?

I navigate to Tools | Data | SQL Manager Select "Database Query Form" select table_name from information_schema.columns where column_name = 'flippityfloop' I select "Enable MySQL Error Output" and ...
0
votes
1answer
36 views

Should I run the EE Install & Update Wizard after updating mySQL

We are currently running EE v2.7.3. Our IT partners have informed us that they will be updating the server this week. They will also be updating Linux, PHP, httpd, and mysql-server moving up to the ...
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
0answers
22 views

Error Number: 1153, Exrpression Engine 2.7.3

We're having an issues on "Importer". While we're importing data to our site we encounter this error. The site is on shared-hosting. Please we need help on this. UPDATE: Here is the error message: A ...
0
votes
0answers
23 views

Super Search Query Overloads DB and Brings Down Websites

Once a day for the past week our websites have been going down around the same time, but then slowly comes back up after 30 minutes. We've discovered it's due to a MySQL overload caused by the Super ...
1
vote
1answer
45 views

mySQL script to update non-unique URL titles

We need to update a set of url-titles that have some duplicate entries (migrated from a non-EE site). Because of the size of the database I would prefer to use direct mysql method, but I am open to ...
0
votes
0answers
13 views

Deleted site from the Multi Site Manager BUT it is still present in the MySQL exp_sites table?

We had a slow responsive site in our multisite configuration that meant we could no longer edit the content. We tried many things but could not resolve; so decided the best course of action was to ...
0
votes
1answer
12 views

MySQL Script to identify old accounts

Need help with creating a MySQL query to create a list of users that have not logged into the site within the past 6 months. Needs to contain Username, Email address and last login date. Will use ...
2
votes
1answer
61 views

SQL Query to get entries with their categories

I have the following query that is grabbing entries, but I would also like a 'categories' column that will show a pipe seperated list of the categories assigned to each entry. I have tried using ...
0
votes
0answers
79 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
1answer
51 views

MySQL query to output variables grouped by entry status

I have schools, teachers and students channels with each of the students and teachers channels with a field that contains the entry_id of the school they're related to (not actually using native EE ...
0
votes
0answers
76 views

Very slow load issues on Chrome & FireFox

On our local build, load time really wasn't the issue until last week when the following would happen on Chrome & FF: After loading a few pages, site would take minutes to load ("waiting for ...
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
129 views

MySQL strict mode: disable on a session basis?

I'm getting mysql errors suggesting that my host's use of strict mode is a problem (with an addon). The host wants mysql strict mode on their DB server. Can I override strict mode for my EE ...
1
vote
0answers
121 views

Highest version of mySQL and PHP for EE 1.7.3

My hosting company needs to upgrade my server to the latest versions of PHP and mySQL. The problem is I'm running a number of EE sites varying between versions 1.6.8 and 1.7.3. So what is the highest ...
0
votes
0answers
23 views

Remove symbols from jSON data with ce_str:ing

How do I remove symbols with json data which is fetch using a sql statement using ce_str:ing. My json data: "sb": [ {exp:query sql="SELECT t.title, d.field_id_1447 as info, ...
0
votes
0answers
75 views

SQL select channel entries by category, AJW export to create XML file

What would the query be to display all entries (with entry id, title) by category (with category name)? I hope to use AJW export to create an xml file with the information. So the result might look ...
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 ...
0
votes
2answers
34 views

Trying to login via database

As you have probably seen by my somewhat regular postings, I am a newbie to EE. The company that I work has all of their web sites using EE and some of the sites have not been updated or worked on ...
0
votes
1answer
105 views

Displaying Category Name and Channel Entry Data with Query Module

I have a SQL query set-up to display a list of entries based on the category ID found in the third segment, but I'm having a hell of a time trying to display the category name that goes along with it. ...
0
votes
0answers
58 views

Using Host file Centos 6.5 / mySQL / Apache / ExpressionEngine

I am having issues with my host file. I am tasked with creating a working local copy of our marketing website so that our sales team can access our website while in conventions. I guess the internet ...
0
votes
1answer
128 views

Getting To Know The EE Database Structure

I am new to ExpressionEngine2 and already working with it, but find the database structure very confusing coming from a pure OOP environment. What is an easy, fast way to actually find references or ...
0
votes
0answers
103 views

Field 'title' doesn't have a default value

I'm using getting a nice mysql error on submitting the exp:cartthrob:checkout_form Error Number: 1364 Field 'title' doesn't have a default value INSERT INTO `exp_channel_titles` (`site_id`, ...
0
votes
1answer
58 views

Categories of a category_group won’t show

I have a strange thing in EE 2.8.1. I want to show a list of all categories in category_group=“1” but nothing won’t show up. I have 3 category groups ID 1 - with 105 categories, top & sub ...
1
vote
2answers
76 views

Expresso Checkout conditional (use hook?)

So, at the end of the checkout process (where it becomes an order) I want to fire off an SQL query wrapped inside AJW export (which creates an xml file). However, within the confines of ...
1
vote
1answer
101 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 ...
2
votes
2answers
90 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 ...
3
votes
3answers
96 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 ...
1
vote
1answer
55 views

Solspace Freeform not updating, mySQL error?

I'm getting database errors when trying update Freeform. I think I've narrowed it down to one specific mySQL statement, but I don't know enough about mySQL to know what's wrong, I just know that this ...
0
votes
1answer
149 views

Get all entries where expiration date is within last 12 months

I know this is more of a SQL question, but I'm having trouble getting EE to cooperate. I have entries that expire, and want to show only entries which have expired in the last 12 months. I tried: ...
1
vote
2answers
117 views

All channel entries have had their statuses changed to 'closed'

It looks like one of my sites has been compromised with an SQL injection. All the channel entries have been closed, which amounts to over 5k entries. I restored the database with a previous daily ...
1
vote
1answer
617 views

table is marked as crashed and should be repaired

All of a sudden I cannot log into my control panel. Does anyone have any advice as to where I could start to get this repaired? A Database Error Occurred Error Number: 145 Table ...
2
votes
4answers
704 views

Very slow performance on production, not on local dev, doesn't seem to be the database

I'm running an ExpressionEngine site using CartThrob for a shopping cart. Some of the pages are loading extremely slowly on the production server (7, 10, 15 seconds of Controller Execution Time as ...
3
votes
1answer
161 views

How to prevent CartThrob from making hundreds of SQL queries and running extremely slow?

this may be somewhat of a noob question as I just started administering an ExpressionEngine site that uses CartThrob. My client complained of the site being slow during the shopping / checkout process ...
2
votes
1answer
90 views

Move categories from one group to another

In a category group "Shops & Services" we have three parent categories each with many sub-categories: Offices Services Retail The Retail (parent category) has grown to a point where it needs ...
1
vote
1answer
121 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 ...
0
votes
1answer
222 views

Error Number: 1062 Duplicate entry '465628' for key 'PRIMARY'

Running into some serious issues with CartThrob. All of a sudden I am getting this error when I add an item to the cart and try to view cart or checkout: It was working last night and sometime over ...
1
vote
2answers
127 views

Optimizing performance when sorting through hundreds of entries

Currently working on a new EE site that I've inherited, and having difficulty optimizing performance. Everything was dandy until I finished imported all the old content. Now there are ~700 page ...
1
vote
1answer
210 views

Help with SQL to Export Channel entry status

I've built an accessory to allow my client to export channel entry data to a CSV. All is working fine but they now want to add the entry status to the list of exported fields and I'm having trouble ...