Upload paths for images, etc seem to be in the database. So, in moving to a new server it seems not to update those paths, and if I go to the image upload editor to change them, I get:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘0’ in ‘where clause’:
SELECT group_id
, group_name
, sort_order
FROM (exp_category_groups
) WHERE site_id
= 1 AND (exclude_group = “0” OR exclude_group = “1”) ORDER BY group_name
ee/legacy/database/drivers/mysqli/mysqli_connection.php:117
Stack Trace: Please include when reporting this error
I am on 5.3.2 PHP 7.2.24 Centos 8
Okay, yes, it is possible to override in the configuration files, but my fundamental issue was incorrect sql being submitted. I noticed that the query would run if I just had single quotes on the ‘0’. So, there is a mysql setting that allows double quotes to act as single quotes. Which is something about ansi_quotes sql mode.
So change the mode on your mysql server
Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.