Reload Error

Posted: Thu Feb 28, 2008 4:18 am

I backed up my database and tried to reload it on my new hosting providers site and I get these errors:

Quote:

# --------------------------------------------------------
#
# Table structure for table 'nuke_nsnst_tracked_ips'
#
CREATE TABLE nuke_nsnst_tracked_ips(

tid int( 10 ) NOT NULL AUTO_INCREMENT ,
ip_addr varchar( 15 ) NOT NULL ,
ip_long int( 10 ) unsigned DEFAULT '0' NOT NULL ,
user_id int( 11 ) DEFAULT '1' NOT NULL ,
username varchar( 60 ) NOT NULL ,
user_agent text NOT NULL ,
refered_from text NOT NULL ,
date int( 20 ) DEFAULT '0' NOT NULL ,
page text NOT NULL ,
x_forward_for varchar( 32 ) NOT NULL ,
client_ip varchar( 32 ) NOT NULL ,
remote_addr varchar( 32 ) NOT NULL ,
remote_port varchar( 11 ) NOT NULL ,
request_method varchar( 10 ) NOT NULL ,
c2cchar( 2 ) DEFAULT '00' NOT NULL ,
PRIMARY KEY ( tid ) ,
KEY ip_addr( ip_addr ) ,
KEY ip_long( ip_long ) ,
KEY user_id( user_id ) ,
KEY username( username ) ,
KEY user_agent( user_agent ) ,
KEY refered_from( refered_from ) ,
KEY date( date ) ,
KEY page( page ) ,
KEY c2c( c2c )
);

MySQL said:

#1170 - BLOB/TEXT column 'user_agent' used in key specification without a key length

How can I stop them so I can finish my database load. I really don't want to redo everything.

Thank you

registered · Posted: Thu Feb 28, 2008 7:41 am

Remove the line

Code:




KEY user_agent( user_agent ) ,

Posted: Thu Feb 28, 2008 3:33 pm

I got another error for the referred from field. I removed that and now get #1072 - Key column 'refered_from' doesn't exist in table