vb.org Archive - [Bug] - Database error on tournament creation

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- ibProArcade Archive (https://vborg.vbsupport.ru/forumdisplay.php?f=174)

- - [Bug] - Database error on tournament creation (https://vborg.vbsupport.ru/showthread.php?t=136529)

jiffy

01-14-2007 10:55 PM

[Bug] - Database error on tournament creation

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

Code:

mySQL query error: INSERT INTO tournaments

                                                                                         (gid,numplayers,datestarted,demare,creat,plibre,nbtries,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

01-15-2007 09:19 AM

in AdminCP or in Arcade itself ?

Robru

02-02-2007 04:43 PM

In the Arcade itself !

In AdminCP:

Quote:

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

02-04-2007 10:11 AM

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

Robru

02-05-2007 02:16 PM

We talking about two error messages:

1st error is in the arcade when you create a tournament:

Quote:

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:

Quote:

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

02-17-2007 02:31 PM

Please do you have a solution for this problem?

MrZeropage

02-20-2007 12:14 PM

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

Robru

02-20-2007 05:03 PM

Thanks for the future fix Marcel :up:

All times are GMT. The time now is 08:23 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01174 seconds Memory Usage 1,725KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: