🌍
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 2020-03-21 18:19:10
- THudson
- Member
- 2017-03-23
- 15
Error under photos?
Hello/Hi/Greetings,
I get the following error displayed under the photos:
Warning: [mysql error 1054] Unknown column 'last_visit' in 'field list'
UPDATE piwigo_user_infos
SET last_visit = NOW(),
lastmodified = lastmodified
WHERE user_id = 1
in /home/hp3-linc4-nfs2-y/555/1099555/user/htdocs/Photos/include/dblayer/functions_mysqli.inc.php on line 856
I have gone to phpmyadmin and looked at the table piwigo_user_infos but there isn't a column last_visit, but there is a column lastmodified.
Is it because I deleted the old version and re-installed the program from scratch
Is there any wayI can recify this without starting from scratch.
Piwigo version: 2.10.1
PHP version: 7.3
MySQL version: 5.6
Piwigo URL: http://www.1066mfc.co.uk/Photos/index.php
Offline
#2 2020-03-21 18:55:28
- erAck
- Only trying to help
- 2015-09-06
- 2021
Re: Error under photos?
You didn't do yourself a favour by deleting the old version first.. a proper upgrade would had updated the database and added necessary tables, fields and indexes. Probably best to restore a backup, or lacking that (do a backup first!) delete the new version, install the old version again, and then do an upgrade.
Otherwise you'd have to execute the necessary upgrade steps manually that can be found in install/db/*-database.php and first find out from which to start, check your old version's plugins/check_files_integrity/data/piwigo-*-sums.txt file and search for install/db/ and note down the highest number listed there. All steps in all higher numbered install/db/*-database.php files would have to be executed in order. Cumbersome.
Running Piwigo at https://erack.net/gallery/
Offline
#3 2020-03-23 18:29:16
- THudson
- Member
- 2017-03-23
- 15
Re: Error under photos?
I am not sure which version I installed before. Is there a file in the database that will show what version it was created with?
I setup the Piwgo in March 2017. What version was available then. Can I get an old version, as I have had a new PC since then and lost some data.
If the above fails, looks like I will have to start from stratch and delete the database and start again.
What do you suggest?
Offline
#4 2020-03-23 22:05:53
- erAck
- Only trying to help
- 2015-09-06
- 2021
Re: Error under photos?
March 2017 was Piwigo 2.8.6 the latest release.
All releases are available from GitHub Releases.
Running Piwigo at https://erack.net/gallery/
Offline