| View previous topic :: View next topic |
| Author |
Message |
laurencefrazerreeves
Joined: 26 Nov 2010
Posts: 23
Location: united kingdom, surrey
|
 Posted: Mar 15, 2011 12:17 am Post subject: download error |
 |
|
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 (webmaster@chimphost.com), giving this error message and the time and date of the error. |
|
| Back to top |
|
 |
PilgrimX182
Joined: 22 Mar 2006
Posts: 2106
Location: UFO Lab
|
| Posted: Mar 15, 2011 12:57 pm Post subject: |
|
|
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: | 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; |
|
|
| Back to top |
|
|
verzing
Joined: 02 Mar 2011
Posts: 125
|
| Posted: Jul 28, 2011 7:31 am Post subject: |
|
|
| if I drop table IP@Files , does it effect to all user member ? does I lose anything if I drop table ip2files ? |
|
| Back to top |
|
|
verzing
Joined: 02 Mar 2011
Posts: 125
|
| Posted: Jul 28, 2011 7:42 am Post subject: |
|
|
| LoL, just fix it. dont need to delete anything, just restart MySQL Server to fix it. |
|
| Back to top |
|
|
verzing
Joined: 02 Mar 2011
Posts: 125
|
| Posted: Aug 02, 2011 8:13 pm Post subject: |
|
|
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 ? |
|
| Back to top |
|
|
ankurs
Joined: 10 Mar 2009
Posts: 604
|
| Posted: Aug 03, 2011 7:04 am Post subject: |
|
|
| verzing wrote: | | Does I lost anything if I drop table ip2file ? |
nope
| verzing wrote: |
can drop or empty table ip2files ? |
empty it |
|
| Back to top |
|
|
|
Register
Search
Profile
Log in to check your private messages
Log in
