Kunena 7.0.11 & Kunena 6.4.16 – Security Updates Released and K7.1 in RC1 2

The Kunena team has announce the arrival of three simultaneous security release : K6.4.16, K7.0.11 and K7.1 RC2. Just a reminder K6.4.16 receives only securities fixes untill end of 2026, so it's advised for users to upgrade to K7.0.11. K7.0.11 is the last release of the K7.0 because it's replaced by K7.1 branch with the stable release in the corner. The translations for K7.1 on crowdin.com/project/kunena-forum-7-1 needs to be checked or improved becasue it has been generated by TM (Translation Machine).

Solved Message1054 Unknown column 'rankSpecial' in 'where clause'

More
3 years 11 months ago - 3 years 11 months ago #226505 by rich
Replied by rich on topic Message1054 Unknown column 'rankSpecial' in 'where clause'

Unknown column 'vimeo' in 'field list' " Serching for a "field list" i can not find it.

These columns "github" and "vimeo" did not exist in K5 and were only added for K6.0. I don't know why they were not added during the upgrade, but I don't think there are any more missing.
Open the table #__kunena_users and click on structure. If the table is complete, it must have 60 columns.
If there are only 59 columns, then only 'vimeo' is still missing.
In this case, the command should solve the problem:
.
Code:
ALTER TABLE `#__kunena_users` ADD vimeo varchar(75) NULL AFTER `qzone`;
 
Important! Always create a backup before you make any changes to your website!
Last edit: 3 years 11 months ago by rich.

Please Log in or Create an account to join the conversation.

More
3 years 11 months ago - 3 years 11 months ago #226518 by SIETWOLT
Replied by SIETWOLT on topic Message1054 Unknown column 'rankSpecial' in 'where clause'
Thanks for your quick replies.
I have added the column. It appeared more columns were not in my table. Added these too and it works now great.
Thanks a lot.
Re your remark about the template Blue eagle: my default template is Aurelia. Although separate mentioned remains blue eagle as to sale. See screenprint
 
Last edit: 3 years 11 months ago by SIETWOLT.

Please Log in or Create an account to join the conversation.

More
3 years 11 months ago #226519 by rich
Replied by rich on topic Message1054 Unknown column 'rankSpecial' in 'where clause'
Yes, that's true, but the download page says it's not suitable for Bootstrap 4 or 5 templates. But it's probably better to remove the reference to Blue Eagle in K6.0.
Important! Always create a backup before you make any changes to your website!

Please Log in or Create an account to join the conversation.

Time to create page: 0.130 seconds