We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 21054
    • 78 Posts
    [post originally posted on the support page]

    I’ve just upgraded from version 0.9.6.1 to 0.9.6.3

    Everything seemed fine... until I clicked on an item on the menu and received this message:
    -------------------------
    « MODx Parse Error »
    MODx encountered the following error while attempting to parse the requested resource:
    « Execution of a query to the database failed - Unknown column ’Array’ in ’where clause’ »
          SQL: SELECT sc.id,sc.parent,sc.pagetitle,sc.longtitle,sc.menutitle,sc.description,sc.published,sc.hidemenu FROM `modx_her`.`modx_site_content` sc LEFT JOIN `modx_her`.`modx_document_groups` dg on dg.document = sc.id WHERE (sc.id=Array ) AND (sc.privateweb=0) LIMIT 1
          [Copy SQL to ClipBoard]

    Parser timing
      MySQL:    0.0062 s  (4 Requests)
      PHP:    0.0546 s 
      Total:    0.0608 s
    -------------------------

    It loads the home page okay from the root, but getting to any page through the menu (run by Wayfinder 2.0) brings up that error. 
    This error also occurs when I try to access a page directly using its URL. ie. http://www.domain.com/index.php?id=47

    I’m using wayfinder like this: [!Wayfinder? &startId=`0` &hideSubMenus=1 !]

    Is this related to UltimateParent? I know some people have had this issue based on having duplicates of a snippet, but this isn’t the case with me.

    Thanks in advance!

    These are the stats of our server:


    Apache version 1.3.41 (Unix)
    PHP version 4.4.8
    MySQL version 4.1.22-standard-log
    Operating system Linux