|
Ped,
The db doesnot import into phpadmin without error. So I found this on a forum post on nukecoders.
To fix this, open up includes/dump.php
Find
Code:
$structure .= ") TYPE=".$statusrow['Type'];
Change to
Code:
$structure .= ") TYPE=".$statusrow['Engine'];
I made these changes but it still does not import without error. The error is now different. Below is the error I get when I try to import into phpadmim:
Error
SQL query:
CREATE TABLE `nuke_nsnst_tracked_ips` (
`tid` int( 10 ) NOT NULL AUTO_INCREMENT ,
`ip_addr` varchar( 15 ) NOT NULL default '',
`ip_long` int( 10 ) unsigned NOT NULL default '0',
`user_id` int( 11 ) NOT NULL default '1',
`username` varchar( 60 ) NOT NULL default '',
`user_agent` text NOT NULL ,
`refered_from` text NOT NULL ,
`date` int( 20 ) NOT NULL default '0',
`page` text NOT NULL ,
`x_forward_for` varchar( 32 ) NOT NULL default '',
`client_ip` varchar( 32 ) NOT NULL default '',
`remote_addr` varchar( 32 ) NOT NULL default '',
`remote_port` varchar( 11 ) NOT NULL default '',
`request_method` varchar( 10 ) NOT NULL default '',
`c2c` char( 2 ) NOT NULL default '00',
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` )
) TYPE = MYISAM AUTO_INCREMENT =4485;
MySQL said:
#1170 - BLOB/TEXT column 'user_agent' used in key specification without a key length
Any ideas? Could I get a copy of your dump.php file? NOTE: 144 of a 172 tables did import.
Thanks
|
|
|
