🌍
English
Announcement
- [2024-04-17] Piwigo 14.4.0
- [2024-04-01] Piwigo in Hobbit runes
- [2024-03-01] Piwigo 14.3.0
- [2024-01-30] Piwigo 14.2.0
- [2023-12-29] Piwigo 14.1.0
#1 2017-07-08 09:16:44
- phillipv1101
- Member
- 2017-07-08
- 2
DB error after 2.9.1 upgrade
Hello/Hi/Greetings,
I have recently upgraded my Piwigo version to 2.9.1. After the upgrade i am seeing this message near the bottom of every page:
Warning: [mysql error 1054] Unknown column 'last_visit' in 'field list'
UPDATE user_infos
SET last_visit = NOW(),
lastmodified = lastmodified
WHERE user_id = 1
in /var/www/html/include/dblayer/functions_mysqli.inc.php on line 845
Can anyone tell me what needs to be repaired? This looks like a database issue but could just be a file left over from the old version that didn't get properly updated. Thanks in advance for any help.
Piwigo version: 2.9.1
PHP version: 7.0.18
MySQL version: 5.7.18
Piwigo URL: http://
Offline
#2 2017-07-11 00:55:41
- flop25
- Piwigo Team
- 2006-07-06
- 7037
Re: DB error after 2.9.1 upgrade
Hello
[Forum, topic 23208] READ ME: getting an error after the update? first pelase thx
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-07-11 06:02:07
- phillipv1101
- Member
- 2017-07-08
- 2
Re: DB error after 2.9.1 upgrade
I followed the instructions for a manual upgrade and completed all steps. The database upgrade step just came up with a message that said the database was already current and no updates were needed. All source files were copied over from the latest 2.9.1 release. The error is still there. Any other ideas? Thanks for your help.
Offline
Notice: Undefined offset: 5 in /var/www/piwigo.org/forum/include/parser.php on line 551
#4 2017-07-11 15:42:10
- flop25
- Piwigo Team
- 2006-07-06
- 7037
Re: DB error after 2.9.1 upgrade
unfortunately updates didn't go well
this one [Github] Piwigo file install/db/149-database.php You didn't have a blank page or errors during the upgrade?
put $conf['check_upgrade_feed'] = true; in your local config and if an update is found missing it will ask you to upgrade through a top banner
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