Hello everyone. I had used 1.7.2 for a while. There was only a few problems ( appearance with items in guild bank, guild title, realm status )
I have looked so long times for a fix. And decided to update to 1.7.3 because it seems the this version fixes many problems and many users reported here like that.
After the upgrade ( it was really hard for me! < noob here ) i had some problems. Some SQL warnings. I have re-installed the roster. Those SQL problems was gone. But now i have another problem. Here is the SQL code shown up when i press roster.

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`, '%a %b %D, %l:%i %p' ) AS 'last_online', `players`.`race`, `players`.`lifetimeRankName`, `players`.`lifetimeHighestRank`, IF( `players`.`lifetimeHighestRank` IS NULL OR `players`.`lifetimeHighestRank` = '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`.`class` ASC, `members`.`level` DESC, `members`.`name` ASC
File: memberslist.php
Line: 247

I did everything correct, used 1.7.2 before, there was no such problem. I configured all needed and uploaded guild etc.
What can my problem be? Should i use 1.7.2? Or can it be fixed?
By the way, there is still appearance problem with items in guild bank/Cat guild bank. But realm status is working now : )

Maybe it can help you, here is my roster:
http://www.wow-revenant.com/roster

You didn't overwrite all your files on the server

I uploaded everything again and...oh my...works great. no problem. everything is working without any problem. Even guild titles, appearance with items in guild bank, realm status...that is so...good. thank you all for that great work. Thank you all one by one. Excellent job there!

Glad it works

Hello,

I have a problem with my roster.
When I will see profession of a member, I have this error:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home.17/l/a/m/lamesang/www/Roster/lib/wowdb.php on line 136

I have the same error, when I see madeby.

Can you help me ?

Thanks

Hi,

Can you help me, the problem below always exists and that is génant for my guild which is useful itself much of the roster?