sqlserver/IIS support abysmal. had to hack the installer. about install HOT 9 CLOSED

After some hacking and swearing at iis

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <system.webServer>
 <rewrite>
    <rules>
        <rule name="redirect all requests" stopProcessing="true">
        <match url="^(.*)$" ignoreCase="false" />
        <conditions logicalGrouping="MatchAll">
            <add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" pattern="" ignoreCase="false" />
        </conditions>
        <action type="Rewrite" url="index.php" appendQueryString="true" />
        </rule>
    </rules>
    </rewrite>
    </system.webServer>
</configuration>

from install.

In \modules\backend\widgets\Lists.php on line 429

            $joinSql = $this->isColumnRelated($column, true)
                ? /*DbDongle::raw("group_concat(" . $sqlSelect . " separator ', ')")*/DbDongle::raw("" . $sqlSelect . " + ', '")
                : DbDongle::raw($sqlSelect);

from install.

\vendor\october\rain\src\Database\Dongle.php 145

if(this->driver === 'sqlsrv') {
return str_ireplace('isnull(', 'coalesce(', $sql);
}

from install.

\vendor\october\rain\src\Databse\Relations\DeferOneOrmany.php

->whereRaw(DbDongle::parse('id > isnull((select max(id) from '.DbDongle::getTablePrefix().'deferred_bindings where

ifnull doesn't exist in sqlserver, isnull does.

Also, why not use the check from Dongle here?

from install.

\vender\october\rain\src\Database\Relations\DeferOneOrMany.php

line 40

$query->select('*')->from('deferred_bindings')

Line 51

$query->select('*')->from('deferred_bindings')

from install.

in MediaManager.php line 978

$realpath = (empty(trim($uploadedFile->getRealPath())) ? $uploadedFile->getPath().''.$uploadedFile->getFileName() : $uploadedFile->getRealPath());
File::get($realpath)

For some reason getRealPath returns false, but patching up the string like this works fine.

from install.

File.php in \vendor\october\rain\src\Database\Attach\File.php

Line 86
$realpath = (empty(trim($uploadedFile->getRealPath())) ? $uploadedFile->getPath().''.$uploadedFile->getFileName() : $uploadedFile->getRealPath());
$this->putFile($realpath, $this->disk_name);

Line 106
$realpath = (empty(trim($uploadedFile->getRealPath())) ? $uploadedFile->getPath().''.$uploadedFile->getFileName() : $uploadedFile->getRealPath());
$this->putFile($realpath, $this->disk_name);

from install.

When the installer calls the actual config for connecting to the server with the laravel install, it has inserted the port into the configuration file, even if you left this empty in the setup.

but when you make this field empty in the config the connection string is invalid because of the surplus ,

I patched it by adding

 $dsn = str_replace('SQLEXPRESS,;','SQLEXPRESS;',$dsn);

in /vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php on line 47

less than ideal, but it works.

from install.

If this is still an issue, please log it in the main October repo.

from install.