Announcement

#1 2022-12-11 21:43:25

TheDoc
Member
Munich / Germany
2015-10-18
171

"Currently running version 13.3.0" but database not updated?

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

 

#2 2022-12-12 01:44:26

erAck
Only trying to help
2015-09-06
1587

Re: "Currently running version 13.3.0" but database not updated?

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).


Running Piwigo at https://erack.net/gallery/

Offline

 

#3 2022-12-12 11:41:05

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13634

Re: "Currently running version 13.3.0" but database not updated?

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;

Offline

 

#4 2022-12-12 21:27:46

TheDoc
Member
Munich / Germany
2015-10-18
171

Re: "Currently running version 13.3.0" but database not updated?

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.

Code:

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

 

Board footer

Powered by FluxBB

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