барохлит статистика

сборка l2j-eqal
собствено статистика выдаёт ошибки,
прмиеры ошибок

Ошибка запроса (95.169.186.19, eqgs):
SELECT `characters`.`obj_Id` AS `charId`, `characters`.`account_name` AS `account_name`, `characters`.`clanid` AS `clanid`, `characters`.`lastAccess` AS `lastAccess`, `characters`.`accesslevel` AS `accessLevel`, `characters`.`char_name` AS `char_name`, `characters`.`online` AS `online`, `characters`.`level` AS `level`, `characters`.`sex` AS `sex`, `characters`.`pvpkills` AS `pvpkills`, `characters`.`pkkills` AS `pkkills`, `characters`.`onlinetime` AS `onlinetime`, `characters`.`base_class` AS `base_class`, `characters`.`exp` AS `exp`, `characters`.`sp` AS `sp`, `characters`.`race` AS `race`, `characters`.`karma` AS `karma`, `characters`.`maxHp` AS `maxHp`, `characters`.`maxMp` AS `maxMp`, `characters`.`x` AS `x`, `characters`.`y` AS `y`, `characters`.`z` AS `z`, `characters`.`nobless` AS `nobless`, `characters`.`title` AS `title`, `items`.`item_id` FROM `items` LEFT JOIN `characters` ON `characters`.`charId` = `items`.`owner_id` WHERE `items`.`item_id` = '8689' OR `items`.`item_id` = '8190'

1054, Unknown column 'characters.charId' in 'on clause'
такое в общей но такое не всегда выскакивает

Ошибка запроса (95.169.186.19, eqgs):
SELECT `clan_data`.`clan_id` AS `clan_id`, `clan_data`.`clan_name` AS `clan_name`, `clan_data`.`ally_id` AS `ally_id`, `clan_data`.`ally_name` AS `ally_name`, `clan_data`.`clan_level` AS `clan_level`, `clan_data`.`reputation_score` AS `reputation_score`, `clan_data`.`leader_id` AS `leader_id`, `characters`.`obj_Id` AS `charId`, `characters`.`account_name` AS `account_name`, `characters`.`clanid` AS `clanid`, `characters`.`lastAccess` AS `lastAccess`, `characters`.`accesslevel` AS `accessLevel`, `characters`.`char_name` AS `char_name`, `characters`.`online` AS `online`, `characters`.`level` AS `level`, `characters`.`sex` AS `sex`, `characters`.`pvpkills` AS `pvpkills`, `characters`.`pkkills` AS `pkkills`, `characters`.`onlinetime` AS `onlinetime`, `characters`.`base_class` AS `base_class`, `characters`.`exp` AS `exp`, `characters`.`sp` AS `sp`, `characters`.`race` AS `race`, `characters`.`karma` AS `karma`, `characters`.`maxHp` AS `maxHp`, `characters`.`maxMp` AS `maxMp`, `characters`.`x` AS `x`, `characters`.`y` AS `y`, `characters`.`z` AS `z`, `characters`.`nobless` AS `nobless`, `characters`.`title` AS `title`, csum, ccount, cavg FROM clan_data LEFT JOIN characters ON clan_data.leader_id=characters.charId LEFT JOIN ( SELECT clanid, SUM(level) AS csum, count(level) AS ccount, AVG(level) AS cavg FROM characters WHERE clanid GROUP BY clanid ) AS levels ON clan_data.clan_id = levels.clanid ORDER BY csum DESC LIMIT 10

1054, Unknown column 'characters.charId' in 'on clause'

Такое у кланов

ап

Unknown column 'characters.charId' - как бэ неизвестная колонка, мб статистика под другую структуру базы сделана!?)

скорее всео есть у когонить под l2j-eqal

Unknown column 'characters.charId' in 'on clause'

Открой в навикане таблицу characters и посмотри как пишется столбец где находится ид чара.
Скорее всего у тебя просто столбец называется objId или obj_Id, или char_Id.
Если стлбик называется не charId, то тебе придётся переписывать скрипт под свою сборку.

Жестокий запрос.

Pikovit: собствено статистика выдаёт ошибки,
прмиеры ошибок

1054, Unknown column 'characters.charId' in 'on clause'
такое в общей но такое не всегда выскакивает

1054, Unknown column 'characters.charId' in 'on clause'

Такое у кланов