🌍
English
Getting mysql errors when attempting to load picture.php. Error output follows.
Warning: [mysql error 2006] MySQL server has gone away UPDATE piwigo_images SET hit = hit+1, lastmodified = lastmodified WHERE id = 1075 ; in /include/dblayer/functions_mysqli.inc.php on line 845 Warning: [mysql error 2006] MySQL server has gone away SELECT id,uppercats,commentable,visible,status,global_rank FROM piwigo_image_category INNER JOIN piwigo_categories ON category_id = id WHERE image_id = 1075 AND (id NOT IN (90,131)) ; in /include/dblayer/functions_mysqli.inc.php on line 845 Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /include/dblayer/functions_mysqli.inc.php:911 Stack trace: #0 /include/functions.inc.php(1453): query2array('\nSELECT id,uppe...') #1 /picture.php(473): array_from_query('\nSELECT id,uppe...') #2 {main} thrown in /include/dblayer/functions_mysqli.inc.php on line 911 Warning: [mysql error 2006] MySQL server has gone away REPLACE INTO piwigo_sessions (id,data,expiration) VALUES('6CF5d42a7a0e0d0554211b1d6686681998e8','pwg_show_metadata|b:1;pwg_whois_list_ids|s:0:\"\";pwg_whois_url_type|s:0:\"\";pwg_device|s:7:\"desktop\";pwg_uid|i:1;pwg_multiview|a:8:{s:7:\"view_as\";s:1:\"1\";s:5:\"theme\";s:7:\"elegant\";s:4:\"lang\";s:5:\"en_US\";s:12:\"show_queries\";b:0;s:10:\"debug_l10n\";b:0;s:14:\"debug_template\";b:0;s:22:\"template_combine_files\";b:1;s:10:\"no_history\";b:0;}need_update2.9.1|b:0;extensions_need_update|a:1:{s:7:\"plugins\";a:1:{s:15:\"MenuRandomPhoto\";s:5:\"2.8.4\";}}incompatible_plugins|a:2:{s:10:\"~~expire~~\";i:1507035615;s:7:\"AddInfo\";s:5:\"2.7.c\";}pwg_referer_image_id|s:4:\"1075\";bulk_manager_filter|a:1:{s:8:\"category\";s:3:\"105\";}',now()) ; in /include/dblayer/functions_mysqli.inc.php on line 845
Piwigo version: 2.9.1
PHP version: 7.1
MySQL version: 5.1 (last I checked)
Last edited by digibirdtrek (2017-10-03 15:18:39)
Offline
Additional note: This error is only occurring on some images, not all, which is more than a bit odd. I have been moving some categories around (reorganizing)., however some of the failed loads on images are occurring in categories that have not been moved.
Last edited by digibirdtrek (2017-10-03 15:32:13)
Offline