I need some help troubleshooting a problem with the RealmStatus plugin for my roster, which can be seen here:

http://www.powerandtheglory.net/roster/index.php

As you can see, it says "No Status" and has not worked since I upgraded the forums to 1.7.1.

In checking the MySQL table, I notice that there is no data in the "roster_realmstatus" table. The structure looks to be correct, but there are no records in the table. My guess is that something is not right with the scrape of Blizzard's XML file, but I'm not sure how to check that.

Any suggestions?

BTW, I have done some searching on the forums, but haven't found much in the way of clues as to my problem. Cenarion Circle is on a US server, and doesn't have any accents or special characters that other folks were having problems with.

Nelinaa,

At this moment in time, If you are on a European Server, I would not try and fix the Status plugin until wow-europe get their act together, and finally fix The RealmStatus page. It's been down all week.

If you are on a US Server and running on a Windows Server. There is a known problem with Regular Expressions which contain a lot of recursion.
I have posted on another thread, a version of the Realmstatus page, that I use myself. Though my Roster is on a European Server that currently says down.

Thanks for the quick reply. I edited my original post, probably while you were typing your reply. A note to those who jump to the last reply in the thread:

My roster is running on a *nix server, not Windows, and is trying to get status from a US realm.

Another problem that I am encountering with the upgraded 1.7.1 roster is the following error message that I receive when running the Roster Config Diagnostic:

DB Error, could not list tables
MySQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1' at line 1

Diagnostics report the following variables relevant to the RealmStatus addon:

Code: Select all

server_name_comp     Off
guild_name            The Power and the Glory
server_name           Cenarion Circle
use_update_triggers    On
realmstatus_url       http://www.worldofwarcraft.com/realmstatus/status.xml
realmstatus           Uses server_name
rs_mode               On


Seems to be working for me at the moment
http://cvsroster.homeip.net/roster1x/tr ... status.php

Do me a favor, change the following things in realmstatus, and view it by itself and give me the results

realmstatus.php
Find

Code: Select all

$timer = 10; 

Replace

Code: Select all

$timer = 1; 

This makes the script get status on every refresh

Find

Code: Select all

        if( $xml_parse->parse($url) )
        { 

Replace

Code: Select all

        if( $xml_parse->parse($url) )
        {
            print_r($xml_parse->output);die(); 

This will cause realmstatus to spit out the contents of the xml feed
Attatch the output as a text file, if any

I've made the suggested edits to a renamed file:

http://www.powerandtheglory.net/roster/realmstatus2.php

As you can see, it does not produce a text file, which makes me suspect that the program is not actually able to get to the XML feed for some reason...

allow_url_fopen is on for your server
This is the only setting that I would think is restricting realmstatus
Unless you have CURL on your server and it's not working correctly

Realmstatus tries curl first before fopen

Here's the thing: it was working on this server before upgrading to 1.7.2. What changed in RealmStatus between .1 and .2? Anything?

After doing some more "debugging" I've discovered that "$realmData" appears to be unset or empty. I tested this a variety of ways, eventually leading me back to find that "$url" was empty as well.

Code: Select all

// URL for status page
   $url = $roster_conf['realmstatus_url'];
        print_r ($url->output);die();


The above gets a blank page. It's possible that I'm not using the debug code correctly, because I'm relatively new to PHP, but something's not right...

Try this

Code: Select all

// URL for status page
   $url = $roster_conf['realmstatus_url'];
        print_r ($url);die(); 

$url is a variable, not a class so it doesn't have methods

Usually something like $url->output means that $url would be an instance of a class and output would be a function (method) of that class

Further investigation pinpoints where my RealmStatus is failing:

Code: Select all

$xml_parse =& new xmlParser();
$err = 1;

if( $xml_parse->parse($url) )  <---fails here


For some reason, it never makes it past that first IF statement. If I'm reading the code right, this sets $err = 1, which executes the rest of the code, but writing nothing to the database.

How would I go about troubleshooting the XML parser?

BTW, I did discover that curl was not enabled in PHP. I enabled it, with no change. I also went into the MySQL table and manually added some data to see if the image generation was working properly. It is, as the original code now produces a server status equivalent to the data I entered manually, but no timestamp.

The xml parser seems to be failing

Change that part of the code

Code: Select all

$xml_parse =& new xmlParser();
$err = 1;
if( $xml_parse->parse($url) )
{ 

To this

Code: Select all

$xml_parse =& new xmlParser();
$err = 1;
$xml_parse->parse($url);
print $xml_parse->message;
die();
if( $xml_parse->parse($url) )
{ 

Nothing prints out...

Well crap then....

Ack! Don't give up! We're soooo close, I can smell the updated RealmStatus! Perhaps something's changed in the xmlparser from .1 to .2?

I'm not giving up yet...
I am just out of ideas for the moment