9
votes
Accepted
Assets errors with MySQL 5.7.X
The problem is that many developers don't know how to write compliant SQL statements - they're software developers who find themselves also filling the role of database developers. This problem crops ...
- 692
2
votes
Accepted
SuperSearch Install Error
SuperSearch has been obsolete for quite sometime (didn't make it past v2) and will not run on newer versions of EE. Try Low Search.
- 1,987
2
votes
Get all entries where expiration date is within last 12 months
Could you not use native parameters for this?
{exp:channel:entries channel="mychannel" show_expired="only" start_on="-12 months"}
- 1,607
1
vote
What is the MySQL function for exp_members password column?
I want to post an update to this question for EE 5 because the current answer is pretty outdated.
In order to set a member's password in the DB, you'll need to know what the hash algorithm is. From /...
1
vote
Accepted
CE Cache - if page not yet cached, error: Base table or view not found
It looks from the last error you reported that the CP issue is being caused by a configuration error - EE is trying to delete an entry from a table that doesn't exist (the table ...
- 3,585
1
vote
Accepted
General error when trying to access templates
All efforts to locate the offending encoded entity failed. I therefore made another backup of the database and all template files and proceeded to systematically delete template files. It ended up ...
- 1,068
1
vote
General error when trying to access templates
I believe your issue is MySQL attempting to encode an invalid UTF-8 byte sequence. I checked (even though it is obvious if you work with encoding/decoding UTF-8 on string sequences) and \xD5ve is not ...
- 5,900
1
vote
Is ExpressionEngine compatible with MariaDB?
I run it on a Vagrant box and it seems to work fine.
- 1,987
1
vote
Accepted
Passing a GET variable back in a query while using mysqli_real_escape_string()
Use ee()->db->escape_str($event) - it's the native way to escape potentially-unsafe data in EE.
- 17.4k
Only top scored, non community-wiki answers of a minimum length are eligible