We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 40045
    • 534 Posts
    Quote from: goldsky at Dec 09, 2010, 11:02 AM

    This is solved by a dirty hack, thanks to Peter.

    Quote from: D-Force at Dec 09, 2010, 07:02 AM

    Hi, Give this a try,

    Modify the following file "core/xpdo/om/mysql/xpdomanager.class.php"

    @line 296 change the following code
    $sql .= ")";

    Into:
    $sql .= ") ENGINE=MYISAM";

    // Best wishes Peter


    That did the trick.
    Thanks Peter! grin

    Not quite sure yet, maybe I’m doing the whole upgrade process wrong? Just for the protocol: Do I need to upload everything in the modx-2.0.5pl archive to the server and overwrite every old file (from 2.0.4pl2) on the server? What happens to the downloaded packages, do I have to reinstall them after the upgrade?

    The above mentioned file (xpdomanager.class.php") in 2.0.4pl2 had this line on line 247 and it said
     $sql .= ") TYPE={$tableType}";


    in the same file in the 2.0.5pl Archive it says on line 296
    $sql .= ")";
    which should be changed to
    $sql .= ") ENGINE=MYISAM";
    as suggested above...

    I’m really no expert but wouldn’t the 2.0.4pl2 line be the better choice i.e.
    $sql .= ") TYPE={$tableType}";
    because the variable $tableType does also exist int he 2.0.5pl file...and the default of this variable is MyISAM, so wouldn’t the result be the same?
      • 11055 ☆ A M B ☆
      • 3,112 Posts
      Are you using other than MyISAM database engine?
        Rico
        Genius is one percent inspiration and ninety-nine percent perspiration. Thomas A. Edison
        MODx is great, but knowing how to use it well makes it perfect!

        www.virtudraft.com

        Security, security, security! | Indonesian MODx Forum | MODx Revo's cheatsheets | MODx Evo's cheatsheets

        Author of Easy 2 Gallery 1.4.x, PHPTidy, spieFeed, FileDownload R, Upload To Users CMP, Inherit Template TV, LexRating, ExerPlan, Lingua, virtuNewsletter, Grid Class Key, SmartTag, prevNext

        Maintainter/contributor of Babel

        Because it's hard to follow all topics on the forum, PING ME ON TWITTER @_goldsky if you need my help.
        • 40045
        • 534 Posts
        nope, I use standard MyISAM...
          • 22303 MODX Staff
          • 10,725 Posts
          Then this shouldn’t be relevant. This is an issue ONLY if your MySQL database is configured with something other than MyISAM as the default storage engine.
            • 19568
            • 11 Posts
            Just as an update: Ran into this error while using the 2.0.6-pl release on 1/4/11. Peter’s hack above fixed the problem though. Happy X-ing!

            Millibit
              ModX. 'nuff said.