Blank character pages

Requests, feedback, and general discussion about WoWRoster
DO NOT post topics about WoWRoster AddOns here!

Blank character pages

Postby 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.
Akiri
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Wed Jul 18, 2007 5:23 am

Blank character pages

Postby 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
Last edited by zanix on Thu Jul 19, 2007 7:54 am, edited 1 time in total.
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

Blank character pages

Postby 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 ?
User avatar
tuigii
WR.net Master
WR.net Master
 
Posts: 891
Joined: Wed Dec 27, 2006 12:57 pm
Location: Somewhere in the South Ouest of France

Blank character pages

Postby 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.
Image

Thanks for the quick responses.
Akiri
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Wed Jul 18, 2007 5:23 am

Blank character pages

Postby 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.
Akiri
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Wed Jul 18, 2007 5:23 am


Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 0 guests

cron