Bug tracker

This ticket has been moved to our new tracker. Open Ticket PHPBB3-278 now.

[MSSQL7] Fatal SQL-error on installation (fix completed in vcs)

Fatal installation error

A fatal and unrecoverable database error has occured. This may be because the specified user does not have appropriate rights to CREATE TABLES or INSERT data, etc. Further information may be given below. Please contact your hosting provider in the first instance or the support forums of phpBB for further assistance.

d:\programme\apache group\apache\htdocs\phpbb2\install\install.php [ 1100 ]

SQL : ALTER TABLE [phpbb_sessions] WITH NOCHECK ADD CONSTRAINT [DF_sessik_key_id] DEFAULT ('0') FOR [key_id], CONSTRAINT [DF_sessik_user_id] DEFAULT (0) FOR [user_id], CONSTRAINT [DF_sessik_last_ip] DEFAULT ('0') FOR [last_ip], CONSTRAINT [DF_sessik_last_login] DEFAULT (0) FOR [last_login]

[Microsoft][ODBC SQL Server Driver][SQL Server]DEFAULT für Spalte 'key_id' konnte nicht erstellt werden, da dies keine gültige Spalte in Tabelle 'phpbb_sessions' ist.

Comments / History

Linked ticket with changeset: r3609

Action performed by Anonymous (I am too lazy to register) on Mar 7th 2003, 19:32

Posted by StefanKlose on Mar 29th 2006, 15:22

Translation DE-EN:
SQL-Server: Could not create DEFAULT value for 'key_id', because 'key_id' isn't a valid column in table 'phpbb_sessions'

Ticket details

Related SVN changesets