Feedback - can't update properly

Feedback - can't update properly

Éric Bugnet –
Vastuste arv 11
Documentation writers pilt Plugin developers pilt Translators pilt
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

Keskmine hinnang: -
Vastuses Éric Bugnet

Re: Feedback - can't update properly

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.
Keskmine hinnang: -
Vastuses Andy Tagliani

Re: Feedback - can't update properly

Éric Bugnet –
Documentation writers pilt Plugin developers pilt Translators pilt
Thanks for your answer.

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

Eric
Keskmine hinnang: -
Vastuses Éric Bugnet

Re: Feedback - can't update properly

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


Keskmine hinnang: -
Vastuses Andy Tagliani

Re: Feedback - can't update properly

Éric Bugnet –
Documentation writers pilt Plugin developers pilt Translators pilt
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

Keskmine hinnang: -
Vastuses Éric Bugnet

Re: Feedback - can't update properly

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
Keskmine hinnang: -
Vastuses Andy Tagliani

Re: Feedback - can't update properly

Éric Bugnet –
Documentation writers pilt Plugin developers pilt Translators pilt
Sometimes hammer is a good tool silmapilgutus

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

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

++
Eric
Keskmine hinnang: -
Vastuses Éric Bugnet

Re: Feedback - can't update properly

Anthony Borrow –
Core developers pilt Plugin developers pilt Testers pilt
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
Keskmine hinnang: -
Vastuses Anthony Borrow

Re: Feedback - can't update properly

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
Keskmine hinnang: -
Vastuses Mike Forshaw

Re: Feedback - can't update properly

Andreas Grabs –
Core developers pilt Peer reviewers pilt Plugin developers pilt Translators pilt
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
Keskmine hinnang: -
Vastuses Andreas Grabs

Re: Feedback - can't update properly

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

Keskmine hinnang: -