We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 22815
    • 1,097 Posts
    An issue with menu index sorting has been moved to a dedicated thread as it seems that the fault was not with AJAX Menu Index.

    If you have this issue, or if you can help, please read Problem with Menu Index Not Being Used For Sorting Properly.
      No, I don't know what OpenGeek's saying half the time either.
      MODx Documentation: The Wiki | My Wiki contributions | Main MODx Documentation
      Forum: Where to post threads about add-ons | Forum Rules
      Like MODx? donate (and/or share your resources)
      Like me? See my Amazon wishlist
      MODx "Most Promising CMS" - so appropriate!
      • 2851
      • 12 Posts
      i have this problem when i click GO!

      « MODx Parse Error »
      MODx encountered the following error while attempting to parse the requested resource:
      « 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 menuindex ASC’ at line 1 »
      SQL: SELECT id , pagetitle , parent , menuindex FROM `bigbug_modx`.modx_site_content WHERE parent = ORDER BY menuindex ASC
      [Copy SQL to ClipBoard]

      Parser timing
      MySQL: 0.0002 s s (0 Requests)
      PHP: 1159574347.6060 s s
      Total: 1159574347.6062 s s

      can you help me?
      thanks!
        |███|
        • 22303 MODX Staff
        • 10,725 Posts
        Quote from: Bastan at Sep 29, 2006, 06:51 PM
        « 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 menuindex ASC’ at line 1 »
        SQL: SELECT id , pagetitle , parent , menuindex FROM `bigbug_modx`.modx_site_content WHERE parent = ORDER BY menuindex ASC
        For some reason it’s not getting a parent folder value to use for the sorting. Were you attempting to sort items in the root of the site?
          • 12656
          • 13 Posts
          since some days I get exactly the same error. Previously it worked perfect. strange. What I did: added the favorite links module, added some more pages, a bit of content, some template changes... nothing spectacular.
            • 7291
            • 129 Posts
            also have same error

            using modx-0.9.5 and latest versions of apache, sql, php

            Does the module work with 0.9.5?
              [center]-- smiley --[/center]
              [center]New View Media - Custom Website Design[/center]
              [center]Custom Website Design & Marketing = Strategic Business![/center]
              • 6726
              • 7,075 Posts
              I have noticed this on some of my installs too, but not all of them. I’d have to sort out why some exhibit this issue and some don’t (same server, BTW).
                .: COO - Commerce Guys - Community Driven Innovation :.


                MODx est l'outil id
                • 18397
                • 3,250 Posts
                This module was integrated into the DocManager module for 0.9.5. I recommend using that instead as its been tested more extensively.
                  • 6726
                  • 7,075 Posts
                  Oops after verification sorry I was talking about TV sorting as far as I am concerned which doesn’t work when I use DocManager but it does when I use the new "Assigned Template Variables" tab when you edit a template you can sort them alright... not the same problem, Menu Index works fine.
                    .: COO - Commerce Guys - Community Driven Innovation :.


                    MODx est l'outil id
                    • 18174
                    • 116 Posts
                    sounds like a sensational module.
                    half of the users are enthousiastic the others frustrated ....

                    I just installed a plain default installation, installed Ajax Menu Index Editor as instructed.

                    When runnig the module, I get this (see picture modx1.gif).
                    (+ JS Error "MODX_MEDIA_PATH is not defined" in ./manager/media/script/modx.js)

                    When I click on a parent document or site root in the document tree (left) I just leave the module execution.
                    When I click "go", I get this (see picture modx2.gif).

                    What do I wrong? Any clues?

                    Best regards manu37
                    (modx 0.9.5)



                      • 18397
                      • 3,250 Posts
                      This module was integrated into the DocManager module, included in MODx 0.9.5 and later. I recommend using that instead as its been tested more extensively.