I have a virtual column called KG_H in my db.
When I change some value in the form and I save I get this message:
"[08] Error: during query execution. UPDATE `TBL_COMMESSE` SET `ID_LINEA` = '4', `ID_LOTTO` = '24062', `MATERIALE` = 'HD BIANCO', `ID_SOGGETTO` = '189', `ID_MARCHIO` = '0', `NOTE` = NULL, `STATO_COMMESSA` = '2', `POS_SEQUENZA` = '0', `KG_H` = '287.43' where `ID_LOTTO` = '24062'
The DBMS server said: SQLSTATE[HY000]: General error: 1906 The value specified for generated column 'KG_H' in table 'TBL_COMMESSE' has been ignored"
In this case, should I use only HOOKS for updating the value in the column instead using virtual column by the db?
Thank you
You are running the latest release of DaDaBIK
In case you want to upgrade to a more powerful edition (from Pro to Enterprise/Platinum, from Enterprise to Platinum) please contact us.
mysql version: 5.5.5-10.3.39-MariaDB-0+deb10u2
Web server: Apache/2.4.38 (Raspbian)
Client: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36
When I change some value in the form and I save I get this message:
"[08] Error: during query execution. UPDATE `TBL_COMMESSE` SET `ID_LINEA` = '4', `ID_LOTTO` = '24062', `MATERIALE` = 'HD BIANCO', `ID_SOGGETTO` = '189', `ID_MARCHIO` = '0', `NOTE` = NULL, `STATO_COMMESSA` = '2', `POS_SEQUENZA` = '0', `KG_H` = '287.43' where `ID_LOTTO` = '24062'
The DBMS server said: SQLSTATE[HY000]: General error: 1906 The value specified for generated column 'KG_H' in table 'TBL_COMMESSE' has been ignored"
In this case, should I use only HOOKS for updating the value in the column instead using virtual column by the db?
Thank you
Your current DaDaBIK version
You are using DaDaBIK version 11.12-Elba enterprise, installed on 25-03-2024 (installation code: 194506601bb58bf10c), the latest version of DaDaBIK is 11.12-Elba released on 30-11-2023You are running the latest release of DaDaBIK
In case you want to upgrade to a more powerful edition (from Pro to Enterprise/Platinum, from Enterprise to Platinum) please contact us.
System info
PHP Version: 7.3.31-1~deb10u5mysql version: 5.5.5-10.3.39-MariaDB-0+deb10u2
Web server: Apache/2.4.38 (Raspbian)
Client: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36
Last edited: