Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mysql]

The tag has no usage guidance.

0
votes
0answers
28 views

Low Search / Channel Entries Search running very slow in EE2 after move to MySQL 5.7

I've got an old website that's running EE 2.11.2 and Low Search 4.4.4. I'm trying to move the site from a cPanel VPS that runs MySQL 5.6, to a new cPanel VPS (with more RAM so it should be faster) ...
1
vote
1answer
314 views

MySQL ERROR: Error Number: 1364 Description: Field 'whatever' doesn't have a default value

Firstable, I´m designer, hence my ignorance. It´s been awhile since I didn´t updated a site. The client asked me to make a new member in EE. I´ve been able always to do that on the spot, but this ...
1
vote
2answers
82 views

General error when trying to access templates

Running EE 3.5.12 In the process of creating a number of new templates I suddenly got the following error: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xD5ve fo...' for column '...
0
votes
1answer
35 views

How-to connect to secondary external DB in EE2

Im relatively experienced with PHP/HTML, however not so much with EE 2.4. Im working with a company using this set-up, so im on the learning curve at the moment. However, the first db 'expression' has ...
1
vote
3answers
120 views

Is ExpressionEngine compatible with MariaDB?

I have about 50 sites ranging in versions from 2.5 up to 2.11 of ExpressionEngine. All are running on MySQL 5.6.35 at the moment. I am debating about upgrading out server to use MariaDB 10 but ...
1
vote
1answer
43 views

Has anyone set the database on a remote server while the controllers sit on local/hosted system

I host the MySQL server providing the database functions and the site itself on the same hosting platform (a semi-dedicated server). I was wondering if I could improve expression engine performance ...
0
votes
1answer
210 views

Decrypt Password as string

We are using ExpressionEngine v2.10.1, we are going to import data from the database. We have created API that returns data as JOSN by using: {exp:query sql="SELECT * FROM exp_member_data"} But we ...
0
votes
0answers
27 views

EE1 and empty field after MySQL update

Sorry for my English. ;( Now i’m using EE1. My server administrator update PHP and MySQL and now in CP i see empty fields. I do not remember what versions were before. Now: PHP 5.4.45 and MySQL 5.5....
1
vote
0answers
8 views

Can I preserve my mediumtext fields when upgrading from 2 to 3?

I have had to edit a few fields in my EE install from TEXT to MEDIUMTEXT so that all the content for the entries in the relevant channels will fit. On a prior upgrade within EE 2.x, there was a ...
0
votes
1answer
23 views

Cartthrob Order Manager Settings

Under the database table exp_cartthrob_order_manager_settings I have updated the 'cp_menu' to 'no' but the eCommerce tab is still showing in the control panel. I would like to remove the tab but does ...
0
votes
1answer
55 views

Passing a GET variable back in a query while using mysqli_real_escape_string()

I'm trying to take a variable that's passed in a query string (GET) and then use that variable to do a SELECT based on it... // Assign query string to a variable while sanitizing it against XSS $...
4
votes
1answer
396 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
53 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
1answer
78 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
57 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
28 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
29 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
31 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
292 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
623 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
63 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
98 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
77 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
2answers
90 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
48 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
54 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
128 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
44 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
118 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
93 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
93 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
78 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
106 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
83 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
45 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
45 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
42 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
70 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
21 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
461 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
104 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
82 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
719 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
499 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
57 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
106 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
378 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
2k 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
78 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 level,...
1
vote
2answers
102 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 ...