#1 2019-11-30 16:09:10

2otherjobs
Member
2014-07-14
30

Cannot use the 'Admin - Users - Manage' page. JSON Error

Hello/Hi/Greetings,

First, I want to thank the creators and maintainer of Piwigo for doing such a great job over the years.  I have been a happy user since about 2013.  I self-host; I use FreeBSD and run Piwigo in it's own jail. 

All works well except the Admin-Users-Manage page.  I have phpMyAdmin installed and the users_table is present and correct.

Piwigo version:  2.95 and 2.10.1 (two separate installations)
PHP version: 7.2
MySQL version: 8.0
Piwigo URL: https://archive.tgbartlett.net

The error I get when I click on the Users-Manage page is:

DataTables warning: table id=userList - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1

I have searched the forums and the only recent suggestion I have found is:

http://piwigo.org/forum/viewtopic.php?id=23275

As a result, my local/config/config.ini.php is:
<?php

/* The file does not exist until some information is entered
below. Once information is entered and saved, the file will be created. */
$conf['show_php_errors'] = E_ERROR;
/*If you included ImageMagick, don't forget to set*/
$conf['ext_imagick_dir'] = '/usr/local/bin/';

?>
I tried this as well from another forum topic :
$conf['show_php_errors'] = E_ALL ^ E_DEPRECATED;

I have searched the forums for other options and have not found any that help.  Any help?

Thanks in advance,
2otherjobs

Offline

 

#2 2019-11-30 16:50:46

2otherjobs
Member
2014-07-14
30

Re: Cannot use the 'Admin - Users - Manage' page. JSON Error

Additional info:  I disabled all plugins.  Same problem persist.
2otherjobs

Offline

 

#3 2019-12-30 21:28:05

gschramm
Member
2019-12-30
1

Re: Cannot use the 'Admin - Users - Manage' page. JSON Error

I'm brandnew to Piwigo and have the exact same issue.

My environment:
Piwigo 2.10.1
Operating system: WINNT
PHP: 7.2.26 (Show info) [2019-12-30 20:27:03]
MySQL: 8.0.18 [2019-12-30 21:27:03]
Graphics Library: GD bundled (2.1.0 compatible)


The E_ERROR setting also doesn't solve this for me, it's having no effect at all.

Any help is greatly appreciated.

Offline

 

#4 2019-12-30 21:50:24

erAck
Only trying to help
2015-09-06
2236

Re: Cannot use the 'Admin - Users - Manage' page. JSON Error

$conf['show_php_errors']  is about, well, PHP language errors and warnings. The indicated "Invalid JSON response" is not a PHP warning. To investigate what could be wrong do what the also cited link https://datatables.net/manual/tech-notes/1 suggests and use the browser's developer tools.


Running Piwigo at https://erack.net/gallery/

Offline

 

#5 2020-03-08 06:35:16

2otherjobs
Member
2014-07-14
30

Re: Cannot use the 'Admin - Users - Manage' page. JSON Error

In the interests of closing out posts with problems, the following post fixed this problem:  https://piwigo.org/forum/viewtopic.php?id=29922

I thought the upgrade to 2.10.1 might have code to fix the mysql 8.0 restricted words problem, but for this particular piwigo file, the fix was not included.

Line 204 in piwigo/admin/user_list_backend.php needs slight modification to:

GROUP_CONCAT(name ORDER BY name SEPARATOR ", ") AS `groups`

Note the back ticks on the `groups`.  Now I can list and manipulate my users list without trouble.    Thanks to all who developed this fix.

Offline

 

Board footer

Powered by FluxBB