joomla/Component-Builder
42
28 Fork 13
Code Issues 56 Pull Requests Projects Wiki Activity

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 Markus · 2 comments
Markus commented 2024-08-01 17:04:01 +00:00
Member
Copy link
Copy source

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?

### 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
Screenshot 2024-08-01 at 18-26-53 Editing the Joomla Component.png
Markus added the Bug label 2024-08-01 17:04:01 +00:00
Markus reopened this issue 2024-08-01 17:04:54 +00:00
Llewellyn commented 2024-08-01 17:06:25 +00:00
Owner
Copy link
Copy source

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.
Markus commented 2024-08-02 06:51:24 +00:00
Author
Member
Copy link
Copy source

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.
Sign in to join this conversation.
No Branch/Tag Specified
Labels
Clear labels
Beta
Issues related to the a beta release
 Bug
Documentation
URGENT
enhancement
help wanted
invalid
joomla
Joomla related changes
 question
wontfix
No labels Bug
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
aamigo Eunice Hannah Jeff Lemuel Llewellyn Malachi Roline vistamedia Martin (Martin Kopp) aB0t (Robot) ro-ot (root) TLWebdesign (Tom van der Laan)
No Assignees
2 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: joomla/Component-Builder#1157