Сообщений в теме: 8

[erevo2]

Ошибку можно видеть тут http://banswhat.myar...9&advType=admin

 

Дебаг 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) as gag_count, UNIX_TIMESTAMP() as c_time FROM sb_comms AS CO FORCE INDE' at line 5

SQL Query type: EXECUTE
Script: '/index.php'
SQL Query: SELECT CO.bid ban_id, CO.type, CO.authid, CO.name player_name, created ban_created, ends ban_ends, length ban_length, reason ban_reason, CO.ureason unban_reason, CO.aid, AD.gid AS gid, adminIp, CO.sid ban_server, RemovedOn, RemovedBy, RemoveType row_type, SE.ip server_ip, AD.user admin_name, MO.icon as mod_icon, CAST(MID(CO.authid, 9, 1) AS UNSIGNED) + CAST('76561197960265728' AS UNSIGNED) + CAST(MID(CO.authid, 11, 10) * 2 AS UNSIGNED) AS community_id, (SELECT count(*) FROM sb_comms as BH WHERE (BH.authid = CO.authid AND BH.authid != '' AND BH.authid IS NOT NULL AND BH.type = 1)) as mute_count, (SELECT count(*) FROM sb_comms as BH WHERE (BH.authid = CO.authid AND BH.authid != '' AND BH.authid IS NOT NULL AND )) as gag_count, UNIX_TIMESTAMP() as c_time FROM sb_comms AS CO FORCE INDEX (created) LEFT JOIN sb_servers AS SE ON SE.sid = CO.sid LEFT JOIN sb_mods AS MO on SE.modid = MO.mid LEFT JOIN sb_admins AS AD ON CO.aid = AD.aid WHERE CO.aid='39' ORDER BY CO.created DESC LIMIT 0,30
SQL Params: 

 

 

 

Вот текс ошибки

[onik89]

 

Ошибку можно видеть тут http://banswhat.myar...9&advType=admin

 

Дебаг 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) as gag_count, UNIX_TIMESTAMP() as c_time FROM sb_comms AS CO FORCE INDE' at line 5

SQL Query type: EXECUTE
Script: '/index.php'
SQL Query: SELECT CO.bid ban_id, CO.type, CO.authid, CO.name player_name, created ban_created, ends ban_ends, length ban_length, reason ban_reason, CO.ureason unban_reason, CO.aid, AD.gid AS gid, adminIp, CO.sid ban_server, RemovedOn, RemovedBy, RemoveType row_type, SE.ip server_ip, AD.user admin_name, MO.icon as mod_icon, CAST(MID(CO.authid, 9, 1) AS UNSIGNED) + CAST('76561197960265728' AS UNSIGNED) + CAST(MID(CO.authid, 11, 10) * 2 AS UNSIGNED) AS community_id, (SELECT count(*) FROM sb_comms as BH WHERE (BH.authid = CO.authid AND BH.authid != '' AND BH.authid IS NOT NULL AND BH.type = 1)) as mute_count, (SELECT count(*) FROM sb_comms as BH WHERE (BH.authid = CO.authid AND BH.authid != '' AND BH.authid IS NOT NULL AND )) as gag_count, UNIX_TIMESTAMP() as c_time FROM sb_comms AS CO FORCE INDEX (created) LEFT JOIN sb_servers AS SE ON SE.sid = CO.sid LEFT JOIN sb_mods AS MO on SE.modid = MO.mid LEFT JOIN sb_admins AS AD ON CO.aid = AD.aid WHERE CO.aid='39' ORDER BY CO.created DESC LIMIT 0,30
SQL Params: 

 

 

 

Вот текс ошибки

 

Сделай SQL запрос

 

Скрытый текст

