Error during upgrade - Unknown column

[Thomas P]

Hi mates,

after upgrading to latest and greatest 4.7.14 I see one error in our log:

Error (1054) Unknown column 'chart_timescale' in 'ipb_core_saved_charts': changeColumn ["core_saved_charts","chart_timescale",{"name":"chart_timescale","type":"ENUM","length":null,"decimals":null,"values":["hourly","daily","weekly","monthly","none"],"allow_null":true,"default":null,"comment":"","unsigned":false,"auto_increment":false}]

The error was thrown at this step of the upgrade:

.../admin/upgrade/?controller=upgrade&key=abcdef&mr=16&_=1704058060594

Any ideas on why we got this error?
Apart of that the forum looks fine after upgrade.

Happy New Year btw. 🥳

Thanks,
Thomas

 

 

Edited December 31, 2023 by Thomas P

[DawPi]

Go to Support section in the ACP and tell us what saying part named Database. Any issues?

[Thomas P]

Hi,

no issues identified.
Apart of the a.m. error message all sections are clear without issues...

BR

[Miss_B]

20 hours ago, Thomas P said:

Error (1054) Unknown column 'chart_timescale' in 'ipb_core_saved_charts': changeColumn ["core_saved_charts","chart_timescale",{"name":"chart_timescale","type":"ENUM","length":null,"decimals":null,"values":["hourly","daily","weekly","monthly","none"],"allow_null":true,"default":null,"comment":"","unsigned":false,"auto_increment":false}]

 

Can you check the database for the chart_timescale field to see if it is present in the core_saved_charts table? Because the error messages inidicates that it's missing.

[DawPi]

It's "standard" fields from that table (based on core schema.json) and if the DB checker didn't find anything wrong then he must have this field in that table.

Edited January 1 by DawPi

[Marc]

I have created a ticket on this for you, so we can take a closer look

[Thomas P]

Thank you guys, checked as you suggested and yes: It was there.

And verified via support ticket, as well - so we are good. 🙂

Thanks again, appreciated.
Thomas

[Marc]

No problem at all. Enjoy 🙂