I use b2evolution for my blog on my home page. Recently someone from work tried to leave me a comment here and got the message
MySQL error!
Unknown column 'comment_author_ID' in 'field list'(Errno=1054)
Your query:
INSERT INTO evo_comments( comment_post_ID, comment_type, comment_author_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_content) VALUES( 156, 'comment', 1, NULL, NULL, NULL,'68.100.33.135','2006-05-22 20:36:39', 'test comment' )
While this seems simple enough to fix, I wonder why b2evolution wouldn't recognize that this field is missing and create it when upgrading. Perhaps I was upgrading from too old a version and it didn't think it should have to update this field. I dunno. I suppose this has been a problem since I upgraded b2evolution sometimes late last year. In any case, all I had to do was use PHPMyAdmin and do the query
ALTER TABLE evo_comments add comment_author_ID int(11)
and now it works. So visitors should be able to add comments again.
