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

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

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.

I had a similar issue, it was fixed in the latest alpha3 update, so I would recommend you to update JCB and try again.

I had a similar issue, it was fixed in the latest alpha3 update, so I would recommend you to update JCB and try again.
Author

just upgraded to JCB Version: 5.0.4-alpha3 and it looks like the issue is resolved. I am testing my component further to verify.

just upgraded to JCB Version: 5.0.4-alpha3 and it looks like the issue is resolved. I am testing my component further to verify.
Owner

Yes we fixed this issue, its database related, and should now be resolved.

Yes we fixed this issue, its database related, and should now be resolved.
Sign in to join this conversation.
No Milestone
No project
No Assignees
3 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: joomla/Component-Builder#1180
No description provided.