I didnt get and red flags when i loooked... all normal crap that is see all the time:(

http://guild-nightfall.com/roster/

That is the link to it ... and i am still working on it a lil event calender and such but i kinda gave up on the supied armory until i can find out what is going on:( wanted to get it working b4 the guild started actually listening to me and dling the installer(uniuploader)

But i would appreciate anything at all to get this going:)

Here is the error that I receive when I try to update the roster. It is the same when I do it for the entire guild, but with all of the guild member names instead of just this one.

I changed the php.ini to increase my load time, but I only get the white page with no update and no mysql error.

Any help would be appreciated. www.silvermoonodyssey.com/roster

2013: Lost connection to MySQL server during query
SQL:
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Odyssey' AND `server` = 'Silvermoon'
File: wowdb.php
Function: get_guild_info
Line: 1840
Backtrace (most recent call last):

* File: /home/content/w/o/w/wowodyssey/html/roster/lib/commonfunctions.lib.php
o line 248
o function called: backtrace
* File: /home/content/w/o/w/wowodyssey/html/roster/lib/wowdb.php
o line 1840
o function called: die_quietly
o args: 2013: Lost connection to MySQL server during query, WowDB Error, wowdb.php
Function: get_guild_info, 1840, SELECT * FROM `roster_guild` WHERE `guild_name` = 'Odyssey' AND `server` = 'Silvermoon'
* File: /home/content/w/o/w/wowodyssey/html/roster/addons/ArmorySynch/functions.synch.php
o line 67
o function called: get_guild_info
o args: Silvermoon, Odyssey
* File: /home/content/w/o/w/wowodyssey/html/roster/addons/ArmorySynch/index.php
o line 12
o function called: synchplayer
o args: , Syrenity
* File: /home/content/w/o/w/wowodyssey/html/roster/addon.php
o line 77
o function called: include_once
o args: /home/content/w/o/w/wowodyssey/html/roster/addons/ArmorySynch/index.php

Okay, I recently installed ArmorySynch and when I typed in my password I got this 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 '(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') <= DATE_SUB(NOW(),
SQL:
SELECT members.name FROM `roster_members` members LEFT JOIN `roster_players` players ON members.name = players.name WHERE members.level >= 10 AND ( ISNULL(players.name) OR STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') <= DATE_SUB(NOW(), INTERVAL 24 HOUR) ) ORDER BY members.last_online DESC
File: index.php
Line: 37

i've been working on setting this up on my website and have been adjusting things as needed, including updating the php.ini.

I managed to get a few members to update, and then it jumps to a "BAD GATEWAY: Web server received an invalid response while acting as a gateway or proxy server" message.

After at one point getting those few members updated, it no longer updates anyone any further. Any Ideas?

http://www.warcraft-legacy.com/index.ph ... oWRosterDF

Hi Guys I'm getting the following error when I sync

Cannot update Character Data
1264: Out of range value adjusted for column 'stat_def' at row 1

any Ideas


PHP 5.1.4
MySQL 5.0.22
IIS 6.0

Getting a few:

Code: Select all

CRITICAL ERROR - no root XML node found: armory.wow-europe.com page
Retried 2times for: item-tooltip.xml?i=17759&r=Aggramar&n=Hiphiphooray
Hiphiphooray synched: 26 seconds. Total runtime: 177 seconds.
Mamontii synched: 7 seconds. Total runtime: 184 seconds.
CRITICAL ERROR - no root XML node found: armory.wow-europe.com page
Retried 2times for: item-tooltip.xml?i=24962&r=Aggramar&n=Ozboz

during the update process, but works fine overall.

I seen to have the same error. But I dont see an solution? What can it be?

Check http://www.asmodayguild.com/roster/

Danta wrote:SELECT * FROM `roster_guild` WHERE `guild_name` = 'Asmoday' AND `server` = 'Doomhammer'
File: wowdb.php
Function: get_guild_info
Line: 1840
Backtrace (most recent call last):

* File: /home/content/V/i/n/Vincent75/html/sites/asmodayguild_com/www/roster/lib/commonfunctions.lib.php
o line 248
o function called: backtrace
* File: /home/content/V/i/n/Vincent75/html/sites/asmodayguild_com/www/roster/lib/wowdb.php
o line 1840
o function called: die_quietly
o args: 2013: Lost connection to MySQL server during query, WowDB Error, wowdb.php
Function: get_guild_info, 1840, SELECT * FROM `roster_guild` WHERE `guild_name` = 'Asmoday' AND `server` = 'Doomhammer'
* File: /home/content/V/i/n/Vincent75/html/sites/asmodayguild_com/www/roster/addons/ArmorySynch/functions.synch.php
o line 67
o function called: get_guild_info
o args: Doomhammer, Asmoday
* File: /home/content/V/i/n/Vincent75/html/sites/asmodayguild_com/www/roster/addons/ArmorySynch/functions.synch.php
o line 98
o function called: synchplayer
o args: , Shamoll,
* File: /home/content/V/i/n/Vincent75/html/sites/asmodayguild_com/www/roster/addons/ArmorySynch/index.php
o line 53
o function called: synchplayers
o args: , Syrenity
* File: /home/content/V/i/n/Vincent75/html/sites/asmodayguild_com/www/roster/addon.php
o line 77
o function called: include_once
o args: /home/content/V/i/n/Vincent75/html/sites/asmodayguild_com/www/roster/addons/ArmorySynch/index.php

Anyone able to get this to run as a cron job yet? or to at least run on a schedial?

gamergirl484 wrote:Okay, I recently installed ArmorySynch and when I typed in my password I got this 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 '(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') <= DATE_SUB(NOW(),
SQL:
SELECT members.name FROM `roster_members` members LEFT JOIN `roster_players` players ON members.name = players.name WHERE members.level >= 10 AND ( ISNULL(players.name) OR STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') <= DATE_SUB(NOW(), INTERVAL 24 HOUR) ) ORDER BY members.last_online DESC
File: index.php
Line: 37

i get the same error
we have an old mysql version on our servers

there was a workaround for WitchHunt to avoid this problem but i don't know how to do it for ArmorySync

here is the workaroud for WitchHunt
can anyone do this for ArmorySync???

Guntak wrote:For those of you stuck on 4.0.x (like I am) try this...

Change

Code: Select all

SELECT STR_TO_DATE(p.dateupdatedutc, '%m/%d/%Y %H:%i:%s') as MyDate

To

Code: Select all

SELECT p.dateupdatedutc as MyDate

...

Then Change

Code: Select all

$dat2 = explode('-',$dat1[0]);
$newDate= $dat2[2].'/'.$dat2[1].'/'.$dat2[0].' '.$dat1[1];

To

Code: Select all

$dat2 = explode('/',$dat1[0]);
$dat3 = date("m/d/Y", mktime(0,0,0,$dat2[0],$dat2[1],$dat2[2]));
$newDate= $dat3.' '.$dat1[1];

Hy,

I have always a blank page and no sync .... I make my sync with IE and Firefox but isn't change....

I can't change my timeout in php.ini ... a don't find where is the file ....

Can you help me please

Sorry for my english

This thread is now closed. Please do NOT use this thread for anything other than archival purposes.