mahara-contributors team mailing list archive

Thread
Date
[Bug 1412606] [NEW] CAST type 'int' is not supported by MySQL

To: mahara-contributors@xxxxxxxxxxxxxxxxxxx
From: Son Nguyen <1412606@xxxxxxxxxxxxxxxxxx>
Date: Tue, 20 Jan 2015 00:47:48 -0000
Reply-to: Bug 1412606 <1412606@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

Version: 15.04
Platform: Apache 2.2, PHP 5.3, MySQL 5.5
Browser: any

This is a regression caused by https://reviews.mahara.org/4154.

I got the following error when accessing the Dashboard page

 [WAR] 83 (lib/errors.php:747) Failed to get a recordset: mysqli error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int), a.ctime, 'artefact_multirecipient_notification' AS msgtable, subject
    ' at line 8] in EXECUTE("SELECT COUNT(*) FROM (
        (
        SELECT a.id, a.read, a.ctime, 'notification_internal_activity' AS msgtable, subject
        FROM "mh01_notification_internal_activity" AS a
        INNER JOIN "mh01_activity_type" AS at ON a.type = at.id
        WHERE a.usr = '1'
        AND  at.name IN ('feedback','groupmessage','institutionmessage','maharamessage','usermessage','viewaccess','watchlist')
        )
        UNION
        (
        SELECT a.id, CAST(b.read AS int), a.ctime, 'artefact_multirecipient_notification' AS msgtable, subject
        FROM "mh01_artefact_multirecipient_notification" AS a
        INNER JOIN "mh01_artefact_multirecipient_userrelation" AS b
            ON a.id = b.notification
        INNER JOIN "mh01_activity_type" AS at ON a.type = at.id
        WHERE b.usr = '1'
        AND b.deleted = '0'
        AND b.role = 'recipient'
        AND  at.name IN ('feedback','groupmessage','institutionmessage','maharamessage','usermessage','viewaccess','watchlist')
        )) AS dummytable")
Command was: SELECT COUNT(*) FROM (
        (
        SELECT a.id, a.read, a.ctime, 'notification_internal_activity' AS msgtable, subject
        FROM "mh01_notification_internal_activity" AS a
        INNER JOIN "mh01_activity_type" AS at ON a.type = at.id
        WHERE a.usr = ?
        AND  at.name IN ('feedback','groupmessage','institutionmessage','maharamessage','usermessage','viewaccess','watchlist')
        )
        UNION
        (
        SELECT a.id, CAST(b.read AS int), a.ctime, 'artefact_multirecipient_notification' AS msgtable, subject
        FROM "mh01_artefact_multirecipient_notification" AS a
        INNER JOIN "mh01_artefact_multirecipient_userrelation" AS b
            ON a.id = b.notification
        INNER JOIN "mh01_activity_type" AS at ON a.type = at.id
        WHERE b.usr = ?
        AND b.deleted = '0'
        AND b.role = 'recipient'
        AND  at.name IN ('feedback','groupmessage','institutionmessage','maharamessage','usermessage','viewaccess','watchlist')
        )) AS dummytable and values was (1,1)
Call stack (most recent first):
log_message("Failed to get a recordset: mysqli error: [1064: Yo...", 8, true, true) at /home/sonn/code/mahara/master/htdocs/lib/errors.php:97
log_warn("Failed to get a recordset: mysqli error: [1064: Yo...") at /home/sonn/code/mahara/master/htdocs/lib/errors.php:747
SQLException->__construct("Failed to get a recordset: mysqli error: [1064: Yo...") at /home/sonn/code/mahara/master/htdocs/lib/dml.php:477
get_recordset_sql("SELECT COUNT(*) FROM ( ( SELECT a....", array(size 2)) at /home/sonn/code/mahara/master/htdocs/lib/dml.php:266
count_records_sql("SELECT COUNT(*) FROM ( ( SELECT a....", array(size 2)) at /home/sonn/code/mahara/master/htdocs/artefact/multirecipientnotification/lib/activityextend.php:69
activitylistin("feedback,groupmessage,institutionmessage,maharames...", "5") at /home/sonn/code/mahara/master/htdocs/blocktype/inbox/lib.php:56
PluginBlocktypeInbox::render_instance(object(BlockInstance)) at Unknown:0
call_user_func_array(array(size 2), array(size 1)) at /home/sonn/code/mahara/master/htdocs/lib/mahara.php:1578
call_static_method("PluginBlocktypeInbox", "render_instance", object(BlockInstance)) at /home/sonn/code/mahara/master/htdocs/blocktype/lib.php:782
BlockInstance->render_viewing() at /home/sonn/code/mahara/master/htdocs/lib/view.php:2059
View->build_column(1, 2, false) at /home/sonn/code/mahara/master/htdocs/lib/view.php:2016
View->build_columns(1, false) at /home/sonn/code/mahara/master/htdocs/lib/view.php:2001
View->build_rows() at /home/sonn/code/mahara/master/htdocs/index.php:49

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


** Tags: regression

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

Title:
  CAST type 'int' is not supported by MySQL

Status in Mahara ePortfolio:
  In Progress

