Its been awhile since i've updated my guild Roster and when i try to do it now I get Blank Update Log and SQL Query boxes. Nothing updates.

In game I see successful results when I click the Save button in Character Screen and Guild Screens.

If I delete the .lua's and try fresh i get an ingame error about a nil value and it doesn't create them.

Roster Diag generates the following errors at the bottom of the tables

Code: Select all

Warning: fopen(http://www.wowroster.net/roster_updater/version_match.php) [function.fopen]: failed to open stream: Connection timed out in /home3/xxxxxxx/public_html/roster/lib/rosterdiag.lib.php on line 290

Warning: feof(): supplied argument is not a valid stream resource in /home3/xxxxxxx/public_html/roster/lib/rosterdiag.lib.php on line 294

Warning: fread(): supplied argument is not a valid stream resource in /home3/xxxxxxx/public_html/roster/lib/rosterdiag.lib.php on line 296

Then the last 2 error lines repeat indefinitely

Anyone experiencing similar issues and/or know how to solve them?

Thanks guys

These errors don't have anything to do with the update process, it just means you can't access the roster updater code on our site

Anyway, there's a post in the projects section about a possible fix
http://www.wowroster.net/ProjectsPro/ta ... id=28.html

EDIT: Previous link was not working

Gotcha Zanix

I checked the link you sent and saw the code. I found the similar code in the update.php file but was wondering if I needed to replace that section or add to it. The link mentions the new code but doesn't detail exactly what to do with it.

Please forgive my coding ignorance

Thanks for the info

Hi!

I've updated code of update.php to code which was in link zanix gave, but still nothing. I've got the same problem, when someone try tu upload .lua files by roster page, Update Log is totaly clear and in SQL queries I can see only:

Code: Select all

 SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;

Dilgar You handled it?

Waitning for reaply
Thx

No solution yet. Trying to get time to try and mess with code placement and re-test again.

The fix link listed above no longer exist. Was it incorrect? I would like to attempt to get this resolved but don't have the code to reference anymore.

Any suggestions?

Try this
http://www.wowroster.net/ProjectsPro/ta ... id=28.html

Thanks Zanix

Tried that replacing this code

Code: Select all

// Files that we accept for upload
$filefields[] = 'CharacterProfiler.lua';
$filefields[] = 'PvPLog.lua';

// Loop through each posted file
foreach ($_FILES as $filefield => $file)
{
   $filename = $file['tmp_name'];
   $filemode = '';

   if( substr_count($file['name'],'.gz') > 0 )   // If the file is gzipped
      $filemode = 'gz';

   foreach( $filefields as $acceptedfile )   // Itterate through all the possible filefields
   {
      if( $acceptedfile == $file['name'] || $acceptedfile.'.gz' == $file['name'] )
      {


With this code:

Code: Select all

// Files that we accept for upload
// DEBUG: Lowered the filename for avoid wrong uppercase issue
$filefields[] = 'characterprofiler.lua';
$filefields[] = 'pvplog.lua';
// DEBUG END

// Loop through each posted file
foreach ($_FILES as $filefield => $file)
{
   $filename = $file['tmp_name'];
   $filemode = '';

   if( substr_count($file['name'],'.gz') > 0 )   // If the file is gzipped
      $filemode = 'gz';

   foreach( $filefields as $acceptedfile )   // Itterate through all the possible filefields
   {
      // DEBUG: Lowered the filename for get a case-insensitive check
      $lowcase_filename = strtolower($file['name']);
      if( $acceptedfile == $lowcase_filename || $acceptedfile.'.gz' == $lowcase_filename )
      // DEBUG END
      {

with no change in behavior. Just a blank Update Log window and

Code: Select all

SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;


in SQL Queries

I'm using full reinstalls of the Character Profiler 1.6.3 and Guild Profiler 1.6.0 from the rpgoutfitter site.

I saw you promoted the bug to a task so I wish you luck in figuring this one out and will gladly test anything you need tested.

If you need any furhter information from me please let me know

Be well

Dilgar

Well, this was the only thing we have seen that could have been the problem

All I can ask you for is your web server error logs

I checked the error logs after trying the update fresh and there are zero error entries at the time I updated. And none from my source IP.

Here is the only thing in the raw access logs but it doesn't say much that I can tell.

Code: Select all


xx.xx.xx.xx - - [07/Oct/2006:19:43:46 -0500] "GET /roster/admin/update.php HTTP/1.1" 200 11593 "http://www.praetoriansyndicate.com/roster/admin/update.php" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7"
xx.xx.xx.xx - - [07/Oct/2006:19:43:46 -0500] "GET /roster/realmstatus.php HTTP/1.1" 200 6288 "http://www.praetoriansyndicate.com/roster/admin/update.php" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7"
xx.xx.xx.xx - - [07/Oct/2006:19:43:48 -0500] "GET /roster/admin/update.php HTTP/1.1" 200 11607 "http://www.praetoriansyndicate.com/roster/admin/update.php" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7"
xx.xx.xx.xx - - [07/Oct/2006:19:43:49 -0500] "GET /roster/realmstatus.php HTTP/1.1" 200 6414 "http://www.praetoriansyndicate.com/roster/admin/update.php" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7"
xx.xx.xx.xx - - [07/Oct/2006:19:44:03 -0500] "POST /roster/admin/update.php HTTP/1.1" 200 12087 "http://www.praetoriansyndicate.com/roster/admin/update.php" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7"
xx.xx.xx.xx - - [07/Oct/2006:19:44:03 -0500] "GET /roster/realmstatus.php HTTP/1.1" 200 8010 "http://www.praetoriansyndicate.com/roster/admin/update.php" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7"


*grumble*

I have no clue why this is happening, I'm so frustrated...

I solved my "problem"!
All of my guildmembers and me as well, have tried to upload from wrong file location... we tried from:
D:\Games\World of Warcraft\Interface\AddOns\
Yesterday I've noticed that when you mousover file name in Update Profile ther is an example path... and so when we use:
D:\Games\World of Warcraft\WTF\Account\xx-YourAcc-xx\SavedVariables
...everything is ok.

Maybe you make the same mistake

Well sometimes it's good to read EVERYTHING before you do SOMETHING...
C ya guys

Just some thoughts. I just updated the maxres addon on my server, and began getting the same error. I checked the error logs for the server and found the old maxres fix "trigger.php" was causing a fatal error. I renamed it to trigger.bak, and reloaded. All good.

If you just recently upgraded to the new maxres, this could be your answer.

Holy Crap. Brain Fart! You're right Wassik. I am uploading from

Code: Select all

C:\World of Warcraft\Interface\AddOns\CharacterProfiler

instead of

Code: Select all

C:\World of Warcraft\WTF\Account\xx-YourAcc-xx\SavedVariables

Update just worked

DoH! DoH! DoH!
/em beats head repeatedly on the desk

Sorry for being dense Zanix.

Fellon wrote:Just some thoughts. I just updated the maxres addon on my server, and began getting the same error. I checked the error logs for the server and found the old maxres fix "trigger.php" was causing a fatal error. I renamed it to trigger.bak, and reloaded. All good.

God save us! Thanks for the fix! I was getting crazy!!! So can the "trigger.php" file be deleted safely?

Thx,
Andrea