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

Hi, can you tell me what you mean with completely new? Did you fresh install K7.0.1 on a site where there was no Kunena installed on previously?

I'm asking because 'allow_ratings' was used pre 6.0.0 and was change into allowRatings in 6.0.0

So it can only be referenced when there was on old version installed where the upgrade that goes via the Kunena dashboard didn't take place.

Hi ruud,

sorry my mistake I did't explain it well - it's a bit more complicated... I did several test. The test site that throw the error runs currently with a kunena that is updated from 6.4.6 to 7.0.1 on a Joomla 5.3.4, and a php 8.4.

The real site was migrated by a professional service from kunena 5 kunena 6 but unfortunately they did't finished the work very well and we still have many errors on the forum of our live site... So I set up copy of the site and started debugging. First I try to fix the database where I still found a lot of variables with utf8mb3_general_ci type and some missing or wrong fields (I had a clean installation - with kunena test data - in parallel, so that I could compare the database).

My fixes of the database where good enough to let the error messages disappear that I've got on the site (without debugging max on) - how ever it did't fix the existing problems (rank system doesn't work as expected and e-mail notification from the forum doesn't work.)

Interestingly in the clean test version, that uses the kunena test data only, every think works perfect so that I think, it have something to do with the data in the database itself that may not migrated very well.

My problem is, that I have no clue where to start because I could find a proper documentation of the data and I don't have the time and the knowledge to re-engineer the code. So my approach for now is trying to fix the obvious errors first and the see what's happen.

I think the problem is not a bug in kunena itself but probably a problem in the migration process of the existing data in database. My hope was that updating Kunea with the real data from 6.4.6 to 7.0.1 would fix these problems - but it seems that this was not the case...

Do you have any ideas where I can start to search?

THX

note that the deprecated messages are not 'blocking', they are just messages thrown by php 8.4 where e.g. with php 8.3 they would not display.
It is more of a warning to tell you that in future php versions things might stop working.
With the information given it is hard to troubleshoot.
In the Kunena code pre 7.0.2 the dashboard was responsible for doing al kind of upgrade chores (like making changes in the database structure). When visiting the dashboard was 'skipped' and then another upgrade was done, then there was already the issue that the upgrade chores didn't run for the previous version and will not run as the version number was changed.
In version 7.0.2 this will never happen again as the update chores are now part of the upgrade itself, so no more visiting the dashboard after an update.

That said: likely your database is in an state of 'flux' where upgrades did happen and upgrades didn't happen. impossible to tell which ones did and which ones didn't

In the Kunena package there are upgrade xml file(s) with the logic that would run on each version.
I would walk through each one of these database lines and check if the current database tables have these changes and if not run the changes.

Easier said then done I know....

Captain_DXB wrote:

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



 

Hello,

Since K6.0.0 beta3 the column allow_ratings has been renammed in allowRatings, so make an export of the table #__kunena_categories with phpmyadmin just in case. Then you can apply this query to fix the table : 

Captain_DXB wrote:

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

Same here on table #__kunena_ranks before K6.0.0 beta3 there was a column nammed rank_id which has been renammed. so make an export of the table #__kunena_ranks with phpmyadmin just in case, then apply this query : 

Hello xillibit,

I want to thank you and the others here very much. With the change of the two variable names, the test site now runs for the first time without visible error messages with debugging max - and the rank system also works again.

There are still some other problems to which I open a new thread.

Thanks again for the great support!