We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 9652
    • 5 Posts
    Hello!

    First off, I would like to wish everyone a Happy New Year. May this year bring joy and happiness to everyone.

    I just downloaded and installed the revolution however, I’m having errors in installation summary.
    At the very top I’m getting 4 warnings:
    Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ’settings_version’ for key 1 in C:\wamp\www\modx-2.0.6-pl\core\xpdo\om\xpdoobject.class.php on line 1293

    Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ’settings_distro’ for key 1 in C:\wamp\www\modx-2.0.6-pl\core\xpdo\om\xpdoobject.class.php on line 1293

    Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ’fida’ for key 2 in C:\wamp\www\modx-2.0.6-pl\core\xpdo\om\xpdoobject.class.php on line 1293

    Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ’BaseTemplate’ for key 2 in C:\wamp\www\modx-2.0.6-pl\core\xpdo\om\xpdoobject.class.php on line 1293

    Also, I’m getting these 2 errors:
    Error creating table for class modResource
    Error saving the default admin user.
    Array ( [0] => 00000 [1] => 1214 [2] => The used table type doesn’t support FULLTEXT indexes )

    I would really appreciate if anyone can help me.

    Thanks!
      • 8451
      • 3 Posts
      I’m getting the same last 2 errors myself, the one about the modResource error... And can’t find a solution/answer here yet...
        • 18373 ☆ A M B ☆
        • 3,141 Posts
        HEY YOU, READ THIS! If you’re posting about a bug, please state all of your Environment information in your post: Version of MODx, Traditional or Advanced distribution (for Revo), Server OS, Server Version, PHP Version, MySQL Version (client and server), is pdo_mysql installed, your Browser type and version, if you are using any opcode caching such as eAccelerator, APC, winCache, xCache, etc; any relevant errors in core/cache/logs/error.log, and any other environment data we should know. We can’t help you without that information.


        MySQL version.. PHP version... pdo_mysql installed... That notice aint there for nothing wink
          Mark Hamstra • Developer spending his days working on Premium Extras and a MODX Site Dashboard with the ability to remotely upgrade MODX and extras to make the MODX world a little better.

          Tweet me @mark_hamstra, check my infrequent blog at markhamstra.com, my slightly more frequent ramblings at MODX.today or see code at Github.
          • 8451
          • 3 Posts
          Oh, sorry, Mark - I totally forgot to go that route with things... But here’s my details:

          MODx Revolution version 2.0.6-pl2 (Traditional)
          Windows 7 running Apache/2.2.15(Win32) PHP/5.2.3 MYSQL CLIENT/5.0.37 SERVER/5.1.45 (pdo_mysql running)
          Firefox 3.6.8
            • 8451
            • 3 Posts
            Lucky for me, the update to 2.0.7 resolved the issue I was having, which was apparently the table creation when non-isam mysql is default.