Announcement

#1 2016-05-20 09:00:49

lanius
Translation Team
Czech Republic
2012-03-07
21

[resolved] collapse after upgrade 2.7-2.8

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

 

#2 2016-05-20 10:36:13

lanius
Translation Team
Czech Republic
2012-03-07
21

Offline

 

#3 2016-05-20 13:57:54

flop25
Piwigo Team
2006-07-06
6791

Re: [resolved] collapse after upgrade 2.7-2.8

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


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#4 2016-05-20 14:10:18

lanius
Translation Team
Czech Republic
2012-03-07
21

Re: [resolved] collapse after upgrade 2.7-2.8

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

 

#5 2016-05-20 14:12:48

lanius
Translation Team
Czech Republic
2012-03-07
21

Re: [resolved] collapse after upgrade 2.7-2.8

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

 

#6 2016-05-20 14:18:29

flop25
Piwigo Team
2006-07-06
6791

Re: [resolved] collapse after upgrade 2.7-2.8

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?


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#7 2016-05-20 14:25:22

lanius
Translation Team
Czech Republic
2012-03-07
21

Re: [resolved] collapse after upgrade 2.7-2.8

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

 

#8 2016-05-20 14:31:15

lanius
Translation Team
Czech Republic
2012-03-07
21

Re: [resolved] collapse after upgrade 2.7-2.8

I Emptied it and is Piwigo working!!!

Thank you very much for your help!!!!

Ivan

Offline

 

#9 2016-05-20 14:32:38

flop25
Piwigo Team
2006-07-06
6791

Re: [resolved] collapse after upgrade 2.7-2.8

Great!!
Have a good day


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2018 · Contact