Can't add a new discussion topic

Can't add a new discussion topic

by xiaoqiu chen -
Number of replies: 4

Hi, there,

My Forum worked well until this morning. Now whenever we try to add a new discussion topic on any forums, this message will soon follow up in pink:“Could not add your post due to an unknown error”. Please help me solve the problem.Thanks

Cheers,

Chen

Average of ratings: -
In reply to xiaoqiu chen

回复: Can't add a new discussion topic

by xiaoqiu chen -

the problem is till on, please help me to solve it. Thanks. I wonder if I could solve the problem by upgrading Moodle.

In reply to xiaoqiu chen

Re: 回复: Can't add a new discussion topic

by Kelley Underwood -
I also have this problem. Any attempt to post to the forum returns this error.

In reply to Kelley Underwood

回复: Re: 回复: Can't add a new discussion topic

by xiaoqiu chen -

Hi,Kelley Underwood,

Have you solved the problem? If yes, please let me know how to do it. Thanks.

In reply to xiaoqiu chen

Re: 回复: Re: 回复: Can't add a new discussion topic

by adrian don -
Hi everyone. I used to had this problem. What I did was to check the table and it seemed "mdl_forum_posts" was missing(dunno how why when). My solution was to create that table using

CREATE TABLE `mdl_forum_posts` (
`id` BIGINT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`discussion` BIGINT(10) UNSIGNED NOT NULL DEFAULT '0',
`parent` BIGINT(10) UNSIGNED NOT NULL DEFAULT '0',
`userid` BIGINT(10) UNSIGNED NOT NULL DEFAULT '0',
`created` BIGINT(10) UNSIGNED NOT NULL DEFAULT '0',
`modified` BIGINT(10) UNSIGNED NOT NULL DEFAULT '0',
`mailed` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0',
`subject` VARCHAR(255) NOT NULL DEFAULT '',
`message` TEXT NOT NULL,
`format` TINYINT(2) NOT NULL DEFAULT '0',
`attachment` VARCHAR(100) NOT NULL DEFAULT '',
`totalscore` SMALLINT(4) NOT NULL DEFAULT '0',
`mailnow` BIGINT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `mdl_forupost_use_ix` (`userid`),
KEY `mdl_forupost_cre_ix` (`created`),
KEY `mdl_forupost_mai_ix` (`mailed`),
KEY `mdl_forupost_dis_ix` (`discussion`),
KEY `mdl_forupost_par_ix` (`parent`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8 COMMENT='All posts are stored in this table'

(I copy the sturcture from other database)
It works fine now :D