Unknown column (likely for asset/card.php)

[mdeweerd]

Bug

I just upgraded from 19.0.2 to 20.0.2 and decided to add some assets.
When trying to add a financial immobilisation (deposit), I ended up with HTTP 500 error.

Side note: The cancellation amount can not be 0 - it looks like this is the residual end value in the books, and I think it should be allowed to be 0.

2024-11-14 01:00:45 ERR     0.0.0.0     607304     33 DoliDBMysqli::query Exception in query instead of returning an error: Unknown column 'ref_ext' in 'field list'
2024-11-14 01:00:45 ERR     0.0.0.0     607304     33 DoliDBMysqli::query SQL Error query: SELECT rowid, ref, ref_ext FROM llx_asset_model WHERE entity IN (1) AND rowid = 2
2024-11-14 01:00:45 ERR     0.0.0.0     607304     33 DoliDBMysqli::query SQL Error message: DB_ERROR_NOSUCHFIELD Unknown column 'ref_ext' in 'field list' From /home/www/REDACTED/dolibarr20/htdocs/core/class/commonobject.class.php:925.
2024-11-14 01:01:00 ERR     0.0.0.0     607301     33 DoliDBMysqli::query Exception in query instead of returning an error: Unknown column 'ref_ext' in 'field list'
2024-11-14 01:01:00 ERR     0.0.0.0     607301     33 DoliDBMysqli::query SQL Error query: SELECT rowid, ref, ref_ext FROM llx_asset_model WHERE entity IN (1) AND rowid = 2
2024-11-14 01:01:00 ERR     0.0.0.0     607301     33 DoliDBMysqli::query SQL Error message: DB_ERROR_NOSUCHFIELD Unknown column 'ref_ext' in 'field list' From /home/www/REDACTED/dolibarr20/htdocs/core/class/commonobject.class.php:925.
2024-11-14 01:01:13 ERR     0.0.0.0     613692     33 DoliDBMysqli::query Exception in query instead of returning an error: Unknown column 'ref_ext' in 'field list'
2024-11-14 01:01:13 ERR     0.0.0.0     613692     33 DoliDBMysqli::query SQL Error query: SELECT rowid, ref, ref_ext FROM llx_asset_model WHERE entity IN (1) AND rowid = 2
2024-11-14 01:01:13 ERR     0.0.0.0     613692     33 DoliDBMysqli::query SQL Error message: DB_ERROR_NOSUCHFIELD Unknown column 'ref_ext' in 'field list' From /home/www/REDACTED/dolibarr20/htdocs/core/class/commonobject.class.php:925.
2024-11-14 01:01:13 ERR     0.0.0.0     613692     33      DoliDBMysqli::close Closing a connection with an opened transaction depth=5
2024-11-14 01:01:13 WARNING 0.0.0.0     613692     33      --- End access to /dolibarr/asset/card.php (Warn: db disconnection forced, transaction depth was 5) 

Dolibarr Version

20.0.2

Environment PHP

8.2.20

Environment Database

10.11.6-MariaDB-0+deb12u1

Steps to reproduce the behavior and expected behavior

Attached files

No response

[marc-dll]

Hello,

I will try to reproduce

Greetings