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
Additional info: I disabled all plugins. Same problem persist.
2otherjobs
Offline
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
$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.
Offline
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