Comment 0 for bug 1484751

Version: master (15.10)
Browser: any
Platform: any

After upgrading the database from 1.10 or 15.04 to current master (including the patch which changes multirecipientnotification from artefact to module). I got the following errors when sending a message (htdocs/module/multirecipientnotification/sendmessage.php):

[WAR] b5 (lib/errors.php:747) Failed to get a recordset: postgres8 error: [-18: ERROR: relation "module_multirecipient_notification_id_seq" does not exist
LINE 1: SELECT NEXTVAL('module_multirecipient_notification_id_seq')
                      ^] in EXECUTE("SELECT NEXTVAL('module_multirecipient_notification_id_seq')")
Command was: SELECT NEXTVAL('module_multirecipient_notification_id_seq')
Call stack (most recent first):

    log_message("Failed to get a recordset: postgres8 error: [-18: ...", 8, true, true) at /var/www/mahara/master/htdocs/lib/errors.php:97
    log_warn("Failed to get a recordset: postgres8 error: [-18: ...") at /var/www/mahara/master/htdocs/lib/errors.php:747
    SQLException->__construct("Failed to get a recordset: postgres8 error: [-18: ...") at /var/www/mahara/master/htdocs/lib/dml.php:480
    get_recordset_sql("SELECT NEXTVAL('module_multirecipient_notification...", null) at /var/www/mahara/master/htdocs/lib/dml.php:791
    get_field_sql("SELECT NEXTVAL('module_multirecipient_notification...") at /var/www/mahara/master/htdocs/lib/dml.php:1011
    insert_record("module_multirecipient_notification", object(stdClass), "id", true) at /var/www/mahara/master/htdocs/module/multirecipientnotification/notification/ActivityTypeMultirecipientmessage.php:56
    ActivityTypeMultirecipientmessage->notify_users(array(size 2)) at /var/www/mahara/master/htdocs/module/multirecipientnotification/lib/multirecipientnotification.php:120
    send_user_message_mr(array(size 1), "Test", "test", null) at /var/www/mahara/master/htdocs/module/multirecipientnotification/sendmessage.php:245
    sendmessage_submit(object(Pieform), array(size 6)) at Unknown:0
    call_user_func_array("sendmessage_submit", array(size 2)) at /var/www/mahara/master/htdocs/lib/pieforms/pieform.php:537
    Pieform->__construct(array(size 4)) at /var/www/mahara/master/htdocs/lib/pieforms/pieform.php:164
    Pieform::process(array(size 4)) at /var/www/mahara/master/htdocs/lib/pieforms/pieform.php:71
    pieform(array(size 4)) at /var/www/mahara/master/htdocs/module/multirecipientnotification/sendmessage.php:227