SQL Server Code for Drupal 5 Released

Configuring Drupal 6.2 to work with MS SQL Server

Using the code from:
https://code.launchpad.net/~drupal-sql-server/pressflow/drupal-sql-serve...

My current system configuration:
1. Windows XP Service pack 3
2. Apache/2.2.16 (Win32) PHP/5.3.5 – installed from the zip files not using an installer, PHP was thread safe VC6 x86
3. SQL Server Express 2008
4. Drupal 6.2 core

I had already had Apache and PHP running and configured. We were checking out Drupal 6 to use as our CMS and we have support for MS SQL Server and had to see if we could use the two together.

I went through the basic Drupal set up, copied the Drupal files into a folder under the web root. I set up a database on SQL Server, created a user for it. I made the user authenticate against SQL Server, and set it as the default database then copied and renamed default.settings.php to settings.php. The rest of the steps are where I had to do some modifications.

I searched around quite a bit and perhaps I missed the easy install steps but I just did not see them so I found the URL above and used that to create a few files and modify a few.

In /includes I did the following;
1. Created: install.sqlsrv.inc – used the code from the link to make this file.
2. Created: database.sqlsrv.inc – used the code from the link to make the file.
3. Edited – all from the link:
a. Menu.inc
b. Install.inc
c. Bootstrap.inc

Once I had these files in place I started the install as usual, going to the install.php in /drupal6 (or the directory you placed the files in.). This is the point where I had my only issue. During this process at the beginning I received an error stating:
“You cannot cannot declare db_distinct_field() twice”. I looked for the duplicates and found:

In database.sqlsrv.inc @ line 554 (could vary):
//changed 02/17/2011
/**
* Wraps the given table.field entry with a DISTINCT(). The wrapper is added to
* the SELECT list entry of the given query and the resulting query is returned.
* This function only applies the wrapper if a DISTINCT doesn't already exist in
* the query.
*
* @param $table Table containing the field to set as DISTINCT
* @param $field Field to set as DISTINCT
* @param $query Query to apply the wrapper to
* @return SQL query with the DISTINCT wrapper surrounding the given table.field.

function db_distinct_field($table, $field, $query) {
$field_to_select = "DISTINCT ON ($table.$field) $table.$field";
// (?<!foo) is to avoid rewriting queries that already use DISTINCT
$query = preg_replace(
"/(SELECT.)(?:$table.|\s)(?<!DISTINCT()(?<!DISTINCT($table.)$field(.FROM )/AUsi",
'\1 '. $field_to_select .'\2',
$query
);
return $query;
}

In database.inc @ line 391 (could vary)
/**
* Adds the DISTINCT flag to the supplied query and returns the altered query.
*
* The supplied query should not contain a DISTINCT flag. This will not, and
* never did guarantee that you will obtain distinct values of $table.$field.
*
* @param $table
* Unused. Kept to retain API compatibility.
* @param $field
* Unused. Kept to retain API compatibility.
* @param $query
* Query to which the DISTINCT flag should be applied.
*
* @return
* SQL query with the DISTINCT flag set.
/
function db_distinct_field($table, $field, $query) {
$matches = array();
if (!preg_match('/^SELECT\sDISTINCT/i', $query, $matches)) {
// Only add distinct to the outer SELECT to avoid messing up subqueries.
$query = preg_replace('/^SELECT/i', 'SELECT DISTINCT', $query);
}

return $query;
}

I commented out the function in the database.sqlsrv.inc. I did not have any problems with the rest of the install.
I also set up mod_rewrite for clean URL’s. I used the httpd.conf file in Apache and not the .htaccess file.

Uncomment: LoadModule rewrite_module modules/mod_rewrite.so

Add:

added: 02/17/2011

Various rewrite rules.

RewriteEngine on
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d

notice the line below I have my drupal6 installed in the drupal6 directory.

RewriteRule ^(.*)$ /drupal6/index.php?q=$1 [L,QSA]

You must have this after some of the other directives in the conf, so if you get http errors move it under any server/directory information in the file. You can find the rewrite rules on the Drupal site.