A-ha! You were on the right track. Turned out it was a timeout in the FastCGI module in IIS7.
Had to increase the activity timeout setting.

So, now I've got a new error and it is Roster code related and (hopefully) not environment related! I'm also finally starting to see some data make it into the roster_addons_achivements_data for the first time!

Code: Select all

Database Error
1406: Data too long for column 'date_1' at row 1
SQL:
INSERT INTO `roster_addons_achivements_summary` (`id`,`member_id`,`guild_id`,`total`, `general`,`quests`,`exploration`,`pvp`,`dn_raids`,`prof`,`rep`,`world_events`,`feats`, `title_1`,`disc_1`,`date_1`,`points_1`,`title_2`,`disc_2`,`date_2`,`points_2`, `title_3`,`disc_3`,`date_3`,`points_3`,`title_4`,`disc_4`,`date_4`,`points_4`, `title_5`,`disc_5`,`date_5`,`points_5` ) VALUES (null,'98','17','Total Completed: 37 / 1054','7 / 54','5 / 49','2 / 70','1 / 166','1 / 454','19 / 75','1 / 45','1 / 141','0 / ','The Green Hills of Stranglethorn','Complete all of Hemet Nesingwary quests in Stranglethorn Vale up to and including The Green Hills of Stranglethorn and Big Game Hunter.','2009-07-05T07:06:00-07:00','10','Journeyman Fisherman','Become a Journeyman Fisherman.','2009-07-05T07:06:00-07:00','10','Level 30','Reach level 30.','2009-07-05T07:06:00-07:00','10','Giddy Up!','Learn the apprentice riding skill.','2009-07-05T07:06:00-07:00','10','Explore Moonglade','Explore Moonglade, revealing the covered areas of the world map.','2009-07-05T07:06:00-07:00','10');
File: lib\dbal\mysql.php
Line: 234


Code: Select all

PHP Errorsaddons\achivements\inc\update_hook.php
  Notice line 509: Trying to get property of non-object
  Notice line 509: Trying to get property of non-object
  Notice line 510: Trying to get property of non-object
  Notice line 510: Trying to get property of non-object
  Notice line 511: Trying to get property of non-object
  Notice line 511: Trying to get property of non-object
  Notice line 512: Trying to get property of non-object
  Notice line 512: Trying to get property of non-object
  Notice line 513: Trying to get property of non-object
  Notice line 513: Trying to get property of non-object
  Notice line 514: Trying to get property of non-object
  Notice line 514: Trying to get property of non-object
  Notice line 515: Trying to get property of non-object
  Notice line 515: Trying to get property of non-object
  Notice line 516: Trying to get property of non-object
  Notice line 516: Trying to get property of non-object
  Notice line 517: Trying to get property of non-object
  Notice line 517: Trying to get property of non-object


So I went into the roster_addons_achivements_data table and increased the length of the achv_date field from 25 to 50 and I was finally able to upload with no errors!

er... damn... I lie... new error:

Code: Select all

