Solved Kunena 7.0.1 Error-message: Unknown column 'language' in 'SET'

Sorry the problem is marked as solved but it not solved. 

 I’ve now updated to Kunena 7.0.3 – but it didn’t work at first. 
But after running "administrator/index.php?option=com_kunena&task=tools.setupcolumnlanguage", the error when logging in has now disappeared. 

But when I reply to a Kunena-topic, I now get the following error message: 

Unknown column 'deleted_time' in 'INSERT INTO'
and (!)
Der Beitrag wurde erfolgreich gesendet.

No replies or short replies are saved. (Emails are sent to subscribers)


A quick question: I did make a backup of the database table #__kunena_users. Do I need to do anything with the backup?

 

Hello,

I had made something to help users to fix it, you can find the instructions in my message here: www.kunena.org/forum/k7-0-0-support-arch...n-set?start=6#234685

Yes, I ran the "task=tools.setupcolumnlanguage" procedure yesterday (after upgrading to 7.0.3) and it was successful insofar as the error users were getting when logging in has gone (and the "language" column is now also present in the ..users table)
 
The error "Unknown column 'deleted_time' in 'INSERT INTO'" is new and is preventing Kunena from saving new entries. 
so I think there is an other column missing ??

Hello,

Yes the column deleted_time is missing too, there is no tool to add it without using phpmyadmin like for the column language

Make a backup of table #__kunena_messages and in phpmyadmin set this query ALTER TABLE `#__kunena_messages` ADD `deleted_time` int(11) NOT NULL default '0' AFTER `moved`

Thank you.
Now everything seems to work.