ICEFIRE Webmaster Board  

Go Back   ICEFIRE Webmaster Board > CjOverkill Support Forum > CjOverkill General Discussion and Support

CjOverkill General Discussion and Support CjOverkill general discussion and support.

Reply
 
Thread Tools Display Modes
  #1  
Old 29th November 2008, 10:46 PM
cmedia cmedia is offline
Member
 
Join Date: Sep 2008
Posts: 36
Default cjoverkil 4.1.1 and mysql table dagaged, HELP!

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.

Last edited by cmedia; 29th November 2008 at 10:48 PM.
Reply With Quote
  #2  
Old 30th November 2008, 01:02 AM
ICEFIRE ICEFIRE is offline
Administrator
 
Join Date: Sep 2008
Location: Galaxy Media
Posts: 337
Send a message via ICQ to ICEFIRE
Default

Code:
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
Code:
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.
Reply With Quote
  #3  
Old 3rd December 2008, 06:25 AM
cmedia cmedia is offline
Member
 
Join Date: Sep 2008
Posts: 36
Default

Thank you!!! :d
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 08:42 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.