Database
Error1366: Incorrect integer value: '' for column 'achv_points' at row 1
SQL:
INSERT INTO `roster_addons_achivements_data` (`id`,`member_id`,`guild_id`,`achv_cat`,`achv_cat_title`,`achv_cat_sub`,`achv_cat_sub2`, `achv_id`,`achv_points`,`achv_icon`,`achv_title`,`achv_reward_title`,`achv_disc`,`achv_date`, `achv_criteria`,`achv_progress`,`achv_progress_width`,`achv_complete`) VALUES (null,'25','17','81','Feats of Strength', 'Feats of Strength','221','1706','', 'inv_holiday_christmas_present_01','1706title','','1706disc', '2008-12-28T05:12:00-08:00','Crashin\' Thrashin\' Racer Controller
','','','1');
File: lib\dbal\mysql.php
Line: 234


thats an easy one to fix... 493 is up...

Updated to 493
First pass, ran into PHP max_execution time issues:

Code: Select all

Fatal error: Maximum execution time of 60 seconds exceeded in C:\inetpub\wwwroot\roster\lib\functions.lib.php on line 1103

increased max_execution_time = 120
2nd pass, new error:

Code: Select all

Database Error
1406: Data too long for column 'date_1' at row 1
SQL:
INSERT INTO `roster_addons_achivements_summary` (`id`,`member_id`,`guild_id`,`total`, `general`,`quests`,`exploration`,`pvp`,`dn_raids`,`prof`,`rep`,`world_events`,`feats`, `title_1`,`disc_1`,`date_1`,`points_1`,`title_2`,`disc_2`,`date_2`,`points_2`, `title_3`,`disc_3`,`date_3`,`points_3`,`title_4`,`disc_4`,`date_4`,`points_4`, `title_5`,`disc_5`,`date_5`,`points_5` ) VALUES (null,'25','17','Total Completed: 273 / 1054','27 / 54','27 / 49','29 / 70','5 / 166','96 / 454','59 / 75','8 / 45','22 / 141','3 / ','Ring of the Kirin Tor','Purchase a Signet of the Kirin Tor, Band of the Kirin Tor, Loop of the Kirin Tor, or Ring of the Kirin Tor in Dalaran.','2009-12-27T10:41:00-08:00','10','Northrend Vanguard','Gain exalted reputation with the Argent Crusade, Wyrmrest Accord, Kirin Tor and Knights of the Ebon Blade.','2009-12-27T06:39:00-08:00','20','The Wyrmrest Accord','Earn exalted status with The Wyrmrest Accord.','2009-12-27T06:39:00-08:00','10','Trial of the Champion','Defeat the bosses in the Trial of the Champion.','2009-12-27T05:30:00-08:00','10','Heroic: Trial of the Champion','Defeat the bosses in the Trial of the Champion on Heroic Difficulty.','2009-12-27T05:30:00-08:00','10');
File: lib\dbal\mysql.php
Line: 234


Changed date_1 from varchar(12) to varchar(25)
3rd pass, new error, but another date length related one:

Code: Select all

Database Error
1406: Data too long for column 'date_2' at row 1
SQL:
INSERT INTO `roster_addons_achivements_summary` (`id`,`member_id`,`guild_id`,`total`, `general`,`quests`,`exploration`,`pvp`,`dn_raids`,`prof`,`rep`,`world_events`,`feats`, `title_1`,`disc_1`,`date_1`,`points_1`,`title_2`,`disc_2`,`date_2`,`points_2`, `title_3`,`disc_3`,`date_3`,`points_3`,`title_4`,`disc_4`,`date_4`,`points_4`, `title_5`,`disc_5`,`date_5`,`points_5` ) VALUES (null,'25','17','Total Completed: 273 / 1054','27 / 54','27 / 49','29 / 70','5 / 166','96 / 454','59 / 75','8 / 45','22 / 141','3 / ','Ring of the Kirin Tor','Purchase a Signet of the Kirin Tor, Band of the Kirin Tor, Loop of the Kirin Tor, or Ring of the Kirin Tor in Dalaran.','2009-12-27T10:41:00-08:00','10','Northrend Vanguard','Gain exalted reputation with the Argent Crusade, Wyrmrest Accord, Kirin Tor and Knights of the Ebon Blade.','2009-12-27T06:39:00-08:00','20','The Wyrmrest Accord','Earn exalted status with The Wyrmrest Accord.','2009-12-27T06:39:00-08:00','10','Trial of the Champion','Defeat the bosses in the Trial of the Champion.','2009-12-27T05:30:00-08:00','10','Heroic: Trial of the Champion','Defeat the bosses in the Trial of the Champion on Heroic Difficulty.','2009-12-27T05:30:00-08:00','10');
File: lib\dbal\mysql.php
Line: 234


Changed date_2, date_3, date_4, date_5 from varchar(12) to varchar(25)
4th pass, new error, anotehr max_execution timeout

Code: Select all

Fatal error: Maximum execution time of 120 seconds exceeded in C:\inetpub\wwwroot\roster\lib\functions.lib.php on line 1103

Upped max_execution from 120 to 180

5th pass...

OMG....

OMG...

it worked

Thanks for all your help Ulminia!

Looks like there needs to be some optimization done on this

I would concur. The fact that I had to make both PHP and IIS config changes is not ideal and would be problematic for the average roster user.

re. all the changes I had to make to date field lengths, it looks like it's storing timezone offsets which is making the string longer than expected which you can see here - http://anthonyb.dyndns.org/roster/index ... :25&cat=00

i will work on optamizing the code the problem being there is so much data with achievements.....

you arnt using armory sync to do the update are you?

Nope - I still can't get AS to work as per this post - post38777.html#p38777

Another problem I've just hit - uploading through the Roster site works, but uploading through UU seems to have broken. Looks like the guild data gets uploaded but the character stuff barfs throwing the same error as in the above link.

...so I'm confused... it's as though the manual upload is working as expected but the UU upload is triggering an AS sync?

uu is the least of my worries at the moment lol