 |
Member
|

10-15-2007
, 10:33
Re: SourceBans (1.0.0 RC1d)
|
#116
|
Quote:
Originally Posted by FroL
When I add a ban to list, I have an error in web:
Code:
Debug
Table '.\sourcebans\sb_banhistory' is marked as crashed and last (automatic?) repair failed
SQL Query type: EXECUTE
Script: '/bans/index.php'
SQL Query: SELECT SE.ip as server_ip ,SE.port as server_port ,MO.icon as mod_icon ,AD.user as admin_name ,BN.* FROM ( SELECT 'B' as row_type ,BA.bid as ban_id ,BA.ip as ban_ip ,BA.authid as authid ,BA.name as player_name ,BA.created as ban_created ,BA.ends as ban_ends ,BA.length as ban_length ,BA.reason as ban_reason ,BA.aid as ban_admin ,BA.sid as ban_server ,BA.country as ban_country ,(SELECT count(*) from sb_banhistory as BH WHERE BH.authid=BA.authid) as history_count ,(SELECT count(*) FROM sb_demos as DM WHERE DM.demtype='B' and DM.demid=BA.bid) as demo_count FROM sb_bans as BA -- WHERE (`length` = '0' OR `ends` > UNIX_TIMESTAMP()) UNION SELECT 'U' as row_type ,BH.HistId as ban_id ,BH.ip as ban_ip ,BH.authid as authid ,BH.name as player_name ,BH.created as ban_created ,BH.ends as ban_ends ,BH.length as ban_length ,BH.reason as ban_reason ,BH.adminid as ban_admin ,BH.sid as ban_server ,BH.country as ban_country ,(SELECT count(*) from sb_banhistory as BH2 WHERE BH2.authid=BH.authid) as history_count ,(SELECT count(*) FROM sb_demos as DM WHERE DM.demtype='B' and DM.demid=BH.HistId) as demo_count FROM sb_banhistory BH ) as BN LEFT JOIN sb_servers AS SE ON BN.ban_server = SE.sid LEFT JOIN sb_mods AS MO on SE.modid = MO.mid LEFT JOIN sb_admins AS AD ON BN.ban_admin=AD.aid ORDER BY ban_created DESC LIMIT 0,30
SQL Params:
Table '.\sourcebans\sb_banhistory' is marked as crashed and last (automatic?) repair failed
SQL Query type: EXECUTE
Script: '/bans/index.php'
SQL Query: SELECT (count(bid) + (SELECT count(HistId) FROM sb_banhistory)) FROM sb_bans WHERE `length` = '0' OR `ends` > UNIX_TIMESTAMP()
SQL Params:
http://3smedia.net/bans/index.php?p=banlist
|
how I can fix it?
__________________
3SMedia #1 | classic gameplay | tick 100 (81.25.49.19:27015)
3SMedia #2 | pro gaming | tick 100 (81.25.49.19:27016)
3SMedia #3 | deathmatch | tick 100 (81.25.49.19:27017)
Sorry for my VERY bad english .
|
|
|
|