Heroes of Might and Magic Community
visiting hero! Register | Today's Posts | Games | Search! | FAQ/Rules | AvatarList | MemberList | Profile


Age of Heroes Headlines:  
5 Oct 2016: Heroes VII development comes to an end.. - read more
6 Aug 2016: Troubled Heroes VII Expansion Release - read more
26 Apr 2016: Heroes VII XPack - Trial by Fire - Coming out in June! - read more
17 Apr 2016: Global Alternative Creatures MOD for H7 after 1.8 Patch! - read more
7 Mar 2016: Romero launches a Piano Sonata Album Kickstarter! - read more
19 Feb 2016: Heroes 5.5 RC6, Heroes VII patch 1.7 are out! - read more
13 Jan 2016: Horn of the Abyss 1.4 Available for Download! - read more
17 Dec 2015: Heroes 5.5 update, 1.6 out for H7 - read more
23 Nov 2015: H7 1.4 & 1.5 patches Released - read more
31 Oct 2015: First H7 patches are out, End of DoC development - read more
5 Oct 2016: Heroes VII development comes to an end.. - read more
[X] Remove Ads
LOGIN:     Username:     Password:         [ Register ]
HOMM1: info forum | HOMM2: info forum | HOMM3: info mods forum | HOMM4: info CTG forum | HOMM5: info mods forum | MMH6: wiki forum | MMH7: wiki forum
Heroes Community > Tournament of Honor > Thread: Annoying
Thread: Annoying
vesuvius
vesuvius

Hero of Order
Honor Above all Else
posted August 06, 2009 05:45 AM

Annoying

For the past 10 days, I cannot activate new accounts, nor can I modify them and do player services/add winloss etc..  Been waiting for the programmer to fix it.  So FYI email I got from the programmer:

Rob,

I did a lot of testing on the admin section of the toheroes site and tracked the data access problem down to the use of one particular command. I’m not sure why things had changed but I suspect that it is due to some environmental change to that server. Possibly an update to the operating system or something like that. The technology that was used to create the automation part of the site is pretty old (over 10 years old) and is a problem when trying to resolve an issue like this.



The problem comes in when calling the setSQLText function of an ADO record set. That function is need when dynamically changing a database query based on settings and conditions on a particular page. I was able to change most of the pages in the admin section to avoid using this function. There are a couple of pages where I could not avoid using it and had to leave it in, but I did what I could to minimize the effect. The Players page is one such page. There are times that it gets stuck after selecting a player from the list. In these cases, I found, that you can click the cancel button (once or twice) and the data will come up. I have also found that after the page gets stuck it can be helpful to click over to another page in the admin section and then go back to the Players page. I know this is a pain in the ass but you should be able to clear out the pending players in the mean time.



I am continuing to work with the hosting people to see if the problem can be resolved by some adjustment on the server. It is difficult since we are probably the only site on that server that is using ADO record sets. If we weren’t, others would have complained and the issue would probably been resolved by now. I don’t think the first-line support people are really capable of dealing with such a subtle issue. I will try to get them to move the issue up to a higher level of support.





____________

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
infinitus
infinitus


Supreme Hero
posted August 06, 2009 07:48 AM

Yesterday report win not work for me - time out. I use Firefox as internet browser. Tried internet explorer to report and this work for me. This is not coincidence cos happen multiple times.  
____________
Nothing's impossible

http://www.youtube.com/watch?
v=loCSLJ6IodY

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Vangelis21
Vangelis21


Supreme Hero
Manchild
posted August 06, 2009 10:12 AM

any way that my map will be published vesuvius?

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
DIEGIS
DIEGIS


Supreme Hero
power of Zamolxis
posted August 06, 2009 12:58 PM
Edited by DIEGIS at 11:42, 07 Aug 2009.

Quote:
any way that my map will be published vesuvius?


ask Jinxer, I think he will do it for you



 Yes, working on such old platform its almost impossible or at least very very hard, Ves.

 The best idea is to start a fresh new site for the greatest land of Heroes -  TOH.
 Php/mysql platform will do a great job, but this will be only Ves decision; I also believe players from Toh have nothing against, but to enjoy a better eviroment especially when all the medals and prestige points will remain, in the start, only for the active players at least.

 There's also many programs that could save the entire site in html format, so the history will stay for eternity, and meantime the work on the new "land" could start. It's just an idea, cose as Ves mentioned, that platform has been worn out enought time now, and renewing it seems to be the best solution.
Not to mention that Ves' manually work will be minimazed ...

 Many players here could have good ideas about this I'm preatty sure of this !

____________
dacian falx behind you
-knowledge itself is power-
www.cabinet-dentaire-malaunay.fr

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Jinxer
Jinxer


Legendary Hero
*****
posted August 06, 2009 07:04 PM

Quote:
any way that my map will be published vesuvius?



I am in charge of Maps page... please e-mail me your map.  Jinxer@adelphia.net
____________

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Bala_Car
Bala_Car

Tavern Dweller
posted August 06, 2009 11:05 PM

i also can not report

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Jinxer
Jinxer


Legendary Hero
*****
posted August 06, 2009 11:28 PM

I COMPLETED the report for BalaCar...  anyone else who needs help with this...just message me.
____________

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
vesuvius
vesuvius

Hero of Order
Honor Above all Else
posted August 08, 2009 07:13 AM
Edited by vesuvius at 07:18, 08 Aug 2009.

If a new automation would be rebuilt from scratch using current servers/software, it would have to be done at an 'end season'... or when a new heroes (6?) would be released.  The other problem with starting again is that the great old database of almost a decade of player information & records would be lost.  Of course, I would make screenshots of the season like every past season, but its just not the same.  So I hope this will be fixed, and we continue like always.

in other news, here's a video someone caught of me and my Bugatti Veyron.
http://www.youtube.com/watch?v=RU2IykYEnc8
____________

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
infinitus
infinitus


Supreme Hero
posted August 08, 2009 08:51 AM

Looks like Vesuvius was in real harry in his way to fix automation problems
____________
Nothing's impossible

http://www.youtube.com/watch?
v=loCSLJ6IodY

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
valkyrica
valkyrica


Supreme Hero
posted August 09, 2009 10:45 PM

ADO records ... pfff, that's stoneage stuff

Anyhow, you can easily port your database to a newer version regardless of what it's sitting on right now and what will be used in the future. There's ETL tools that'll help you with any kind of combination.

Gimme a buzz if you need a hand with it.
____________
I'm Guybrush Threepwood, mighty pirate

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
vesuvius
vesuvius

Hero of Order
Honor Above all Else
posted August 10, 2009 11:06 PM

Problem solved finally, from the programmer:

The problem has finally been resolved! It turns out that the hosting people had installed a device in mid July that is supposed to protect against SQL injection attacks. The filter was evidently overly aggressive and killing the database connection when certain types of queries were done. This was causing the page to hang during certain queries.

I’m sorry it took so long to resolve this. It was the type of problem that was very hard to track down. I tried to modify the code in order to work around the problem so you could continue working but this could not be done for a couple of the pages. In particular, the players page had to use the type of queries that were getting stuck. I hope you will be able to catch up with the backlog now. Thanks.



____________

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Jump To: « Prev Thread . . . Next Thread »
Post New Poll    Post New Topic    Post New Reply

Page compiled in 0.0379 seconds