Member list no longer shown after guild update

CharacterProfiler.lua file uploading issues

Member list no longer shown after guild update

Postby Propaganda » Fri Apr 06, 2007 1:13 am

Hi,

I've updated the guild information a few days ago and now I can no longer see the member list of the roster. Even stats and honour are missing. I always get the following error message:

Code: Select all
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` , `players`.`RankIcon`, `players`.`Rankexp`, `players`.`hearth`, IF( `players`.`hearth` IS NULL OR `players`.`hearth` = '', 1, 0 ) AS 'hisnull', `players`.`dateupdatedutc` AS 'last_update', IF( `players`.`dateupdatedutc` IS NULL OR `players`.`dateupdatedutc` = '', 1, 0 ) AS 'luisnull' FROM `roster_members` AS members LEFT JOIN `roster_players` AS players ON `members`.`member_id` = `players`.`member_id` AND `members`.`guild_id` = '1' ORDER BY `members`.`level` DESC, `members`.`name` ASC
File: memberslist.php
Line: 247
Backtrace (most recent call last):

    * File: /www/htdocs/abcd/roster/lib/commonfunctions.lib.php
          o line 248
          o function called: backtrace
    * File: /www/htdocs/abcd/roster/memberslist.php
          o line 247
          o function called: die_quietly
          o args: 1054: Unknown column 'players.RankName' in 'field list', Database Error, memberslist.php, 247, 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` , `players`.`RankIcon`, `players`.`Rankexp`, `players`.`hearth`, IF( `players`.`hearth` IS NULL OR `players`.`hearth` = '', 1, 0 ) AS 'hisnull', `players`.`dateupdatedutc` AS 'last_update', IF( `players`.`dateupdatedutc` IS NULL OR `players`.`dateupdatedutc` = '', 1, 0 ) AS 'luisnull' FROM `roster_members` AS members LEFT JOIN `roster_players` AS players ON `members`.`member_id` = `players`.`member_id` AND `members`.`guild_id` = '1' ORDER BY `members`.`level` DESC, `members`.`name` ASC
    * File: /www/htdocs/abcd/roster/index.php
          o line 174
          o function called: include_once
          o args: /www/htdocs/abcd/roster/memberslist.php


The debug entry is as following:

Code: Select all
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Im Zeichen der Wildsau' AND `server` = 'Forscherliga'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Im Zeichen der Wildsau' AND `server` ='Forscherliga'
SELECT IF(`note` LIKE '%alt%',1,0) AS 'isalt',
FLOOR(`level`/10) AS levelgroup,
COUNT(`level`) AS amount,
SUM(`level`) AS sum
FROM `roster_members`
GROUP BY isalt, levelgroup
ORDER BY isalt ASC, levelgroup DESC
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` , `players`.`RankIcon`, `players`.`Rankexp`, `players`.`hearth`, IF( `players`.`hearth` IS NULL OR `players`.`hearth` = '', 1, 0 ) AS 'hisnull', `players`.`dateupdatedutc` AS 'last_update', IF( `players`.`dateupdatedutc` IS NULL OR `players`.`dateupdatedutc` = '', 1, 0 ) AS 'luisnull' FROM `roster_members` AS members LEFT JOIN `roster_players` AS players ON `members`.`member_id` = `players`.`member_id` AND `members`.`guild_id` = '1' ORDER BY `members`.`level` DESC, `members`.`name` ASC


I've deleted the characterprofiler.lua and saved all again, but even after this upload nothing changed. Until that day everything was working fine, I never got problems.

My SQL skills are far beyond low, so unfortunately I can't fix it by myself. Can anybody help me?
Last edited by Propaganda on Fri Apr 06, 2007 1:16 am, edited 2 times in total.
Propaganda
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Mon Jan 15, 2007 2:46 pm

Member list no longer shown after guild update

Postby zanix » Fri Apr 06, 2007 8:28 am

Mostly likely you upgraded roster and didn't overwrite all the files on your server
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Member list no longer shown after guild update

Postby Propaganda » Fri Apr 06, 2007 6:01 pm

No, I've updated to 1.7.3 some weeks ago and deleted all files on the server before.
It worked fine until last week, I got no errors till then.
Propaganda
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Mon Jan 15, 2007 2:46 pm


Return to Uploading

Who is online

Users browsing this forum: No registered users and 1 guest

cron