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
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
Offline
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
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
After many times repeated upload by ftp it is now working! I don't know reason of previous problems
Offline