Public bug reported:
seen on Mahara 17.04 with an upgraded database and 1 Mahara 17.04 with a
few users, but not on 17.10master with a fresh database
When going to the Web services logs, I get the following error message:
[WAR] 77 (lib/errors.php:859) Failed to get a recordset: postgres8 error: [-1:
ERROR: syntax error at end of input
LINE 1: SELECT "displayname" FROM "institution" WHERE "name" = ?
^] in
EXECUTE("SELECT "displayname" FROM "institution" WHERE "name" = ? ")Command
was: SELECT "displayname" FROM "institution" WHERE "name" = ?
Call stack (most recent first):
log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8,
true, true) at /home/kristina/code/1704stable/htdocs/lib/errors.php:95
log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at
/home/kristina/code/1704stable/htdocs/lib/errors.php:859
SQLException->__construct("Failed to get a recordset: postgres8 error: [-1:
E...") at /home/kristina/code/1704stable/htdocs/lib/dml.php:517
get_recordset_sql("SELECT "displayname" FROM "institution" WHERE "na...",
false) at /home/kristina/code/1704stable/htdocs/lib/dml.php:828
get_field_sql("SELECT "displayname" FROM "institution" WHERE "na...",
array(size 0)) at /home/kristina/code/1704stable/htdocs/lib/dml.php:816
get_field("institution", "displayname", "name", null) at
/home/kristina/code/1704stable/htdocs/lib/institution.php:997
institution_display_name(null) at
/home/kristina/code/1704stable/htdocs/webservice/admin/webservicessearchlib.php:222
get_log_search_results(object(stdClass)) at
/home/kristina/code/1704stable/htdocs/webservice/admin/webservicessearchlib.php:39
build_webservice_log_search_results(object(stdClass)) at
/home/kristina/code/1704stable/htdocs/webservice/admin/webservicelogs.php:53
[WAR] 77 (lib/dml.php:517) Failed to get a recordset: postgres8 error: [-1:
ERROR: syntax error at end of input
LINE 1: SELECT "displayname" FROM "institution" WHERE "name" = ?
^] in
EXECUTE("SELECT "displayname" FROM "institution" WHERE "name" = ? ")Command
was: SELECT "displayname" FROM "institution" WHERE "name" = ?
Call stack (most recent first):
get_recordset_sql("SELECT "displayname" FROM "institution" WHERE "na...",
false) at /home/kristina/code/1704stable/htdocs/lib/dml.php:828
get_field_sql("SELECT "displayname" FROM "institution" WHERE "na...",
array(size 0)) at /home/kristina/code/1704stable/htdocs/lib/dml.php:816
get_field("institution", "displayname", "name", null) at
/home/kristina/code/1704stable/htdocs/lib/institution.php:997
institution_display_name(null) at
/home/kristina/code/1704stable/htdocs/webservice/admin/webservicessearchlib.php:222
get_log_search_results(object(stdClass)) at
/home/kristina/code/1704stable/htdocs/webservice/admin/webservicessearchlib.php:39
build_webservice_log_search_results(object(stdClass)) at
/home/kristina/code/1704stable/htdocs/webservice/admin/webservicelogs.php:53
** Affects: mahara
Importance: Undecided
Status: Confirmed
--
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/1694909
Title:
Webservices log shows errors
Status in Mahara:
Confirmed
Bug description:
seen on Mahara 17.04 with an upgraded database and 1 Mahara 17.04 with
a few users, but not on 17.10master with a fresh database
When going to the Web services logs, I get the following error
message:
[WAR] 77 (lib/errors.php:859) Failed to get a recordset: postgres8 error:
[-1: ERROR: syntax error at end of input
LINE 1: SELECT "displayname" FROM "institution" WHERE "name" = ?
^] in
EXECUTE("SELECT "displayname" FROM "institution" WHERE "name" = ? ")Command
was: SELECT "displayname" FROM "institution" WHERE "name" = ?
Call stack (most recent first):
log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8,
true, true) at /home/kristina/code/1704stable/htdocs/lib/errors.php:95
log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at
/home/kristina/code/1704stable/htdocs/lib/errors.php:859
SQLException->__construct("Failed to get a recordset: postgres8 error:
[-1: E...") at /home/kristina/code/1704stable/htdocs/lib/dml.php:517
get_recordset_sql("SELECT "displayname" FROM "institution" WHERE "na...",
false) at /home/kristina/code/1704stable/htdocs/lib/dml.php:828
get_field_sql("SELECT "displayname" FROM "institution" WHERE "na...",
array(size 0)) at /home/kristina/code/1704stable/htdocs/lib/dml.php:816
get_field("institution", "displayname", "name", null) at
/home/kristina/code/1704stable/htdocs/lib/institution.php:997
institution_display_name(null) at
/home/kristina/code/1704stable/htdocs/webservice/admin/webservicessearchlib.php:222
get_log_search_results(object(stdClass)) at
/home/kristina/code/1704stable/htdocs/webservice/admin/webservicessearchlib.php:39
build_webservice_log_search_results(object(stdClass)) at
/home/kristina/code/1704stable/htdocs/webservice/admin/webservicelogs.php:53
[WAR] 77 (lib/dml.php:517) Failed to get a recordset: postgres8 error: [-1:
ERROR: syntax error at end of input
LINE 1: SELECT "displayname" FROM "institution" WHERE "name" = ?
^] in
EXECUTE("SELECT "displayname" FROM "institution" WHERE "name" = ? ")Command
was: SELECT "displayname" FROM "institution" WHERE "name" = ?
Call stack (most recent first):
get_recordset_sql("SELECT "displayname" FROM "institution" WHERE "na...",
false) at /home/kristina/code/1704stable/htdocs/lib/dml.php:828
get_field_sql("SELECT "displayname" FROM "institution" WHERE "na...",
array(size 0)) at /home/kristina/code/1704stable/htdocs/lib/dml.php:816
get_field("institution", "displayname", "name", null) at
/home/kristina/code/1704stable/htdocs/lib/institution.php:997
institution_display_name(null) at
/home/kristina/code/1704stable/htdocs/webservice/admin/webservicessearchlib.php:222
get_log_search_results(object(stdClass)) at
/home/kristina/code/1704stable/htdocs/webservice/admin/webservicessearchlib.php:39
build_webservice_log_search_results(object(stdClass)) at
/home/kristina/code/1704stable/htdocs/webservice/admin/webservicelogs.php:53
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1694909/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : mahara-contributors@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
