MySQL Bugs: #40589: I can't install phpBB

Bug #40589	I can't install phpBB
Submitted:	8 Nov 2008 14:01	Modified:	8 Nov 2008 15:27
Reporter:	Camilo Peuela	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S2 (Serious)
Version:	6.0	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	install, phpBB

Description:
I can't install phpBB (latest stable version on november 8,2008), I run the phpBB installer web-based application, but when this php application tries to execute its .sql mysql installer, the following error message appears:

A fatal and unrecoverable database error has occurred. This may be because the specified user does not have appropriate permissions 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.

install_install.php [ 1194 ]

SQL : CREATE TABLE phpbb_config ( config_name varchar(255) DEFAULT '' NOT NULL, config_value varchar(255) DEFAULT '' NOT NULL, is_dynamic tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (config_name), KEY is_dynamic (is_dynamic) ) CHARACTER SET `utf8` COLLATE `utf8_bin`

Specified key was too long; max key length is 767 bytes

Please pay attention to the error message displayed by MySql (Specified key was too long; max key length is 767 bytes)

How to repeat:
Everytime I try to install phpBB

For now I will use MySql 5, please reply to me as soon as possible when this bug has been deleted.

Thank you.

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.