Errors in sending a message after upgrading from 1.10 or 15.04 to master

Bug #1484751 reported by Son Nguyen
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
Fix Released
High
Son Nguyen
15.10
Fix Released
Undecided
Unassigned

Bug Description

Version: master (15.10)
Browser: any
Platform: apache 2.x, php 5.x and PostgreSQL

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

Revision history for this message
Son Nguyen (ngson2000) wrote :

This issue don't happen on MySQL

description: updated
Revision history for this message
Mahara Bot (dev-mahara) wrote : A patch has been submitted for review

Patch for "master" branch: https://reviews.mahara.org/5103

Changed in mahara:
milestone: none → 15.10.0
Revision history for this message
Mahara Bot (dev-mahara) wrote : A change has been merged

Reviewed: https://reviews.mahara.org/5103
Committed: https://git.nzoss.org.nz/mahara/mahara/commit/ecff116097b00ce1e1d9625739ffdf25e362ee72
Submitter: Jono Mingard (<email address hidden>)
Branch: master

commit ecff116097b00ce1e1d9625739ffdf25e362ee72
Author: Son Nguyen <email address hidden>
Date: Fri Aug 14 14:33:17 2015 +1200

Rename serial sequences come with tables (Bug 1484751)
artefact_multirecipient_notification and
artefact_multirecipient_userrelation

behatnotneeded: as this is an upgrade problem

Change-Id: Iba6984af6f9ea13b1a763a61b426b7fa6eb4f67e

Son Nguyen (ngson2000)
Changed in mahara:
status: In Progress → Fix Committed
Revision history for this message
Mahara Bot (dev-mahara) wrote : A patch has been submitted for review

Patch for "master" branch: https://reviews.mahara.org/5140

Robert Lyon (robertl-9)
Changed in mahara:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.