• This area is dedicated to the support of our xF1 add-ons. For xF2, please use the dedicated area: HERE.
  • We are aware that a no permission error was shown when you tried to purchase in the last 2 days, this is now fixed.

Bug Not a bug Creating tournament error

MtoR

Freaky Coder
Staff member
Joined
Nov 14, 2015
Messages
4,459
Just tried to create a tournament, it worked like a charm.
 

MattiGB

Member
Joined
Apr 2, 2016
Messages
118
You created tournament on fresh installation? I have old tournaments in my database so maybe it is a problem?
 

MtoR

Freaky Coder
Staff member
Joined
Nov 14, 2015
Messages
4,459
Yes I did.

Can you check in the xfa_tournament table if the field tournament_id has AI (autoincrement) checked ?
 

MtoR

Freaky Coder
Staff member
Joined
Nov 14, 2015
Messages
4,459
I don't speak whatever language that is in.
Do you see one that would look like autocinrement ?
 

MtoR

Freaky Coder
Staff member
Joined
Nov 14, 2015
Messages
4,459
It should be a column extra, in which you should have AUTO_INCREMENT
 

MattiGB

Member
Joined
Apr 2, 2016
Messages
118
I found only column called A_I with check option. It was unchecked.

When I clicked check button and try to save I have error:
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key
 

MtoR

Freaky Coder
Staff member
Joined
Nov 14, 2015
Messages
4,459
Hum odd can you try to make the tournament_id a primary key ?
There must have been something wrong when you copied the db, it changed the structure.
 

MtoR

Freaky Coder
Staff member
Joined
Nov 14, 2015
Messages
4,459
Try that :
ALTER TABLE xfa_tournament ADD PRIMARY KEY (`tournament_id`)
 

MattiGB

Member
Joined
Apr 2, 2016
Messages
118
I run this:
ALTER TABLE xfa_tourn_tournament ADD PRIMARY KEY (`tournament_id`)

but I get the same error while creating new tournament
 

MtoR

Freaky Coder
Staff member
Joined
Nov 14, 2015
Messages
4,459
Something may have gone wrong when you did stuff coz you shouldn't have had that issue.

Will release a fix version right now for the other issues you had.
 

MattiGB

Member
Joined
Apr 2, 2016
Messages
118
Ok when I want to register I get:
Server Error
Mysqli statement execute error : Field 'participant_id' doesn't have a default value

  1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
  2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
  3. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
  4. Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1638
  5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1627
  6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1419
  7. XenForo_DataWriter->save() in XFA/Tournament/ControllerPublic/Tournament.php at line 944
  8. XFA_Tournament_ControllerPublic_Tournament->actionRegister() in XenForo/FrontController.php at line 351
  9. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  10. XenForo_FrontController->run() in /vhosts/gamesboard.pl/web/index.php at line 13
 

MtoR

Freaky Coder
Staff member
Joined
Nov 14, 2015
Messages
4,459
Seem issue for this table...

What have you done dude with the db dude ?
Seems like all the table structures are corrupted.
 

MtoR

Freaky Coder
Staff member
Joined
Nov 14, 2015
Messages
4,459
Well I think it didn't go correctly, all the autoincrement fields are missing...