[485] Fatal error: Call to undefined method RosterArmory::fe

Displays character achievements

Moderator: Ulminia

Re: [485] Fatal error: Call to undefined method RosterArmory::fe

Postby AnthonyB » Sun Dec 27, 2009 8:32 am

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! :D
Roster 2.0.2 svn [latest] latest trunk SVN svn [latest] running on IIS7/Windows Server 2008 SP2 | MySQL 5.0.85 | PHP 5.2.10 | Yes, Roster and PHP rocks on IIS! Even run as FastCGI extension!
User avatar
AnthonyB
Gimpy Developer
Gimpy Developer
 
Posts: 346
Joined: Tue Jul 04, 2006 2:44 pm
Location: Sydney, Australia

Re: [485] Fatal error: Call to undefined method RosterArmory::fe

Postby AnthonyB » Sun Dec 27, 2009 8:34 am

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
Roster 2.0.2 svn [latest] latest trunk SVN svn [latest] running on IIS7/Windows Server 2008 SP2 | MySQL 5.0.85 | PHP 5.2.10 | Yes, Roster and PHP rocks on IIS! Even run as FastCGI extension!
User avatar
AnthonyB
Gimpy Developer
Gimpy Developer
 
Posts: 346
Joined: Tue Jul 04, 2006 2:44 pm
Location: Sydney, Australia

Re: [485] Fatal error: Call to undefined method RosterArmory::fe

Postby Ulminia » Sun Dec 27, 2009 6:30 pm

thats an easy one to fix... 493 is up...
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Re: [485] Fatal error: Call to undefined method RosterArmory::fe

Postby AnthonyB » Mon Dec 28, 2009 1:55 am

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!
Roster 2.0.2 svn [latest] latest trunk SVN svn [latest] running on IIS7/Windows Server 2008 SP2 | MySQL 5.0.85 | PHP 5.2.10 | Yes, Roster and PHP rocks on IIS! Even run as FastCGI extension!
User avatar
AnthonyB
Gimpy Developer
Gimpy Developer
 
Posts: 346
Joined: Tue Jul 04, 2006 2:44 pm
Location: Sydney, Australia

Re: [485] Fatal error: Call to undefined method RosterArmory::fe

Postby zanix » Mon Dec 28, 2009 3:09 am

Looks like there needs to be some optimization done on this
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

Re: [485] Fatal error: Call to undefined method RosterArmory::fe

Postby AnthonyB » Mon Dec 28, 2009 5:54 am

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
Roster 2.0.2 svn [latest] latest trunk SVN svn [latest] running on IIS7/Windows Server 2008 SP2 | MySQL 5.0.85 | PHP 5.2.10 | Yes, Roster and PHP rocks on IIS! Even run as FastCGI extension!
User avatar
AnthonyB
Gimpy Developer
Gimpy Developer
 
Posts: 346
Joined: Tue Jul 04, 2006 2:44 pm
Location: Sydney, Australia

Re: [485] Fatal error: Call to undefined method RosterArmory::fe

Postby Ulminia » Mon Dec 28, 2009 8:07 am

i will work on optamizing the code the problem being there is so much data with achievements.....
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Re: [485] Fatal error: Call to undefined method RosterArmory::fe

Postby Ulminia » Tue Dec 29, 2009 12:39 am

you arnt using armory sync to do the update are you?
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Re: [485] Fatal error: Call to undefined method RosterArmory::fe

Postby AnthonyB » Tue Dec 29, 2009 1:40 am

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?
Roster 2.0.2 svn [latest] latest trunk SVN svn [latest] running on IIS7/Windows Server 2008 SP2 | MySQL 5.0.85 | PHP 5.2.10 | Yes, Roster and PHP rocks on IIS! Even run as FastCGI extension!
User avatar
AnthonyB
Gimpy Developer
Gimpy Developer
 
Posts: 346
Joined: Tue Jul 04, 2006 2:44 pm
Location: Sydney, Australia

Re: [485] Fatal error: Call to undefined method RosterArmory::fe

Postby Ulminia » Tue Dec 29, 2009 1:56 am

uu is the least of my worries at the moment lol
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Previous

Return to Achievements

Who is online

Users browsing this forum: No registered users and 0 guests

cron