Kunena 7.0.2 Released

The Kunena team has announce the arrival of Kunena 7.0.2 [K 7.0.2] in stable which is now available for download as a native Joomla extension for J! 5.3.x/5.4.x/6.0.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 7.0

Question Incorrect integer value: '' for column 'rank' at row 1

More
5 months 21 hours ago #234031 by Web-Mex
Incorrect integer value: '' for column 'rank' at row 1 was created by Web-Mex
Hi,   I get an Error message after a Kunena migration fom Kunena 5 to Kunena 6.

When i add newRank to a user following error will apear:

 
Code:
Es ist ein Fehler aufgetreten. [quote]0 Incorrect integer value: '' for column 'rank' at row 1[/quote] Call Stack[b]#[/b][b]Function[/b][b]Location[/b]1()JROOT/libraries/kunena/src/User/KunenaUser.php:11042Kunena\Forum\Libraries\User\KunenaUser->save()JROOT/administrator/components/com_kunena/src/Controller/UserController.php:1563Kunena\Forum\Administrator\Controller\UserController->saveInternal()JROOT/administrator/components/com_kunena/src/Controller/UserController.php:2264Kunena\Forum\Administrator\Controller\UserController->applychanges()JROOT/libraries/src/MVC/Controller/BaseController.php:7305Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/libraries/src/Dispatcher/ComponentDispatcher.php:1436Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch()JROOT/libraries/src/Component/ComponentHelper.php:3617Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/AdministratorApplication.php:1508Joomla\CMS\Application\AdministratorApplication->dispatch()JROOT/libraries/src/Application/AdministratorApplication.php:2059Joomla\CMS\Application\AdministratorApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:30410Joomla\CMS\Application\CMSApplication->execute()JROOT/administrator/includes/app.php:5811require_once()JROOT/administrator/index.php:32

My Configuration:
This message contains confidential information

Database collation check: lpj7c_kunena_aliases have wrong collation of type utf8mb3_general_ci on field alias  lpj7c_kunena_aliases have wrong collation of type utf8mb3_general_ci on field type  lpj7c_kunena_aliases have wrong collation of type utf8mb3_general_ci on field item  lpj7c_kunena_announcement have wrong collation of type utf8mb3_general_ci on field title  lpj7c_kunena_announcement have wrong collation of type utf8mb3_general_ci on field sdescription  lpj7c_kunena_announcement have wrong collation of type utf8mb3_general_ci on field description  lpj7c_kunena_attachments have wrong collation of type utf8mb3_general_ci on field hash  lpj7c_kunena_attachments have wrong collation of type utf8mb3_general_ci on field folder  lpj7c_kunena_attachments have wrong collation of type utf8mb3_general_ci on field filetype  lpj7c_kunena_attachments have wrong collation of type utf8mb3_general_ci on field filename  lpj7c_kunena_attachments have wrong collation of type utf8mb3_general_ci on field filename_real  lpj7c_kunena_attachments have wrong collation of type utf8mb3_general_ci on field caption  lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field name  lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field alias  lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field icon  lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field accesstype  lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field channels  lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field description  lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field headerdesc  lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field class_sfx  lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field topicOrdering  lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field iconset  lpj7c_kunena_categories have wrong collation of type utf8mb3_general_ci on field params  lpj7c_kunena_configuration have wrong collation of type utf8mb3_general_ci on field params  lpj7c_kunena_keywords have wrong collation of type utf8mb3_general_ci on field name  lpj7c_kunena_logs have wrong collation of type utf8mb3_general_ci on field ip  lpj7c_kunena_logs have wrong collation of type utf8mb3_general_ci on field operation  lpj7c_kunena_messages have wrong collation of type utf8mb3_general_ci on field name  lpj7c_kunena_messages have wrong collation of type utf8mb3_general_ci on field email  lpj7c_kunena_messages have wrong collation of type utf8mb3_general_ci on field subject  lpj7c_kunena_messages have wrong collation of type utf8mb3_general_ci on field ip  lpj7c_kunena_messages have wrong collation of type utf8mb3_general_ci on field modified_reason  lpj7c_kunena_messages_text have wrong collation of type utf8mb3_general_ci on field message  lpj7c_kunena_polls have wrong collation of type utf8mb3_general_ci on field title  lpj7c_kunena_polls_options have wrong collation of type utf8mb3_general_ci on field text  lpj7c_kunena_ranks have wrong collation of type utf8mb3_general_ci on field rankTitle  lpj7c_kunena_ranks have wrong collation of type utf8mb3_general_ci on field rankImage  lpj7c_kunena_sessions have wrong collation of type utf8mb3_general_ci on field allowed  lpj7c_kunena_sessions have wrong collation of type utf8mb3_general_ci on field readtopics  lpj7c_kunena_smileys have wrong collation of type utf8mb3_general_ci on field code  lpj7c_kunena_smileys have wrong collation of type utf8mb3_general_ci on field location  lpj7c_kunena_smileys have wrong collation of type utf8mb3_general_ci on field greylocation  lpj7c_kunena_topics have wrong collation of type utf8mb3_general_ci on field subject  lpj7c_kunena_topics have wrong collation of type utf8mb3_general_ci on field first_post_message  lpj7c_kunena_topics have wrong collation of type utf8mb3_general_ci on field first_post_guest_name  lpj7c_kunena_topics have wrong collation of type utf8mb3_general_ci on field last_post_message  lpj7c_kunena_topics have wrong collation of type utf8mb3_general_ci on field last_post_guest_name  lpj7c_kunena_topics have wrong collation of type utf8mb3_general_ci on field params  lpj7c_kunena_user_categories have wrong collation of type utf8mb3_general_ci on field params  lpj7c_kunena_user_topics have wrong collation of type utf8mb3_general_ci on field params  lpj7c_kunena_users have wrong collation of type utf8mb3_general_ci on field status_text  lpj7c_kunena_users have wrong collation of type utf8mb3_general_ci on field view  lpj7c_kunena_users have wrong collation of type utf8mb3_general_ci on field signature  lpj7c_kunena_users have wrong collation of type utf8mb3_general_ci on field avatar  lpj7c_kunena_users have wrong collation of type utf8mb3_general_ci on field personalText  lpj7c_kunena_users have wrong collation of type utf8mb3_general_ci on field location  lpj7c_kunena_users have wrong collation of type utf8mb3_general_ci on field websitename  lpj7c_kunena_users have wrong collation of type utf8mb3_general_ci on field websiteurl  lpj7c_kunena_users have wrong collation of type utf8mb3_general_ci on field ip  lpj7c_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field ip  lpj7c_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field reason_private  lpj7c_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field reason_public  lpj7c_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field comments  lpj7c_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field params  
       

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

