Module Builder creates invalid SQL when using chkbxlst

[jeff-techstension]

Bug

When building an object for a custom module with the chkbxlst type the column type becomes chkbxlst instead of text. This prevents the table from being able to be created.

public $fields=array(
		"rowid" => array("type"=>"integer", "label"=>"TechnicalID", "enabled"=>"1", 'position'=>1, 'notnull'=>1, "visible"=>"0", "noteditable"=>"1", "index"=>"1", "css"=>"left", "comment"=>"Id"),
		
"fk_filepurpose" => array("type"=>"chkbxlst:c_filepurpose:label:rowid", "label"=>"FilePurpose", "enabled"=>"1", 'position'=>120, 'notnull'=>1, "visible"=>"1", "index"=>"1", "css"=>"maxwidth500 widthcentpercentminusxx", "csslist"=>"tdoverflowmax150", "help"=>"Link to the file purpose", "validate"=>"1",)
	);

This is an example of the SQL that it generates

CREATE TABLE llx_filepurpose_filepurposeassociation(
	-- BEGIN MODULEBUILDER FIELDS
	rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, 
	fk_filepurpose chkbxlst NOT NULL, 
	-- END MODULEBUILDER FIELDS
) ENGINE=innodb;

Dolibarr Version

20.0.1

Environment PHP

8.2

Environment Database

MariaDb 11.5.2-ubi9

Steps to reproduce the behavior and expected behavior

1. Create a custom module using the rad builder
2. Create a new object through the UI
3. Add a column with type chkbxlst
4. Generate the SQL
5. View the objectname_modulename.sql file
6. check the column and see chkbxlst as the type.

Attached files

No response

[bafbes]

Fixed in #31923