Dashboard > Full Sitemap stopped working
Permalink
I am using Concrete5 version 5.5.1.
I had to modify some data directly in the database as I was importing data from another system into C5. The data has been properly imported into the respective tables and the front-end is able to show them in the right place on the page.
Using the Full Sitemap, I was moving the pages from the root directory into another directory to have them as sub-pages. The first few steps are fine. While I keep going, the ajax loading gif icon would not stop and when I go back to the Full Sitemap view all I can see is the Home page. When I go to the Flat View or Page Search, the pages are all listed there. The pages are listed on the front-end as well. I just cannot move a page into another directory anymore through Flat View and Page Search either.
I had a look at Dashboard > System & Settings > Optimization > Automated Jobs, I could see these errors:
On Index Search Engine:
-----------------------
mysql error: [1242: Subquery returns more than 1 row] in EXECUTE("select p1.cID, pt.ctHandle from Pages p1 left join PageTypes pt on (pt.ctID = p1.ctID) left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = p1.cID) inner join CollectionVersions cv on (cv.cID = p1.cID and cvID = (select cvID from CollectionVersions where cvIsApproved = 1 and cID = cv.cID)) inner join Collections c on (c.cID = p1.cID) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = p1.cID) where 1=1 and (c.cDateModified > psi.cDateLastIndexed or UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(psi.cDateLastIndexed) > 259200 or psi.cID is null or psi.cDateLastIndexed is null) and (ak_exclude_search_index is null or ak_exclude_search_index = 0) and (p1.cPointerID < 1 or p1.cPointerID is null) and cvIsApproved = '1' and p1.cIsTemplate = '0' and p1.cIsActive = '1' and (p1.cIsSystemPage = 0) order by p1.cID asc limit 0,200 ")
On Remove Old Page Versions:
----------------------------
mysql error: [1242: Subquery returns more than 1 row] in EXECUTE("select p1.cID, pt.ctHandle from Pages p1 left join Pages p2 on (p1.cPointerID = p2.cID) left join PageTypes pt on (pt.ctID = (if (p2.cID is null, p1.ctID, p2.ctID))) 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)) 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 cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and p1.cIsActive = '1' and (p1.cIsSystemPage = 0 or p2.cIsSystemPage = 0) limit 0,3 ")
I have already re-installed the system but I keep getting this error. Any idea what's going on? Is there a way to resolve this?
I had to modify some data directly in the database as I was importing data from another system into C5. The data has been properly imported into the respective tables and the front-end is able to show them in the right place on the page.
Using the Full Sitemap, I was moving the pages from the root directory into another directory to have them as sub-pages. The first few steps are fine. While I keep going, the ajax loading gif icon would not stop and when I go back to the Full Sitemap view all I can see is the Home page. When I go to the Flat View or Page Search, the pages are all listed there. The pages are listed on the front-end as well. I just cannot move a page into another directory anymore through Flat View and Page Search either.
I had a look at Dashboard > System & Settings > Optimization > Automated Jobs, I could see these errors:
On Index Search Engine:
-----------------------
mysql error: [1242: Subquery returns more than 1 row] in EXECUTE("select p1.cID, pt.ctHandle from Pages p1 left join PageTypes pt on (pt.ctID = p1.ctID) left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = p1.cID) inner join CollectionVersions cv on (cv.cID = p1.cID and cvID = (select cvID from CollectionVersions where cvIsApproved = 1 and cID = cv.cID)) inner join Collections c on (c.cID = p1.cID) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = p1.cID) where 1=1 and (c.cDateModified > psi.cDateLastIndexed or UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(psi.cDateLastIndexed) > 259200 or psi.cID is null or psi.cDateLastIndexed is null) and (ak_exclude_search_index is null or ak_exclude_search_index = 0) and (p1.cPointerID < 1 or p1.cPointerID is null) and cvIsApproved = '1' and p1.cIsTemplate = '0' and p1.cIsActive = '1' and (p1.cIsSystemPage = 0) order by p1.cID asc limit 0,200 ")
On Remove Old Page Versions:
----------------------------
mysql error: [1242: Subquery returns more than 1 row] in EXECUTE("select p1.cID, pt.ctHandle from Pages p1 left join Pages p2 on (p1.cPointerID = p2.cID) left join PageTypes pt on (pt.ctID = (if (p2.cID is null, p1.ctID, p2.ctID))) 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)) 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 cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and p1.cIsActive = '1' and (p1.cIsSystemPage = 0 or p2.cIsSystemPage = 0) limit 0,3 ")
I have already re-installed the system but I keep getting this error. Any idea what's going on? Is there a way to resolve this?
Now the Automatic jobs are running without generating any error.
I now have another issue though. Still with the Full Sitemap. Whenever I move pages to a parent after few successful moves, everthing in the sitemap except the top-level "Home" disappear. Then when I add a new page to Home, everything appears back again. After few moves again, the whole thing repeats. So everytime I want to move something, I have to create a dummy page first. Is this a bug?