Upgrading 2.9 to 3.0

Upgrading 2.9 to 3.0

by Sue Kirkland-Smith -
Number of replies: 3

Am unable to upgrade moodle database because of the following error. Is it possible to delete the plugin causing the error from the httpdocs and try updating the database again or is their another recommended fix?

mod_flashcard

DDL sql execution error

More information about this error
Debug info: Unknown column 'customreviewemptyfileid' in 'mdl_flashcard'
ALTER TABLE mdl_flashcard ADD extracss LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci AFTER customreviewemptyfileid
Error code: ddlexecuteerror
Stack trace:

    line 449 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
    line 905 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
    line 76 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
    line 533 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
    line 273 of /mod/flashcard/db/upgrade.php: call to database_manager->add_field()
    line 716 of /lib/upgradelib.php: call to xmldb_flashcard_upgrade()
    line 427 of /lib/upgradelib.php: call to upgrade_plugins_modules()
    line 1647 of /lib/upgradelib.php: call to upgrade_plugins()
    line 683 of /admin/index.php: call to upgrade_noncore()

Average of ratings: -
In reply to Sue Kirkland-Smith

Re: Upgrading 2.9 to 3.0

by Luis de Vasconcelos -

Is that /mod/flashcard plugin compatible with Moodle 3.0? Did you install the correct /mod/flashcard version when you upgraded to Moodle 3.0?

Average of ratings: -
In reply to Luis de Vasconcelos

Re: Upgrading 2.9 to 3.0

by Sue Kirkland-Smith -

I may not have. How do I fix now as cannot get past this error.

Average of ratings: -
In reply to Sue Kirkland-Smith

Re: Upgrading 2.9 to 3.0

by Luis de Vasconcelos -
According to the note on https://moodle.org/plugins/mod_flashcard it seems that there are now two forks of the flashcard module:


So you need to check which one you are using.

It seems like the tmuras version is no longer supported, so if that't the one you're using you have a problem...

Once you've established your version, download the code from the corresponding github.com repository and REPLACE the flashcard folder on your Moodle server with the one you downloaded (NOTE: REPLACE the folder, don't OVERWRITE it with the new one).

Then go to the Notifications page in your Moodle Site Admin block and let the plugin be upgraded.
Average of ratings: -