Page 1 of 1

Year Change does not create correct rate table

Posted: Fri Jan 15, 2021 3:42 am
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

Re: Year Change does not create correct rate table

Posted: Fri Jan 15, 2021 3:58 am
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;