Datatables warning after update to 4.1.1

[jorola]

When selecting Members under Admnistration I get the following error:

Datatables warning table id = table_members Ajax error
For more information about this error, please see http://datatables.net/tn/7
No members are shown.

I can list members under Groups and roles.

Plugins were updated to latest version.

I've reverted to v 4.011.

Can anyone direct me where to look ?

BR Johnny

[fasse]

Hi Johnny,

I think there is a problem with the data that should be shown. Do you had selected a special list that should be shown within members or do you use the default selection of columns?

To find the problem within Admidio we must know which data is the cause for the problem.

Fasse

[plawrie]

Upgraded to 4.1.1. tonight.
I have had the same problem as jorola. I do not use the default columns
DataTables warning: table id=tbl_members - Ajax error. For more information about this error, please see http://datatables.net/tn/7

Under administration and module members, I get the above error
In groups and roles, I can click on "show member list" and all my data appears and can be edited.

[fasse]

To find the problem within Admidio members module we must know the column and maybe the value that causes this problem within your installations.

- Therefore please create a new simple list within groups & roles.
- This new list should only contain the columns first name and last name.
- Now assign this new list as the default list within the members module.
- Now open the members module.
- No error should occurs and the members should be shown.

If this works now add one additional column to this list.
Open the members module again and look if it works.
Do this again until the error occurs. Now we know which column causes the error.

Please post the column configuration and possible values of that column here so that I could try to reproduce the problem within my installation.

[plawrie]

Sorry, I can't make it NOT fail. How to I set the default in the members module. I've spent half an hour trying to find it!

[fasse]

Go to preferences to the modules tab and select members. There the first preference is the list whose columns should be shown.

[plawrie]

The preferences only show your default lists. Any lists which I have created "your configuration" do not show.

[plawrie]

I don't know if jorola applied the update to 4.1.1 as I did, but just to clarify what I did.
I installed 4.0 before Xmas, last night I downloaded 4.1.1, extracted it and ftp'd it all to my website
Version 4.0 was not deleted from my website beforehand.
Could the developers confirm whether this would be OK, or should I have deleted 4.0 before starting the ftp?

[plawrie]

While experimenting with displaying lists in order to find the datables warning, I noted that if more fields are defined than the screen-width can show then the list is truncated on the right. I do appreciate that longer fields, such as address lines take multiple lines in order to squeeze more on to the display, but fields later in the list do not appear, although they do appear in the csv extract.
Would it be possible to have a scroll bar on the bottom of the screen to show the additional fields?

[tomarppe]

Same issue here as well here is some error logs

DataTables warning: table id=tbl_members - Ajax error. For more information about this error, please see http://datatables.net/tn/7

when I use the search or try to access the user management, the following error message appears:

The server returns a "500 - Internal Error"

The following entries appears in the error.log file:

[Thu Jan 06 22:10:29.384167 2022] [php7:notice] [pid 17193] [client xxx.xxx.xxx.xxx:10064] PHP Notice: Undefined index: in /var/www/sitename/members/adm_program/system/classes/ListConfiguration.php on line 351, referer: https://site.com/members/adm_program/mo ... ?rol_ids=2
[Thu Jan 06 22:10:29.384296 2022] [php7:notice] [pid 17193] [client xxx.xxx.xxx.xxx:10064] PHP Notice: Undefined index: in /var/www/sitename/members/adm_program/system/classes/ListConfiguration.php on line 312, referer: https://site.com/members/adm_program/mo ... ?rol_ids=2
[Thu Jan 06 22:10:30.052653 2022] [php7:error] [pid 10477] [client xxx.xxx.xxx.xxx:13268] PHP Fatal error: Uncaught Error: Call to a member function fetch() on bool in /var/www/sitename/members/adm_program/modules/members/members_data.php:211\nStack trace:\n#0 {main}\n thrown in /var/www/sitename/members/adm_program/modules/members/members_data.php on line 211, referer: https://site.com/members/adm_program/mo ... embers.php
[Thu Jan 06 22:34:36.405653 2022] [php7:error] [pid 10477] [client xxx.xxx.xxx.xxx:45368] PHP Fatal error: Uncaught Error: Call to a member function fetch() on bool in /var/www/sitename/members/adm_program/modules/members/members_data.php:211\nStack trace:\n#0 {main}\n thrown in /var/www/sitename/members/adm_program/modules/members/members_data.php on line 211, referer: https://site.com/members/adm_program/mo ... embers.php
[Thu Jan 06 22:42:20.625006 2022] [php7:error] [pid 17190] [client xxx.xxx.xxx.xxx:32056] PHP Fatal error: Uncaught TypeError: Argument 1 passed to Session::reload() must be of the type int, string given, called in /var/www/sitename/members/adm_program/system/classes/TableMembers.php on line 185 and defined in /var/www/sitename/members/adm_program/system/classes/Session.php:355\nStack trace:\n#0 /var/www/sitename/members/adm_program/system/classes/TableMembers.php(185): Session->reload('')\n#1 /var/www/sitename/members/adm_program/system/classes/User.php(293): TableMembers->save()\n#2 /var/www/sitename/members/adm_program/system/classes/User.php(1800): User->changeRoleMembership('set', 2, '2022-01-05', '9999-12-31', false)\n#3 /var/www/sitename/members/adm_program/modules/profile/roles_save.php(186): User->setRoleMembership(2, '2022-01-06', '9999-12-31', false)\n#4 {main}\n thrown in /var/www/sitename/members/adm_program/system/classes/Session.php on line 355, referer: https://site.com/members/adm_program/mo ... new_user=1


This is the error in Browser console
GET https://site.com/members/adm_program/mo ... 1500294329 500

[fasse]

I found the error with help of toms log file and could resolve this for the next version.
https://github.com/Admidio/admidio/issues/1158

If you cant wait, you can go to your database (PhpMyAdmin) and send the following sql statement to the database where admidio is installed.

Code: Alles auswählen

DELETE FROM adm_list_columns WHERE lsc_usf_id IS NULL AND lsc_special_field IS NULL

If you use another table prefix than adm you must change the table name in the statement.

After that the members module should work again.

[plawrie]

Thanks, that has fixed it for me

[jorola]

Solved in version 4.1.2