mahara-contributors team mailing list archive

[Mahara Bot <1484751@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/5103
Committed: https://git.nzoss.org.nz/mahara/mahara/commit/ecff116097b00ce1e1d9625739ffdf25e362ee72
Submitter: Jono Mingard (reason.koan@xxxxxxxxx)
Branch:    master

commit ecff116097b00ce1e1d9625739ffdf25e362ee72
Author: Son Nguyen <son.nguyen@xxxxxxxxxxxxxxx>
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

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1484751

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

Status in Mahara:
  In Progress

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

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1484751/+subscriptions