Can't add a new discussion topic

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

by adrian don -
Number of replies: 0
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