Database must be updated. - Nothing to be updated

[Caesar]

Hello,

I just updated Hoteldruid from ver. 2.3.2 to ver. 3.0.6 and did exactly the update steps as described in the Readme file. After all files were transfered I went to https://...../inizio.php and it showed "Database must be updated." So I hit the button and then came this message: " HOTELDRUID version 3.0.6, Copyright (C) 2001-2023 Marco M. F. De Santis
HotelDruid comes with ABSOLUTELY NO WARRANTY;
for details see the file COPYING.
This is free software, and you are welcome to redistribute it
under certain conditions; see the file COPYING for details.

Nothing to be updated."
Then I hit the button Go To Main Menu and it asks me again "Database must be updated."

I can't go anywhere now. I made a backup before the version update. How can I resolve it please?
Thank you kindly/Mille Grazie!

Cheers
Caesar

[Caesar]

Ok, after going back to the old version and installing each and every following version I'm finally at the latest version 3.0.6.
The only issue I have now is that I can't go to the years 2014 and 2017 anymore. All other years are working fine (and worked before the updates).
It tells me:
"Availability from
Warning: SQLite3::query(): Unable to prepare statement: 1, no such table: periodi2014 in /home/tutu/public_html/booking/ov1/includes/funzioni_sqlite.php on line 82

ERROR in: select datainizio,datafine from periodi2014 where datainizio <= '2024-05-31' and datafine > '2024-05-31' "
And:

"Availability from
Warning: SQLite3::query(): Unable to prepare statement: 1, no such table: periodi2017 in /home/tutu/public_html/booking/ov1/includes/funzioni_sqlite.php on line 82

ERROR in: select datainizio,datafine from periodi2017 where datainizio <= '2024-05-31' and datafine > '2024-05-31' "

Any help would be highly appreciated.

Cheers
Gerhard

[marco]

Hello Gerhard,
the error says that the database table doesn't exist, maybe there was a problem with not enough time or memory while upgrading, but you should check php logs to see the exact problem. If the problem was caused by not enough resources by php you can check php documentation and support about increasing them.

There should be no need to upgrade through each version of php-residence/hoteldruid, you can upgrade directly with the latest version. The loop "update"/"nothing to be updated" is probably caused by a different version in files and database, maybe for not having the right permissions to write the files (as described in README) during upgrade or an interrupted upgrade.

Regards,
Marco