X-Cart forums

[GlasPak]

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

[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}

[qualiteam]

How does your Model class (the one that adds the field) look like?

[GlasPak]

Originally Posted by qualiteam

How does your Model class (the one that adds the field) look like?

<?php
// vim: set ts=4 sw=4 sts=4 et:

namespace XLite\Module\EBLIEB\GlasPak\Model;

class Product extends \XLite\Model\Product implements \XLite\Base\IDecorator
{
    /**
     * @Column (type="string", length=32)
     */
    protected $PPCField;
    
    /**
     * Updates "Pieces per case" field.
     * 
     * @param string $value New value
     * 
     * @return void
     */
    public function setPPCField($value)
    {
        $this->PPCField = $value;
    }

    /**
     * Returns the value of "Pieces per case" field.
     * 
     * @return string
     */
    public function getPPCField()
    {
        return $this->PPCField;
    }
}

http://devs.x-cart.com/en/basics/understanding_models.html - This doesn't seem to reference Not Null vs Null...

Edit:

Does Xlite follow the doctrine? http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/annotations-reference.html

Would this work to my PPCField set to null?

{
    /**
     * @Column (type="string", length=32, nullable=true)
     */
    protected $PPCField;

[qualiteam]

Would this work to my PPCField set to null?

@Column (type="string", length=32, nullable=true)

Yes, this should work.

Also, if you need the opposite, you can it like this:

@Column (type="integer", options={ "unsigned": true, "default": 0 })