Year Change does not create correct rate table

Post here if you think you have found a bug in hoteldruid or error in its documentation.

Moderator: marco

Post Reply
nethead
Posts: 13
Joined: Thu Jan 06, 2011 7:48 am

Year Change does not create correct rate table

Post by nethead »

Hello,

i did just do the year change creating the 2021 sql tables and php scripts. Unluckily only one of my rates did made it to 2021? Please see attached images. Any ideas why this happens and how to fix it?

My 2020 rate tables has about 16 rates, my 2021 rate table only 1?! I did backup the database before doing the year change, like always. And tried twice using the default of the daily rates to bring over to 2021.

I am using the latest version, 3.01

cheers,

Arnd

nethead
Posts: 13
Joined: Thu Jan 06, 2011 7:48 am

Re: Year Change does not create correct rate table

Post by nethead »

I did check the sql table and the rates did not get copied from periodi2020 into periodi2021. This did fix it:

Code: Select all

drop table periodi2021;

CREATE TABLE  periodi2021 LIKE periodi2020;

INSERT periodi2021
SELECT * FROM periodi2020;

Post Reply