Page 1 of 1

Unknown column 'FeelsLike' in 'field list'

Posted: Sat 16 May 2020 11:11 am
by Sadgit
Hello

I just updated to Cumulus MX 3.6.0 b3076 and I have started to see the folloiwng errors.. Should I have done something to update my DB? or do I add it manually into one of the tables?

2020-05-16 12:01:13.368 Error encountered during Realtime MySQL operation.
2020-05-16 12:01:13.369 Unknown column 'FeelsLike' in 'field list'
2020-05-16 12:01:43.378 Error encountered during Realtime MySQL operation.
2020-05-16 12:01:43.379 Unknown column 'FeelsLike' in 'field list'
2020-05-16 12:02:13.385 Error encountered during Realtime MySQL operation.
2020-05-16 12:02:13.385 Unknown column 'FeelsLike' in 'field list'
2020-05-16 12:02:43.392 Error encountered during Realtime MySQL operation.
2020-05-16 12:02:43.393 Unknown column 'FeelsLike' in 'field list'

Re: Unknown column 'FeelsLike' in 'field list'

Posted: Sat 16 May 2020 11:23 am
by freddie
I don't wish to preach, but you should really read the release notes before updating. They are linked from the release notification in the board announcement section that appears at the top of each forum page: viewtopic.php?f=40&t=17887&p=142085#p142085

Re: Unknown column 'FeelsLike' in 'field list'

Posted: Sat 16 May 2020 11:58 am
by Big Daddy
There was a script to run to change something in the SQL databases. I am not an SQL user (yet) but remember reading about the changes.

Re: Unknown column 'FeelsLike' in 'field list'

Posted: Sat 16 May 2020 3:42 pm
by Sadgit
thanks and preach away.. I read the wiki update but didn't read it on the forum... my mistake

Re: Unknown column 'FeelsLike' in 'field list'

Posted: Sat 16 May 2020 4:10 pm
by sfws
Sadgit wrote: Sat 16 May 2020 3:42 pm I read the wiki update but didn't read it on the forum..
2 points:
1. The wiki actually says
Changes to the MYSQL database tables are required
for release 3.6.0. Ok, it does not include specific instructions for how to do the changes that are listed after that quote, nor the script that Mark attached to his release notice for adding the new columns, but this leads to point number 2.

2. The wiki also has
1.1 Instructions

This page is a précis of the information contained in the support forum at Cumulus MX Announcements and Download - PLEASE READ FIRST

As that topic name suggests you should read it before you upgrade to a new release. If you are intending to upgrade to any new release, please read all of the release notes since the build you are currently running.
In other words, the wiki does make it clear that it is helping you understand what is in each release, not specifically a substitute set of instructions for how to upgrade.

Re: Unknown column 'FeelsLike' in 'field list'

Posted: Sat 16 May 2020 6:04 pm
by jlmr731
Now I have always read the " Cumulus MX Announcements and Download - PLEASE READ FIRST"
one, it lets me know if there is an update, two, i can see if i missed an update or something
most importantly it discuses what has changed and what files has changed.

Now to Mark, you are awesome and have been doing wonderful work keeping this alive, and your update post's are fantastic very detailed and easy to follow.

Re: Unknown column 'FeelsLike' in 'field list'

Posted: Sat 16 May 2020 6:33 pm
by water01
Sadgit wrote: Sat 16 May 2020 3:42 pm thanks and preach away.. I read the wiki update but didn't read it on the forum... my mistake
RTFM :lol: :lol: :lol: :lol: :lol: :bash: :bash: :bash: :bash: :bash: