joomla/Component-Builder

Fork 10

component configuration save fails with errors Data truncated for column 'not_required' at row 1 #1157

New Issue

Open

opened 2024-08-01 17:04:01 +00:00 by kommid · 2 comments

kommid commented

2024-08-01 17:04:01 +00:00

Member

What Happened?

I can't save my joomla components' settings in JCB. First JCB complained about:
Save failed with the following error: Incorrect integer value: '' for column c2j5.y1fda_componentbuilder_joomla_component.add_backup_folder_path at row 1
Overriding the Backup Folder Path, fixed this, but I think, this is not as intended....
Same happened for Git Folder Path and JCB Powers Path. After overriding all of those optional settings, it now complains:
Save failed with the following error: Data truncated for column 'not_required' at row 1

Steps to reproduce the Bug

Click on a component in JCB and save it

Which Joomla version are you compiling in?

5.1.2

Which PHP version are you compiling in?

8.3

Which Joomla versions are you targeting?

Which PHP version are you targeting?

8.3

Which Web server is JCB running on?

Apache 2.4

Which Relational Database is JCB running on?

10.5.23-MariaDB-0+deb11u1

Which OS is JCB running on?

Debian 11

Which JCB version are you using?

first 5.0.1 then 5.0.2-beta2

Where in JCB did this issue occur?

Joomla Components(admin_views)

On which browsers did you encounter the issue?

Firefox

Additional Comments

I did not test this on a fresh J! install with a fresh JCB. It's an updated Installation that comes from J!3. It worked perfectly on J!3 and it compiled well for J!5. So maybe anyone else could check, if they have this problem too?

### What Happened? I can't save my joomla components' settings in JCB. First JCB complained about: `Save failed with the following error: Incorrect integer value: '' for column `c2j5`.`y1fda_componentbuilder_joomla_component`.`add_backup_folder_path` at row 1` Overriding the Backup Folder Path, fixed this, but I think, this is not as intended.... Same happened for Git Folder Path and JCB Powers Path. After overriding all of those optional settings, it now complains: `Save failed with the following error: Data truncated for column 'not_required' at row 1` ### Steps to reproduce the Bug Click on a component in JCB and save it ### Which Joomla version are you compiling in? 5.1.2 ### Which PHP version are you compiling in? 8.3 ### Which Joomla versions are you targeting? 5 ### Which PHP version are you targeting? 8.3 ### Which Web server is JCB running on? Apache 2.4 ### Which Relational Database is JCB running on? 10.5.23-MariaDB-0+deb11u1 ### Which OS is JCB running on? Debian 11 ### Which JCB version are you using? first 5.0.1 then 5.0.2-beta2 ### Where in JCB did this issue occur? Joomla Components(admin_views) ### On which browsers did you encounter the issue? Firefox ### Additional Comments I did not test this on a fresh J! install with a fresh JCB. It's an updated Installation that comes from J!3. It worked perfectly on J!3 and it compiled well for J!5. So maybe anyone else could check, if they have this problem too?

Screenshot 2024-08-01 at 18-26-53 Editing the Joomla Component.png

196 KiB

kommid added the

Bug

label 2024-08-01 17:04:01 +00:00

kommid closed this issue

2024-08-01 17:04:28 +00:00

kommid reopened this issue

2024-08-01 17:04:54 +00:00

Llewellyn commented

2024-08-01 17:06:25 +00:00

Owner

this must be an existing component, so just remove not_required from the #__componentbuilder_joomla_component table.

this must be an existing component, so just remove `not_required` from the `#__componentbuilder_joomla_component` table.

kommid commented

2024-08-02 06:51:24 +00:00

Author

Member

OK, this did the trick for the Save failed with the following error: Data truncated for column not_required at row 1 error message, but it still won't let me save my component without overriding Backup folder path, Git Folder Path and JCB Powers Path.

OK, this did the trick for the `Save failed with the following error: Data truncated for column not_required at row 1` error message, but it still won't let me save my component without overriding Backup folder path, Git Folder Path and JCB Powers Path.