Integrity constraint violation: 1048 Column 'variable_data' cannot be null

Hi Low.
This site works great on my server, but when i install it on the client's server, I am unable to edit low variable fields of the grid type.

Do you have any idea how this can be fixed? Whenever i click save on the variables i get this:

Exception Caught
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'variable_data' cannot be null:
UPDATE `exp_global_variables` SET `variable_data` = NULL WHERE `variable_id` = 22

ee/legacy/database/drivers/mysqli/mysqli_connection.php:116
Stack Trace: Please include when reporting this error

#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(111): CI_DB_mysqli_connection->query('UPDATE `exp_glo...')
#1 ee/legacy/database/DB_driver.php(269): CI_DB_mysqli_driver->_execute('UPDATE `exp_glo...')
#2 ee/legacy/database/DB_driver.php(179): CI_DB_driver->simple_query('UPDATE `exp_glo...')
#3 ee/legacy/database/DB_active_rec.php(1476): CI_DB_driver->query('UPDATE `exp_glo...')
#4 ee/EllisLab/ExpressionEngine/Service/Model/Query/Update.php(128): CI_DB_active_record->update('global_variable...')
#5 ee/EllisLab/ExpressionEngine/Service/Model/Query/Update.php(98): EllisLab\ExpressionEngine\Service\Model\Query\Update->actOnGateway(Object(EllisLab\ExpressionEngine\Service\Model\SyntheticGateway), Object(EllisLab\ExpressionEngine\Model\Template\GlobalVariable))
#6 ee/EllisLab/ExpressionEngine/Service/Model/Query/Update.php(47): EllisLab\ExpressionEngine\Service\Model\Query\Update->doWork(Object(EllisLab\ExpressionEngine\Model\Template\GlobalVariable))
#7 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(281): EllisLab\ExpressionEngine\Service\Model\Query\Update->run()
#8 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(247): EllisLab\ExpressionEngine\Service\Model\DataStore->runQuery('Update', Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#9 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(70): EllisLab\ExpressionEngine\Service\Model\DataStore->updateQuery(Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#10 ee/EllisLab/ExpressionEngine/Service/Model/Model.php(360): EllisLab\ExpressionEngine\Service\Model\Query\Builder->update()
#11 user/addons/low_variables/models/low_variables_variable_model.php(135): EllisLab\ExpressionEngine\Service\Model\Model->save()
#12 [internal function]: Low_variables_variable_model->{closure}(Object(EllisLab\ExpressionEngine\Model\Template\GlobalVariable))
#13 ee/EllisLab/ExpressionEngine/Library/Data/Collection.php(290): array_map(Object(Closure), Array)
#14 user/addons/low_variables/models/low_variables_variable_model.php(136): EllisLab\ExpressionEngine\Library\Data\Collection->each(Object(Closure))
#15 user/addons/low_variables/mcp.low_variables.php(403): Low_variables_variable_model->update(22, Array)
#16 [internal function]: Low_variables_mcp->save('6')
#17 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(1661): call_user_func_array(Array, Array)
#18 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(945): EllisLab\ExpressionEngine\Controller\Addons\Addons->getModuleSettings('low_variables', 'save', Array)
#19 [internal function]: EllisLab\ExpressionEngine\Controller\Addons\Addons->settings('low_variables', 'save', '6')
#20 ee/EllisLab/ExpressionEngine/Core/Core.php(240): call_user_func_array(Array, Array)
#21 ee/EllisLab/ExpressionEngine/Core/Core.php(109): EllisLab\ExpressionEngine\Core\Core->runController(Array)
#22 ee/EllisLab/ExpressionEngine/Boot/boot.php(146): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
#23 html/admin.php(147): require_once('...')
#23 html/admin.php(147): require_once('...')

Thanks for your help!
1 person has
this problem
+1
Reply