I’m experiencing another issue with Dolibarr version 22.0.4 on Ubuntu, specifically with the Members module. When I try to create a contribution, the page does not load all the necessary fields. After selecting Create Contribution, I don’t receive any error message, but the form only shows New Contribution and Date of membership." This suggests the form is partially loading but missing several fields. How can I fix this
Can you enable the dolibarr debug log module, and set it to the highest level. Then you load the members contribution page and take a screenshot.
Dolibarr logs the data to the file dolibarr.log which is in the Documents folder. Please provide the a subset of that file where you load the member contribution page.
Please also include the error logs from your webserver.
Now, remember to set the debug level down to something like level 5.
No errors when activating the Create Button, see attached.
To Create Contribution for Memeber problem, Not all fields is loaded.
When selecting Create Contribution button
Only the heading New Contribution and Date of Contribution is showing on the page
No error msg is showing. Web Console show
There are no PHP or Database Error that pop up
error log.txt (283.0 KB)
I add a 0 to PHP $dolibarr_main_prod = ‘0’; to see if a error show when pressing the Create Contribution. Get this error 
Fatal error: Uncaught Exception: Unknown or bad format (P1) in /var/www/html/dolibarr/htdocs/core/lib/date.lib.php:170 Stack trace: #0 /var/www/html/dolibarr/htdocs/core/lib/date.lib.php(170): DateInterval->__construct() #1 /var/www/html/dolibarr/htdocs/adherents/subscription.php(990): dol_time_plus_duree() #2 {main} thrown in /var/www/html/dolibarr/htdocs/core/lib/date.lib.php on line 170
Let us see your extrafield definitions for members
2026-03-29 04:58:12 ERR 102.128.173.9 673890 33 DoliDBMysqli::query Exception in query instead of returning an error: Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1
2026-03-29 04:58:12 ERR 102.128.173.9 673890 33 DoliDBMysqli::query SQL Error message: DB_ERROR_1366 Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1 From /var/www/html/dolibarr/htdocs/debugbar/class/TraceableDB.php:362.
2026-03-29 04:58:15 ERR 102.128.173.9 673890 33 DoliDBMysqli::query Exception in query instead of returning an error: Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1
2026-03-29 04:58:15 ERR 102.128.173.9 673890 33 DoliDBMysqli::query SQL Error message: DB_ERROR_1366 Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1 From /var/www/html/dolibarr/htdocs/debugbar/class/TraceableDB.php:362.
2026-03-29 04:58:28 ERR 102.128.173.9 674295 33 DoliDBMysqli::query Exception in query instead of returning an error: Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1
2026-03-29 04:58:28 ERR 102.128.173.9 674295 33 DoliDBMysqli::query SQL Error message: DB_ERROR_1366 Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1 From /var/www/html/dolibarr/htdocs/debugbar/class/TraceableDB.php:362.
2026-03-29 05:00:31 ERR 102.128.173.9 673572 33 DoliDBMysqli::query Exception in query instead of returning an error: Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1
2026-03-29 05:00:31 ERR 102.128.173.9 673572 33 DoliDBMysqli::query SQL Error message: DB_ERROR_1366 Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1 From /var/www/html/dolibarr/htdocs/debugbar/class/TraceableDB.php:362.
2026-03-29 05:01:11 ERR 102.128.173.9 674286 33 DoliDBMysqli::query Exception in query instead of returning an error: Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1
2026-03-29 05:01:11 ERR 102.128.173.9 674286 33 DoliDBMysqli::query SQL Error query: UPDATE llx_extrafields set param = 'N;', printable = '' WHERE name = 'terminalpos' AND elementtype = 'user'
2026-03-29 05:01:11 ERR 102.128.173.9 674286 33 DoliDBMysqli::query SQL Error message: DB_ERROR_1366 Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1 From /var/www/html/dolibarr/htdocs/debugbar/class/TraceableDB.php:362.
2026-03-29 05:01:23 ERR 102.128.173.9 673573 33 DoliDBMysqli::query Exception in query instead of returning an error: Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1
2026-03-29 05:01:23 ERR 102.128.173.9 673573 33 DoliDBMysqli::query SQL Error query: UPDATE llx_extrafields set param = 'N;', printable = '' WHERE name = 'terminalpos' AND elementtype = 'user'
2026-03-29 05:01:23 ERR 102.128.173.9 673573 33 DoliDBMysqli::query SQL Error message: DB_ERROR_1366 Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1 From /var/www/html/dolibarr/htdocs/debugbar/class/TraceableDB.php:362.
2026-03-29 05:01:25 ERR 102.128.173.9 673573 33 DoliDBMysqli::query Exception in query instead of returning an error: Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1
2026-03-29 05:01:25 ERR 102.128.173.9 673573 33 DoliDBMysqli::query SQL Error query: UPDATE llx_extrafields set param = 'N;', printable = '' WHERE name = 'terminalpos' AND elementtype = 'user'
2026-03-29 05:01:25 ERR 102.128.173.9 673573 33 DoliDBMysqli::query SQL Error message: DB_ERROR_1366 Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1 From /var/www/html/dolibarr/htdocs/debugbar/class/TraceableDB.php:362.
2026-03-29 05:01:29 ERR 102.128.173.9 673573 33 DoliDBMysqli::query Exception in query instead of returning an error: Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1
2026-03-29 05:01:29 ERR 102.128.173.9 673573 33 DoliDBMysqli::query SQL Error query: UPDATE llx_extrafields set param = 'N;', printable = '' WHERE name = 'terminalpos' AND elementtype = 'user'
2026-03-29 05:01:29 ERR 102.128.173.9 673573 33 DoliDBMysqli::query SQL Error message: DB_ERROR_1366 Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1 From /var/www/html/dolibarr/htdocs/debugbar/class/TraceableDB.php:362.
2026-03-29 05:01:31 ERR 102.128.173.9 673573 33 DoliDBMysqli::query Exception in query instead of returning an error: Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1
2026-03-29 05:01:31 ERR 102.128.173.9 673573 33 DoliDBMysqli::query SQL Error query: UPDATE llx_extrafields set param = 'N;', printable = '' WHERE name = 'terminalpos' AND elementtype = 'user'
2026-03-29 05:01:31 ERR 102.128.173.9 673573 33 DoliDBMysqli::query SQL Error message: DB_ERROR_1366 Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1 From /var/www/html/dolibarr/htdocs/debugbar/class/TraceableDB.php:362.
2026-03-29 05:01:41 ERR 102.128.173.9 673573 33 DoliDBMysqli::query Exception in query instead of returning an error: Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1
2026-03-29 05:01:41 ERR 102.128.173.9 673573 33 DoliDBMysqli::query SQL Error query: UPDATE llx_extrafields set param = 'N;', printable = '' WHERE name = 'terminalpos' AND elementtype = 'user'
2026-03-29 05:01:41 ERR 102.128.173.9 673573 33 DoliDBMysqli::query SQL Error message: DB_ERROR_1366 Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1 From /var/www/html/dolibarr/htdocs/debugbar/class/TraceableDB.php:362.
jonbendtsen@Jons-MacBook-Pro ~ % wc -l /tmp/error\ log.txt
1163 /tmp/error log.txt
jonbendtsen@Jons-MacBook-Pro ~ % tail /tmp/error\ log.txt
2026-03-29 05:01:36 WARNING 102.128.173.9 673573 33 functions::dol_include_once Tried to load unexisting file: /core/boxes/box_members.php
2026-03-29 05:01:36 WARNING 102.128.173.9 673573 33 Failed to load box 'box_members' into file '/core/boxes/box_members.php'
2026-03-29 05:01:36 WARNING 102.128.173.9 673573 33 Functions.lib::dol_print_date function called with a bad value from page /index.php
2026-03-29 05:01:40 NOTICE 102.128.173.9 673573 33 --- Access to GET /admin/index.php - action=, massaction=
2026-03-29 05:01:41 NOTICE 102.128.173.9 673573 33 --- Access to GET /admin/modules.php - action=, massaction=
2026-03-29 05:01:41 ERR 102.128.173.9 673573 33 DoliDBMysqli::query Exception in query instead of returning an error: Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1
2026-03-29 05:01:41 ERR 102.128.173.9 673573 33 DoliDBMysqli::query SQL Error query: UPDATE llx_extrafields set param = 'N;', printable = '' WHERE name = 'terminalpos' AND elementtype = 'user'
2026-03-29 05:01:41 ERR 102.128.173.9 673573 33 DoliDBMysqli::query SQL Error message: DB_ERROR_1366 Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1 From /var/www/html/dolibarr/htdocs/debugbar/class/TraceableDB.php:362.
2026-03-29 05:01:51 NOTICE 102.128.173.9 674295 33 --- Access to GET /admin/syslog.php - action=, massaction=
2026-03-29 05:01:53 NOTICE 102.128.173.9 674295 33 --- Access to GET /document.php - action=, massaction= NOTOKENRENEWAL=1% jonbendtsen@Jons-MacBook-Pro ~ % grep -ir fail /tmp/error\ log.txt
/tmp/error log.txt:2026-03-29 04:58:25 WARNING 102.128.173.9 674295 33 Failed to load box 'box_members' into file '/core/boxes/box_members.php'
/tmp/error log.txt:2026-03-29 05:00:25 WARNING 102.128.173.9 673572 33 Failed to load box 'box_members' into file '/core/boxes/box_members.php'
/tmp/error log.txt:2026-03-29 05:01:08 WARNING 102.128.173.9 674286 33 Failed to load box 'box_members' into file '/core/boxes/box_members.php'
/tmp/error log.txt:2026-03-29 05:01:36 WARNING 102.128.173.9 673573 33 Failed to load box 'box_members' into file '/core/boxes/box_members.php'
Okay, the missing file is not an issue
jonbendtsen@Jons-MacBook-Pro dolibarr % find . -iname '*box*' | grep -v "/langs/" | grep -i member
./htdocs/core/boxes/box_members_last_modified.php
./htdocs/core/boxes/box_members_by_type.php
./htdocs/core/boxes/box_members_last_subscriptions.php
./htdocs/core/boxes/box_birthdays_members.php
./htdocs/core/boxes/box_members_subscriptions_by_year.php
./htdocs/core/boxes/box_members_by_tags.php
openingWe have identified the root cause: the duration column in llx_adherent_type contains values like 0y and 1y, but the Dolibarr code expects an ISO 8601 duration string such as P1Y (1 year) or P0Y (0 years). The error occurred when the code tried to parse 1y as P1 (invalid).
Changing that is still not opening the fields
I update the database : UPDATE llx_adherent_type SET duration = ‘P1Y’ WHERE duration = ‘1y’;
UPDATE llx_adherent_type SET duration = ‘P0Y’ WHERE duration = ‘0y’;
Not fixing the Problem Turn back to 1y
@MobileIT I would still like to see the definitions of your extrafields/complementary attributes for the members module
here’s what I’d like you to do: Change Visibility to 0 for all complementary attributes on members, then enable debug logging, load the member page that creates issues and post the dolibarr.log section, the webserver log segment, but do not bother about the browsers webconsole, I do not think it is an JavaScript issue.
Do you have any Complementary Attributes on member types??
Okay, so I split the log file using csplit, and a little bit of shell script to rename the files.
jonbendtsen@Jons-MacBook-Pro a % head -1 xx*
==> xx00 <==
2026-03-29 15:07:56 DEBUG 102.128.173.9 689081 33 Removed file /var/www/html/dolibarr/documents/dolibarr.log
==> xx01_adherents_index.php <==
2026-03-29 15:08:02 NOTICE 102.128.173.9 689083 33 --- Access to GET /adherents/index.php - action=, massaction=
==> xx02_adherents_list.php <==
2026-03-29 15:08:04 NOTICE 102.128.173.9 689083 33 --- Access to GET /adherents/list.php - action=, massaction=
==> xx03_index.php <==
2026-03-29 15:08:06 NOTICE 185.16.39.146 689077 33 --- Access to GET /index.php - action= - actionlogin= - showing the login form and exit
==> xx04_adherents_card.php <==
2026-03-29 15:08:07 NOTICE 102.128.173.9 689083 33 --- Access to GET /adherents/card.php - action=, massaction=
==> xx05_adherents_subscription.php <==
2026-03-29 15:08:12 NOTICE 102.128.173.9 692247 33 --- Access to GET /adherents/subscription.php - action=, massaction=
==> xx06_adherents_subscription.php <==
2026-03-29 15:08:14 NOTICE 102.128.173.9 692247 33 --- Access to GET /adherents/subscription.php - action=addsubscription, massaction=
==> xx07_index.php <==
2026-03-29 15:08:18 NOTICE 102.128.173.9 692247 33 --- Access to GET /index.php - action=, massaction=
==> xx08_admin_index.php <==
2026-03-29 15:08:21 NOTICE 102.128.173.9 692247 33 --- Access to GET /admin/index.php - action=, massaction=
==> xx09_admin_modules.php <==
2026-03-29 15:08:24 NOTICE 102.128.173.9 692247 33 --- Access to GET /admin/modules.php - action=, massaction=
==> xx10_admin_syslog.php <==
2026-03-29 15:08:31 NOTICE 102.128.173.9 689072 33 --- Access to GET /admin/syslog.php - action=, massaction=
==> xx11_document.php <==
2026-03-29 15:08:34 NOTICE 102.128.173.9 689072 33 --- Access to GET /document.php - action=, massaction= NOTOKENRENEWAL=1
I only have errors in these files
xx02_adherents_list.php
xx04_adherents_card.php
xx05_adherents_subscription.php
xx06_adherents_subscription.php
xx09_admin_modules.php
jonbendtsen@Jons-MacBook-Pro a % grep ERR xx*
xx02_adherents_list.php:2026-03-29 15:08:04 ERR 102.128.173.9 689083 33 DoliDBMysqli::query Exception in query instead of returning an error: Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1
xx02_adherents_list.php:2026-03-29 15:08:04 ERR 102.128.173.9 689083 33 DoliDBMysqli::query SQL Error message: DB_ERROR_1366 Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1 From /var/www/html/dolibarr/htdocs/debugbar/class/TraceableDB.php:362.
xx04_adherents_card.php:2026-03-29 15:08:07 ERR 102.128.173.9 689083 33 DoliDBMysqli::query Exception in query instead of returning an error: Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1
xx04_adherents_card.php:2026-03-29 15:08:07 ERR 102.128.173.9 689083 33 DoliDBMysqli::query SQL Error message: DB_ERROR_1366 Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1 From /var/www/html/dolibarr/htdocs/debugbar/class/TraceableDB.php:362.
xx05_adherents_subscription.php:2026-03-29 15:08:12 ERR 102.128.173.9 692247 33 DoliDBMysqli::query Exception in query instead of returning an error: Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1
xx05_adherents_subscription.php:2026-03-29 15:08:12 ERR 102.128.173.9 692247 33 DoliDBMysqli::query SQL Error message: DB_ERROR_1366 Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1 From /var/www/html/dolibarr/htdocs/debugbar/class/TraceableDB.php:362.
xx06_adherents_subscription.php:2026-03-29 15:08:14 ERR 102.128.173.9 692247 33 DoliDBMysqli::query Exception in query instead of returning an error: Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1
xx06_adherents_subscription.php:2026-03-29 15:08:14 ERR 102.128.173.9 692247 33 DoliDBMysqli::query SQL Error message: DB_ERROR_1366 Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1 From /var/www/html/dolibarr/htdocs/debugbar/class/TraceableDB.php:362.
xx09_admin_modules.php:2026-03-29 15:08:24 ERR 102.128.173.9 692247 33 DoliDBMysqli::query Exception in query instead of returning an error: Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1
xx09_admin_modules.php:2026-03-29 15:08:24 ERR 102.128.173.9 692247 33 DoliDBMysqli::query SQL Error message: DB_ERROR_1366 Incorrect integer value: '' for column `dolibarr`.`llx_extrafields`.`printable` at row 1 From /var/www/html/dolibarr/htdocs/debugbar/class/TraceableDB.php:362.
I would delete all the Complementary Attributes/extrafields, then see if there is still an error, and after that is all green, I would recreate the Complementary Attributes one by one testing if it still works fine after adding each Complementary Attributes/extrafields
I deleted the complementary attributes, but it makes no difference to the rest of the field loading.
I don’t like this. I think you need to examine the code, and examine the data in your database to see exactly why and where it fails
