mahara-contributors team mailing list archive

[Jinelle Foley-Barnes <jinelleb@xxxxxxxxxxxxxxx>]

Hi Tobias,

Text dump from the error I was getting. I hope it can help you sort it
out.

[WAR] c9 (lib/errors.php:747) Failed to get a recordset: postgres8 error: [-1: ERROR:  each UNION query must have the same number of columns
LINE 11:            SELECT a.id, a.ctime, 'artefact_multirecipient_n...
                            ^] in EXECUTE("SELECT COUNT(*) FROM (
            (
            SELECT a.id, a.read, a.ctime, 'notification_internal_activity' AS msgtable, subject
            FROM "notification_internal_activity" AS a
            INNER JOIN "activity_type" AS at ON a.type = at.id
            WHERE a.usr = ?
           
            )
            UNION
            (
            SELECT a.id, a.ctime, 'artefact_multirecipient_notification' AS msgtable, subject
            FROM "artefact_multirecipient_notification" AS a
            INNER JOIN "artefact_multirecipient_userrelation" AS b
                ON a.id = b.notification
            INNER JOIN "activity_type" AS at ON a.type = at.id
            WHERE b.usr = ?
            AND b.deleted = '0'
            AND b.role = 'recipient'
           
            )) AS dummytable")
Command was: SELECT COUNT(*) FROM (
            (
            SELECT a.id, a.read, a.ctime, 'notification_internal_activity' AS msgtable, subject
            FROM "notification_internal_activity" AS a
            INNER JOIN "activity_type" AS at ON a.type = at.id
            WHERE a.usr = ?
           
            )
            UNION
            (
            SELECT a.id, a.ctime, 'artefact_multirecipient_notification' AS msgtable, subject
            FROM "artefact_multirecipient_notification" AS a
            INNER JOIN "artefact_multirecipient_userrelation" AS b
                ON a.id = b.notification
            INNER JOIN "activity_type" AS at ON a.type = at.id
            WHERE b.usr = ?
            AND b.deleted = '0'
            AND b.role = 'recipient'
           
            )) AS dummytable and values was (1,1)
Call stack (most recent first):

    log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8, true, true) at /var/www/html/maharawip/htdocs/lib/errors.php:97
    log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/maharawip/htdocs/lib/errors.php:747
    SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/maharawip/htdocs/lib/dml.php:480
    get_recordset_sql("SELECT COUNT(*) FROM ( ( S...", array(size 2)) at /var/www/html/maharawip/htdocs/lib/dml.php:269
    count_records_sql("SELECT COUNT(*) FROM ( ( S...", array(size 2)) at /var/www/html/maharawip/htdocs/artefact/multirecipientnotification/lib/activityextend.php:87
    activitylistin("all", 10, 0) at /var/www/html/maharawip/htdocs/artefact/multirecipientnotification/lib/activityextend.php:126
    activitylistin_html("all") at /var/www/html/maharawip/htdocs/artefact/multirecipientnotification/inbox.php:70

[WAR] c9 (lib/dml.php:480) Failed to get a recordset: postgres8 error: [-1: ERROR:  each UNION query must have the same number of columns
LINE 11:            SELECT a.id, a.ctime, 'artefact_multirecipient_n...
                            ^] in EXECUTE("SELECT COUNT(*) FROM (
            (
            SELECT a.id, a.read, a.ctime, 'notification_internal_activity' AS msgtable, subject
            FROM "notification_internal_activity" AS a
            INNER JOIN "activity_type" AS at ON a.type = at.id
            WHERE a.usr = ?
           
            )
            UNION
            (
            SELECT a.id, a.ctime, 'artefact_multirecipient_notification' AS msgtable, subject
            FROM "artefact_multirecipient_notification" AS a
            INNER JOIN "artefact_multirecipient_userrelation" AS b
                ON a.id = b.notification
            INNER JOIN "activity_type" AS at ON a.type = at.id
            WHERE b.usr = ?
            AND b.deleted = '0'
            AND b.role = 'recipient'
           
            )) AS dummytable")
Command was: SELECT COUNT(*) FROM (
            (
            SELECT a.id, a.read, a.ctime, 'notification_internal_activity' AS msgtable, subject
            FROM "notification_internal_activity" AS a
            INNER JOIN "activity_type" AS at ON a.type = at.id
            WHERE a.usr = ?
           
            )
            UNION
            (
            SELECT a.id, a.ctime, 'artefact_multirecipient_notification' AS msgtable, subject
            FROM "artefact_multirecipient_notification" AS a
            INNER JOIN "artefact_multirecipient_userrelation" AS b
                ON a.id = b.notification
            INNER JOIN "activity_type" AS at ON a.type = at.id
            WHERE b.usr = ?
            AND b.deleted = '0'
            AND b.role = 'recipient'
           
            )) AS dummytable and values was (1,1)
Call stack (most recent first):

    get_recordset_sql("SELECT COUNT(*) FROM ( ( S...", array(size 2)) at /var/www/html/maharawip/htdocs/lib/dml.php:269
    count_records_sql("SELECT COUNT(*) FROM ( ( S...", array(size 2)) at /var/www/html/maharawip/htdocs/artefact/multirecipientnotification/lib/activityextend.php:87
    activitylistin("all", 10, 0) at /var/www/html/maharawip/htdocs/artefact/multirecipientnotification/lib/activityextend.php:126
    activitylistin_html("all") at /var/www/html/maharawip/htdocs/artefact/multirecipientnotification/inbox.php:70

Mahara: Site unavailable



Thanks,
Jinelle

-- 
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/1369569

Title:
  Search/Filter for the inbox/outbox

Status in Mahara ePortfolio:
  In Progress

Bug description:
  As notifications cannot be archived or stored in folders, it would be
  nice to have a search/filter functionality for all the notifications
  in your inbox/outbox.

  We actually had this ready for some time and would like to upload that
  (in case it's approved/appreciated) before any further work on the
  notification system

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