Failed.

[ncopz]

Failed when leave a comment.

FaildUnknown column 'author_type' in 'field list'

[Thindwa]

Failed when leave a comment.

FaildUnknown column 'author_type' in 'field list'

hey !

you need to add 'author_type' attribute in comments table and insert 'author_type' as 'user'. you will have to re-import your database after changing it.

CREATE TABLE comments (
comment_id int(3) NOT NULL,
comment_post_id int(3) NOT NULL,
comment_author varchar(255) NOT NULL,
author_type varchar(255) NOT NULL,
comment_email varchar(255) NOT NULL,
comment_content text NOT NULL,
comment_reply text NOT NULL,
comment_reply_date varchar(50) NOT NULL,
comment_status varchar(255) NOT NULL,
comment_date varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table comments

INSERT INTO comments (comment_id, comment_post_id, comment_author, author_type, comment_email, comment_content, comment_reply, comment_reply_date, comment_status, comment_date) VALUES
(34, 59, 'asliabir', 'user', 'abir@gmail.com', 'Hay man... you rocked......... ', 'Thanks...', 'Wed, September 13, 2017 - 05:07:54 PM', 'approve', 'Wed, September 13, 2017 - 04:53:17 PM');