New installation Piwigo 13.7.0, installed Mugshot get "doesn't support this version of Piwigo" message;go to Plugins/Check for updates, see that MugShot 2.0.2-> 2.0.3 is avail, so I select 'Install' and get "All plugins are up to date" and go back to Plugins/List/Deactivated.
MugShot is still listed with red triangle error "WARNING: this plugin does not seem to be compatible with this version of Piwigo" and it still reports Ver 2.0.2
Try activating anyway, get "an error occurred" toast message and PHP logs error:
[02-Jun-2023 13:47:58 America/Los_Angeles] PHP Fatal error: Uncaught mysqli_sql_exception: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) in /home/dh_kgmndt/kmpics.stidolph.com/piwigo/include/dblayer/functions_mysqli.inc.php:132
Stack trace:
#0 /home/dh_kgmndt/kmpics.stidolph.com/piwigo/include/dblayer/functions_mysqli.inc.php(132): mysqli->query('CREATE TRIGGER ...')
#1 /home/dh_kgmndt/kmpics.stidolph.com/piwigo/plugins/MugShot/include/helpers.php(75): pwg_query('CREATE TRIGGER ...')
#2 /home/dh_kgmndt/kmpics.stidolph.com/piwigo/plugins/MugShot/maintain.inc.php(43): create_tag_drop_trigger()
#3 /home/dh_kgmndt/kmpics.stidolph.com/piwigo/admin/include/plugins.class.php(139): MugShot_maintain->install('2.0.2', Array)
#4 /home/dh_kgmndt/kmpics.stidolph.com/piwigo/admin/include/plugins.class.php(191): plugins->perform_action('install', 'MugShot')
#5 /home/dh_kgmndt/kmpics.stidolph.com/piwigo/include/ws_functions/pwg.extensions.php(76): plugins->perform_action('activate', 'MugShot')
#6 /home/dh_kgmndt/kmpics.stidolph.com/piwigo/include/ws_core.inc.php(600): ws_plugins_performAction(Array, Object(PwgServer))
#7 /home/dh_kgmndt/kmpics.stidolph.com/piwigo/include/ws_protocols/rest_handler.php(41): PwgServer->invoke('pwg.plugins.per...', Array)
#8 /home/dh_kgmndt/kmpics.stidolph.com/piwigo/include/ws_core.inc.php(281): PwgRestRequestHandler->handleRequest(Object(PwgServer))
#9 /home/dh_kgmndt/kmpics.stidolph.com/piwigo/ws.php(22): PwgServer->run()
#10 {main}
thrown in /home/dh_kgmndt/kmpics.stidolph.com/piwigo/include/dblayer/functions_mysqli.inc.php on line 132
From the helpers.php file I see the comment around line 68 that indicates you know this "is silently failing" so this Issue might be just to alert you that it specifically seems bad for MugShot if deployed on a server that doesn't have full permissions; for example, Dreamhost Shared Hosting doesn't allow creating Triggers (https://help.dreamhost.com/hc/en-us/articles/115000263911-MySQL-limitations-due-to-shared-hosting
says Shared: Allow existing triggers to be used (creating of new triggers is not supported)
New installation Piwigo 13.7.0, installed Mugshot get "doesn't support this version of Piwigo" message;go to Plugins/Check for updates, see that MugShot 2.0.2-> 2.0.3 is avail, so I select 'Install' and get "All plugins are up to date" and go back to Plugins/List/Deactivated.
MugShot is still listed with red triangle error "WARNING: this plugin does not seem to be compatible with this version of Piwigo" and it still reports Ver 2.0.2
Try activating anyway, get "an error occurred" toast message and PHP logs error:
From the helpers.php file I see the comment around line 68 that indicates you know this "is silently failing" so this Issue might be just to alert you that it specifically seems bad for MugShot if deployed on a server that doesn't have full permissions; for example, Dreamhost Shared Hosting doesn't allow creating Triggers (https://help.dreamhost.com/hc/en-us/articles/115000263911-MySQL-limitations-due-to-shared-hosting
says
Shared: Allow existing triggers to be used (creating of new triggers is not supported)