Getting error when trying to sync with the armory

Sync Blizzards' Armory data with WoWRoster (addon depreciated no longer works see ApiSync)

Moderators: Ulminia, poetter

Getting error when trying to sync with the armory

Postby Shenandoah » Wed Sep 26, 2007 12:24 am

At first the page was timing out, so I figured it might be because it's trying to grab over 100 people from the armory. So I edited the config to get people lvl 60 and up and to turn on debugging. I ran it and it actually loaded the page but I got this error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/r/m/a/****/html/roster/lib/wowdb.php on line 199

It also said it found the members, but it didn't update anything.

I changed the config again to pull only lvl 65 so it would load faster and higher and now it's timing out again. Not sure what's going on.

I'm not sure if I'm doing something wrong, or if the script is just buggy and I need to tweak a few things.

Thanks for any help.

*Edit

I ran it again for players 69 and up. It gave me the same error and said it found 14 players. But the players didn't get updated in the roster. This is what the page shows:

Code: Select all
SELECT members.name , ISNULL(players.name) AS playerExists , STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') AS playerLastUpdated FROM `roster_members` members LEFT JOIN `roster_players` players ON members.name = players.name WHERE members.level >= 69 AND ( ISNULL(players.name) OR STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') <= DATE_SUB(NOW(), INTERVAL 24 HOUR) OR STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') >= DATE_ADD(NOW(), INTERVAL 1 YEAR) ) ORDER BY members.last_online DESC
Dogan   0   2007-08-11 03:07:09
Mekaochan   1   
Pellerin   0   2007-09-23 16:10:16
Palnud   0   2007-09-24 03:12:31
Michator   1   
Drgonzo   1   
Alily   1   
Cottonswab   1   
Iwoow   0   2007-08-18 01:19:06
Killerai   1   
Delaena   1   
Clevilly   1   
Gimblozzo   1   
Stleathkillz   1   
Found 14 players.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Dogan, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Dogan. Player has probably not updated in awhile.
Dogan synched: 3 seconds. Total runtime: 3 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Mekaochan, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Mekaochan. Player has probably not updated in awhile.
Mekaochan synched: 0 seconds. Total runtime: 3 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Pellerin, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Pellerin. Player has probably not updated in awhile.
Pellerin synched: 8 seconds. Total runtime: 11 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Palnud, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Palnud. Player has probably not updated in awhile.
Palnud synched: 5 seconds. Total runtime: 16 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Michator, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Michator. Player has probably not updated in awhile.
Michator synched: 1 seconds. Total runtime: 17 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Drgonzo, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Drgonzo. Player has probably not updated in awhile.
Drgonzo synched: 5 seconds. Total runtime: 22 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Alily, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Alily. Player has probably not updated in awhile.
Alily synched: 3 seconds. Total runtime: 25 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Cottonswab, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Cottonswab. Player has probably not updated in awhile.
Cottonswab synched: 5 seconds. Total runtime: 30 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Iwoow, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Iwoow. Player has probably not updated in awhile.
Iwoow synched: 0 seconds. Total runtime: 30 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Killerai, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Killerai. Player has probably not updated in awhile.
Killerai synched: 0 seconds. Total runtime: 30 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Delaena, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Delaena. Player has probably not updated in awhile.
Delaena synched: 5 seconds. Total runtime: 35 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Clevilly, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Clevilly. Player has probably not updated in awhile.
Clevilly synched: 4 seconds. Total runtime: 39 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Gimblozzo, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Gimblozzo. Player has probably not updated in awhile.
Gimblozzo synched: 4 seconds. Total runtime: 43 seconds.
GetContentCurl: armory.worldofwarcraft.com/character-sheet.xml?r=Shadowsong&n=Stleathkillz, 1, User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2, cookieLangId=en_us;
Non-Critical Error: Incomplete Data for Stleathkillz. Player has probably not updated in awhile.
Stleathkillz synched: 6 seconds. Total runtime: 49 seconds.
Last edited by Shenandoah on Wed Sep 26, 2007 12:35 am, edited 1 time in total.
User avatar
Shenandoah
WR.net Apprentice
WR.net Apprentice
 
