I have had a module for a while that I wrote that creates a "Products Per Case" ppcField field in xcProducts .. For some reason everytime I update the site (or disable a module) it attempts to reset this field to Not Null (this field can be null and default is set to Null). How do I prevent Xcart redeploy (step 5 I believe) to stop trying to set this field to Not Null?
Here is the error in the php_error log
Code:
[06-Jan-2017 15:33:21] Error (code: 0): An exception occurred while executing 'ALTER TABLE xc_products CHANGE PPCField PPCField VARCHAR(32) NOT NULL':
SQLSTATE[22004]: Null value not allowed: 1138 Invalid use of NULL value
Server API: fpm-fcgi;
Request method: GET;
URI: /admin.php?target=addons_list_installed&__cache_key__=82b5339fc4a155b03641a06c2c6b47ad&cpid=34d5b4bb4d90caf09248f04d54627d4c;
Backtrace:
#0 /home/numus/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(116): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))
#1 /home/numus/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(XLite\Core\PDOMySqlDriver), Object(Doctrine\DBAL\Driver\PDOException), 'ALTER TABLE xc_...', Array)
#2 /home/numus/public_html/var/run.82b5339fc4a155b03641a06c2c6b47ad/classes/XLite/Core/Connection.php(51): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE xc_...', Array, Array, NULL)
#3 /home/numus/public_html/var/run.82b5339fc4a155b03641a06c2c6b47ad/classes/XLite/Core/DatabaseAbstract.php(657): XLite\Core\Connection->executeQuery('ALTER TABLE xc_...')
#4 /home/numus/public_html/Includes/Decorator/Plugin/Doctrine/Plugin/UpdateSchema/Main.php(28): XLite\Core\DatabaseAbstract->executeQueries(Array)
#5 /home/numus/public_html/Includes/Decorator/Utils/PluginManager.php(62): Includes\Decorator\Plugin\Doctrine\Plugin\UpdateSchema\Main->executeHookHandler()
#6 /home/numus/public_html/Includes/Decorator/Utils/CacheManager.php(981): Includes\Decorator\Utils\PluginManager::invokeHook('step_fifth')
#7 [internal function]: Includes\Decorator\Utils\CacheManager::executeStepHandler5()
#8 /home/numus/public_html/Includes/Utils/Operator.php(213): call_user_func_array(Array, Array)
#9 /home/numus/public_html/Includes/Decorator/Utils/CacheManager.php(826): Includes\Utils\Operator::executeWithCustomMaxExecTime('600', Array)
#10 /home/numus/public_html/Includes/Decorator/Utils/CacheManager.php(845): Includes\Decorator\Utils\CacheManager::runStep(5)
#11 /home/numus/public_html/Includes/Decorator/Utils/CacheManager.php(1188): Includes\Decorator\Utils\CacheManager::runStepConditionally(5)
#12 /home/numus/public_html/top.inc.PHP53.php(90): Includes\Decorator\Utils\CacheManager::rebuildCache()
#13 /home/numus/public_html/top.inc.php(26): require_once('/home/numus/pub...')
#14 /home/numus/public_html/admin.php(16): require_once('/home/numus/pub...')
#15 {main}
__________________
Business License
https://glaspak.com
GoDaddy VPS - Apache with WHM
2GB ECC DDR3 1600MHz
2x Intel E5-2630L v2 Hex Core 2.4/2.8ghz
15 MB proc cache
60 GB 10k RPM hdd
PHP 7.0.15
MariaDB 10.1.21 with InnoDB engine