Error setting up mail for a forum

[Migrated From Jforum.net]

I'm trying to set up the mail integration for our test forum. In doing do, I've checked enable e-mail integration, and entered the pop details. When I have done this, I get the following error when I hit update:

Unknown column 'forum_email' in 'field list'

I'm running 2.1.7. Any ideas?
[originally posted on jforum.net by graeme]

[Migrated From Jforum.net]

Graeme,

the mysql db struct was missing this field. Please run the following statement in your mysql database:

DROP TABLE IF EXISTS jforum_mail_integration;
CREATE TABLE jforum_mail_integration (
	forum_id INT NOT NULL,
	forum_email VARCHAR(100) NOT NULL,
	pop_username VARCHAR(100) NOT NULL,
	pop_password VARCHAR(100) NOT NULL,
	pop_host VARCHAR(100) NOT NULL,
	pop_port INT DEFAULT 110,
	pop_ssl TINYINT DEFAULT '0',
	KEY(forum_id)
) TYPE=InnoDB;

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

That sorted it out, thank you.
[originally posted on jforum.net by graeme]

[Migrated From Jforum.net]

that's cause of ORA-00942 when modify forum... with jforum 2.1.7 and Oracle
you just have to create jforum_mail_integration...

CREATE TABLE JFORUM2.jforum_mail_integration
(
  FORUM_ID INT NOT NULL,
  FORUM_EMAIL VARCHAR2(100) NOT NULL,
  POP_USERNAME VARCHAR2(100) NOT NULL,
  POP_PASSWORD VARCHAR2(100) NOT NULL,
  POP_HOST VARCHAR2(100) NOT NULL,
  POP_PORT INT DEFAULT 110,
  POP_SSL INT DEFAULT 0,
  CONSTRAINT PK_jforum_mail_integration PRIMARY KEY (FORUM_ID )
)

[originally posted on jforum.net by sburky]