XF\Db\Exception: MySQL query error [1364]: Field 'competition_entries' doesn't have a default value in src/XF/Db/AbstractStatement.php at line 212
[LIST=1]
[*]XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 174
[*]XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 70
[*]XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 74
[*]XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 151
[*]XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1381
[*]XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1113
[*]XF\Mvc\Entity\Entity->save() in src/XF/Service/User/Registration.php at line 254
[*]XF\Service\User\Registration->_save() in src/XF/Service/ValidateAndSavableTrait.php at line 40
[*]XF\Service\User\Registration->save() in src/XF/Pub/Controller/Register.php at line 369
[*]XF\Pub\Controller\Register->actionRegister() in src/XF/Mvc/Dispatcher.php at line 249
[*]XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
[*]XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
[*]XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1880
[*]XF\App->run() in src/XF.php at line 328
[*]XF::runApp() in index.php at line 13
Yeah, there is a fix in the installer so not sure at first glance why that didn't happen.
Anyway, the fix is this:
Code:ALTER TABLE xf_user CHANGE COLUMN competition_entries competition_entries BLOB NULL
While Competitions for XF2 is being developed, does anyone have any great ideas for new features?
Has it been suggested already to restrict winners to be unique within X many days or X many competitions? The idea being that for smaller sites the same people aren't winning multiple competitions in a short time span helping to ensure that other users are encouraged to enter.While Competitions for XF2 is being developed, does anyone have any great ideas for new features?
We use essential cookies to make this site work, and optional cookies to enhance your experience.