Installation issue v1.0.6

[Chrispy]

Your Portal Version: v1.0.6
Your phpBB Type: Standard phpBB3
MODs installed: No
Your knowledge: Beginner

What have you done before the problem was there?
Installed a fresh phpBB bulletin board

What have you already tryed to solve the problem?
Searched google.com, board3.de and phpbb.com. Unfortunately no solution found.

Description and Message
L.S.

I tried to install Board3 Portal v1.0.6 on a freshly installed phpBB 3.0.7-PL1 bulletin board which is running on Windows Server 2008 R2 with IIS 7.5 and SQL Server 2008 R2 Express.

When i go to install/index.php I have a message on the top of the page which says:

[phpBB Debug] PHP Notice: in file /install/index.php on line 135: Undefined variable: sql

When I continue to the Install tab and click on Proceed to next step I receive the message:

Information
Sorry, unsupported Databases found.

Is SQL Server 2008 R2 Express supported or is this a result of a configuration error?

Regards,

Christian

[Marc]

I'll take a look at it and see what I can do.

[Marc]

Ok, it would be great if you could help me on this one.
Open install/index.php
Find:

Code: Select all

        /**
        * Get tables of a database
        */
        function get_tables($db)
        {
            switch ($db->sql_layer)
            { 

Replace with:

Code: Select all

        /**
        * Get tables of a database
        */
        function get_tables($db)
        {
            echo $db->sql_layer;
            switch ($db->sql_layer)
            { 

When you access the installer, you should now see some information displayed in the top left corner. Post that output here and undo the changes. Then I can tell you what you need to do to fix this.

[Chrispy]

Hi Marc,

Here is the requested information from the top left corner:

mssqlnative[phpBB Debug] PHP Notice: in file /install/index.php on line 136: Undefined variable: sql

Regards,

Christian

[Marc]

Open install/index.php
Find:

Code: Select all

				case 'mssql':
				case 'mssql_odbc':
					$sql = "SELECT name
						FROM sysobjects
						WHERE type='U'";
				break;

Replace with:

Code: Select all

				case 'mssql':
				case 'mssql_odbc':
				case 'mssqlnative':
					$sql = "SELECT name
						FROM sysobjects
						WHERE type='U'";
				break;

[Chrispy]

Hello Marc,

Sorry for not getting back on this a bit earlier. Been a crazy time last month but I finally found some time to continue on this.

I have editied install/index.php as descibed in your post. This resolved the error message in the Overview and Install tab.

Unforunately, when I click Proceed to next step I receive a message:
Sorry, unsupported Databases found

I decided to look further in the other files that are located in the install directory and changed the following:

In install/install_functions.php I changed:

Code: Select all

		case 'mssql':
		case 'mssql_odbc':
			$return['db_schema'] = 'mssql';
			$return['delimiter'] = 'GO';
		break;

into:

Code: Select all

		case 'mssql':
		case 'mssql_odbc':
		case 'mssqlnative':
			$return['db_schema'] = 'mssql';
			$return['delimiter'] = 'GO';
		break;

Unfortunately this resulted in a white screen with one single line:
The service is unavailable

Can you please assist me further in this matter?

Regards,

Christian

[Marc]

I think MSSQLNATIVE causes errors in phpBB 3.0.7-PL1. You might want to update to phpBB 3.0.8.

[Chrispy]

Hi Marc,

I forgot to mention it but I got this message on 3.0.7-PL1 aswell on 3.0.8. I updated phpBB yesterday after I got this message.

If the problem is related to phpBB and SQL Server 2008 R2 Express, wouldn't my forum have a problem with functionality also?

Regards,

Christian

[Marc]

Open install/install_functions.php
Find:

Code: Select all

		case 'mssql':
		case 'mssql_odbc':
			$return['db_schema'] = 'mssql';
			$return['delimiter'] = 'GO';
		break;

Replace with:

Code: Select all

		case 'mssql':
		case 'mssql_odbc':
		case 'mssqlnative':
			$return['db_schema'] = 'mssql';
			$return['delimiter'] = 'GO';
		break;

[Chrispy]

Hi Marc,

Thank you for your time but I allready tried that (2 posts above).

I have tried to digg a bit further and in install_functions.php I also changed the following without any success :

Code: Select all

function b3p_drop_table($table)
{
	global $db, $table_prefix, $db_schema;

	$table_name = substr($table . '#', 6, -1);

	if ($db->sql_layer != 'mssql' && $db->sql_layer != 'mssql_odbc')

Into

Code: Select all

function b3p_drop_table($table)
{
	global $db, $table_prefix, $db_schema;

	$table_name = substr($table . '#', 6, -1);

	if ($db->sql_layer != 'mssql' && $db->sql_layer != 'mssql_odbc' && $db->sql_layer != 'mssqlnative')

If needed I'm willing to give you access to my test environment with IIS 7.5 and SQL Server 2008 R2 Express as I have the idea that that configuration is not used much. Neither for phpBB as for Board3 as a portal. It will be fully available if needed.

Regards,

Christian

[Marc]

That would be great. Could you contact me via PM?

[Chrispy]

You got a PM.

[Chrispy]

Marc has done a great job by getting Board3 working on IIS7.5 and Microsoft SQL server 2008 R2 Express. Here are the steps that has to be followed to get a successfull installation:

In the install folder:

index.php

Find:

Code: Select all

				case 'mssql':
				case 'mssql_odbc':
					$sql = "SELECT name
						FROM sysobjects
						WHERE type='U'";
				break;

Change it into:

Code: Select all

				case 'mssql':
				case 'mssql_odbc':
				case 'mssqlnative':
					$sql = "SELECT name
						FROM sysobjects
						WHERE type='U'";
				break;

install_functions.php

Find:

Code: Select all

		case 'mssql':
		case 'mssql_odbc':
			$return['db_schema'] = 'mssql';
			$return['delimiter'] = 'GO';
		break;

Add after:

Code: Select all

		case 'mssqlnative':
			$return['db_schema'] = 'mssqlnative';
			$return['delimiter'] = 'GO';
		break;

Find:

Code: Select all

	if ($db->sql_layer != 'mssql' && $db->sql_layer != 'mssql_odbc')
	{
		$sql = 'DROP TABLE IF EXISTS ' . $table_prefix . $table_name;
		$result = $db->sql_query($sql);
		$db->sql_freeresult($result);
	}

Change it into:

Code: Select all

	if ($db->sql_layer != 'mssql' && $db->sql_layer != 'mssql_odbc' && $db->sql_layer != 'mssqlnative')
	{
		$sql = 'DROP TABLE IF EXISTS ' . $table_prefix . $table_name;
		$result = $db->sql_query($sql);
		$db->sql_freeresult($result);
	}

In the install/schemas/phpbb_portal_config folder:

Create a file named:

_mssqlnative_schema.sql

Add:

Code: Select all

/*

 $Id: _mssql_schema.sql 447 2009-01-22 17:56:58Z Christian_N $

*/

/*
	Table: 'phpbb_portal_config'
*/
CREATE TABLE [phpbb_portal_config] (
	[config_name] [varchar] (255) DEFAULT ('') NOT NULL ,
	[config_value] [text] DEFAULT ('') NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [phpbb_portal_config] WITH NOCHECK ADD 
	CONSTRAINT [PK_phpbb_portal_config] PRIMARY KEY  CLUSTERED 
	(
		[config_name]
	)  ON [PRIMARY] 
GO

In the portal/block folder:

birthday_list.php

Find:

Code: Select all

		case 'mssql':
		case 'mssql_odbc':
			$order_by = 'u.user_birthday ASC';
		break;

Change it into:

Code: Select all

		case 'mssql':
		case 'mssql_odbc':
		case 'mssqlnative':
			$order_by = 'u.user_birthday ASC';
		break;

Besides of these changes you should follow the instal.xml found inside the installation package. This should result in a successfull installation.

To make portal.php the default page you should add portal.php to the Default document of your website in the IIS Management Console. Also make sure when encountering any problems to set the Error Pages settings to Detailed for your website in IIS Management Console.