Kunena 6.4.8 Released

The Kunena team has announce the arrival of Kunena 6.4.8 [K 6.4.8] in stable which is now available for download as a native Joomla extension for J! 5.0.x/5.1.x/5.2.x/5.3.x/5.4.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 6.4
Important note: Go to the Kunena Dashboard after an upgrade so that the Kunena database tables are also updated. This is particularly necessary for major version jumps so that the table changes are adapted.

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

More
3 years 3 months ago #225808 by SIETWOLT
Message1054 Unknown column 'rankSpecial' in 'where clause' was created by SIETWOLT
I am using Joomla 4.2.3 and Kunena 6.0.3.  Kunena runs good. But: when I go to Kunena ? Users in the backend and click on a user the message: "1054 Unknown column 'rankSpecial' in 'where clause' " appears. Apparently a table is not correct.
Question: how to solve it.
Look forward to your reaction.

Kunena config. settings:
This message contains confidential information

Database collation check: The collation of your table fields are correct
        

Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |
       

This message contains confidential information
htaccess: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 128M | Max file upload: 

Kunena menu details:

Warning: Spoiler!

Joomla default template details : shaper_helixultimate | author: JoomShaper.com | version: 2.0.11 | creationdate: Feb 2018

Kunena default template details : Aurelia | author: Kunena Team | version: 6.0.3 | creationdate: 2022-09-22

Kunena template params:

Warning: Spoiler!

Kunena version detailed: Kunena 6.0.3 | 2022-09-22 [ Git Repository ]
        | Kunena detailed configuration:

Warning: Spoiler!
| Kunena integration settings:
Warning: Spoiler!
| Joomla! detailed language files installed:
Warning: Spoiler!

Third-party components: None

Third-party SEF components: None

Plugins: Search - Kunena Search 5.2.2

Modules: Kunena Search 5.2.2

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

More
3 years 3 months ago #225867 by xillibit
Replied by xillibit on topic Message1054 Unknown column 'rankSpecial' in 'where clause'
Hello,

In table #__kunena_ranks, it doesn't found the column rankSpecial you need to rename the column

If it's an update from Kunena 5.2.x it could have failed during update the tables
I don't provide support by PM, because this can be useful for someone else.

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

More
3 years 2 months ago - 3 years 2 months ago #226454 by SIETWOLT
Replied by SIETWOLT on topic Message1054 Unknown column 'rankSpecial' in 'where clause'
Thanks. I renamed the column and the problem looked solved. But after changing the moderator task of a user I get the message: Unknown column 'github' in 'field list'
So I still can not the change the role of administrator
Is there a solution?
Kind regads
Last edit: 3 years 2 months ago by SIETWOLT.

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

More
3 years 2 months ago #226457 by rich
Replied by rich on topic Message1054 Unknown column 'rankSpecial' in 'where clause'
It seems that the users table is also not up to date. Go to the #__kunena_users table and check if the github column is present. If not, use this sql command (instead of #__ add your prefix.
Code:
ALTER TABLE `#__kunena_users` ADD github varchar(75) NULL AFTER `google`;
Make a database backup before!
Important! Always create a backup before you make any changes to your website!

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

More
3 years 2 months ago #226499 by SIETWOLT
Replied by SIETWOLT on topic Message1054 Unknown column 'rankSpecial' in 'where clause'
Thanks again. What is going on i don't understand. Apparently my database in not ok. After applying your suggested chabge  I receive now the message:
"Unknown column 'vimeo' in 'field list' " Serching for a "field list" i can not find it.
I reloaded Kunena 6.04, but it did not help. Is there an other way to get the database-strucure right?
Kind regards
Han

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

More
3 years 2 months ago #226502 by Leen
Replied by Leen on topic Message1054 Unknown column 'rankSpecial' in 'where clause'
Hello, I see in your configuration report at template old Blue_Eagle may still be standing
check the current kunena template Aurelia and click the default button.
With kind regards
Leen

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

Time to create page: 0.363 seconds