What's new
Xen Factory

Register today to become a member! Once signed in, you'll be able to start purchasing our products, ask questions, request support and suggest new ideas!

  • This area is dedicated to the support of our xF1 add-ons. For xF2, please use the dedicated area: HERE.

Bug Not a bug Creating tournament error

You created tournament on fresh installation? I have old tournaments in my database so maybe it is a problem?
 
Yes I did.

Can you check in the xfa_tournament table if the field tournament_id has AI (autoincrement) checked ?
 
I don't speak whatever language that is in.
Do you see one that would look like autocinrement ?
 
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
 
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.
 
I run this:
ALTER TABLE xfa_tourn_tournament ADD PRIMARY KEY (`tournament_id`)

but I get the same error while creating new tournament
 
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.
 
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
 
Seem issue for this table...

What have you done dude with the db dude ?
Seems like all the table structures are corrupted.
 
You must log in or register to reply here.
Top