The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
0answers
22 views

Assets errors with MySQL 5.7.X

I've started having issues with old EE sites on my development machine now that I'm running newer versions of PHP and MySQL. I've been able to sort most of these out except for the following MySQL ...
0
votes
1answer
35 views

Refine by, returning results back to template

In a new site I am working on, I have a refine section that allows users to select from a range of checkbox questions (around 40 checkboxes, 7 questions). I have currently wrapped these in a form, ...
0
votes
0answers
16 views

Update database from the front end?

Is it possible with a native, third party or even the expresso store module itself to update a Database row from the front end? We are using Expresso Store for internal orders, and want to be able to ...
0
votes
1answer
32 views

Optimising structure of exp_channel_data table

I have a site with around 800 columns on exp_channel_data table. I would like to know if I can go ahead and optimise the structure of this table by doing the following 1) changing field from text to ...
0
votes
1answer
30 views

Automated deployment (Wordmove for EE)

I've been trying to figure out a way for executing automated deployment of EE sites via Capistrano or similar. I've come across various tutorials but all require Git on the server, and most don't ...
0
votes
1answer
17 views

SuperSearch Module Install Creates 1044 Error

I've just attempted to install SuperSearch 2.2.3 on EE 2.9.2 and receive a a database 1044 error: Access denied for user 'db######'@'%' to database 'db202322_##########' It then goes on to list the ...
0
votes
0answers
18 views

Query works in Database Query Form but not in exp:query

I have a query that works fine if I run it through the Database Query Form, but it doesn't return any results if I use exp:query: SELECT DISTINCT ect.title FROM exp_channel_titles ect JOIN ...
1
vote
1answer
22 views

Use Expresso tags to show stock sold on front end

A specific user group on my website has the ability to create products on my website. This is all done using Channel Form tags. Unregistered guests may purchase these products. For the user group ...
0
votes
0answers
138 views

Error importing EXP_MEMBERS

I'm trying to import EXP_MEMBERS but I get the following error: Static analysis: 2 errors were found during analysis. Ending quote ' was expected. (near "" at position 3821) 76 ...
0
votes
1answer
103 views

A Database Error Occurred Error Number: 1064 when Trying to delete an entry..

So, trying to delete an entry .. after the "ARE YOU SURE?"-page and the click on delete, I get the following error. Anyone else had this problem? I'm afraid of mySQL, so this is freaking me out :( A ...
0
votes
0answers
29 views

How can I restore a revision through the MySQL DB?

Is it possible to restore a previous version of a channel entry through the DB using phpMyAdmin? If so, where in the DB would I do that? My client's assigns are entering things in Matrix fields with ...
0
votes
1answer
67 views

ExpressionEngine v.s. Database.Mangement System

I'm really confused! I've been trying non stop to connect to an Oracle database through ExpressionEngine throughout the last two weeks. I've finally given up when I saw a previous post(Is it possible ...
1
vote
3answers
50 views

Is it safe to change the MySQL storage engine on a live site?

I've got a site that will not let me create any new custom fields. On a test install I changed the MySql storage engine from InnoDB to my MyISAM, which seemed to fix it. Is this safe to do on a live ...
0
votes
1answer
24 views

ExpressionEngine versions and MYSQL support

Does anyone have a link to the MYSQL version supported by different versions of ExpressionEngine? I need to upgrade the MYSQL version on a server containing several EE sites. Thanks, Clive
0
votes
1answer
42 views

MYSQL Error Importing Database

This is a first for me... I'm importing into an database with no tables from a working backup. Error SQL query: -- -- Dumping data for table `exp_accessories` -- INSERT INTO `exp_accessories` (`...
0
votes
1answer
43 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 I'...
0
votes
1answer
81 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
1answer
24 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
109 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
59 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, `L0`.`...
1
vote
2answers
66 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
64 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
63 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
64 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 ...
1
vote
0answers
29 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
30 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
29 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
64 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
1answer
16 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
167 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
1answer
69 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
2answers
66 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
1answer
265 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 sessions?...
1
vote
0answers
255 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 ...
1
vote
1answer
40 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
47 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
232 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
1answer
405 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
1answer
67 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
85 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
160 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
116 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
101 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
76 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
407 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
133 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
963 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 './db-name/...
2
votes
4answers
1k 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
199 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
140 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 ...