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

    I tried several times to install Modx Revo 2.0.0 on a Windows machine with the following specs:

    - Windows Server 2008 SP2
    - IIS 7 with FastCGI
    - MySQL 5.1.42 (Strict Mode: Disabled)
    - PHP 5.2.8 with php_pdo.dll and php_pdo_mysql.dll extensions enabled
    - Folders: /core/packages, /core/cache, /core/export, /manager, and /connectors are writable.

    The Installation Summary page shows no problems at all, but after clicking the Install button I get:

    PHP Warning:  PDO::query() [<a href='pdo.query'>pdo.query</a>]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'modx200.modx_access_actions' doesn't exist in C:\McWebSites\modx200\core\xpdo\xpdo.class.php on line 1796
    PHP Warning:  PDO::query() [<a href='pdo.query'>pdo.query</a>]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'modx200.modx_access_actiondom' doesn't exist in C:\McWebSites\modx200\core\xpdo\xpdo.class.php on line 1796
    PHP Warning:  PDO::query() [<a href='pdo.query'>pdo.query</a>]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'modx200.modx_access_context' doesn't exist in C:\McWebSites\modx200\core\xpdo\xpdo.class.php on line 1796
    PHP Warning:  PDO::query() [<a href='pdo.query'>pdo.query</a>]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'modx200.modx_access_elements' doesn't exist in C:\McWebSites\modx200\core\xpdo\xpdo.class.php on line 1796
    PHP Warning:  PDO::query() [<a href='pdo.query'>pdo.query</a>]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'modx200.modx_access_menus' doesn't exist in C:\McWebSites\modx200\core\xpdo\xpdo.class.php on line 1796
    PHP Warning:  PDO::query() [<a href='pdo.query'>pdo.query</a>]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'modx200.modx_access_permissions' doesn't exist in C:\McWebSites\modx200\core\xpdo\xpdo.class.php on line 1796
    PHP Warning:  PDO::query() [<a href='pdo.query'>pdo.query</a>]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'modx200.modx_access_policies' doesn't exist in C:\McWebSites\modx200\core\xpdo\xpdo.class.php on line 1796
    PHP Warning:  PDO::query() [<a href='pdo.query'>pdo.query</a>]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'modx200.modx_access_resources' doesn't exist in C:\McWebSites\modx200\core\xpdo\xpdo.class.php on line 1796
    PHP Warning:  PDO::query() [<a href='pdo.query'>pdo.query</a>]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'modx200.modx_access_resource_groups' doesn't exist in C:\McWebSites\modx200\core\xpdo\xpdo.class.php on line 1796
    PHP Warning:  PDO::query() [<a href='pdo.query'>pdo.query</a>]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'modx200.modx_access_templatevars' doesn't exist in C:\McWebSites\modx200\core\xpdo\xpdo.class.php on line 1796
    PHP Warning:  PDO::query() [<a href='pdo.query'>pdo.query</a>]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'modx200.modx_actions' doesn't exist in C:\McWebSites\modx200\core\xpdo\xpdo.class.php on line 1796
    PHP Warning:  PDO::query() [<a href='pdo.query'>pdo.query</a>]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'modx200.modx_actiondom' doesn't exist in C:\McWebSites\modx200\core\xpdo\xpdo.class.php on line 1796
    PHP Warning:  PDO::query() [<a href='pdo.query'>pdo.query</a>]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'modx200.modx_active_users' doesn't exist in C:\McWebSites\modx200\core\xpdo\xpdo.class.php on line 1796
    PHP Warning:  PDO::query() [<a href='pdo.query'>pdo.query</a>]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'modx200.modx_categories' doesn't exist in C:\McWebSites\modx200\core\xpdo\xpdo.class.php on line 1796
    PHP Warning:  PDO::query() [<a href='pdo.query'>pdo.query</a>]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'modx200.modx_site_htmlsnippets' doesn't exist in C:\McWebSites\modx200\core\xpdo\xpdo.class.php on line 1796
    etc
    etc
    etc


    I can’t wait to install & test the new Revo but this problem is preventing me from happiness. Anyone has an idea of what the problem could be? (note: Modx Evolution has always worked flawlessly on this same server)

    Thanks,

    Mc
      • 37550 ☆ A M B ☆
      • 711 Posts
      Hi,

      In phpinfo(); what version is your mysql client API? Also have you confirmed that the PDO libraries are loaded in phpinfo?

      Thanks
        http://www.onesmarthost.co.uk
        UK MODX Hosting with love.
        • 18878
        • 210 Posts
        Quote from: Onesmarthost at Jul 26, 2010, 02:11 PM

        Hi,

        In phpinfo(); what version is your mysql client API? Also have you confirmed that the PDO libraries are loaded in phpinfo?

        Thanks

        Hi,

        This is what I got from phpinfo:

        mysql
        MySQL Support enabled
        Active Persistent Links 0
        Active Links 0
        Client API version 5.0.51a

        mysqli
        MysqlI Support enabled
        Client API library version 5.0.51a
        Client API header version 5.0.51a
        MYSQLI_SOCKET /tmp/mysql.sock

        PDO
        PDO support enabled
        PDO drivers mysql

        pdo_mysql
        PDO Driver for MySQL, client library version 5.0.51a

        Is that ok?

        Thanks.

        Mc
          • 37550 ☆ A M B ☆
          • 711 Posts
          Ah,

          This is the same issue I ran into your PHP is using client API 5.0.51 which does not work with MODx, even though your PHP Version is higher.

          My problem was down to libmysql.dll in the PHP Directory.

          As a test rename this and do an IISReset command on your server, if all goes well PHP will load the correct libmysql.dll from your MySQL folder.

          If it still reports wrong, you will need to upgrade your PHP Version to fully fix the issue which is what I ended up doing.

          Let me know how it goes.

          Thanks Aaron
            http://www.onesmarthost.co.uk
            UK MODX Hosting with love.
            • 18698
            • 12 Posts
            Hey Aaron,

            I don’t know if this is the problem here...I am getting the exact same error, which I posted in another thread, and my settings check out. I even downgraded my PHP version on the off chance that 5.3 and higher was the problem, but it doesn’t seem to want to work. Here are my specs that show during the pre-installation check. All the other ones check out too:

            Checking PHP version: OK! Running: 5.2.5

            Checking MySQL server version: OK! Running: 5.1.48-community

            Checking MySQL client version: OK! Running: 5.0.45

            Any thoughts?