How to use topic trees in page lists without massive error? Help please
Permalink
I need help or else I have to eventually abandon my entire website.
So I was finally forced to make a new topic tree because, as I found out, when you make them too big they start breaking and not working correctly. So I made a new topic tree for a specific section of my website, I added all the pages to their appropriate topics, and then when I finally go to update the page lists, it breaks the entire site. If I use any topic from the new topic tree in any page list it gives the errors I include in this post and in the screenshots.
Once I add the new page list with the second topic tree the entire block disappears, if I refresh the page then the page is permanently broken and cannot be accessed, it only gives the error information. The only way out of this is to duplicate a previous version of the page using the sitemap.
As far as I can tell it's something about where the page lists are stored, and concrete 5 maybe is expecting the page list to be in the default place for the first page list and secondary page lists are not where it's expecting so then it destroyed the entire page every time it tries to build it. That's about as much as I can glean from the error but I'm not an expert on concrete 5 code and how it goes together.
Please, I need somebody to help me with this or else I have to abandon my website. I have to be able to use new topic trees in page lists or else my website is unsustainable. Does anyone know how to fix this? I'd love if there was a simple fix to something that shouldn't be a problem in the first place, but at this point I'm even willing to try difficult fixes. I'm not the best at coding but I will do my best to fix this any way I can, but I desperately need assistance on this one or it's all over for my website development.
I included screenshots of the error page and here's the main chunk of code from the error message
I am using the latest version of Concrete5.
So I was finally forced to make a new topic tree because, as I found out, when you make them too big they start breaking and not working correctly. So I made a new topic tree for a specific section of my website, I added all the pages to their appropriate topics, and then when I finally go to update the page lists, it breaks the entire site. If I use any topic from the new topic tree in any page list it gives the errors I include in this post and in the screenshots.
Once I add the new page list with the second topic tree the entire block disappears, if I refresh the page then the page is permanently broken and cannot be accessed, it only gives the error information. The only way out of this is to duplicate a previous version of the page using the sitemap.
As far as I can tell it's something about where the page lists are stored, and concrete 5 maybe is expecting the page list to be in the default place for the first page list and secondary page lists are not where it's expecting so then it destroyed the entire page every time it tries to build it. That's about as much as I can glean from the error but I'm not an expert on concrete 5 code and how it goes together.
Please, I need somebody to help me with this or else I have to abandon my website. I have to be able to use new topic trees in page lists or else my website is unsustainable. Does anyone know how to fix this? I'd love if there was a simple fix to something that shouldn't be a problem in the first place, but at this point I'm even willing to try difficult fixes. I'm not the best at coding but I will do my best to fix this any way I can, but I desperately need assistance on this one or it's all over for my website development.
I included screenshots of the error page and here's the main chunk of code from the error message
Doctrine \ DBAL \ Exception \ InvalidFieldNameException An exception occurred while executing 'SELECT p.cID FROM Pages p LEFT JOIN PagePaths pp ON (p.cID = pp.cID and pp.ppIsCanonical = true) LEFT JOIN PageSearchIndex psi ON p.cID = psi.cID LEFT JOIN PageTypes pt ON p.ptID = pt.ptID INNER JOIN Collections c ON p.cID = c.cID INNER JOIN CollectionVersions cv ON p.cID = cv.cID LEFT JOIN CollectionSearchIndexAttributes csi ON c.cID = csi.cID WHERE (cvName != ?) AND (ak_Minecraft_Seeds LIKE ?) AND (ak_exclude_page_list <> 1 or ak_exclude_page_list is null) AND (p.cPointerID < 1) AND (p.cIsTemplate = 0) AND (cv.cvIsApproved = 1) AND ((cv.cvPublishDate IS NULL) OR (cv.cvPublishDate <= ?)) AND ((cv.cvPublishEndDate IS NULL) OR (cv.cvPublishEndDate >= ?)) AND (p.cIsActive = ?) AND (p.siteTreeID = 1) AND (p.cIsSystemPage = 0) ORDER BY p.cDisplayOrder asc LIMIT 5 OFFSET 0' with params ["", "%||\/Java\/Version\/1.15.1%||", "2020-01-30 18:59:29", "2020-01-30 18:59:29", true]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ak_Minecraft_Seeds' in 'where clause' Previous exceptions SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ak_Minecraft_Seeds' in 'where clause' (42S22) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ak_Minecraft_Seeds' in 'where clause' (42S22)
I am using the latest version of Concrete5.
Thank god you helped. I'm so happy not only that I got a reply, but that it was something simple. I renamed the page list all lower case with no underscores and it magically fixed it all.
I have another page list that has capital letters and underscores but works, which makes me think this may have actually been a one time error. We'll see if it holds up once I repopulate the list again. It might break again when I put all the pages back into it, but we'll see. Either way at least there's a chance it may work now. If not I'll be back to this forum again lol.
I have another page list that has capital letters and underscores but works, which makes me think this may have actually been a one time error. We'll see if it holds up once I repopulate the list again. It might break again when I put all the pages back into it, but we'll see. Either way at least there's a chance it may work now. If not I'll be back to this forum again lol.
it seems you gave your topic tree the handle Minecraft_Seeds and it's not finding it. It says it doesn't exist.
Normally handles should all be lowercase as in minecraft_seeds, not Minecraft_Seeds
I am not sure that would have an impact but the first thing to do is make sure you have been consistent with your handles.