mysql error on article pages and admin pro dashboard list ...
Permalink Browser Info Environment
Getting the following error for blog article pages and admin blog list ...
An unexpected error occurred. mysqli error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') and cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and p1.c' at line 1] in EXECUTE("select p1.cID, pt.ctHandle from Pages p1 left join Pages p2 on (p1.cPointerID = p2.cID) left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = if(p2.cID is null, p1.cID, p2.cID)) inner join CollectionVersions cv on (cv.cID = if(p2.cID is null, p1.cID, p2.cID) and cvID = (select cvID from CollectionVersions where cvIsApproved = 1 and cID = cv.cID)) left join PageTypes pt on pt.ctID = cv.ctID inner join Collections c on (c.cID = if(p2.cID is null, p1.cID, p2.cID)) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = if (p2.cID is null, p1.cID, p2.cID)) where 1=1 and cv.cID > 208 and (CHAR_LENGTH(cv.cvName) > 4 OR cv.cvName NOT REGEXP '^[0-9]') and cv.cvDatePublic <= '2016-12-08 22:13:15' and () and cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and p1.cIsActive = '1' and (p1.cIsSystemPage = 0 or p2.cIsSystemPage = 0) ")
| Type: | Pre-Sale |
|---|---|
| Status: | New |
