View Single Post
FroL
Member
Join Date: Jul 2007
Old 10-12-2007 , 02:58   Re: SourceBans (1.0.0 RC1d)
#107

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
__________________

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 .

Last edited by FroL; 10-12-2007 at 05:36.
FroL is offline