PHP Forum Installation

Discussion in 'HTML / PHP / JavaScript / CSS' started by mervynj, Dec 1, 2005.

  1. 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
     
  2. 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
     
  3. 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?
     
  4. Bruce

    Bruce DiscountASP.NET Staff

    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
     
  5. Bruce

    Bruce DiscountASP.NET Staff

    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
     

Share This Page