PDA

View Full Version : cjoverkil 4.1.1 and mysql table dagaged, HELP!


cmedia
29th November 2008, 11:46 PM
Hello,

i have a problem in a old cjoverkill installation, this is waht the support server told me about:

-----------------------

It appears the the cjoverkill_cheatreports and cjoverkill_blacklist tables have been damaged beyond repair. If you could contact the script authors and get the structure for these tables we can recreate them for you, which should then solve the connection error. However, the data will not be available.

----------------------

Can you help me and provide this info? structure for these tables:
cjoverkill_cheatreports
cjoverkill_blacklist
please?

i prefer try like this instead to reinstall all, because i guess if only this 2 table have lost the data
all the site for trade are still in database and if i reinstall in a fresh database/empty this one, i will lost all...

can you help me with this info?

thank you.

ICEFIRE
30th November 2008, 02:02 AM
CREATE TABLE cjoverkill_blacklist (
id int(11) NOT NULL auto_increment,
domain varchar(250) NOT NULL default '',
email varchar(250) NOT NULL default 'some@email.com',
icq varchar(50) NOT NULL default '0',
reason varchar(250) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM



CREATE TABLE cjoverkill_cheatreports (
trade_id int(11) default NULL,
hour int(2) NOT NULL default '0',
what varchar(250) NOT NULL default ''
) TYPE=MyISAM


CjOverkill always repairs tables automatically and issues a warning. If you get a table broken completely like this time it's usually either MySQL going wrong on your server, a HD full at 100% or failing.

cmedia
3rd December 2008, 07:25 AM
Thank you!!! :d