*** This bug is a duplicate of bug 1514272 ***
https://bugs.launchpad.net/bugs/1514272
Many thanks Aaron, that's fixed it.
Cheers!
Ed
--
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/1515150
Title:
User search fails and throws a "A nonrecoverable error occurred"
message
Status in Mahara:
New
Bug description:
We have just upgraded to the latest version of Mahara 15.10.0 from
15.04.2 and we are now having issues searching for users from the top
search box or from /user/find.php resulting in the following error
message: "A nonrecoverable error occurred. This probably means you
have encountered a bug in the system".
The PHP errors are as follows:
2015/11/11 09:04:08 [error] 1077#0: *2071 FastCGI sent in stderr: "PHP
message: [WAR] 5f (lib/errors.php:747) Failed to get a recordset: mysqli error:
[-9999: Input Array does not match ?:
PHP message: [WAR] 5f (lib/errors.php:747) SELECT
PHP message: [WAR] 5f (lib/errors.php:747) COUNT(u.id)
PHP message: [WAR] 5f (lib/errors.php:747) FROM "usr" u
PHP message: [WAR] 5f (lib/errors.php:747) LEFT OUTER JOIN
"usr_account_preference" h ON (u.id = h.usr AND h.field =
'hiderealname')
PHP message: [WAR] 5f (lib/errors.php:747) WHERE
PHP message: [WAR] 5f (lib/errors.php:747) u.id != 0 AND
u.active = 1 AND u.deleted = 0
PHP message: [WAR] 5f (lib/errors.php:747) AND (
PHP message: [WAR] 5f (lib/errors.php:747)
u.preferredname LIKE '%' || 'test' || '%'
PHP message: [WAR] 5f (lib/errors.php:747) OR (
PHP message: [WAR] 5f (lib/errors.php:747)
(u.preferredname IS NULL OR u.preferredname = '' OR NOT FALSE OR h.value != '1'
OR h.value IS NULL)
PHP message: [WAR] 5f (lib/errors.php:747) AND
(u.firstname LIKE '%' || 'test' || '%' OR u.lastname LIKE '%' || 'test' || '%')
PHP message: [WAR] 5f (lib/errors.php:747) )
PHP message: [WAR] 5f (lib/errors.php:747) OR (TRUE AND
u.username LIKE '%' || 'test' || '%')
PHP message: [WAR] 5f (lib/errors.php:747) OR (u.email
LIKE '%' || 'test' || '%' OR (SELECT email FROM
"artefact_internal_profile_email" ai WHERE ai.email LIKE '%' || 1 ||
'%' AND ai.owner = u.id AND ai.verified = 1 LIMIT 1) LIKE '%' || ] in
Execute(, )
PHP message: [WAR] 5f (lib/errors.php:747) Command was:
PHP message: [WAR] 5f (lib/errors.php:747) SELECT
PHP message: [WAR] 5f (lib/errors.php:747) COUNT(u.id)
PHP message: [WAR] 5f (lib/errors.php:747) FROM "usr" u
PHP message: [WAR] 5f (lib/errors.php:747)
2015/11/11 09:04:08 [error] 1077#0: *2071 FastCGI sent in stderr: " SELECT
PHP message: COUNT(u.id)
PHP message: ...", array(size 6)) at
/scratch/var/mahara/htdocs/lib/dml.php:269
PHP message: * count_records_sql("
PHP message: SELECT
PHP message: COUNT(u.id)
PHP message: ...", array(size 6)) at
/scratch/var/mahara/htdocs/search/internal/lib.php:159
PHP message: * PluginSearchInternal::search_user("test", 10, 0, array(size
1)) at Unknown:0
PHP message: * call_user_func_array(array(size 2), array(size 4)) at
/scratch/var/mahara/htdocs/lib/mahara.php:1693
PHP message: * call_static_method("PluginSearchInternal", "search_user",
"test", 10, 0, array(size 1)) at /scratch/var/mahara/htdocs/lib/searchlib.php:52
PHP message: * search_user("test", 10, 0, array(size 1)) at
/scratch/var/mahara/htdocs/json/friendsearch.php:41
PHP message:" while reading response header from upstream, client: *.*.*.*,
server: _, request: "GET
/json/friendsearch.php?query=test&extradata=%7B%22page%22%3A%22find%22%7D&sesskey=****
HTTP/1.1", upstream: "fastcgi://unix:/tmp/php-fpm.sock:", host: "****",
referrer: "http://****/user/find.php";
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1515150/+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
