Data too long for column 'bank' at row 1

Using my Dolibarr CRM/SRM Modules
1

Hi all.
I’m new in using Dolibarr. Have `st time istalled Dolibarr: 13.0.0-beta.
I wanto write dowm Bank name in bank in Edit account, but have problem:
Requested URL: /compta/bank/card.php?id=1
Menu manager: eldy_menu.php
Modules/Applications: user, societe, propal, fournisseur, supplier_proposal, banque
Database type manager: mysqli
Return code for latest database access request error: DB_ERROR_1406
Information for latest database access request error: Data too long for column ‘bank’ at row 1
How to FIX?
I don’t want to allow whole base use longer name, just for this column.

2

Hi,

Beta versions are not supported on the forum, only the stable versions.

You should install V12.0.3

4

Have tried on test version 12.0.3. Have same problem.
I think need to make long name int his column…but i have not fixed it yet.
Data too long for column ‘bank’ at row 1 sql=INSERT INTO llx_bank_account

5

I have manually changed VARCHAR to 100 by mySQL:

ALTER TABLE «llx_bank_account» CHANGE «bank» «bank» VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

Need to change " to `

Don’t know where is installation file to change it.

6

Dolibarr 13.0.4

Error “Data too long for column ‘rum’ at row 1” when trying to add a new bank account for supplier.

I see the “rum” field in “llx_societe_rib” is set to 32 characters.

Is it possible that it is too small or does it need to be of this length, if so, why does Dolibarr try to create a more than 32 characters longer length RUM and cause the error?

Anyone else please?

Regards