1 Topic by Rockie (edited by Rockie 2008-08-03 13:54)

  • Rockie
  • Junior Member
  • Offline
  • Registered: 2008-07-10
  • Posts: 3

Topic: Specified key was too long

Hi!

I'am trying to innstal a punbb 1.2 forum at freehostia.com/punbb/upload but i just get this error message:

[color='red']An error occured on line 1269 in file /home/www/difo.freehostia.com/punbb/upload/install.php.[/color]
PunBB reported: Unable to create indexes. Please check your configuration and try again.

Database reported: Specified key was too long; max key length is 255 bytes (Errno: 1071)

I have innstales i joomla innstaltion in the same database and the table i wan't to use don't exists, so will the punbbinnstaler make it or should i make it?

(Sorr my bad english! neutral)

  • From: Russia
  • Registered: 2007-12-13
  • Posts: 642

Re: Specified key was too long

This may help:
* http://www.xaprb.com/blog/2006/04/17/ma … -in-mysql/
* http://lists.mysql.com/mysql/179290

Seems like you have too strong mysql key length limitation (255 bytes) at your hosting. Change charset to latin1 or decrease the field length (the key is being created for).

Carpe diem

Anatoly's Website