Hello/Hi/Greetings,
firstly I have to say that I am not familiar with PHP MySQL etc. I am only user (but really satisfied with Piwigo!).
I click on the automatic upgrade from 2.7.0 to 2.8.1 but everything was collapsed, message on the screen you can see below. Can somebody help me?
Thanks a lot!!!!
Ivan
Warning: [mysql error 2006] MySQL server has gone away
INSERT INTO
phpwebgallery_config (param, value)
VALUES('piwigo_db_version', '2.8')
ON DUPLICATE KEY UPDATE value = '2.8'
; in /srv6/www/natureblink.com/subdomains/www/gallery/include/dblayer/functions_mysqli.inc.php on line 832
Warning: [mysql error 2006] MySQL server has gone away
SELECT id
FROM phpwebgallery_plugins
WHERE state = 'active'
AND id NOT IN ('AdminTools','TakeATour','language_switch','LocalFilesEditor')
; in /srv6/www/natureblink.com/subdomains/www/gallery/include/dblayer/functions_mysqli.inc.php on line 832
Fatal error: Call to a member function fetch_assoc() on a non-object in /srv6/www/natureblink.com/subdomains/www/gallery/include/dblayer/functions_mysqli.inc.php on line 213
Warning: [mysql error 2006] MySQL server has gone away
REPLACE INTO phpwebgallery_sessions
(id,data,expiration)
VALUES('93E7b2e8383850d8f792886d1a16b2393392','pwg_device|s:7:\"desktop\";pwg_mobile_theme|b:0;amm_random_pics|a:125:{i:0;s:4:\"2740\";i:1;s:4:\"8097\";i:2;s:3:\"681\";i:3;s:3:\"165\";i:4;s:4:\"1412\";i:5;s:4:\"2790\";i:6;s:4:\"7732\";i:7;s:4:\"1024\";i:8;s:4:\"1033\";i:9;s:4:\"2021\";i:10;s:4:\"3957\";i:11;s:3:\"801\";i:12;s:4:\"4380\";i:13;s:4:\"1276\";i:14;s:4:\"3482\";i:15;s:4:\"2734\";i:16;s:4:\"1730\";i:17;s:4:\"4875\";i:18;s:4:\"8466\";i:19;s:4:\"4205\";i:20;s:4:\"4151\";i:21;s:4:\"1102\";i:22;s:4:\"2904\";i:23;s:4:\"5519\";i:24;s:4:\"1578\";i:25;s:3:\"356\";i:26;s:4:\"7558\";i:27;s:4:\"1614\";i:28;s:4:\"6365\";i:29;s:4:\"5038\";i:30;s:4:\"7415\";i:31;s:4:\"4999\";i:32;s:4:\"6576\";i:33;s:4:\"8388\";i:34;s:4:\"3687\";i:35;s:4:\"5494\";i:36;s:3:\"673\";i:37;s:4:\"4895\";i:38;s:4:\"3484\";i:39;s:4:\"6540\";i:40;s:4:\"7292\";i:41;s:4:\"5845\";i:42;s:4:\"3961\";i:43;s:4:\"4973\";i:44;s:4:\"5675\";i:4 in /srv6/www/natureblink.com/subdomains/www/gallery/include/dblayer/functions_mysqli.inc.php on line 832
Piwigo version:
PHP version:
MySQL version:
Piwigo URL: http://
Offline
Offline
could you be mroe specific?
Is the message "MySQL server has gone away" appearing when you launch the upgrade of the database? If yes that means your server has trouble to process the database probably due to a big history table. Check that and try to empty it
Or your server is very low in ressources
Offline
Yes,
this message appears after my trying to upgrade Piwigo to 2.8.1
As I wrote I am not familiar with databases software. Please can zou write me what I have to change/empty (see figure)?
Offline
Excuse me, figure had a wrong size, now it could be OK
edited: don't display the url
Last edited by flop25 (2016-05-20 14:15:38)
Offline
Go 'up' ; when you have all tables listed on the right, a column is about the table size. Is it big for the history one?
Offline
If I understand to it it is really big:
phpwebgallery_history Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 14,887,406 MyISAM latin1_swedish_ci
I have to press "empty"???
Thanks a lot!
Ivan
edited: don't display the url!!
Last edited by flop25 (2016-05-20 14:26:22)
Offline
I Emptied it and is Piwigo working!!!
Thank you very much for your help!!!!
Ivan
Offline
Great!!
Have a good day
Offline