Announcement

#1 2017-10-12 21:00:40

lanius
Translation Team
Czech Republic
2012-03-07
28

unexpected behaviour after update to 2.9.2

Hello/Hi/Greetings,

I am only user, not IT man (my Piwigo gallery is at http://natureblink.com/gallery/index.php?.htm (the whole web is www.natureblink.com).

I have problems after update to Piwigo 2.9.2 (I am not sure, but probably from 2.8)

When I go to Albums, at head I see:

Notice: Undefined index: index_edit_icon in /srv6/www/natureblink.com/subdomains/www/gallery/index.php on line 202

Notice: Undefined index: index_caddie_icon in /srv6/www/natureblink.com/subdomains/www/gallery/index.php on line 210

Notice: Undefined index: index_sizes_icon in /srv6/www/natureblink.com/subdomains/www/gallery/index.php on line 325

Warning: Cannot modify header information - headers already sent by (output started at /srv6/www/natureblink.com/subdomains/www/gallery/index.php:202) in /srv6/www/natureblink.com/subdomains/www/gallery/include/page_header.php on line 101"

And at the foot:

Warning:  [mysql error 1054] Unknown column 'last_visit' in 'field list'

UPDATE phpwebgallery_user_infos
  SET last_visit = NOW(),
      lastmodified = lastmodified
  WHERE user_id = 1
in /srv6/www/natureblink.com/subdomains/www/gallery/include/dblayer/functions_mysqli.inc.php on line 845

When I press Tool I se:
parsererror SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data


I tried also Repair and optimize database with error:

Warning:  [mysql error 1034] 137 when fixing table
ALTER TABLE phpwebgallery_history ORDER BY id; in /srv6/www/natureblink.com/subdomains/www/gallery/include/dblayer/functions_mysqli.inc.php on line 845



Warning:  [mysql error 2006] MySQL server has gone away
DESC phpwebgallery_history_summary; in /srv6/www/natureblink.com/subdomains/www/gallery/include/dblayer/functions_mysqli.inc.php on line 845


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 226



Warning:  [mysql error 2006] MySQL server has gone away

REPLACE INTO phpwebgallery_sessions
  (id,data,expiration)
  VALUES('50BC7f653b518f9a9f22b8086b5ab8789277','pwg_device|s:7:\"desktop\";pwg_mobile_theme|b:0;pwg_uid|i:1;pwg_multiview|a:8:{s:7:\"view_as\";s:1:\"1\";s:5:\"theme\";s:4:\"dark\";s:4:\"lang\";s:5:\"en_UK\";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.2|b:0;extensions_need_update|a:1:{s:9:\"languages\";a:2:{s:5:\"no_NO\";s:5:\"2.9.2\";s:5:\"sl_SL\";s:5:\"2.9.2\";}}',now())
; in /srv6/www/natureblink.com/subdomains/www/gallery/include/dblayer/functions_mysqli.inc.php on line 845


Please, can everybody help me?

Thanks a lot!!!

Ivan


My Environment is:

    Piwigo 2.9.2
    Operating system: Linux
    PHP: 5.2.10-2ubuntu6.4 (Show info) [2017-10-12 20:50:08]
    MySQL: 5.0.67-0ubuntu6-log [2017-10-12 20:50:08]
    Graphics Library: ImageMagick 6.5.1-0



Piwigo URL: http://natureblink.com/gallery/index.php?.htm

Last edited by lanius (2017-10-12 21:01:41)

Offline

 

#2 2017-10-12 21:53:38

flop25
Piwigo Team
2006-07-06
7037

Re: unexpected behaviour after update to 2.9.2

Hello
your history is so huge that the update did not succeed and now you have a not correctly updated database with up to date files

Take your database backup (because you come from 2.8.x) and before updating purge the history or make sure you're doing it while the server is not too busy


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

 

#3 2017-10-12 22:07:40

lanius
Translation Team
Czech Republic
2012-03-07
28

Re: unexpected behaviour after update to 2.9.2

Hello flop25,

thank you. You are probably right.
But excuse me my stupid, I am only user - how I will do database backup (and purge the history)?

Thank you very much for your help

Ivan

Offline

 

#4 2017-10-13 14:09:30

lanius
Translation Team
Czech Republic
2012-03-07
28

Re: unexpected behaviour after update to 2.9.2

Hello,

I made all necessary for manual upgrade according procedure at web, including backup tables and copy all files by ftp but still I have problem.

When I tried to upgrade I obtained message:

Warning: include_once(./admin/include/functions.php) [function.include-once]: failed to open stream: No such file or directory in /srv6/www/natureblink.com/subdomains/www/gallery/upgrade.php on line 52

Warning: include_once() [function.include]: Failed opening './admin/include/functions.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /srv6/www/natureblink.com/subdomains/www/gallery/upgrade.php on line 52

Warning: include(./admin/include/languages.class.php) [function.include]: failed to open stream: No such file or directory in /srv6/www/natureblink.com/subdomains/www/gallery/upgrade.php on line 140

Warning: include(./admin/include/languages.class.php) [function.include]: failed to open stream: No such file or directory in /srv6/www/natureblink.com/subdomains/www/gallery/upgrade.php on line 140

Warning: include() [function.include]: Failed opening './admin/include/languages.class.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /srv6/www/natureblink.com/subdomains/www/gallery/upgrade.php on line 140

Fatal error: Class 'languages' not found in /srv6/www/natureblink.com/subdomains/www/gallery/upgrade.php on line 141


Please, can you help me???

Thanks a lot

Ivan

Offline

 

#5 2017-10-14 11:06:54

lanius
Translation Team
Czech Republic
2012-03-07
28

Re: unexpected behaviour after update to 2.9.2

After many times repeated upload by ftp it is now working! I don't know reason of previous problems

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact