Importing Invite database

void4ever · 12-22-2005, 06:18 PM

Hey there guys, so i'm having some trouble importing the invite sql statements to a linux box running Mysql v4.0.26

here is the error log

Query:
CREATE TABLE `invite_hosts` (
`ftp_user` varchar(255) NOT NULL default '',
`hostmask` varchar(255) NOT NULL default '',
PRIMARY KEY (`ftp_user`,`hostmask`)
)

Error occured at:2005-12-22 15:06:42
Line no.:18
Error Code: 1071 - Specified key was too long. Max key length is 500

unfortunatly i don't know jack about sql so i'm not sure how to rewrite this to fix it. I'm using the invite.sql file included with 0.6.0. And i know i got this to import once before on it's windows counterpart, same version.

Any ideas?

Void4ever