Error re-saving Getcustims dynamicgets with Joomla table option #1180

New Issue

Closed

opened 2024-10-16 22:45:17 +00:00 by eciudad · 3 comments

eciudad commented

2024-10-16 22:45:17 +00:00

Steps to reproduce the issue

Create a Getcustom dynamics get and select joomla database table

Expected result

Save the first time and able to save after change

Actual result

Cannot re-save after initial save. Getting error:
"Save failed with the following error: Incorrect integer value: '' for column 'view_table_main' at row 1"

System information (as much as possible)

OS Name & Version: Joomla! 5.1.4 Stable [ Kudumisha ] 27-August-2024 16:00 GMT
MySql Version: 8.0.34-cll-lve
Apache Version:
PHP Version: 8.2.23
Joomla Version: Joomla! 5.1.4
JCB Version: 5.0.4-alpha2
Browser: Microsoft Edge

Additional comments

I found more of this error:
It is specific to all dynamicgets that are Getcustoms types. This message relates to a table named qyj_componentbuilder_dynamic_get . The column is question gets a '0' value on the getcustoms dynamicgets type with a joomla database selection option. The getlistQuery and getitems all get values when saved, but getcustoms do not. I did a query on four columns of the table.

SELECT id,asset_id,view_selection,view_table_main FROM qyj_componentbuilder_dynamic_get WHERE 1;

The results files screen shots are included with this issue.

### Steps to reproduce the issue Create a Getcustom dynamics get and select joomla database table ### Expected result Save the first time and able to save after change ### Actual result Cannot re-save after initial save. Getting error: "Save failed with the following error: Incorrect integer value: '' for column 'view_table_main' at row 1" ### System information (as much as possible) - OS Name & Version: Joomla! 5.1.4 Stable [ Kudumisha ] 27-August-2024 16:00 GMT - MySql Version: 8.0.34-cll-lve - Apache Version: - PHP Version: 8.2.23 - Joomla Version: Joomla! 5.1.4 - JCB Version: 5.0.4-alpha2 - Browser: Microsoft Edge ### Additional comments I found more of this error: It is specific to all dynamicgets that are Getcustoms types. This message relates to a table named qyj_componentbuilder_dynamic_get . The column is question gets a '0' value on the getcustoms dynamicgets type with a joomla database selection option. The getlistQuery and getitems all get values when saved, but getcustoms do not. I did a query on four columns of the table. SELECT `id`,`asset_id`,`view_selection`,`view_table_main` FROM `qyj_componentbuilder_dynamic_get` WHERE 1; The results files screen shots are included with this issue.

Screenshot_16-10-2024_165913.jpeg

215 KiB

Screenshot_16-10-2024_17231.jpeg

279 KiB

Screenshot_16-10-2024_17445.jpeg

156 KiB

Screenshot_16-10-2024_17356.jpeg

193 KiB