[Plugin: WP Db Abstraction] Changes to 1.1.4 to run with 3.3.2 on MSSQL
-
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.