We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 28042 ☆ A M B ☆
    • 24,524 Posts
    I frequently have to do just that when I dump the database from one server to clone a system in another server; the differences in MySQL versions causes all kinds of problems. So when I dump the originating database, I run the resulting .sql file through a text editor and remove everything after the basic table definition before uploading the file to the second database.
      Studying MODX in the desert - http://sottwell.com
      Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
      Join the Slack Community - http://modx.org
      • 22303 MODX Staff
      • 10,725 Posts
      BTW, you can have phpmyadmin handle this automatically in your dumps by selecting MYSQL323 in the SQL Export Compatability drop down that is available on the Export view of the database, a part of the Structure settings (at least in the version that comes with XAMPP, 2.6.2-pl1).
        • 28042 ☆ A M B ☆
        • 24,524 Posts
        Never noticed that, not sure what version the remote servers have.
          Studying MODX in the desert - http://sottwell.com
          Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
          Join the Slack Community - http://modx.org
          • 33337
          • 3,975 Posts
          Quote from: OpenGeek at Nov 26, 2005, 07:09 PM

          BTW, you can have phpmyadmin handle this automatically in your dumps by selecting MYSQL323 in the SQL Export Compatability drop down that is available on the Export view of the database, a part of the Structure settings (at least in the version that comes with XAMPP, 2.6.2-pl1).

          Jason beat me to post.. tongue
            Zaigham R - MODX Professional | Skype | Email | Twitter

            Digging the interwebs for #MODX gems and bringing it to you. modx.link
            • 1764
            • 680 Posts
            I’m going to check in some significant QE fixes also. They should be in the next release that Jason sends out.

            Here are some of the things that should be tested in QE

            • Option to turn Manager and Help links on and off (in module configuration)
            • Multi-lingual support
            • AJAX single-checkbox TVs (including Published and Show in Menu)
            • Apply button in editor (saves changes without closing editor window)
            • Revert button in editor (undoes all of the changes you’ve applied in the editor)
              • 1764
              • 680 Posts
              I also just added a new permission that allows a logged-in manager user to view unpublished documents in the frontend. This means that with the right permissions the Preview window will actually work for unpublished documents and you will be able to use QuickEdit on unpublished documents.

              This should also be tested, be sure to check the "View unpublished documents in frontend" permission in the role editor.
                • 25663 MODX Staff
                • 12,272 Posts
                Very nice Adam. smiley
                  Ryan Thrash, MODX Co-Founder
                  Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me