• Hi,
    I must run WP on MSSQL.
    Installing and running WP v3.3.2 on my Windows machine I found few changes to plugin and one to original distribution of WP.

    ———————————————————–
    Changes to plugin v1.1.4:
    ———————————————————–
    wp-content/mu-plugins/wp-db-abstraction/drivers/sqlsrv.php
    @line:350 – @sqlsrv_query(‘SET TEXTSIZE 2147483647’);
    @line:350 + @sqlsrv_query($this->dbh,’SET TEXTSIZE 2147483647′);
    @line:351 + @sqlsrv_query($this->dbh,’SET DATEFORMAT ymd’);
    //line 351 is optional – I use Polish and when not set then error while populating database with sample data during install WP)

    wp-content/mu-plugins/wp-db-abstraction/translations/sqlsrv/translations.php
    @line:283 – $query = vsprintf($query, $this->preg_data);
    @line:283 + $query = vsprintf($query, str_replace(‘`’, ”, $this->preg_data));

    wp-content/mu-plugins/wp-db-abstraction/translations/sqlsrv/translations.php
    @line:390 – if($param[0] !== “‘”) {
    @line:391 – $param = “‘$param'”;
    @line:392 – }
    @line:390 + //if($param[0] !== “‘”) {
    @line:391 + // $param = “‘$param'”;
    @line:392 + //}

    wp-content/mu-plugins/wp-db-abstraction/translations/sqlsrv/translations.php
    @line:740 – } elseif ( count($limit_matches) == 5 && $limit_matches[1] == ‘0’ ) {
    @line:740 + } elseif ( count($limit_matches) == 6 && $limit_matches[1] == ‘0’ ) {
    ———————————————————–
    Changes to WP v3.3.2:
    ———————————————————–
    wp-includes/query.php
    @line:2041 – $fields = “$wpdb->posts.*”;
    @line:2041 + $fields = “distinct $wpdb->posts.*”;
    @line:2268 – $groupby = “{$wpdb->posts}.ID”;
    @line:2268 + if($fields!==”distinct $wpdb->posts.*”) $groupby = “$fields”;

    Cheers,
    Mariusz (PL)

    https://www.ads-software.com/extend/plugins/wordpress-database-abstraction/

  • The topic ‘[Plugin: WP Db Abstraction] Changes to 1.1.4 to run with 3.3.2 on MSSQL’ is closed to new replies.