Create tourney bug fixed (hopefully)

General tournament news, announcements, ideas and suggestions.

Moderators: 9balldotcom, zwylle

Post Reply
Nugget
Asst Admin
Asst Admin
Posts: 173
Joined: Thu Oct 07, 2004 2:39 am
Contact:

Create tourney bug fixed (hopefully)

Post by Nugget »

Hello, I've fixed the bugs.

It didn't like the format of the dates I was passing to the database. I don't know why because it always worked before. Maybe they have changed the date settings on the database.
Anyway, give it a try and let me know if there are anymore problems.

Simon
Tournament Website: http://www.vphqtournaments.com
User avatar
9balldotcom
Site Admin
Site Admin
Posts: 2051
Joined: Mon Oct 04, 2004 1:37 pm
Location: Kilmarnock(Scotland)
Contact:

Post by 9balldotcom »

Tested it seems to be working ok again ty
User avatar
9balldotcom
Site Admin
Site Admin
Posts: 2051
Joined: Mon Oct 04, 2004 1:37 pm
Location: Kilmarnock(Scotland)
Contact:

Post by 9balldotcom »

Ok I did a tourney tonight and all was ok till i tried to finish the tourney.Then I got this message


Adding tournament to history....
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

/tourney/finish_tourney.asp, line 82


so the tournament hasnt been saved to gistory and the results not been saved to the database yet.
Nugget
Asst Admin
Asst Admin
Posts: 173
Joined: Thu Oct 07, 2004 2:39 am
Contact:

Post by Nugget »

Hi,



sorry I was away working for a few days.



Will look into it later on today.



Simon
Tournament Website: http://www.vphqtournaments.com
Nugget
Asst Admin
Asst Admin
Posts: 173
Joined: Thu Oct 07, 2004 2:39 am
Contact:

Post by Nugget »

right definitley should be working again now.

Simon
Tournament Website: http://www.vphqtournaments.com
polomint77
Banger
Banger
Posts: 297
Joined: Mon Dec 05, 2005 3:19 pm
Location: Colne, Lancashire, UK
Contact:

Post by polomint77 »

heheh, we will email you later in the week when its dies again, :P

What was the problem? Obviously summat to do with the way dates were entered into the db. did the host of the system change summat without letting you know?

Nosey fecker aint I :D
DISCLAIMER
All opinions expressed by myself are just that, opinions of *mine*. They are in no way anyone elses.
If you disagree with them, then please feel free to take it up with you local drunkard, hooker, or local drug dealer. Just don’t bother me with it because I couldn’t care less.
Post Reply