PHP Forum Installation

[mervynj]

Hello guys,

I am trying to install the phpBB 2 on my account. I tried installing with MS Access first - but got a series of errors so I changed the configuration to SQL Server 2000 on the installation options of phpBB.

But now I get the following error:

An error has occurred during installation
The PHP configuration on your server doesn't support the database type that you chose.

Could you guys tell me what this error means and if there's anything I can do to get the forum up and running?

Thanks in advance,

-Mervyn

[Swirl]

Iam having problems also

Who has been able to install phpBB 2.0.18 on their site?

I was trying to install it and now I get this error:

An error occurred trying to update the database
[Microsoft][ODBC SQL Server Driver][SQL Server]There is already an index on table 'phpbb_sessions_keys' named 'IX_phpbb_sessions_keys'.
(I don't see this table in the DB)

Has anyone else seen this or know of a way around it?

Swirl


CoH/CoV: Online Badge Tracker
http://www.cityinfoterminal.com

[GeekRex]

I am trying to install the latest version of phpBB2 and running into the same issues you are. It sure would be nice for someone to respond to this!! Anyone listening out there?

[bruce]

Hmm... The error seems like there's a name conflict on one of the object.

I'll try it when i have some time

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[bruce]

OK... this is a bug w/ phpbb 2.0.18

CREATE INDEX [IX_phpbb_sessions_keys] ON [phpbb_sessions_keys]([key_id], [user_id]) ON [PRIMARY]
GO

CREATE INDEX [IX_phpbb_sessions_keys] ON [phpbb_sessions_keys]([last_login]) ON [PRIMARY]
GO

The lines above try to create 2 indexes w/ the same name. To fix it, you can either

a) Update the file \install\schemas\mssql_schema.sql

change

CREATE INDEX [IX_phpbb_sessions_keys] ON [phpbb_sessions_keys]([last_login]) ON [PRIMARY]

to


CREATE INDEX [IX_phpbb_sessions_keys_1] ON [phpbb_sessions_keys]([last_login]) ON [PRIMARY]

b) Get the latest version 2.0.19

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)