Blank character pages

by **Akiri** » Wed Jul 18, 2007 5:41 am

Hello,

I'm experimenting with wowroster in the hopes to get it setup for my guild. I have setup a roster on a private internal webserver that can't be accessed from the internet to play with.

I am running Apache 2.2.4, MySQL 5.0.37 and php 5.2.1 with GD support. I have loaded wowroster 1.7.3 with no addons and have the wowdb.php patch installed.

I have successfully uploaded a GP lua and all my guild members are listed on the roster main page. I then uploaded a CP lua and the information is present in the database and additional info is present on the roster main page as well as the Honor, stats, and professions pages, but when I click on my character's name I'm presented with a blank page with nothing but the Header image, nav bar and a line that reads last update: Tue Jul 17th, 8:42pm.

I have looked all over this site for a possible solution and have even tried completely removing wowroster and dropping the MySQL database and starting over and have the same issue every time.

I'm using CP 2.1.1 and GP 2.1.0 both downloaded from RPGO this morning.

I'm really at a lose, any help that can be given would be great. Thanks.

by **zanix** » Wed Jul 18, 2007 8:59 am

It's hard to say without a link to your roster
Check the servers error log and see if there are errors in memberdetails.php, or lib/char.php

by **tuigii** » Wed Jul 18, 2007 2:03 pm

Activate SQL debug option (and the other 2 ones for that matter).
Do you have somting like this ? :

SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Papy team' AND `server` = 'Khaz Modan'
SELECT a.*, b.*, c.guild_name FROM `roster_players` a, `roster_members` b, `roster_guild` c WHERE a.member_id = b.member_id AND a.name = 'Nowwhat' AND a.server = 'Khaz Modan' AND a.guild_id = c.guild_id
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Nowwhat'
SELECT * FROM `roster_players` WHERE `name` = 'Nowwhat' AND `server` = 'Khaz Modan'
SELECT * FROM `roster_pets` WHERE `member_id` = '21' order by `level` DESC
SELECT * FROM `roster_items` WHERE `member_id` = 21 AND `item_slot` = 'Head'
.....
[SNIP]
SELECT * FROM `roster_talents` where `member_id` = '21' and `tree` = 'Protection' and `column` = '4' and `row` ='6'
SELECT * FROM `roster_talents` where `member_id` = '21' and `tree` = 'Protection' and `column` = '4' and `row` ='7'
SELECT * FROM `roster_talents` where `member_id` = '21' and `tree` = 'Protection' and `column` = '4' and `row` ='8'
SELECT * FROM `roster_talents` where `member_id` = '21' and `tree` = 'Protection' and `column` = '4' and `row` ='9'
SELECT i.item_tooltip, i.item_name, i.item_color, p.parry, p.dodge, p.block, p.crit, p.mitigation, p.clientLocale
FROM `roster_items` i, `roster_players` p
WHERE i.item_parent = 'equip'
and i.member_id = p.member_id
and p.name = 'Nowwhat'
and p.server = 'Khaz Modan'
SELECT b.name, b.icon, b.tooltip FROM `roster_buffs` b, `roster_players` p WHERE b.member_id = p.member_id and p.name = 'Nowwhat' and p.server = 'Khaz Modan' ORDER BY b.name ASC;

If it's the case, then SQL is doing fine, no need to hassle with the tables.
Double check the presents of SELECT statements after SELECT `dateupdatedutc` .....

Can you consult the other personnal pages - sacs, mail, etc ?

by **Akiri** » Thu Jul 19, 2007 12:57 am

Here is a copy of the last lines in my httpd error_log.

http://172.25.168.33/roster/char.php?name=Akiri&server=Earthen+Ring&action=mail
[Tue Jul 17 11:15:00 2007] [error] [client 172.25.168.107] PHP Fatal error: Call to undefined function utf8_decode() in /home/chris/web/roster/lib/recipes.php on line 48, referer: http://172.25.168.33/roster/char.php?na ... ion=quests
[Tue Jul 17 11:15:01 2007] [error] [client 172.25.168.107] PHP Fatal error: Call to undefined function utf8_decode() in /home/chris/web/roster/lib/item.php on line 57, referer: http://172.25.168.33/roster/char.php?na ... on=recipes
[Tue Jul 17 11:19:19 2007] [error] [client 172.25.168.107] PHP Fatal error: Call to undefined function utf8_decode() in /home/chris/web/roster/lib/item.php on line 57, referer: http://172.25.168.33/roster/char.php?na ... ction=bags
[Tue Jul 17 11:19:22 2007] [error] [client 172.25.168.107] PHP Fatal error: Call to undefined function utf8_decode() in /home/chris/web/roster/lib/item.php on line 57, referer: http://172.25.168.33/roster/char.php?na ... =spellbook
[Tue Jul 17 11:19:24 2007] [error] [client 172.25.168.107] PHP Fatal error: Call to undefined function utf8_decode() in /home/chris/web/roster/lib/item.php on line 57, referer: http://172.25.168.33/roster/char.php?na ... =spellbook
[Tue Jul 17 11:20:01 2007] [error] [client 172.25.168.107] PHP Fatal error: Call to undefined function utf8_decode() in /home/chris/web/roster/lib/item.php on line 57, referer: http://172.25.168.33/roster/char.php?na ... =spellbook
[Tue Jul 17 11:21:30 2007] [error] [client 172.25.168.107] PHP Fatal error: Call to undefined function utf8_decode() in /home/chris/web/roster/lib/recipes.php on line 48, referer: http://172.25.168.33/roster/char.php?na ... =spellbook
[Tue Jul 17 11:21:33 2007] [error] [client 172.25.168.107] PHP Fatal error: Call to undefined function utf8_decode() in /home/chris/web/roster/lib/char.php on line 213, referer: http://172.25.168.33/roster/char.php?na ... on=recipes
[Tue Jul 17 11:21:49 2007] [error] [client 172.25.168.107] PHP Fatal error: Call to undefined function utf8_decode() in /home/chris/web/roster/lib/item.php on line 57, referer: http://172.25.168.33/roster/char.php?na ... ction=mail
[Tue Jul 17 11:22:51 2007] [error] [client 172.25.168.107] PHP Fatal error: Call to undefined function utf8_decode() in /home/chris/web/roster/lib/item.php on line 57, referer: http://172.25.168.33/roster/char.php?na ... =spellbook
[Tue Jul 17 11:27:56 2007] [error] [client 172.25.168.107] PHP Fatal error: Call to undefined function utf8_decode() in /home/chris/web/roster/lib/item.php on line 57, referer: http://172.25.168.33/roster/char.php?na ... =character

I have the sql debug windows turned on, but on the character detail pages it doesn't show up. Here is a screenshot of what it is doing.

Thanks for the quick responses.

by **Akiri** » Thu Jul 19, 2007 1:46 am

Good news, seems that the utf8 functions are part of the php xml package which wasn't installed by default on the server. I installed that package and now everything is working great.