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 ...
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"}
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
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 ...
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
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 ...
1
vote
Is ExpressionEngine compatible with MariaDB?
I run it on a Vagrant box and it seems to work fine.
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.
1
vote
Accepted
Use Expresso tags to show stock sold on front end
There is not going to be an actual Store tag that you could use to get this. Having said that it should be fairly simple to query the DB for the information that you need. Something along the lines of:...
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 /...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
mysql × 111database × 28
php × 11
query × 11
ee2 × 10
error × 7
cartthrob × 6
add-on × 6
custom-fields × 6
sql × 6
database-error × 6
channel-entries × 5
categories × 5
performance × 5
ee1 × 4
expresso-store × 3
solspace × 3
supersearch × 3
super-admin × 3
templates × 2
solspace-freeform × 2
assets × 2
members × 2
control-panel × 2
relationships × 2