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.
  • 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

M

MattiGB

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

Clement

Freaky Coder
Staff member
Yes I did.

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

Clement

Freaky Coder
Staff member
I don't speak whatever language that is in.
Do you see one that would look like autocinrement ?
 
M

MattiGB

Member
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
 
Clement

Clement

Freaky Coder
Staff member
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.
 
M

MattiGB

Member
I run this:
ALTER TABLE xfa_tourn_tournament ADD PRIMARY KEY (`tournament_id`)

but I get the same error while creating new tournament
 
Clement

Clement

Freaky Coder
Staff member
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.
 
M

MattiGB

Member
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
 
Clement

Clement

Freaky Coder
Staff member
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