Questions tagged [mysql]
The mysql tag has no summary.
112 questions
0
votes
2
answers
93
views
Can EE 2.4 MySql db be used with EE 7.4
My client wants to upgrade their EE 2.4 site to the current EE 7.4. Will the old db work with the current version?
If there are is any other info or caveats about such an upgrade they would be ...
1
vote
1
answer
555
views
Site was working, but this morning there is an error showing. mysqli_connection.php:117
I installed the site with whatever the version was 5 months ago. When I log into the control panel, I get this. I don't know what any of it means and I'm desperate to get my site up and running again.
...
0
votes
1
answer
63
views
SuperSearch Install Error
EE 5.2.6
I'm trying to install the SuperSearch module and I'm getting an error.
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes:
I'm ...
- 317
0
votes
1
answer
90
views
CE Cache - if page not yet cached, error: Base table or view not found
If a not cached page is accessed for the first time, give an error message (EE cache is disabled from the control panel).
When this same page is accessed one more time, the page is well displayed, no ...
- 885
0
votes
1
answer
141
views
Exception Caught: 1615 Prepared statement needs to be re-prepared
Running ExpressionEngine 5.1.3, php 7.2 on Dreamhost shared server.
This error has brought our site down repeatedly for hours at a time over the last few days. We cannot access the site backend or ...
- 11
0
votes
0
answers
76
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,349
1
vote
1
answer
2k
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 ...
- 11
1
vote
2
answers
214
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 '...
- 1,068
0
votes
1
answer
119
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 ...
- 13
1
vote
3
answers
269
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 ...
- 157
1
vote
1
answer
131
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 ...
- 11
0
votes
1
answer
390
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 ...
- 101
1
vote
0
answers
27
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 ...
- 695
0
votes
1
answer
38
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 ...
- 155
0
votes
1
answer
111
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
$...
- 1,079