Page List Bug

Permalink
I created a page list and added a custom template for thumbnails. The first thumbnail was the wrong image and I couldn't get the page list to refresh to find the right image. I deleted the page list in order to start over. Now when I try to add the page list the radial buttons that let you choose where the page list comes from (everywhere, under this page, under a certain page) don't work. I can click the radials and the button moves but no options appear. I can't choose where the page list is generated from.

Update: I tried going around this issue by creating a page list in a scrapbook and adding it that way but I'm haveing the same problem there. I also tried adding Page Lists to other pages on my site - in every instance I am unable to use the radials to determine from where the page list is populated. YIKES!
Any Ideas? Are there some db tables I could delete or empty to get this working again?

cannonf700
 
guythomas replied on at Permalink Reply
guythomas
Clear the Concrete5 cache and see if that helps. If not, download the concrete5 install again and just copy over the concrete/blocks/pagelist directory. If that doesn't fix it, it's fubar'd!
cannonf700 replied on at Permalink Reply
cannonf700
Cache cleared and Page_list block reloaded but still no love.
Anyone with thoughts? This Page List is a critical piece of the design and I'm road blocked until I can get it resolved.
guythomas replied on at Permalink Reply
guythomas
Try going into the add functionality page, then click the page list "Edit" button. Then "Refresh" the database schema.
cannonf700 replied on at Permalink Reply
cannonf700
Still Nothing.
It's even worse. I tried restoring a back-up I made of the site (via dashboard) about two weeks ago and it the restore failed and destroyed my website. now all I get is this error:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1054: Unknown column 'Pages.cPointerExternalLinkNewWindow' in 'field list'] in EXECUTE("select Pages.cID, Pages.pkgID, Pages.cPointerID, Pages.cPointerExternalLink, Pages.cPointerExternalLinkNewWindow, Pages.cFilename, Collections.cDateAdded, Pages.cDisplayOrder, Collections.cDateModified, cInheritPermissionsFromCID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cPendingAction, cPendingActionUID, cPendingActionTargetCID, cPendingActionDatetime, cCheckedOutUID, cIsTemplate, uID, cPath, Pages.ctID, ctHandle, ctIcon, ptID, cParentID, cChildren, ctName, cCacheFullPageContent, cCacheFullPageContentOverrideLifetime, cCacheFullPageContentLifetimeCustom from Pages inner join Collections on Pages.cID = Collections.cID left join PageTypes on (PageTypes.ctID = Pages.ctID) left join PagePaths on (Pages.cID = PagePaths.cID and PagePaths.ppIsCanonical = 1) where Pages.cID = '128'") ' in /home/rynomed1/public_html/rynomediaonline.com/updates/concrete5 in /home/rynomed1/public_html/rynomediaonline.com/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
guythomas replied on at Permalink Reply
guythomas
you may check to see if your web host does automatic backups as well. It would probably only work if they backed up both your files and your database though.

Did you uninstall any block types between that backup and now?
cannonf700 replied on at Permalink Reply
cannonf700
guythomas,
Thanks so much for all your help. The error came from trying to restore a db backup from 5.4.1 on top of 5.4.1.1.
I'm back in the site but after clearing cache, and all this other stuff - still no luck with the Page_List block. Very weird.