Every time that someone tries to write a comment for an article it shows hi,/her this message:TableK2Comment::store failed - Unknown
column 'approved' in 'field list' SQL=INSERT INTO `jos_k2_comments` (
`itemID`,`userID`,`userName`,`commentDate`,`commentText`,`commentEmail`,`published`,`approved`,`ip`
) VALUES ( '369','62','b_dark','2010-06-16
20:53:29','test!!!','[email protected]','1','0','79.107.73.237' )How can I fix this?

help plz?

After upgrading from 2.3svn to 2.3 today and looking at phpmyadmin database table jos_k2_comments I dont see the field "approved"

Grep finds TableK2Comment as below - I would start searching there
C:\downloads\k2\K2_v2.3\administrator\components\com_k2\tables\k2comment.php
00008: */
00009:
00010: // no direct access
00011: defined('_JEXEC') or die('Restricted access');
00012:
00013: class TableK2Comment extends JTable
00014: {
00015:
00016: var $id = null;
00017: var $itemID = null;
00018: var $userID = null;

jos_k2_comments

Hi. It seems that you have modified some core php files. There is no such field in the K2 comments table.

B_Dark said:help plz?

everything is ok now with the new version , thnx :)!!

I had the same problem and it was because i tried to install tha extension extensions.joomla.org/extensions/extension-specific/k2-extensions/11511?qh=YToxOntpOjA7czoyOiJrMiI7fQ%3D%3D (doesn't work for me)

It mades a patch in your tables in administrator/components/com_k2/tables/k2comment.php where i supose it adds that value of approved.

If somebody has the same problem just reload the original php file of k2....

From the README.txt file for com_tc_comments:

2. Add two fields to the jos_k2_comments table:

ALTER TABLE `jos_k2_comments`
ADD COLUMN `approved` TINYINT(1),
ADD COLUMN `ip` CHAR(20);