Pages: 1
Hi all,
I have run the updates to 13.3.0 in my sandbox. According to the UI it says "Currently running version 13.3.0", "Repair and optimise database" runs without issues and update.php results in "No upgrade required, the database structure is up to date".
BUT
in the last update in piwigo_upgrades is 162 and the database changes like adding 'user_agent' haven't happened:
Warning: [mysql error 1054] Unknown column 'user_agent' in 'field list'
How can I get my database back into valid state?
Thanks for any hints!
Piwigo 13.3.0 Check for upgrade
Installed on 17 October 2015, 7 years 1 month 3 weeks 4 days ago
Operating system: WINNT
PHP: 7.3.7 (Show info) [2022-12-11 21:42:49]
MySQL: 5.7.24 [2022-12-11 21:42:49]
Graphics Library: GD bundled (2.1.0 compatible)
Cache size N/A never calculated Refresh
Offline
It seems that at least the last db upgrade was not executed: install/db/164-database.php
But that should had been already in 13.0.0 ...
And install/db/163-database.php since 12.0.0 if 162 was the last piwigo_upgrade id.
Run upgrade.php (not update.php).
Offline
I'd like to understand how this new column can be "not created". Can you perform this SQL query :
select * from piwigo_upgrade order by applied desc limit 20;
Offline
plg wrote:
I'd like to understand how this new column can be "not created". Can you perform this SQL query :
Code:
select * from piwigo_upgrade order by applied desc limit 20;
See below. I have now added the changes from 163-database.php and 164-database.php manually to the database. Now import starts but I end up in https://piwigo.org/forum/viewtopic.php?id=32381. Will try the fix mentioned there.
localhost/piwigo/piwigo_upgrade/ http://localhost/phpmyadmin/index.php?route=/table/sql&db=piwigo&table=piwigo_users Showing rows 0 - 19 (20 total, Query took 0.0016 seconds.) [applied: 2021-11-14 19:52:34... - 2015-10-17 22:30:38...] select * from piwigo_upgrade order by applied desc limit 20; id applied description 161 2021-11-14 19:52:34 [migration from 11.0.0 to 12.1.0, 0.007 s] remove ... 162 2021-11-14 19:52:34 [migration from 11.0.0 to 12.1.0, 0.144 s] change ... 160 2021-11-14 19:52:34 [migration from 11.0.0 to 12.1.0, 0.004 s] add lou... 158 2021-06-20 16:38:26 [migration from 2.10.0 to 11.5.0, 0.056 s] set def... 157 2021-06-20 16:38:26 [migration from 2.10.0 to 11.5.0, 0.001 s] add con... 159 2021-06-20 16:38:26 [migration from 2.10.0 to 11.5.0, 0.503 s] add ind... 156 2019-10-09 15:54:00 [migration from 2.9.0 to 2.10.0, 0.001 s] bug fixi... 153 2019-10-09 15:54:00 [migration from 2.9.0 to 2.10.0, 0.001 s] Show dat... 155 2019-10-09 15:54:00 [migration from 2.9.0 to 2.10.0, 0.015 s] add colu... 154 2019-10-09 15:54:00 [migration from 2.9.0 to 2.10.0, 0.004 s] add acti... 149 2017-05-29 21:42:36 [migration from 2.8.0 to 2.9.0, 0.004 s] add last_... 152 2017-05-29 21:42:36 [migration from 2.8.0 to 2.9.0, 0.005 s] add 5 par... 150 2017-05-29 21:42:36 [migration from 2.8.0 to 2.9.0, 0.006 s] add histo... 151 2017-05-29 21:42:36 [migration from 2.8.0 to 2.9.0, 0.002 s] add "pict... 148 2016-03-29 21:10:20 [migration from 2.7.0 to 2.8.0, 0.044 s] add auth_... 147 2016-03-29 21:10:20 [migration from 2.7.0 to 2.8.0, 0.002 s] add user ... 146 2016-03-29 21:10:20 [migration from 2.7.0 to 2.8.0, 0.040 s] add forma... 145 2016-03-29 21:10:20 [migration from 2.7.0 to 2.8.0, 0.002 s] add image... 104 2015-10-17 22:30:38 upgrade included in installation 111 2015-10-17 22:30:38 upgrade included in installation
Offline
Pages: 1