mahara-contributors team mailing list archive

[Aaron Wells <1484751@xxxxxxxxxxxxxxxxxx>]

** Also affects: mahara/15.10
   Importance: Undecided
       Status: New

** Also affects: mahara/15.10
   Importance: Undecided
       Status: Fix Released

-- 
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:
  Fix Committed
Status in Mahara 15.10 series:
  Fix Released

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