Feedback - can't update properly

Feedback - can't update properly

by Éric Bugnet -
Number of replies: 11
Picture of Documentation writers Picture of Plugin developers Picture of Translators
Hi,

I would like to update my moodle 1.6 to moodle 1.8.2+
But when I install feedback module, there is many errors :

I think it's because I didn't use 1.7 defore... no ?
Can someone help me ???

Eric


(mysql): CREATE TABLE `mdl_feedback_sitecourse_map` ( `id` int(10) unsigned NOT NULL auto_increment, `feedbackid` int(10) NOT NULL default '0', `courseid` int(10) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `feebackid_courseid` (`feedbackid`, `courseid`) ) TYPE=MyISAM COMMENT='feedback sitecourse map'
1050: Table 'mdl_feedback_sitecourse_map' already exists
ErreurScroll to next warning

(mysql): ALTER TABLE `mdl_feedback` ADD `page_after_submit` TEXT NOT NULL AFTER `multiple_submit`
1146: Table 'moodle.mdl_feedback' doesn't exist
Scroll to previous warningErreurScroll to next warning

(mysql): ALTER TABLE `mdl_feedback` ADD `timeopen` int(10) NOT NULL DEFAULT '0' AFTER `publish_stats`
1146: Table 'moodle.mdl_feedback' doesn't exist
Scroll to previous warningErreurScroll to next warning

(mysql): ALTER TABLE `mdl_feedback` ADD `timeclose` int(10) NOT NULL DEFAULT '0' AFTER `timeopen`
1146: Table 'moodle.mdl_feedback' doesn't exist
Scroll to previous warningErreurScroll to next warning

(mysql): ALTER TABLE mdl_feedback_completed ADD random_response BIGINT(10) unsigned NOT NULL DEFAULT 0
1146: Table 'moodle.mdl_feedback_completed' doesn't exist
Scroll to previous warningErreurScroll to next warning

Scroll to previous warningUpgrading feedback from 2006061602 to 2007073101 FAILED!Scroll to continue button

Average of ratings: -
In reply to Éric Bugnet

Re: Feedback - can't update properly

by Andy Tagliani -
Eric

The first question is, exist feedack installations in courses? If yes it will be a little problem, if no do it the follow way.

Go on to your server, if you have phpMyAdmin login and delete exact these tables. Thats the reason, because this tables are already exist, thats all. If yoz have successfull delte these tables, your installation will run without any problems.

Andy

P.S. Dont forget to delete first the block feedback if you have not done at this time. If u delete first the module it can be you became a blank_page in the admin section.
Average of ratings: -
In reply to Andy Tagliani

Re: Feedback - can't update properly

by Éric Bugnet -
Picture of Documentation writers Picture of Plugin developers Picture of Translators
Thanks for your answer.

Yes, there is feedback in some course, does I havr to delete them ?

Eric
Average of ratings: -
In reply to Éric Bugnet

Re: Feedback - can't update properly

by Andy Tagliani -
Eric

I´m sorry, i have to specify my question. Are the feedbacks fill out or are they installed but empty? When yes, they must install new, when they are not empty ... hmm

You did not deinstall the module yet? I´m not sure what goes on, if you did not delete the module and clean the tables in the database. I think in this case Eric and i´m sorry, you should wait if any other user can tell if this works or not.

Andy


Average of ratings: -
In reply to Andy Tagliani

Re: Feedback - can't update properly

by Éric Bugnet -
Picture of Documentation writers Picture of Plugin developers Picture of Translators
I've delete the Block and Mod, test again upgrade (1.6 -> 1.8.2) : problem
I finnaly delete my feedback, unisntall Feedback, and install again...

That's working now...
Thanks again.
Eric

Average of ratings: -
In reply to Éric Bugnet

Re: Feedback - can't update properly

by Andy Tagliani -
Eric

First, good news thats your problem (with a hook) is solved. I have a pleasure, i hope you allow that i asking you Eric. Did you have for the last Feedback version french language files. I have it, but they are incomplete. I would be great to have such one for one of our school. If not it is not a problem.

Andy
Average of ratings: -
In reply to Andy Tagliani

Re: Feedback - can't update properly

by Éric Bugnet -
Picture of Documentation writers Picture of Plugin developers Picture of Translators
Sometimes hammer is a good tool wink

Here is the French translation, I've just finish it...

http://buggy.free.fr/pro/feedback_1.9_fr_utf8.zip

++
Eric
Average of ratings: -
In reply to Éric Bugnet

Re: Feedback - can't update properly

by Anthony Borrow -
Picture of Core developers Picture of Plugin developers Picture of Testers
Eric - If memory serves me correctly, I was able to upgrade smoothly with feedback module provided that I had the updated feedback module installed for 1.8 when I started the upgrade. The problem comes when you try to upgrade Moodle to 1.8 and have old feedback code or feedback data and no feedback code. In any case, I'm glad you were able to get it working; however, there are ways of doing it so that you can preserve the data. Peace - Anthony
Average of ratings: -
In reply to Anthony Borrow

Re: Feedback - can't update properly

by Mike Forshaw -

Hi,

I am having he same problem. Get the error message:

(mysql): ALTER TABLE mdl_feedback_completed ADD random_response BIGINT(10) unsigned NOT NULL DEFAULT 0

 

1146: Table 'moodle.mdl_feedback_completed' doesn't exist

I have deleted all mysql tables to do with feedback but still get the same message. There are no current feedback modules within our Moodle site.

I'm running version 1.9.1 of Moodle and have tried installing 1.8 and 1.9 feedback but to no avail.

Any help would be appreciated.

Mike

add_field(Object:XMLDBTable, Object:XMLDBField) % line 108, file: upgrade.phpexecute_sql_arr(Array[1], true, true) % line 1060, file: ddllib.phpexecute_sql(ALTER TABLE mdl_feedback_completed ADD random_response BIGINT(10) unsigned NOT NULL DEFAULT 0, true) % line 2223, file: dmllib.phpADOConnection.Execute(ALTER TABLE mdl_feedback_completed ADD random_response BIGINT(10) unsigned NOT NULL DEFAULT 0) % line 89, file: dmllib.phpADOConnection._Execute(ALTER TABLE mdl_feedback_completed ADD random_response BIGINT(10) unsigned NOT NULL DEFAULT 0, false) % line 891, file: adodb.inc.php
Average of ratings: -
In reply to Mike Forshaw

Re: Feedback - can't update properly

by Andreas Grabs -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Translators
Hi Mike,

your errormessages let me assume that there are some leavings of older feedback-installations.
Try to go into the administration panel -> modules -> activities -> manage activities and try to delete the old installation. Perhaps it is shown as modulename. If it is not listed or possible to delete so go into your database to the table mdl_modules. There you can drop the line with the field name = feedback. After that you should be able to install the feedback again.

Andreas
Average of ratings: -
In reply to Andreas Grabs

Re: Feedback - can't update properly

by Mike Forshaw -

Thanks Andreas. You were right, I had deleted the feedback tables but not actually deleted it from the modules and blocks tables. Installed fine after they were removed.

Mike

Average of ratings: -