We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 8869
    • 32 Posts
    Hi

    Have just upgraded to 1.2.1 from 1.1 and hit an issue...

    On the left hand side the treeview of the page structure isn't loading initially (does load if I hit the refresh tree icon) and none of the icon tabs are showing to display TVs, plugins etc

    i have tried uploading the files and rerunning the install several times but nothing has worked

    The parser error displayed in red says:

    « MODX Parse Error »
    Execution of a query to the database failed - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY 5,1' at line 1
    SQL > SELECT Array FROM ORDER BY 5,1

    Error information
    Current Plugin ElementsInTree(OnManagerTreeRender)

    Basic info
    REQUEST_URI http://www.mysite.co.uk/manager/index.php?a=1&f=tree
    Manager action 1 - Loading a frame(set)
    Referer http://www.mysite.co.uk/manager/
    User Agent Mozilla/5.0 (Windows NT 10.0; WOW64; rv:51.0) Gecko/20100101 Firefox/51.0
    IP 81.1xx.xx.xx
    Current time 2017-02-16 12:51:21

    Benchmarks
    MySQL 0.0122 s (6 Requests)
    PHP 0.1818 s
    Total 0.1940 s
    Memory 3.5601272583008 mb

    Backtrace
    include_once(string $var1)
    manager/index.php on line 287
    DocumentParser->invokeEvent('OnManagerTreeRender', array $var2)
    manager/frames/tree.php on line 597
    DocumentParser->evalPlugin(string $var1, array $var2)
    manager/includes/document.parser.class.inc.php on line 4482
    eval()
    manager/includes/document.parser.class.inc.php on line 1318
    require(string $var1)
    manager/includes/document.parser.class.inc.php(1318) : eval()'d code on line 1
    include_once(string $var1)
    assets/plugins/elementsintree/plugin.elementsintree.php on line 25
    createElementsList('site_templates', 16, 'templatename')
    assets/plugins/elementsintree/includes/on_manager_tree_render.inc.php on line 28
    DBAPI->select(array $var1, NULL, '', 'ORDER BY 5,1')
    assets/plugins/elementsintree/includes/functions.inc.php on line 75
    DBAPI->query(string $var1)
    manager/includes/extenders/dbapi.mysqli.class.inc.php on line 146 [ed. note: en8scl last edited this post 7 years, 1 month ago.]