We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 5091
    • 332 Posts
    Hi, I followed closely with the Ditto tagging screencast tutorial.

    created a TVs ’myTags’, a Chunk ’storeList’, had names entered in the documents in the Tags area. I also created a tag landing page, but with or withouth this page I am getting the same parse error.

    This is the Ditt0 calls in the parent page (16)
    [[Ditto? &parents=`16` &summarize=`16` &total=`20` &tpl=`storeList` &tagDelimiter=`, ` &tagData=`myTags` &tagDocumentID=`19`]]

    and the Ditto template in Chunk:

    <div id="announce">

            <p>Store Listing: [+tagLinks+]</p>

        </div>


    I am getting this when I preview the page ID #16:
    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 ’c’ in ’order clause’ »
          SQL: SELECT DISTINCT sc.id,sc.published FROM `database name`.`site_content` sc LEFT JOIN `database name`.`document_groups` dg on dg.document = sc.id WHERE sc.id IN (17,18) AND sc.published=1 AND sc.deleted=0 AND sc.isfolder = 0 GROUP BY sc.id ORDER BY c

    what did I do wrong? Will it be anything to do with webhost’s mySql setting? I am with Media Temple.

    tgp
      • 18397
      • 3,250 Posts
      What version of Ditto and MODx are you using?

      FYI, I host all my sites with (mt) Grid Servers without any issues.
        • 5091
        • 332 Posts
        Mark, thanks so much for the prompt response.


        What version of Ditto and MODx are you using?

        Good question!

        I downloaded the ditto 2.1 beta and replaced the folder wit the 2.0.2 before I did the page. however I didn’t replaced the snippet, instead, I created another Ditto2.1 snippet embarrassed

        The error is gone now. Probably need to ask a question or two before this page goes live : grin

        Is the 2.1 Beta stable for live site?

        p/s. that Tagging screen cast is awesome. Kudos for the great job and thanks millions for presenting it to us. I hope to see more screen cast tutorials coming. Also, hope nobody throws stones on me by suggesting this: I know making screen cast takes lots of time, therefor I don’t mind to pay for screen cast so that it can make my learning curve of modx a lot easier - of course bottom line is it’s not too expensive grin. I was slowly learning Ruby on Rails, Some RoRs developers make screen cast and charge ($2 to $5 per download) per tutorial.


        tgp
          • 18397
          • 3,250 Posts
          Beta 1 or 2?
            • 5091
            • 332 Posts
            2.1.BETA2
              • 18397
              • 3,250 Posts
              Unless anyone reports any bugs, 2.1 Beta 2 will be released as 2.1 Final.