Hi Giulio,

You can try to execute below sql statement from your phpmyadmin.

update jos_discuss_posts as a

inner join jos_discuss_migrators as b on a.`id` = b.`internal_id` and b.`component` = 'com_kunena' and b.`type` = 'post'

	set a.isresolve = 1,

		a.answered = 1	

where a.parent_id = 0;

The above sql will update all the migrated parent posts from kunena to 'resolved' and 'answered'.
Please backup your database first before you run the above sql update statement. Also, you might need to replace the jos_ to your own Joomla table prefix.

Hope this help and have a nice day

You guys ROCK !!!!!


Thank you !!!

Hello, I had a slight problem… after I executed this command all of the post disappeared from the front view (they're not being cancelled… but disappeared from the front page view ! )

Now I restored the backupped version of the database ! Can you give me a fix ??

Hello Giulio Curà,

Sorry for late reply to this,
Is it possible provide us with your phpmyadmin access so we can investigate on your issues? Please advise.
*Notice : Remember backup all your data and file.

Ciao Arlex, I solved this problem manually and with some database operations !!

Anyway you should debug the import from kunena since i found thaw many forum answers were translated as new forum posts , I had to reconstruct manually on the DB the hierarchy

anyway thanx !!!

Great support !!!!

Hello Giulio Curà,

You're welcome, glad to heard your issues resolved.
Great, thanks for suggestion.

Sam wrote:

You can try to execute below sql statement from your phpmyadmin.

update jos_discuss_posts as a

inner join jos_discuss_migrators as b on a.`id` = b.`internal_id` and b.`component` = 'com_kunena' and b.`type` = 'post'

	set a.isresolve = 1,

		a.answered = 1	

where a.parent_id = 0;

The above sql will update all the migrated parent posts from kunena to 'resolved' and 'answered'.
Please backup your database first before you run the above sql update statement. Also, you might need to replace the jos_ to your own Joomla table prefix.

Hope this help and have a nice day

Hi, this also resulted in all posts disappearing for me. Do you have a solution, as there seems to be something wrong with this SQL?

Hello Mark,

I am really sorry for the delay of this reply, our staff should have responded to this sooner but they probably missed this thread. Can I know if you are still having issues with this?

Hi Mark, Yes.

If you run the above SQL command that Sam wrote all messages are deleted!

Do you know what i sarong with the syntax?

Hi Mark,

I am sorry for the delay of this reply.

The sql i provided is to reset the question's state to 'resolved' and 'answered' and no items will be deleted from the database.

Can you pass me your Joomla backend admin access and your ftp account so that I can further investigate this issue?
Please advise.