Problem with moving pages in sitemap
Permalink 1 user found helpful
Since upgrading to C5 5.6.2.1 I'm not able to move / reorder pages in the sitemap anymore. The following error is thrown:
Exception Occurred: /home/abc/some/updates/concrete5.6.2.1_updater/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 mysqlt error: [1054: Unknown column 'Array' in 'where clause'] in EXECUTE("select Pages.cID, Pages.pkgID, Pages.cPointerID, Pages.cPointerExternalLink, Pages.cIsActive, Pages.cIsSystemPage, Pages.cPointerExternalLinkNewWindow, Pages.cFilename, Collections.cDateAdded, Pages.cDisplayOrder, Collections.cDateModified, cInheritPermissionsFromCID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cCheckedOutUID, cIsTemplate, uID, cPath, cParentID, cChildren, cCacheFullPageContent, cCacheFullPageContentOverrideLifetime, cCacheFullPageContentLifetimeCustom from Pages inner join Collections on Pages.cID = Collections.cID left join PagePaths on (Pages.cID = PagePaths.cID and PagePaths.ppIsCanonical = 1) where Pages.cID = Array")
(1054)
#0 /home/abc/some/updates/concrete5.6.2.1_updater/concrete/libraries/3rdparty/adodb/adodb.inc.php(1074): adodb_throw('mysqlt', 'EXECUTE', 1054, 'Unknown column ...', 'select Pages.cI...', false, Object(ADODB_mysqlt))
#1 /home/abc/some/updates/concrete5.6.2.1_updater/concrete/libraries/3rdparty/adodb/adodb.inc.php(1030): ADOConnection->_Execute('select Pages.cI...')
#2 /home/abc/some/updates/concrete5.6.2.1_updater/concrete/libraries/3rdparty/adodb/adodb.inc.php(796): ADOConnection->Execute('select Pages.cI...', Array)
#3 /home/abc/some/updates/concrete5.6.2.1_updater/concrete/core/models/page.php(66): ADOConnection->Query('select Pages.cI...', Array)
#4 /home/abc/some/updates/concrete5.6.2.1_updater/concrete/core/models/page.php(48): Concrete5_Model_Page->populatePage(Array, 'where Pages.cID...', 'RECENT')
#5 /home/abc/some/packages/language_manager/helpers/language_detect.php(96): Concrete5_Model_Page::getByID(Array)
#6 /home/abc/some/packages/language_manager/controller.php(123): LanguageDetectHelper->runDetection()
#7 /home/abc/some/updates/concrete5.6.2.1_updater/concrete/startup/packages.php(12): LanguageManagerPackage->on_start()
#8 /home/abc/some/updates/concrete5.6.2.1_updater/concrete/dispatcher.php(101): require('/home/abc/...')
#9 /home/abc/some/concrete/startup/updated_core_check.php(6): require('/home/abc/...')
#10 /home/abc/some/concrete/dispatcher.php(20): require('/home/abc/...')
#11 /home/abc/some/index.php(2): require('/home/abc/...')
#12 {main}
# concrete5 Version
5.6.2.1
# concrete5 Packages
Automatic Email Obfuscator (1.2.3), Dashboard Maximizer (2.0.4), Designer Content (3.1.1), Fancybox links (1.0), Form Tableless Layout (1.2.1), Handy Toolbar (1.0.2), Honeypot (1.0), Internationalisierung (1.2), Language Manager (1.4.3), Manual Nav (1.2), Mediaplayer - Video, Audio (1.0.3), MindNet Optimize MySQL database (1.11), Page Redirect (1.2), Page Selector Attribute (1.1), UnoSlider (1.4.1).
Exception Occurred: /home/abc/some/updates/concrete5.6.2.1_updater/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 mysqlt error: [1054: Unknown column 'Array' in 'where clause'] in EXECUTE("select Pages.cID, Pages.pkgID, Pages.cPointerID, Pages.cPointerExternalLink, Pages.cIsActive, Pages.cIsSystemPage, Pages.cPointerExternalLinkNewWindow, Pages.cFilename, Collections.cDateAdded, Pages.cDisplayOrder, Collections.cDateModified, cInheritPermissionsFromCID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cCheckedOutUID, cIsTemplate, uID, cPath, cParentID, cChildren, cCacheFullPageContent, cCacheFullPageContentOverrideLifetime, cCacheFullPageContentLifetimeCustom from Pages inner join Collections on Pages.cID = Collections.cID left join PagePaths on (Pages.cID = PagePaths.cID and PagePaths.ppIsCanonical = 1) where Pages.cID = Array")
(1054)
#0 /home/abc/some/updates/concrete5.6.2.1_updater/concrete/libraries/3rdparty/adodb/adodb.inc.php(1074): adodb_throw('mysqlt', 'EXECUTE', 1054, 'Unknown column ...', 'select Pages.cI...', false, Object(ADODB_mysqlt))
#1 /home/abc/some/updates/concrete5.6.2.1_updater/concrete/libraries/3rdparty/adodb/adodb.inc.php(1030): ADOConnection->_Execute('select Pages.cI...')
#2 /home/abc/some/updates/concrete5.6.2.1_updater/concrete/libraries/3rdparty/adodb/adodb.inc.php(796): ADOConnection->Execute('select Pages.cI...', Array)
#3 /home/abc/some/updates/concrete5.6.2.1_updater/concrete/core/models/page.php(66): ADOConnection->Query('select Pages.cI...', Array)
#4 /home/abc/some/updates/concrete5.6.2.1_updater/concrete/core/models/page.php(48): Concrete5_Model_Page->populatePage(Array, 'where Pages.cID...', 'RECENT')
#5 /home/abc/some/packages/language_manager/helpers/language_detect.php(96): Concrete5_Model_Page::getByID(Array)
#6 /home/abc/some/packages/language_manager/controller.php(123): LanguageDetectHelper->runDetection()
#7 /home/abc/some/updates/concrete5.6.2.1_updater/concrete/startup/packages.php(12): LanguageManagerPackage->on_start()
#8 /home/abc/some/updates/concrete5.6.2.1_updater/concrete/dispatcher.php(101): require('/home/abc/...')
#9 /home/abc/some/concrete/startup/updated_core_check.php(6): require('/home/abc/...')
#10 /home/abc/some/concrete/dispatcher.php(20): require('/home/abc/...')
#11 /home/abc/some/index.php(2): require('/home/abc/...')
#12 {main}
# concrete5 Version
5.6.2.1
# concrete5 Packages
Automatic Email Obfuscator (1.2.3), Dashboard Maximizer (2.0.4), Designer Content (3.1.1), Fancybox links (1.0), Form Tableless Layout (1.2.1), Handy Toolbar (1.0.2), Honeypot (1.0), Internationalisierung (1.2), Language Manager (1.4.3), Manual Nav (1.2), Mediaplayer - Video, Audio (1.0.3), MindNet Optimize MySQL database (1.11), Page Redirect (1.2), Page Selector Attribute (1.1), UnoSlider (1.4.1).
I was running the script again, but with no success. Still the same error message.
Update all your addons.
The culprit here would be an addon that has a header nav menu in it's packages on_start method.
ChadStrat
The culprit here would be an addon that has a header nav menu in it's packages on_start method.
ChadStrat
You are awesome ChadStrat. Thanks for saving me tons of time!
How do you reorder your pages? I thought I could just drag and drop where I wanted them before but now I can't.
Run the script again by going to 'yourdomain.com/index.php/tools/upgrade'.
Hopefully that will solve your problem.