XFileSharing Pro - download error

[laurencefrazerreeves]

Software error:

Can't execute select:
Incorrect information in file: './chimphos_chimphos/IP2Files.frm' at Modules/DataBase.pm line 63.
For help, please send mail to the webmaster ([email protected]), giving this error message and the time and date of the error.

[PilgrimX182]

Seems your SQL table IP2Files damaged a lot.

Try to execute this from SQL console "REPAIR TABLE IP2Files;"

or re-create this table completely:

Code: Select all

DROP TABLE IP2Files;
CREATE TABLE `IP2Files` (
  `file_id` int(10) unsigned NOT NULL default '0',
  `ip` int(20) unsigned NOT NULL default '0',
  `usr_id` mediumint(8) unsigned NOT NULL default '0',
  `owner_id` mediumint(8) unsigned NOT NULL default '0',
  `size` bigint(20) unsigned NOT NULL default '0',
  `money` decimal(8,4) unsigned NOT NULL default '0.0000',
  `referer` varchar(255) NOT NULL default '',
  `created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`file_id`,`ip`,`usr_id`),
  KEY `owner` (`owner_id`),
  KEY `user` (`usr_id`),
  KEY `ip` (`ip`,`created`),
  KEY `date` (`created`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

[verzing]

if I drop table IP@Files , does it effect to all user member ? does I lose anything if I drop table ip2files ?

[verzing]

LoL, just fix it. dont need to delete anything, just restart MySQL Server to fix it.

[verzing]

Does I lost anything if I drop table ip2file ?
my ip2files table:
~2,725,864 InnoDB latin1_swedish_ci 735.5 MiB

can drop or empty table ip2files ?

[ankurs]

Does I lost anything if I drop table ip2file ?

nope

can drop or empty table ip2files ?

empty it