BUG: Unknown column 't.ref' in 'field list' object link to category for a project

[JonBendtsen]

Bug

I added a complementary attribute to my projects, an link to an object with this definition: Categorie:categories/class/categorie.class.php

And I got this error in the GUI when I tried to modify a project, even before trying to modify this new complementary attribute.

In dolibarr.log I got this error:

2025-01-28 22:24:11 WARNING 10.0.2.100         9354     33 functions::dol_include_once Tried to load unexisting file: /categorie/class/categorie.class.php
2025-01-28 22:24:11 ERR     10.0.2.100         9354     33 DoliDBMysqli::query Exception in query instead of returning an error: Unknown column 't.ref' in 'field list'
2025-01-28 22:24:11 ERR     10.0.2.100         9354     33 DoliDBMysqli::query SQL Error query: SELECT t.rowid, t.ref FROM llx_categorie as t WHERE 1=1 ORDER BY t.ref ASC
2025-01-28 22:24:11 ERR     10.0.2.100         9354     33 DoliDBMysqli::query SQL Error message: DB_ERROR_NOSUCHFIELD Unknown column 't.ref' in 'field list' From /var/www/html/core/class/html.form.class.php:8547.
2025-01-28 22:24:11 ERR     10.0.2.100         9354     33 Error url=/projet/card.php?action=edit&token=****&id=21, query_string=action=edit&token=****&id=21, 

but after doing this command ln -s categories/ categorie the WARNING disappeared. But the error message is still there,

The text of the GUI error message is

This website or feature is currently temporarily not available or failed after a technical error.

This may be due to a maintenance operation. Current status of operation (2025-01-28T23:26:18Z) are on next line...

Dolibarr has detected a technical error. You can read log file or set option $dolibarr_main_prod to '0' in your config file to get more information.

Dolibarr Version

v.20.0.2 docker image

Environment PHP

v.20.0.2 docker image

Environment Database

MariaDB 11.5.2-MariaDB-ubu2404

Steps to reproduce the behavior and expected behavior

No response

Attached files

No response

[hregis]

@JonBendtsen you can test this fix : #32846

[hregis]

@JonBendtsen you can add filter to have just product categories :

Categorie:categories/class/categorie.class.php:0:(t.type:=:0)

[JonBendtsen]

@JonBendtsen you can add filter to have just product categories :

Categorie:categories/class/categorie.class.php:0:(t.type:=:0)

this change alone still gives this GUI error

This website or feature is currently temporarily not available or failed after a technical error.

This may be due to a maintenance operation. Current status of operation (2025-01-29T19:08:54Z) are on next line...

Dolibarr has detected a technical error. You can read log file or set option $dolibarr_main_prod to '0' in your config file to get more information.

[JonBendtsen]

@JonBendtsen you can test this fix : #32846

Thank you, this seems to work perfectly, I even changed the Complementary Attribute definition back to

Categorie:categories/class/categorie.class.php

and it still works

[JonBendtsen]

If I may move the goal post. Even before the fix you made @hregis I noticed that I could not as expected edit unless I modified the entire project, that is still the case and would probably warrant it's own bug report/(feature request).

product_category definition

View project does not allow edit of product category

modify project allows edit of product_category

[hregis]

@JonBendtsen ok it's fixed : #32846

[JonBendtsen]

@hregis many thanks, this works too