Public bug reported:

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

** Affects: mahara
     Importance: High
     Assignee: Son Nguyen (ngson2000)
         Status: In Progress

-- 
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: 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

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

_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~mahara-contributors
More help   : https://help.launchpad.net/ListHelp

Reply via email to