Hello,
I installed the addon without any error. I made the config and uploaded a whole new guild file. When I now click on the Mains/Twinks button I got the following error :
Database Error
1054: Unknown column 'players.RankName' in 'field list'
SQL:
SELECT `members`.`member_id`, `members`.`name`, `members`.`class`, `members`.`note`, IF( `members`.`note` IS NULL OR `members`.`note` = '', 1, 0 ) AS 'nisnull', `members`.`level`, `members`.`guild_rank`, `members`.`guild_title`, `members`.`zone`, DATE_FORMAT( `members`.`last_online`, '%d.%m. %k:%i' ) AS 'last_online', `players`.`race`, `players`.`RankName`, `players`.`RankInfo`, IF( `players`.`RankInfo` IS NULL OR `players`.`RankInfo` = '0', 1, 0 ) AS 'risnull', `players`.`exp`, `players`.`server`, `players`.`clientLocale`, IF( `alts`.`alt_type` & 2, 1, 0 ) AS 'isalt', `alts`.`alt_type`, `mains`.`name` AS 'main_name', IF( `mains`.`name` IS NULL OR `mains`.`name` = '' ,1, 0 ) AS 'nomain', IF( `mains`.`note` IS NULL OR `mains`.`note` = '', 1, 0 ) AS 'mnisnull', IF( `main_players`.`RankInfo` IS NULL OR `main_players`.`RankInfo` = '0', 1, 0 ) AS 'mrisnull' , `players`.`RankIcon`, `players`.`Rankexp`, `players`.`hearth`, IF( `players`.`hearth` IS NULL OR `players`.`hearth` = '', 1, 0 ) AS 'hisnull', IF( `main_players`.`hearth` IS NULL OR `main_players`.`hearth` = '', 1, 0 ) AS 'mhisnull', `players`.`dateupdatedutc` AS 'last_update', IF( `players`.`dateupdatedutc` IS NULL OR `players`.`dateupdatedutc` = '', 1, 0 ) AS 'luisnull', IF( `main_players`.`dateupdatedutc` IS NULL OR `main_players`.`dateupdatedutc` = '', 1, 0 ) AS 'mluisnull' FROM `roster_members` AS members LEFT JOIN `roster_players` AS players ON `members`.`member_id` = `players`.`member_id` AND `members`.`guild_id` = '1' LEFT JOIN `roster_addon_altmonitor` AS alts ON `members`.`member_id` = `alts`.`member_id` LEFT JOIN `roster_members` as mains ON `mains`.`member_id` = `alts`.`main_id` LEFT JOIN `roster_players` AS main_players ON `mains`.`member_id` = `main_players`.`member_id` AND `mains`.`guild_id` = 1 ORDER BY nomain, `mains`.`name` ASC, isalt, `members`.`name` ASC
File: altlist.php
Line: 267
Has someone an idea ?
thx