FlashFXP Forums - View Single Post

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

12-22-2005, 06:18 PM
void4ever Junior Member Join Date: Nov 2005 Posts: 27	Importing Invite database 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