Kunena 6.3.0 released

The Kunena team has announce the arrival of Kunena 6.3.0 [K 6.3.0] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x. This version addresses most of the issues that were discovered in K 6.2 and issues discovered during the last development stages of K 6.3

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

More
1 year 6 months ago #1 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
1 year 6 months ago #2 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
1 year 5 months ago - 1 year 5 months ago #3 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: 1 year 5 months ago by SIETWOLT.

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

More
1 year 5 months ago #4 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!

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

More
1 year 5 months ago #5 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
1 year 5 months ago #6 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.
L.v.d.A
Attachments:

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

More
1 year 5 months ago - 1 year 5 months ago #7 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`;
 
Last edit: 1 year 5 months ago by rich.

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

More
1 year 5 months ago - 1 year 5 months ago #8 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
 
Attachments:
Last edit: 1 year 5 months ago by SIETWOLT.

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

More
1 year 5 months ago #9 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.

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

Time to create page: 0.648 seconds