Upgrade from 1.9 failed with ALTER table error

[johanreinalda]

Trying to upgrade from Moodle 1.9.19+ (Build: 20120823). We are running OUWiki for 1.9, version = 2010042201.

After a clean code upgrade from 1.9 -> 2.2 -> 2.3, and installing latest OUWiki 2.2 in 2.3 (both from Moodle plugins, and latest git build "41aea1d"), we get the following error:

"DDL sql execution error

More information about this error Debug info: Unknown column 'locked' in 'mdl_ouwiki_pages' ALTER TABLE mdl_ouwiki_pages ADD firstversionid BIGINT(10) DEFAULT 0 AFTER locked Error code: ddlexecuteerror "

We tried the install at the Moodle 2.2 stage as well, but get the same error. What are we missing? Is there a later OUWiki 1.9 that we need to start from ? Any other ideas on how to fix this ?

Thanks, Johan

[sammarshallou]

Hi, I should make clear that we have not done this upgrade approach (we started fresh) so it hasn't been tested by us and may have issues.

Yes I think this particular problem is because you had an old version of ouwiki. Upgrading to the latest ouwiki for 1.9 first ought to fix it.

If you do not need to keep existing wiki content, you could uninstall ouwiki entirely before installing, however this will wipe all content so isn't an option if you do need to keep it.

[sammarshallou]

note: if you don't want to upgrade ouwiki on 1.9, you could try manually making the table changes, but that might be a bit challenging

[johanreinalda]

Where can we find the latest for Moodle 1.9 ? Following the old plugins link in moodle.org/plugins, I find a google docs page that has a OU Wiki v2.5. I had looked at the previously, but it showed the same version (2010042201) Is that the latest for Moodle 1.9 ?

Thanks, Johan

[sammarshallou]

Latest version is here:

https://docs.google.com/folder/d/0BwFVUu6OwBtgYzhiMzQzZmUtODdhZC00NTExLTgwYmQtMDVjYjlhZjllYmUz/edit

I don't know what the version number is, haven't checked

--sam

-----Original Message----- From: johanreinalda [mailto:notifications@github.com] Sent: 24 September 2012 18:45 To: moodleou/moodle-mod_ouwiki Cc: sam marshall Subject: Re: [moodle-mod_ouwiki] Upgrade from 1.9 failed with ALTER table error (#10)

Where can we find the latest for Moodle 1.9 ? Following the old plugins link in moodle.org/plugins, I find a google docs page that has a OU Wiki v2.5. I had looked at the previously, but it showed the same version (2010042201) Is that the latest for Moodle 1.9 ?

Thanks, Johan

— Reply to this email directly or view it on GitHub https://github.com/moodleou/moodle- mod_ouwiki/issues/10#issuecomment-8827595 .

https://github.com/notifications/beacon/J6T91GIPIyhU- 8ti4GCGP2qo8Vx5dod77Xxd5ZcmHah2MlLJpN0-N-M0kQKEYxzb.gif

The Open University is incorporated by Royal Charter (RC 000391), an exempt charity in England & Wales and a charity registered in Scotland (SC 038302).