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

Problem with Help_Documents #1300

New Issue
Closed
opened 2026-03-30 18:24:11 +00:00 by pctechnikch · 2 comments
pctechnikch commented 2026-03-30 18:24:11 +00:00
Member
Copy link
Copy source

Steps to reproduce the issue

Hello

I'm really excited about the new version of JCB. I've been tasked with migrating a client's project from JCB V3 to V6. Version 3 had the Help_Document function. I've seen that this code is also included in JCB V6, so I have everything I need. The single view displays correctly. Unfortunately, saving causes an error "Incorrect integer value! What's wrong? Is it my MySQL or the new MariaDB version, or am I missing something? I also need to know where I can insert the use Joomla\Filesystem\Folder; statement in the header for custom fields.

Expected result

Actual result

Error [],site_view,url' for column 'not_required' at row 1

System information (as much as possible)

  • OS Name & Version: Ubuntu Linux 24.04.4
  • MySql Version: MariaDB Version 10.11.14
  • Apache Version: 2.4.58
  • PHP Version: 8.3
  • Joomla Version: 6.0.3
  • JCB Version: 6.1.5
  • Browser: Chrome Firefox

Additional comments

It would be fantastic if we could find a solution. I would be happy with inline help, but as they say, this is how it's requested.

Thanks René

### Steps to reproduce the issue Hello I'm really excited about the new version of JCB. I've been tasked with migrating a client's project from JCB V3 to V6. Version 3 had the Help_Document function. I've seen that this code is also included in JCB V6, so I have everything I need. The single view displays correctly. Unfortunately, saving causes an error "Incorrect integer value! What's wrong? Is it my MySQL or the new MariaDB version, or am I missing something? I also need to know where I can insert the `use Joomla\Filesystem\Folder;` statement in the header for custom fields. ### Expected result ### Actual result Error `[],site_view,url' for column 'not_required' at row 1` ### System information (as much as possible) - OS Name & Version: Ubuntu Linux 24.04.4 - MySql Version: MariaDB Version 10.11.14 - Apache Version: 2.4.58 - PHP Version: 8.3 - Joomla Version: 6.0.3 - JCB Version: 6.1.5 - Browser: Chrome Firefox ### Additional comments It would be fantastic if we could find a solution. I would be happy with inline help, but as they say, this is how it's requested. Thanks René
ErrorHelpDocumentsMigration01.jpg
181 KiB
ErrorHelpDocumentsMigration01.jpg
Lemuel commented 2026-04-13 08:44:46 +00:00
Owner
Copy link
Copy source

Hi, thanks for reaching out and for the detailed description of the issue.

From what you've described, this looks very likely to be related to a legacy database structure carried over from Joomla 3, rather than something directly caused by JCB itself.

In Joomla 3, there were cases where a not_required column existed in certain tables. During migration to newer Joomla versions (like Joomla 6), this column is no longer expected, and its presence can lead to errors such as:

"Incorrect integer value for column not_required"
or
"Data truncated for column not_required"

I encountered a very similar issue on a migrated system. In that case, simply removing the not_required column from the relevant help document table resolved the problem completely. The column didn't appear to be used anywhere in the current system, and once removed, saving worked as expected again.

What I recommend:

  1. Inspect the database table related to the help document that's throwing the error.
  2. Check whether a not_required column exists.
  3. If it does, try removing that column and test saving again.

Important note:

The Help Documents in JCB are not the same as help documents inside your own custom components, so this is most likely specific to your migrated environment rather than a general JCB issue.

That said, if you are seeing this error directly within JCB (not just your own component), it would be good for us to verify further. In that case, please share:

  • Screenshots of the error
  • Full debug logs
  • The table structure (especially the affected table)

In our clean test environments (including standard JCB test setups), this issue does not occur. However, we did observe it on a long-lived dev system that was originally migrated from Joomla 3, which further supports the database migration angle.

So the immediate fix is to clean up that legacy column, and if anything still persists after that, we can dig deeper together.

Hi, thanks for reaching out and for the detailed description of the issue. From what you've described, this looks very likely to be related to a legacy database structure carried over from Joomla 3, rather than something directly caused by JCB itself. In Joomla 3, there were cases where a `not_required` column existed in certain tables. During migration to newer Joomla versions (like Joomla 6), this column is no longer expected, and its presence can lead to errors such as: > *"Incorrect integer value for column `not_required`"* > or > *"Data truncated for column `not_required`"* I encountered a very similar issue on a migrated system. In that case, simply removing the `not_required` column from the relevant help document table resolved the problem completely. The column didn't appear to be used anywhere in the current system, and once removed, saving worked as expected again. ### What I recommend: 1. Inspect the database table related to the help document that's throwing the error. 2. Check whether a `not_required` column exists. 3. If it does, try removing that column and test saving again. ### Important note: The Help Documents in JCB are not the same as help documents inside your own custom components, so this is most likely specific to your migrated environment rather than a general JCB issue. That said, if you are seeing this error directly within JCB (not just your own component), it would be good for us to verify further. In that case, please share: * Screenshots of the error * Full debug logs * The table structure (especially the affected table) In our clean test environments (including standard JCB test setups), this issue does not occur. However, we did observe it on a long-lived dev system that was originally migrated from Joomla 3, which further supports the database migration angle. So the immediate fix is to clean up that legacy column, and if anything still persists after that, we can dig deeper together.
pctechnikch commented 2026-04-15 11:27:59 +00:00
Author
Member
Copy link
Copy source

Thank you, unbelievable! I won't even mention how long I searched, anyway. Thank you so much, the problem is solved.

I've seen that the Inline Help is quite good. The only issue is that you have to re-enter it first.

JCB is brilliant, thanks again!

René

Thank you, unbelievable! I won't even mention how long I searched, anyway. Thank you so much, the problem is solved. I've seen that the Inline Help is quite good. The only issue is that you have to re-enter it first. JCB is brilliant, thanks again! René
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
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#1300