Bug description:
  Version: 15.04
  Platform: Apache 2.2, PHP 5.3, MySQL 5.5
  Browser: any

  This is a regression caused by https://reviews.mahara.org/4154.

  I got the following error when accessing the Dashboard page

   [WAR] 83 (lib/errors.php:747) Failed to get a recordset: mysqli error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int), a.ctime, 'artefact_multirecipient_notification' AS msgtable, subject
      ' at line 8] in EXECUTE("SELECT COUNT(*) FROM (
          (
          SELECT a.id, a.read, a.ctime, 'notification_internal_activity' AS msgtable, subject
          FROM "mh01_notification_internal_activity" AS a
          INNER JOIN "mh01_activity_type" AS at ON a.type = at.id
          WHERE a.usr = '1'
          AND  at.name IN ('feedback','groupmessage','institutionmessage','maharamessage','usermessage','viewaccess','watchlist')
          )
          UNION
          (
          SELECT a.id, CAST(b.read AS int), a.ctime, 'artefact_multirecipient_notification' AS msgtable, subject
          FROM "mh01_artefact_multirecipient_notification" AS a
          INNER JOIN "mh01_artefact_multirecipient_userrelation" AS b
              ON a.id = b.notification
          INNER JOIN "mh01_activity_type" AS at ON a.type = at.id
          WHERE b.usr = '1'
          AND b.deleted = '0'
          AND b.role = 'recipient'
          AND  at.name IN ('feedback','groupmessage','institutionmessage','maharamessage','usermessage','viewaccess','watchlist')
          )) AS dummytable")
  Command was: SELECT COUNT(*) FROM (
          (
          SELECT a.id, a.read, a.ctime, 'notification_internal_activity' AS msgtable, subject
          FROM "mh01_notification_internal_activity" AS a
          INNER JOIN "mh01_activity_type" AS at ON a.type = at.id
          WHERE a.usr = ?
          AND  at.name IN ('feedback','groupmessage','institutionmessage','maharamessage','usermessage','viewaccess','watchlist')
          )
          UNION
          (
          SELECT a.id, CAST(b.read AS int), a.ctime, 'artefact_multirecipient_notification' AS msgtable, subject
          FROM "mh01_artefact_multirecipient_notification" AS a
          INNER JOIN "mh01_artefact_multirecipient_userrelation" AS b
              ON a.id = b.notification
          INNER JOIN "mh01_activity_type" AS at ON a.type = at.id
          WHERE b.usr = ?
          AND b.deleted = '0'
          AND b.role = 'recipient'
          AND  at.name IN ('feedback','groupmessage','institutionmessage','maharamessage','usermessage','viewaccess','watchlist')
          )) AS dummytable and values was (1,1)
  Call stack (most recent first):
  log_message("Failed to get a recordset: mysqli error: [1064: Yo...", 8, true, true) at /home/sonn/code/mahara/master/htdocs/lib/errors.php:97
  log_warn("Failed to get a recordset: mysqli error: [1064: Yo...") at /home/sonn/code/mahara/master/htdocs/lib/errors.php:747
  SQLException->__construct("Failed to get a recordset: mysqli error: [1064: Yo...") at /home/sonn/code/mahara/master/htdocs/lib/dml.php:477
  get_recordset_sql("SELECT COUNT(*) FROM ( ( SELECT a....", array(size 2)) at /home/sonn/code/mahara/master/htdocs/lib/dml.php:266
  count_records_sql("SELECT COUNT(*) FROM ( ( SELECT a....", array(size 2)) at /home/sonn/code/mahara/master/htdocs/artefact/multirecipientnotification/lib/activityextend.php:69
  activitylistin("feedback,groupmessage,institutionmessage,maharames...", "5") at /home/sonn/code/mahara/master/htdocs/blocktype/inbox/lib.php:56
  PluginBlocktypeInbox::render_instance(object(BlockInstance)) at Unknown:0
  call_user_func_array(array(size 2), array(size 1)) at /home/sonn/code/mahara/master/htdocs/lib/mahara.php:1578
  call_static_method("PluginBlocktypeInbox", "render_instance", object(BlockInstance)) at /home/sonn/code/mahara/master/htdocs/blocktype/lib.php:782
  BlockInstance->render_viewing() at /home/sonn/code/mahara/master/htdocs/lib/view.php:2059
  View->build_column(1, 2, false) at /home/sonn/code/mahara/master/htdocs/lib/view.php:2016
  View->build_columns(1, false) at /home/sonn/code/mahara/master/htdocs/lib/view.php:2001
  View->build_rows() at /home/sonn/code/mahara/master/htdocs/index.php:49

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

[Bug 1412606] Re: CAST type 'int' is not supported by MySQL
From: Robert Lyon, 2015-04-17
[Bug 1412606] A change has been merged
From: Mahara Bot, 2015-01-27
[Bug 1412606] Re: CAST type 'int' is not supported by MySQL
From: Robert Lyon, 2015-01-27
[Bug 1412606] A patch has been submitted for review
From: Mahara Bot, 2015-01-20
[Bug 1412606] [NEW] CAST type 'int' is not supported by MySQL
From: Son Nguyen, 2015-01-20
References

[Bug 1412606] [NEW] CAST type 'int' is not supported by MySQL
From: Son Nguyen, 2015-01-20