A few times a day I’m seeing a SQL error in the Manager > Reports > System Events:
« Execution of a query to the database failed - Unknown column '7Pr' in 'where clause' »
SQL: SELECT DISTINCT sc.id FROM `scigirls2`.`modx_site_content` sc LEFT JOIN `scigirls2`.`modx_document_groups` dg on dg.document = sc.id WHERE (sc.id IN (7Pr) AND sc.published=1 AND sc.deleted=0) AND (sc.privateweb=0) GROUP BY sc.id
Interestingly, the column mentioned in each event is different (e.g. ’6Pr’, ’7Pr’, ’8Pr’). It’s always in that pattern, though (’[n]Pr’).
Any thoughts?