This message contains confidential information
htaccess: Exists | PHP environment: Max execution time: 50000 seconds | Max execution memory: -1 | Max file upload: 

Kunena menu details:

Warning: Spoiler!

Joomla default template details : tp_master | author: joomlaPlates | version: 2.5 | creationdate: 2025-09-02

Kunena default template details : Aurelia | author: Kunena Team | version: 6.4.6 | creationdate: 2025-09-30

Kunena template params:

Warning: Spoiler!

Kunena version detailed: Kunena 6.4.6 | 2025-09-30 [ 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: None

Modules: Kunena Latest 6.1.0 | Kunena Stats 6.1.0



I did the Database diagnostics and checked all Tables without any issues.
 

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

More
5 months 19 hours ago #234038 by rich
Replied by rich on topic Incorrect integer value: '' for column 'rank' at row 1
Which version of Kunena did you update Kunena from? There are lots of versions in the Kunena 5 series.
You also need to update your database, including the columns. Kunena and Joomla use utf8mb4_unicode or utf8mb4_general.
Incidentally, you also have an incorrect menu item in your main menu (see image). Links in other menus that lead to the forum must be of the alias menu type ( see here ). 
.
 
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
1 week 1 day ago #234659 by Captain_DXB
Replied by Captain_DXB on topic Incorrect integer value: '' for column 'rank' at row 1
Hi, meanwhile I fixed the utf8mb3_general_ci problem - how ever the rank error still exists. My suspect is, that the data format for the table kunena_users column rank had somewhen changed (we're migrating from a very old version...). Old type was tinyint - how ever it looks like that Kunena 6.4.6 tries to store an other datatype what results in the error. I'd tried to change the type to varchar(10). That let the error message disappear - how ever nothing is written in the table and the rank system still doesn't work.

Do you have any ideas how to fix this?

THX

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

More
1 week 14 hours ago #234666 by rich
Replied by rich on topic Incorrect integer value: '' for column 'rank' at row 1

I'd tried to change the type to varchar(10).

Yes, it's varchar. The screenshot is from a K6.4.6 installation. Is there no longer an error message with varchar, not even with Error Reporting = Maximum?
.
 
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
1 week 10 hours ago #234669 by Captain_DXB
Replied by Captain_DXB on topic Incorrect integer value: '' for column 'rank' at row 1
Correct. Now there is no error message anymore, but if I try to assign a rank manually in the kunena user settings - despite which rank I chose - after saving the user settings the highest rank (that one with the highest number) is stored somewhere and there no change in the DB table kunena_users column rank (still 0).

But anyway - I thing there's probably much more screwed up in the database (even if the kunena configuration report and the kunena diagnostic say every think is fine...) I don't know how web-max did the migration, but I guess he simply try's to copy the old database and tweak some values directly in the database.

Meanwhile I made a second clean and empty installation and found out, that there are even more data types had changed in the new kunena version. More over a couple of new values were added which are partly missing in the current installation (e.g. timestamp in the user data). So I will now try to fix the datatypes and the missing colums first and then come back if the error still exists.

Migrating a old Forum ist really pretty complicated... I appreciate your help!

THX!

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

More
4 days 21 hours ago #234692 by Captain_DXB
Replied by Captain_DXB on topic Incorrect integer value: '' for column 'rank' at row 1
Hi rich,

I'm maybe a step further: I turned the extended php debugging on and get two error messages, that I couldn't interpret well - it seems that they are caused by the migration - how ever I wondering how this could be possible because kunena was set up completely new (now with v. 7.0.1).

Do you have a idea, what causes the following error and how to fix it?:

Deprecated: Creation of dynamic property Kunena\Forum\Libraries\Forum\Category\KunenaCategory::$allow_ratings is deprecated in /mnt/web508/e1/97/510678697/htdocs/Update/libraries/kunena/src/Database/KunenaDatabaseObject.php on line 128 Deprecated: Creation of dynamic property


and,

Warning: Undefined property: stdClass::$rankId in /mnt/web508/e1/97/510678697/htdocs/Update/libraries/vendor/joomla/database/src/DatabaseDriver.php on line 1309

THX

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

Time to create page: 0.647 seconds