Posts: 8
Joined: Tue Sep 25, 2007 10:07 pm

Getting error when trying to sync with the armory

Postby poetter » Wed Sep 26, 2007 12:36 am

Which version are you using?
Image
User avatar
poetter
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 462
Joined: Sat Jun 30, 2007 9:41 pm
Location: Germany/Hamburg

Re: Getting error when trying to sync with the armory

Postby Shenandoah » Wed Sep 26, 2007 1:07 am

poetter wrote:Which version are you using?


WoWRoster v1.7.3
User avatar
Shenandoah
WR.net Apprentice
WR.net Apprentice
 
Posts: 8
Joined: Tue Sep 25, 2007 10:07 pm

Getting error when trying to sync with the armory

Postby zanix » Wed Sep 26, 2007 1:26 am

I think he wants to know which version of armorysync too
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

Getting error when trying to sync with the armory

Postby poetter » Wed Sep 26, 2007 1:57 am

Yes indeed ;-)
Image
User avatar
poetter
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 462
Joined: Sat Jun 30, 2007 9:41 pm
Location: Germany/Hamburg

Getting error when trying to sync with the armory

Postby Shenandoah » Wed Sep 26, 2007 2:23 am

I can't find a version anywhere in the script, and there is no readme or anything with it, but I downloaded it from this page:

http://www.wowroster.net/Downloads/details/id=112.html
User avatar
Shenandoah
WR.net Apprentice
WR.net Apprentice
 
Posts: 8
Joined: Tue Sep 25, 2007 10:07 pm

Getting error when trying to sync with the armory

Postby poetter » Wed Sep 26, 2007 2:37 am

Ahh, i see. Try this one: Link
Image
User avatar
poetter
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 462
Joined: Sat Jun 30, 2007 9:41 pm
Location: Germany/Hamburg

Re: Getting error when trying to sync with the armory

Postby Shenandoah » Wed Sep 26, 2007 3:55 am

poetter wrote:Ahh, i see. Try this one: Link


Ok, I installed that one and it's timing out on me every time. It just goes to a blank white page and says done.

My config:

Code: Select all
$addon_conf['ArmorySync']['Host'] = "www.wowarmory.com"; //Americans use "www.wowarmory.com", European players use: "eu.wowarmory.com"
$addon_conf['ArmorySync']['MinLevel'] = 69; //The minimum level to be updated
$addon_conf['ArmorySync']['SynchCutoffTime'] = 60; //Time, in minutes.  All players who have not updated in the last (24) hours will be updated.
$addon_conf['ArmorySync']['UseCurl'] = false; //Set this to false if you want to use the original FileSocket function.
$addon_conf['ArmorySync']['DebugLevel'] = 2; //0 = no debug messages, 1 = some debug messages, 2 = verbose debug messages
$addon_conf['ArmorySync']['UpdateRoster'] = true; //Wether or not to update Roster.  Useful if you're just debugging.
$addon_conf['ArmorySync']['Locale'] = $roster_conf['roster_lang']; //The language used, but default it is the language that roster is configured to.
$addon_conf['ArmorySync']['ArmoryLocale'] = strtolower(substr($addon_conf['ArmorySync']['Locale'], 0, 2)) . "_" . strtolower(substr($addon_conf['ArmorySync']['Locale'], 2, 2)); //The Locale that armory is expecting, in the format of lowercase_lowercase (ie en_us or de_de).
$addon_conf['ArmorySync']['MemberSorting'] = "members.last_online DESC"; //alternatives are "members.update_time DESC" to use the last time the member was updated
$addon_conf['ArmorySync']['ServerMonth'] = array("January","February","March","April","May","June","July","August","September","October","November","December"); //just a list of the month names for the server.  Change this to whatever language necessary.
$addon_conf['ArmorySync']['DateUpdatedFormat'] = "%m/%d/%y %H:%i:%s"; //Don't touch this!!! As i can see the time format is always set as it is set here
$addon_conf['ArmorySync']['IsWoWRosterDF'] = 0; //DragonFly Users with WoWRosterDF want this to be 1
$addon_conf['ArmorySync']['IsMySQLLower411'] = 0; //Users of MySQL Version lower than 4.1.1 want thi sto be 1
User avatar
Shenandoah
WR.net Apprentice
WR.net Apprentice
 
