WordPress.org

Ready to get started?Download WordPress

Forums

WP Db Abstraction
Changes to 1.1.4 to run with 3.3.2 on MSSQL (1 post)

  1. kamelek
    Member
    Posted 2 years ago #

    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)

    http://wordpress.org/extend/plugins/wordpress-database-abstraction/

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.