Choice Module and News Forum

Choice Module and News Forum

by Josh Brown -
Number of replies: 3

Encountered the following problem while upgrading.  Not sure if its going to cause severe difficulties. 

Also, news on the News Forum won't display on the first page.  Not sure what's wrong there either.

--Josh Brown

 

choice module needs upgrading



(mysql): ALTER TABLE `choice` ADD `answer3` varchar(255) NOT NULL AFTER `answer2`  


2000: Duplicate column name 'answer3'

Error



(mysql): ALTER TABLE `choice` ADD `answer4` varchar(255) NOT NULL AFTER `answer3`  


2000: Duplicate column name 'answer4'

Error



(mysql): ALTER TABLE `choice` ADD `answer5` varchar(255) NOT NULL AFTER `answer4`  


2000: Duplicate column name 'answer5'

Error



(mysql): ALTER TABLE `choice` ADD `answer6` varchar(255) NOT NULL AFTER `answer5`  


2000: Duplicate column name 'answer6'

Error

choice tables have been set up correctly

Average of ratings: -
In reply to Josh Brown

Re: Choice Module and News Forum

by Josh Brown -

Referring back to that News Forum problem...

The site has somehow generated over 100 "News forum"s

I'm trying to delete them all, but I've just realized that every time the main paged is accessed it creates a new forum for the news.  I'm at 237 news forums now.

I also have an error that I'm getting in the admin control panel: 

Warning: Failed opening '/home/wh37219/public_html/mod/reading/db/mysql.php' for inclusion (include_path='') in /wh37219/public_html/admin/index.php on line 137

 

In reply to Josh Brown

Re: Choice Module and News Forum

by Martin Dougiamas -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
I've never heard of that before: something very wrong has happened during your upgrade.

Sounds like you upgraded a new install on top of an old one, or have been going backwards in versions...

Which version have you installed, and which version were you replacing? 1.0.6 changed a module name (reading -> resources) so you shouldn't see anything about readings.

I recommend going back to your most recent backup and following the upgrading instructions:

http://moodle.com/doc/?file=upgrade.html
In reply to Josh Brown

Re: Choice Module and News Forum

by Martin Dougiamas -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
Moodle creates a news forum if it can't find one.

It might not be able to find the news forum if the forum tables have been messed up somehow.