Saving delivery or payment service error

[whatdaro]

Aimeos Ver: 2021.10.2
OS: Linux

hi Aimeos team,
I'm trying to save new delivery and payment services however they fail when I include price information.
If I create a new service without price information it completes and saves fine.
When I enter a price and try to save it fails with this error:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'value' cannot be null:
INSERT INTO "mshop_price" (
"type", "currencyid", "domain", "label",
"quantity", "value", "costs", "rebate", "taxrate",
"status", "mtime", "editor", "siteid", "ctime"
) VALUES (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
)
["default","AUD","service","",1,null,"888.00","0.00","\"\":\"20.00\"",1,"2021-11-23 14:51:34","jl@somewhere.com","1.","2021-11-23 14:51:34"]
#0 /var/www/html/ecom/shopten/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Price/Manager/Standard.php(511): Aimeos\MW\DB\Statement\DBAL\Prepared->execute()



I believe the problem is with this file \vendor\aimeos\aimeos-core\lib\mshoplib\src\MShop\Price\Manager\Standard.php
this line:

$stmt->bind( $idx++, $item->getValue() );
is retrieving a null value. I've tried entering values in all available fields for entry form in the admin control panel, but still have the issue.
Could you please let me know where this getValue() function is trying to retrieve the data from, thanks.

[aimeos]

You use PostgreSQL, don't you?

The mshop_price.value column already allows NULL values for ~4 month, so it's included in 2021.10.x:
https://github.com/aimeos/aimeos-core/b ... ce.php#L48

Just check:
- Run "php artisan aimeos:setup" to make sure the tables are up to date
- Does mshop_price.value actually allow NULL values in the database?

[whatdaro]

You use PostgreSQL, don't you?

Just check:
- Run "php artisan aimeos:setup" to make sure the tables are up to date
- Does mshop_price.value actually allow NULL values in the database?

I'm using MariaDB
I checked mshop_price.value was not set up to allow NULL.
I did do an Aimeos update but for some reason this table was not updated.

I ran "php artisan aimeos:setup", now it is working as expected, is this command part of the update process?

thanks for your help.

[aimeos]

I ran "php artisan aimeos:setup", now it is working as expected, is this command part of the update process?

Yes, if you update, you have to run this command.