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

    Im in the process of building a new website for my local sailing club and everything was going great(my first MODX experience) but last week i started getting errors.

    Every front-end page you visit triggers a error in the Error Log.

    [2013-03-24 04:43:20] (ERROR @ /index.php) Error 42S22 executing statement: 
    Array
    (
        [0] => 42S22
        [1] => 1054
        [2] => Unknown column 'name' in 'order clause'
    )


    At first i thought it was something todo with the MXCalendar plugin as it was only happening on the pages with that running but now its on every page ( the only thing running on every page is the Login plugin).

    Ive tried running the setup again and created a new database user and double checked its permissions but to no avail.

    Could anyone spread some light on this?

    Many Thanks
    Cian
      • 3749
      • 24,544 Posts
      Plugins execute on System Events, so if there's a plugin that is connected to a page-load event line OnWebPagePrender, OnParseWebDocument, OnHandleRequest, etc, its code will execute when any page is visited in the front end.

      That said, it sounds more like a problem within MODX to me. If you haven't already, try turning off the compress_js and compress_css System Settings and manually deleting all files in the core/cache directory.

      You could also have a corrupted or missing file in your install, especially if you transferred the files individually with FTP.

        Did I help you? Buy me a beer
        Get my Book: MODX:The Official Guide
        MODX info for everyone: http://bobsguides.com/modx.html
        My MODX Extras
        Bob's Guides is now hosted at A2 MODX Hosting
        • 41889
        • 10 Posts
        Ive just double checked, compress_js and compress_css are turned off and ive deleted everything in the cache directory.

        Ive also uploaded the setup folder compressed and extracted it within cpanel and ran it, but still having the same issue.

        Cheers
        Cian
          • 3749
          • 24,544 Posts
          Good. That eliminates some possibilities. What version of PHP is running on the server?
            Did I help you? Buy me a beer
            Get my Book: MODX:The Official Guide
            MODX info for everyone: http://bobsguides.com/modx.html
            My MODX Extras
            Bob's Guides is now hosted at A2 MODX Hosting
            • 41889
            • 10 Posts
            The PHP version is: 5.3.21 and MySQL version: 5.5.28
              • 3749
              • 24,544 Posts
              Do you have anything like eAccelerator or APC running to speed up the site? Some versions of them have trouble in PHP 5.3.
                Did I help you? Buy me a beer
                Get my Book: MODX:The Official Guide
                MODX info for everyone: http://bobsguides.com/modx.html
                My MODX Extras
                Bob's Guides is now hosted at A2 MODX Hosting
                • 41889
                • 10 Posts
                To my knowledge there are not any installed, is there a way to double check?
                my hosting is a reseller account on HostDime
                  • 3749
                  • 24,544 Posts
                  In the Manager: Reports -> System Info -> PhpInfo link.
                    Did I help you? Buy me a beer
                    Get my Book: MODX:The Official Guide
                    MODX info for everyone: http://bobsguides.com/modx.html
                    My MODX Extras
                    Bob's Guides is now hosted at A2 MODX Hosting