CREATE TABLE `sb_comms` (
`bid` int(6) NOT NULL AUTO_INCREMENT,
`authid` varchar(64) NOT NULL,
`name` varchar(128) NOT NULL DEFAULT 'unnamed',
`created` int(11) NOT NULL DEFAULT '0',
`ends` int(11) NOT NULL DEFAULT '0',
`length` int(10) NOT NULL DEFAULT '0',
`reason` text NOT NULL,
`aid` int(6) NOT NULL DEFAULT '0',
`adminIp` varchar(32) NOT NULL DEFAULT '',
`sid` int(6) NOT NULL DEFAULT '0',
`RemovedBy` int(8) DEFAULT NULL,
`RemoveType` varchar(3) DEFAULT NULL,
`RemovedOn` int(11) DEFAULT NULL,
`type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1 - Mute, 2 - Gag',
`ureason` text,
PRIMARY KEY (`bid`),
KEY `authid` (`authid`),
KEY `created` (`created`),
KEY `RemoveType` (`RemoveType`),
KEY `type` (`type`),
KEY `sid` (`sid`),
KEY `aid` (`aid`),
FULLTEXT KEY `authid_2` (`authid`),
FULLTEXT KEY `name` (`name`),
FULLTEXT KEY `reason` (`reason`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Сообщение отредактировал onik89: 03 Февраль 2016 - 15:42

[erevo2]

Сделай SQL запрос

 

Скрытый текст

CREATE TABLE `sb_comms` (
`bid` int(6) NOT NULL AUTO_INCREMENT,
`authid` varchar(64) NOT NULL,
`name` varchar(128) NOT NULL DEFAULT 'unnamed',
`created` int(11) NOT NULL DEFAULT '0',
`ends` int(11) NOT NULL DEFAULT '0',
`length` int(10) NOT NULL DEFAULT '0',
`reason` text NOT NULL,
`aid` int(6) NOT NULL DEFAULT '0',
`adminIp` varchar(32) NOT NULL DEFAULT '',
`sid` int(6) NOT NULL DEFAULT '0',
`RemovedBy` int(8) DEFAULT NULL,
`RemoveType` varchar(3) DEFAULT NULL,
`RemovedOn` int(11) DEFAULT NULL,
`type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1 - Mute, 2 - Gag',
`ureason` text,
PRIMARY KEY (`bid`),
KEY `authid` (`authid`),
KEY `created` (`created`),
KEY `RemoveType` (`RemoveType`),
KEY `type` (`type`),
KEY `sid` (`sid`),
KEY `aid` (`aid`),
FULLTEXT KEY `authid_2` (`authid`),
FULLTEXT KEY `name` (`name`),
FULLTEXT KEY `reason` (`reason`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Я сделал

Сделай SQL запрос

 

Скрытый текст

CREATE TABLE `sb_comms` (
`bid` int(6) NOT NULL AUTO_INCREMENT,
`authid` varchar(64) NOT NULL,
`name` varchar(128) NOT NULL DEFAULT 'unnamed',
`created` int(11) NOT NULL DEFAULT '0',
`ends` int(11) NOT NULL DEFAULT '0',
`length` int(10) NOT NULL DEFAULT '0',
`reason` text NOT NULL,
`aid` int(6) NOT NULL DEFAULT '0',
`adminIp` varchar(32) NOT NULL DEFAULT '',
`sid` int(6) NOT NULL DEFAULT '0',
`RemovedBy` int(8) DEFAULT NULL,
`RemoveType` varchar(3) DEFAULT NULL,
`RemovedOn` int(11) DEFAULT NULL,
`type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1 - Mute, 2 - Gag',
`ureason` text,
PRIMARY KEY (`bid`),
KEY `authid` (`authid`),
KEY `created` (`created`),
KEY `RemoveType` (`RemoveType`),
KEY `type` (`type`),
KEY `sid` (`sid`),
KEY `aid` (`aid`),
FULLTEXT KEY `authid_2` (`authid`),
FULLTEXT KEY `name` (`name`),
FULLTEXT KEY `reason` (`reason`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Но не работает

[onik89]

Я сделал

Но не работает

Ты заходил на свой сб?

[erevo2]

Ты заходил на свой сб?

Всмысле?

[onik89]

Всмысле?

После SQL запроса все работает

[erevo2]

Ошибка осталась

После SQL запроса все работает

Ошибка осталась

После SQL запроса все работает

Поиск по мутам не работает

[onik89]

Ошибка осталась

Ошибка осталась

Поиск по мутам не работает

Вот

[erevo2]

Вот

Огромное спасибо