[Bug] - Database error on tournament creation

[jiffy]

I just upgraded to 2.5.9 and I'm still getting this error when I click "create tournament".

mySQL query error: INSERT INTO tournaments
(gid,numplayers,datestarted,demare,creat,plibre,nb tries,cost) VALUES
('1','2','1168822014','0','JiffyPark','1','1','0')

mySQL error: Field 'champion' doesn't have a default value
mySQL error code:
Date: Sunday 14th 2007f January 2007 04:46:54 PM

[MrZeropage]

in AdminCP or in Arcade itself ?

[Robru]

In the Arcade itself !

In AdminCP:

mySQL query error: INSERT INTO tournaments (gid,numplayers,datestarted,demare,creat,plibre,nb tries,cost,champion) VALUES ('2060','2','1170527863','1','','0','3','','')

mySQL error: Field 'url_discut' doesn't have a default value
mySQL error code:
Date: Saturday 03rd 2007f February 2007 07:37:43 PM

[MrZeropage]

strange, as I don'T know where "url_discut" apprears there... and now you have a different error-message

[Robru]

We talking about two error messages:

1st error is in the arcade when you create a tournament:
mySQL query error: INSERT INTO tournaments
(gid,numplayers,datestarted,demare,creat,plibre,nb tries,cost) VALUES
('1622','2','1170691470','0','Ronald','1','2','0')

mySQL error: Field 'champion' doesn't have a default value
mySQL error code:
Date: Monday 05th 2007f February 2007 05:04:30 PM


2nd error is in AdminCP when you create a tournament:
mySQL query error: INSERT INTO tournaments (gid,numplayers,datestarted,demare,creat,plibre,nb tries,cost,champion) VALUES ('1617','2','1170691983','1','','0','3','','')

mySQL error: Field 'url_discut' doesn't have a default value
mySQL error code:
Date: Monday 05th 2007f February 2007 05:13:03 PM

The 1st error is the most important error that may have a solution, I think!

Thanks for your answers Mr.Zeropage :)

[Robru]

Please do you have a solution for this problem?

[MrZeropage]

thanks for information, fixed for v2.6.0+ (coming soon)

[Robru]

Thanks for the future fix Marcel :up: