Magento – Magento2.3 – How to set text column table value default is None using declarative schema

databasedeclarative-schemamagento2magento2.3

I want to create a custom table using db_schema.xml like that contains column like this:

I tried to do it like this:

<column name="description" nullable="false" default="null" xsi:type="text"/>

but always got an error like this:

The XML in file "/var/www/M2/app/code/Vendor/Module/etc/db_schema.xml" is invalid:
Element 'column', attribute 'default': The attribute 'default' is not allowed.

Best Answer

I think the problem is nullable="false" your setting the column should not be null and you are setting its default value to null, so, here you are creating a conflict for an interpreter I guess. Try the below code and let us know the result.

<column xsi:type="text" name="description" nullable="true" default="NULL" comment="Description"/>

Related Solutions

Magento 2.2.5 – Fix Customer Export After Creating Custom Attributes

I have tried the below code with static datatype but it has consequences as mentioned below:

$customerSetup->addAttribute(Customer::ENTITY, self::APPROVE_ACCOUNT,
        [
            'type' => 'static',
            'label' => 'Approve Account',
            'input' => 'select',
            "source"   => "RBC\Customersegment\Model\Config\Source\CustomerYesNoOptions",
            'required' => false,
            'default' => '1',
            'visible' => true,
            'user_defined' => true,
            'sort_order' => 215,
            'position' => 215,
            'system' => false,
        ]);

Using static datatype in attribute will solve the problem in grid export but will throw error while reindexing as the the attribute type is static, it will look into customer_entity table for this field which you might not have created. So in your case, you can follow the suggestions as mentioned below.

It seems that you have not created field in customer_entity table, you are using attribute here, so make sure you have not added field in customer_listing layout in ui_component directory. Also you don't have to add the field in indexer.xml as for attributes, it automatically updates data in customer_grid_flat table.

I hope this helps you with your problem.

Best Answer

Related Solutions

Magento 2.2.5 – Fix Customer Export After Creating Custom Attributes

Related Topic