XFileSharing Pro - download error

Message
Author
laurencefrazerreeves
Posts: 23
Joined: Nov 26, 2010 5:06 pm

download error

#1 Postby laurencefrazerreeves » Mar 15, 2011 12:17 am

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.

User avatar
PilgrimX182
Posts: 2186
Joined: Mar 22, 2006 1:39 pm

#2 Postby PilgrimX182 » Mar 15, 2011 12:57 pm

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
Posts: 174
Joined: Mar 02, 2011 7:00 pm

#3 Postby verzing » Jul 28, 2011 7:31 am

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

verzing
Posts: 174
Joined: Mar 02, 2011 7:00 pm

#4 Postby verzing » Jul 28, 2011 7:42 am

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

verzing
Posts: 174
Joined: Mar 02, 2011 7:00 pm

#5 Postby verzing » Aug 02, 2011 8:13 pm

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
Posts: 1054
Joined: Mar 10, 2009 2:34 am

#6 Postby ankurs » Aug 03, 2011 7:04 am

verzing wrote:Does I lost anything if I drop table ip2file ?
nope
verzing wrote: can drop or empty table ip2files ?
empty it