2022.04 Checkout suppliercode null

[columbo]

Hi,

in Aimeos 2022.04 checkout, after click on "buy now" I receive the error below:

Not null violation: 7 FEHLER: NULL-Wert in Spalte \u00bbsuppliercode\u00ab verletzt Not-Null-Constraint\n
DETAIL: Fehlgeschlagene Zeile enth\u00e4lt (611, 320, 1.

Code: Select all

SQLSTATE[25P02]: In failed sql transaction: 7 FEHLER: aktuelle Transaktion wurde abgebrochen, Befehle werden bis zum Ende der Transaktion ignoriert: INSERT INTO "madmin_log" ( "facility", "timestamp", "priority", "message", "request", "siteid" ) VALUES ( ?, ?, ?, ?, ?, ? ) ["client\/html","2022-05-23 08:00:55",4,

"SQLSTATE[23502]: Not null violation: 7 FEHLER: NULL-Wert in Spalte \u00bbsuppliercode\u00ab verletzt Not-Null-Constraint\n
DETAIL: Fehlgeschlagene Zeile enth\u00e4lt (611, 320, 1., null, null, select, 38117, dasd, null, default, test, , , , , 1, EUR, 978.00, 0.00, 0.00, 88.9091, {\"tax\":\"10.00\"}, 1, 0, 0, -1, 2022-05-23 08:00:55, 2022-05-23 08:00:55, Test (Firma 1), 38115, Default, 1, -1, ).: \n\t\t\t\t\t\tINSERT INTO \"mshop_order_base_product\" ( \n\t\t\t\t\t\t\t\"baseid\", \"ordprodid\", \"ordaddrid\", \"type\", \"parentprodid\", \"prodid\", \"prodcode\",\n\t\t\t\t\t\t\t\"vendor\", \"stocktype\", \"name\", \"description\", \"mediaurl\", \"timeframe\",\n\t\t\t\t\t\t\t\"quantity\", \"currencyid\", \"price\", \"costs\", \"rebate\", \"tax\", \"taxrate\", \"taxflag\",\n\t\t\t\t\t\t\t\"flags\", \"statuspayment\", \"statusdelivery\", \"pos\", \"mtime\", \"editor\", \"target\", \"qtyopen\", \"notes\",\n\t\t\t\t\t\t\t\"siteid\", \"ctime\"\n\t\t\t\t\t\t) VALUES ( \n\t\t\t\t\t\t\t?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?\n\t\t\t\t\t\t)\n\t\t\t\t\t[\"320\",null,null,\"select\",\"38115\",\"38117\",\"dasd\",\"Default\",\"default\",\"test\",\"\",\"\",\"\",1,\"EUR\",\"978.00\",\"0.00\",\"0.00\",\"88.9091\",\"{\\\"tax\\\":\\\"10.00\\\"}\",true,0,-1,-1,0,\"2022-05-23 08:00:55\",\" (Firma 1)\",\"\",1,\"\",\"1.\",\"2022-05-23 08:00:55\"]\r\n
#0 C:\\xampp_php8\\htdocs\\shop\\vendor\\aimeos\\aimeos-core\\src\\MShop\\Order\\Manager\\Base\\Product\\Standard.php(835): Aimeos\\Base\\DB\\Statement\\DBAL\\Prepared->execute()\n#1 [internal function]: Aimeos\\MShop\\Order\\Manager\\Base\\Product\\Standard->saveItem(Object(Aimeos\\MShop\\Order\\Item\\Base\\Product\\Standard), true)\n
#2 C:\\xampp_php8\\htdocs\\shop\\vendor\\aimeos\\aimeos-core\\src\\MShop\\Common\\Manager\\Decorator\\Base.php(51): call_user_func_array(Array, Array)\n#3 [internal function]: Aimeos\\MShop\\Common\\Manager\\Decorator\\Base->__call('saveItem', Array)\n#4 

I could not find any info that suppliercode is mandatory.

Thank you

[aimeos]

The "suppliercode" column isn't used any more and should have been removed when running this during updating your installation:

Code: Select all

php artisan aimeos:setup

[columbo]

executed:

Code: Select all

composer up

and

Code: Select all

php artisan aimeos:setup

But column "suppliercode" remains unchanged in table "mshop_order_base_product". (using PostgreSQL)

[aimeos]

Can you please execute:

Code: Select all

composer req aimeos/aimeos-core:2022.04.x-dev
php artisan aimeos:setup

This should remove the "suppliercode" column now to avoid the problem.

[columbo]

Now its resolved - Thank you!