mahara-contributors team mailing list archive

[Richard Mansfield <richard.mansfield@xxxxxxxxxxxxxxx>]

** Changed in: mahara
       Status: Confirmed => Incomplete

-- 
XMLRPC connection from Moodle fails for some users
https://bugs.launchpad.net/bugs/547481
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.

Status in Mahara ePortfolio: Incomplete

Bug description:
Ok, it seems that switching off 'Update user info on login' in the xmlrpc settings solves the issue. I also have all fields locked. Accounts that fails end with a blank white screen on this url:

http://roydshall.org/portfolio/auth/xmlrpc/land.php?token=437e2b0c623d2f8c9f1106d2ee02e1b437a0aabd&idp=http://roydshall.org/moodle&wantsurl=

The logs show that get_record_sql retrives two rows when it is looking for one and this crashes the request.

The apache logs are:

[WAR] 59 (lib/errors.php:654) get_record_sql found more than one row. If you meant to retrieve more than one record, use get_records_*, otherwise check your code or database for inconsistencies, referer: http://roydshall.org/moodle/?
[Tue Feb 10 15:51:35 2009] [error] [client 10.75.48.221] Call stack (most recent first):, referer: http://roydshall.org/moodle/?
[Tue Feb 10 15:51:35 2009] [error] [client 10.75.48.221]   * log_message("get_record_sql found more than one row. If you mea...", 8, true, true) at /home/www/portfolio/lib/errors.php:90, referer: http://roydshall.org/moodle/?
[Tue Feb 10 15:51:35 2009] [error] [client 10.75.48.221]   * log_warn("get_record_sql found more than one row. If you mea...") at /home/www/portfolio/lib/errors.php:654, referer: http://roydshall.org/moodle/?
[Tue Feb 10 15:51:35 2009] [error] [client 10.75.48.221]   * SQLException->__construct("get_record_sql found more than one row. If you mea...") at /home/www/portfolio/lib/dml.php:282, referer: http://roydshall.org/moodle/?
[Tue Feb 10 15:51:35 2009] [error] [client 10.75.48.221]   * get_record_sql("SELECT * FROM "artefact"  WHERE "artefacttype" = ?...", array(size 2)) at /home/www/portfolio/lib/dml.php:247, referer: http://roydshall.org/moodle/?
[Tue Feb 10 15:51:35 2009] [error] [client 10.75.48.221]   * get_record("artefact", "artefacttype", "introduction", "owner", "207") at /home/www/portfolio/artefact/internal/lib.php:148, referer: http://roydshall.org/moodle/?
[Tue Feb 10 15:51:35 2009] [error] [client 10.75.48.221]   * ArtefactTypeProfile->__construct(0array(size 1)) at /home/www/portfolio/lib/user.php:228, referer: http://roydshall.org/moodle/?
[Tue Feb 10 15:51:35 2009] [error] [client 10.75.48.221]   * set_profile_field("207", "introduction", "Imani") at /home/www/portfolio/auth/xmlrpc/lib.php:465, referer: http://roydshall.org/moodle/?
[Tue Feb 10 15:51:35 2009] [error] [client 10.75.48.221]   * AuthXmlrpc->import_user_settings(object(User), object(stdClass)) at /home/www/portfolio/auth/xmlrpc/lib.php:264, referer: http://roydshall.org/moodle/?
[Tue Feb 10 15:51:35 2009] [error] [client 10.75.48.221]   * AuthXmlrpc->request_user_authorise("06a63a69f7473f5c3eac68a6f7f07a6de7aa381d", "http://roydshall.org/moodle";) at /home/www/portfolio/auth/xmlrpc/land.php:94, referer: http://roydshall.org/moodle/?
[Tue Feb 10 15:51:35 2009] [error] [client 10.75.48.221] , referer: http://roydshall.org/moodle/?

This bug was imported from eduforge.org, see:
https://eduforge.org/tracker/index.php?func=detail&aid=3135&group_id=176&atid=739