Steps to reproduce the issue

Installation of a module

Expected result

Installation of a module

Actual result

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'path', table '*****.dbo._menu'; column does not allow nulls. INSERT fails.SQL=INSERT INTO *******_menu VALUES ('1','1','281','282','*','main','***','index.php?option=**','component','0','','1','class:component','0','1')

System information (as much as possible)

Joomla 3.3.6

Additional comments

I insert a code in insertObject() inside JDatabaseDriverSqlsrv

/**
 * Inserts a row into a table based on an object's properties.
 *
 * @param   string  $table    The name of the database table to insert into.
 * @param   object  &$object  A reference to an object whose public properties match the table fields.
 * @param   string  $key      The name of the primary key. If provided the object property is updated.
 *
 * @return  boolean    True on success.
 *
 * @since   12.1
 * @throws  RuntimeException
 */
public function insertObject($table, &$object, $key = null)
{
    $fields = array();
    $values = array();
    $statement = 'INSERT INTO ' . $this->quoteName($table) . ' (%s) VALUES (%s)';

    foreach (get_object_vars($object) as $k => $v)
    {
        // Only process non-null scalars.
        if (is_array($v) or is_object($v) or $v === null)
        {
            continue;
        }

        if (!$this->checkFieldExists($table, $k))
        {
            continue;
        }

        if ($k[0] == '_')
        {
            // Internal field
            continue;
        }

        if ($k == $key && $key == 0)
        {
            continue;
        }

        $fields[] = $this->quoteName($k);
        $values[] = $this->Quote($v);
    }

    // Check null and not null values if have values
    if ($object instanceof JTable && $key !== null)
    {
        foreach ($object->getFields() AS $key_field => $value_field)
        {
            // if is not primary key set defaul value if not exist this value
            // for evade error "Cannot insert the value NULL into column 'XXX', 
            // table 'XXX'; column does not allow nulls.
            if (!in_array($this->quoteName($key_field), $fields) && $value_field->Null == "NO" && ((is_array($key) && !in_array($key_field, $key)) || (!is_array($key) && $key_field != $key)))
            {
                $fixed = null;
                if (gettype($value_field->Default) !== null)
                {
                    $fixed = preg_replace( "/(\A[\(][\'])|(\A[\(][\(])|([\)][\)]$)|([\'][\)]$)/i", "", $value_field->Default );
                }
                else
                {
                    switch ($value_field->Type)
                    {
                        case "char":  case "varchar":  case "text":
                        case "nchar": case "nvarchar": case "ntext":
                            $fixed = '';
                            break;

                        case "bigint":   case "numeric": case "bit":
                        case "smallint": case "decimal": case "smallmoney":
                        case "int":      case "tinyint": case "money":
                        case "int":      case "float":   case "real":
                            $fixed = 0;
                            break;  

                        default:
                            $fixed = '';
                            break;
                    }
                }

                if ($fixed !== null)
                {
                    $fields[] = $this->quoteName($key_field);
                    $values[] = $this->Quote($value_field);
                }
            }
        }
    }
    // die("");


    // Set the query and execute the insert.
    $this->setQuery(sprintf($statement, implode(',', $fields), implode(',', $values)));

    if (!$this->execute())
    {
        return false;
    }

    $id = $this->insertid();

    if ($key && $id)
    {
        $object->$key = $id;
    }

    return true;
}