Database Error : 1.51 with Roster 1.7.3 b2 svn[559]

Scans for, and displays main/alt relations in your Guild

Moderator: PleegWat

Database Error : 1.51 with Roster 1.7.3 b2 svn[559]

Postby m80falcon » Thu Feb 01, 2007 9:08 pm

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
m80falcon
WR.net Apprentice
WR.net Apprentice
 
Posts: 17
Joined: Fri Jul 07, 2006 8:23 pm

Database Error : 1.51 with Roster 1.7.3 b2 svn[559]

Postby PleegWat » Fri Feb 02, 2007 6:51 am

Yes. That is a column that got deleted for 1.7.3; it's part of the old honour system. I have already fixed AltMonitor for this bug, but I'm not pushing the result yet because 1.7.3 isn't released yet. You can get a 1.7.3b2 compatible version of AltMonitor in the addon SVN repository. Check for info at http://www.wowroster.net/addon_repository/
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm


Return to AltMonitor

Who is online

Users browsing this forum: No registered users and 0 guests

cron