Posts: 8
Joined: Tue Sep 25, 2007 10:07 pm

Getting error when trying to sync with the armory

Postby poetter » Wed Sep 26, 2007 4:21 am

A blank white screen normaly happen if the url reloaded is incorrect. Do you have WoWRoster or Dragonfly with WoWRosterDF?

BTW: How can a blank white screen say "done" ? ;-)
Image
User avatar
poetter
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 462
Joined: Sat Jun 30, 2007 9:41 pm
Location: Germany/Hamburg

Re: Getting error when trying to sync with the armory

Postby Shenandoah » Wed Sep 26, 2007 7:42 am

poetter wrote:A blank white screen normaly happen if the url reloaded is incorrect. Do you have WoWRoster or Dragonfly with WoWRosterDF?

BTW: How can a blank white screen say "done" ? ;-)


It says done at the bottom in the status bar. I'm using wowroster, no dragonfly. I just tried it again and got this error:

Code: Select all
2013: Lost connection to MySQL server during query
SQL:
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Coin Operated Army' AND `server` = 'Shadowsong'
File: wowdb.php
Function: get_guild_info
Line: 1840
User avatar
Shenandoah
WR.net Apprentice
WR.net Apprentice
 
Posts: 8
Joined: Tue Sep 25, 2007 10:07 pm

Getting error when trying to sync with the armory

Postby poetter » Wed Sep 26, 2007 7:48 am

You are on a shared host with a small web presents?

This error is a host thing. You have to check your my.cnf, but i think you can't. Try another hoster!
Image
User avatar
poetter
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 462
Joined: Sat Jun 30, 2007 9:41 pm
Location: Germany/Hamburg

Getting error when trying to sync with the armory

Postby Shenandoah » Wed Sep 26, 2007 9:35 am

Well thanks anyway for trying to help. I'm not going to switch hosts because one mod doesn't work and everything else on my site works fine.

Guess I'll just keep reminding everyone to update their roster profile manually.
User avatar
Shenandoah
WR.net Apprentice
WR.net Apprentice
 
Posts: 8
Joined: Tue Sep 25, 2007 10:07 pm

Re: Getting error when trying to sync with the armory

Postby tuigii » Thu Sep 27, 2007 1:39 am

Shenandoah wrote:Guess I'll just keep reminding everyone to update their roster profile manually.

That's a last bottom line solution.

Most Guildies bought these horrible things named "PC's" to run their favourite game.... They spend hours, if not days to set it up correctly to run their WoW Add On's etc.....
They 'could' spend 30 seconds to install UniUpLoader (prepare one for them for your Guild - and offer to your Guildies on your site).

Roster updating : no more problems,
Add On updates : no more hassle.

A nearly perfect solution…. For those who care ;-)

Think about it : it just works.
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

Getting error when trying to sync with the armory

Postby Shenandoah » Thu Sep 27, 2007 4:45 am

Yeah, it sounds great but for some reason most of the people in my guild don't want to do much of anything but get on and play the game. Getting them to even sign up on our forums seems to be too much of a hassle for them :/ I personally don't understand it, but oh well...
User avatar
Shenandoah
WR.net Apprentice
WR.net Apprentice
 
Posts: 8
Joined: Tue Sep 25, 2007 10:07 pm


Return to ArmorySync - Depreciated

Who is online

Users browsing this forum: No registered users and 0 guests

cron