Upgrade Error [4.7.8 > 4.7.13]

[Hisashi]

Hello,

I just updated my site on 'test domain' on same server, and generated this error log at the end of update.

Type: upgrade_error

Error (1054) Unknown column 'chart_timescale' in 'ips_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}]

---

#0 /home/.../public_html/test/system/Application/Application.php(1618): IPS\_Log::log('Error (1054) Un...', 'upgrade_error')
#1 /home/.../public_html/test/applications/core/sources/Setup/Upgrade.php(511): IPS\_Application->installDatabaseUpdates(107700, 0, 10, true)
#2 /home/.../public_html/test/applications/core/sources/Setup/Upgrade.php(326): IPS\core\Setup\_Upgrade->step1(Array)
#3 /home/.../public_html/test/applications/core/modules/setup/upgrade/upgrade.php(47): IPS\core\Setup\_Upgrade->process(Array)
#4 /home/.../public_html/test/system/Helpers/MultipleRedirect/MultipleRedirect.php(93): IPS\core\modules\setup\upgrade\_upgrade->IPS\core\modules\setup\upgrade\{closure}(Array)
#5 /home/.../public_html/test/applications/core/modules/setup/upgrade/upgrade.php(77): IPS\Helpers\_MultipleRedirect->__construct(Object(IPS\Http\Url), Object(Closure), Object(Closure))
#6 /home/.../public_html/test/system/Dispatcher/Controller.php(118): IPS\core\modules\setup\upgrade\_upgrade->manage()
#7 /home/.../public_html/test/system/Dispatcher/Setup.php(220): IPS\Dispatcher\_Controller->execute()
#8 /home/.../public_html/test/admin/upgrade/index.php(34): IPS\Dispatcher\_Setup->run()
#9 {main}

 

The only thing different I noticed was this here.

 

In other places it appears to be displaying normally. (4.7.13)

 

Everything seems to be working normally, so I don't know if I should worry about it.

Edited September 7, 2023 by Hisashi

[Marc Stridgen]

Please go to Support in the ACP  and make sure nothing is showing in the mysql section. If there isnt anything showing you should be all good.

In terms of that report, are you seeing any other errors in your system logs?

[Hisashi]

9 hours ago, Marc Stridgen said:

Please go to Support in the ACP  and make sure nothing is showing in the mysql section. If there isnt anything showing you should be all good.

In terms of that report, are you seeing any other errors in your system logs?

The system is not generating any other error, it only generated this one at end of the update.

[Miss_B]

16 hours ago, Hisashi said:

Error (1054) Unknown column 'chart_timescale' in 'ips_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}]

This error indicates a missing field. Can you check the ips_core_saved_charts table at the database and see if the  chart_timescale column is indeed missing?

Edited September 7, 2023 by Miss_B

[Hisashi]

17 minutes ago, Miss_B said:

This error indicates a missing field. Can you check the ips_core_saved_charts table at the database and see if the  chart_timescale column is indeed missing?

It exists, only empty.

In 4.7.8 database is also empty.

 

[Hisashi]

I saved a chart, it looks like no errors on that.

Should I assume that everything is working perfectly?

Edited September 7, 2023 by Hisashi

[Miss_B]

1 minute ago, Hisashi said:

I saved a chart, it looks like no errors on that.

 

It's strange that the upgrader threw an error about a missing column when in fact that was not the case. Anyways, if everything works fine with the chart then you have nothing to worry about imo. 

[Marc Stridgen]

14 hours ago, Miss_B said:

It's strange that the upgrader threw an error about a missing column when in fact that was not the case. Anyways, if everything works fine with the chart then you have nothing to worry about imo. 

I agree

[Hisashi]

I updated again, now officially the main site and it generated the same error. But everything is working normally.

[Marc Stridgen]

That would indeed be expected, as it's the same action performed. I can only say if its caused no issues, then just let us know if you see this happen again on your next upgrade