2012-01-26 09:53:48 |
Patrick Pollet |
bug |
|
|
added bug |
2012-01-26 09:59:11 |
Patrick Pollet |
description |
When importing a LEAP2 zip into a 1.5 Mahara site (latest 1.5.0dev from git) and if the new user email is already known, importation proceed normally but the mahara site then starts to fail in various places (search friends, see groups members) ...
Errors reported in httpd error_log are :
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] [WAR] a9 (lib/errors.php:749) 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://vm107-04.insa-lyon.fr/m
ahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] Call stack (most recent first):, referer: http://vm107-04.insa-lyon.fr/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * log_message("get_record_sql found more than one row. If you mea...", 8, true, true)
at /var/www/html/mahara.git/htdocs/lib/errors.php:109, referer: http://vm107-04.insa-lyon.fr/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * log_warn("get_record_sql found more than one row. If you mea...") at /var/www/html/
mahara.git/htdocs/lib/errors.php:749, referer: http://vm107-04.insa-lyon.fr/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * SQLException->__construct("get_record_sql found more than one row. If you mea...")
at /var/www/html/mahara.git/htdocs/lib/dml.php:339, referer: http://vm107-04.insa-lyon.fr/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * get_record_sql("SELECT * FROM "usr" WHERE "email" = ? ", array(size 1)) at /var/ww
w/html/mahara.git/htdocs/lib/dml.php:302, referer: http://vm107-04.insa-lyon.fr/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * get_record("usr", "email", "pp@patrickpollet.net") at /var/www/html/mahara.git/htdo
cs/local/insa/remote_avatar.php:17, referer: http://vm107-04.insa-lyon.fr/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * local_remote_avatar("pp@patrickpollet.net", array(size 2), "http://vm107-04.insa-ly
on.fr/mahara/theme/raw/stat...") at /var/www/html/mahara.git/htdocs/lib/user.php:2246, referer: http://vm107-04.insa-lyon.fr/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * remote_avatar("pp@patrickpollet.net", array(size 2), "http://vm107-04.insa-lyon.fr/
mahara/theme/raw/stat...") at /var/www/html/mahara.git/htdocs/lib/user.php:2227, referer: http://vm107-04.insa-lyon.fr/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * profile_icon_url(object(stdClass), 40, 40) at /var/www/html/mahara.git/htdocs/lib/d
woo/mahara/plugins/function.profile_icon_url.php:13, referer: http://vm107-04.insa-lyon.fr/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * Dwoo_Plugin_profile_icon_url(object(Dwoo_Mahara), object(stdClass), 40, 40) at /wor
k/maharadata/dwoo/compile/insalyon/var/www/html/mahara.git/htdocs/theme/raw/templates/user/user.tpl.d17.php:92, referer: http://vm107-04.insa-lyon.
fr/mahara/
It is also impossible to delete that user under site administration since getting that user data fails with the above error...
To return site to 'normal operation' one has to go to table usr and manually edit the new user email to an unique value
Cheers.
Edit : I did not tested it yet, but I do hope that this behaviour does not occur also in importing users from a CSV file ;-) |
When importing a LEAP2 zip into a 1.5 Mahara site (latest 1.5.0dev from git) and if the new user email is already known, importation proceeds normally but the mahara site then starts to fail in various places (search friends, see groups members) ...
Errors reported in httpd error_log are :
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] [WAR] a9 (lib/errors.php:749) 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://xxxxxxxxxxxxx/m
ahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] Call stack (most recent first):, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * log_message("get_record_sql found more than one row. If you mea...", 8, true, true)
at /var/www/html/mahara.git/htdocs/lib/errors.php:109, referer: http://vm107-04.insa-lyon.fr/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * log_warn("get_record_sql found more than one row. If you mea...") at /var/www/html/
mahara.git/htdocs/lib/errors.php:749, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * SQLException->__construct("get_record_sql found more than one row. If you mea...")
at /var/www/html/mahara.git/htdocs/lib/dml.php:339, referer: http:///mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * get_record_sql("SELECT * FROM "usr" WHERE "email" = ? ", array(size 1)) at /var/www/html/mahara.git/htdocs/lib/dml.php:302, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * get_record("usr", "email", "pp@patrickpollet.net") at /var/www/html/mahara.git/htdo
cs/local/insa/remote_avatar.php:17, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * local_remote_avatar("pp@patrickpollet.net", array(size 2), "http://xxxxxxxxxxxx/mahara/theme/raw/stat...") at /var/www/html/mahara.git/htdocs/lib/user.php:2246, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * remote_avatar("pp@patrickpollet.net", array(size 2), "http://xxxxxxxxxxxx/
mahara/theme/raw/stat...") at /var/www/html/mahara.git/htdocs/lib/user.php:2227, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * profile_icon_url(object(stdClass), 40, 40) at /var/www/html/mahara.git/htdocs/lib/d
woo/mahara/plugins/function.profile_icon_url.php:13, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * Dwoo_Plugin_profile_icon_url(object(Dwoo_Mahara), object(stdClass), 40, 40) at /wor
k/maharadata/dwoo/compile/insalyon/var/www/html/mahara.git/htdocs/theme/raw/templates/user/user.tpl.d17.php:92, referer: http://xxxxxxxxxxxx/mahara/
It is also impossible to delete that user under site administration since getting that user data fails with the above error...
To return site to 'normal operation' one has to go to table usr and manually edit the new user email to an unique value
Cheers.
Edit : I did not tested it yet, but I do hope that this behaviour does not occur also in importing users from a CSV file ;-) |
|
2012-01-26 09:59:53 |
Patrick Pollet |
description |
When importing a LEAP2 zip into a 1.5 Mahara site (latest 1.5.0dev from git) and if the new user email is already known, importation proceeds normally but the mahara site then starts to fail in various places (search friends, see groups members) ...
Errors reported in httpd error_log are :
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] [WAR] a9 (lib/errors.php:749) 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://xxxxxxxxxxxxx/m
ahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] Call stack (most recent first):, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * log_message("get_record_sql found more than one row. If you mea...", 8, true, true)
at /var/www/html/mahara.git/htdocs/lib/errors.php:109, referer: http://vm107-04.insa-lyon.fr/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * log_warn("get_record_sql found more than one row. If you mea...") at /var/www/html/
mahara.git/htdocs/lib/errors.php:749, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * SQLException->__construct("get_record_sql found more than one row. If you mea...")
at /var/www/html/mahara.git/htdocs/lib/dml.php:339, referer: http:///mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * get_record_sql("SELECT * FROM "usr" WHERE "email" = ? ", array(size 1)) at /var/www/html/mahara.git/htdocs/lib/dml.php:302, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * get_record("usr", "email", "pp@patrickpollet.net") at /var/www/html/mahara.git/htdo
cs/local/insa/remote_avatar.php:17, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * local_remote_avatar("pp@patrickpollet.net", array(size 2), "http://xxxxxxxxxxxx/mahara/theme/raw/stat...") at /var/www/html/mahara.git/htdocs/lib/user.php:2246, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * remote_avatar("pp@patrickpollet.net", array(size 2), "http://xxxxxxxxxxxx/
mahara/theme/raw/stat...") at /var/www/html/mahara.git/htdocs/lib/user.php:2227, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * profile_icon_url(object(stdClass), 40, 40) at /var/www/html/mahara.git/htdocs/lib/d
woo/mahara/plugins/function.profile_icon_url.php:13, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * Dwoo_Plugin_profile_icon_url(object(Dwoo_Mahara), object(stdClass), 40, 40) at /wor
k/maharadata/dwoo/compile/insalyon/var/www/html/mahara.git/htdocs/theme/raw/templates/user/user.tpl.d17.php:92, referer: http://xxxxxxxxxxxx/mahara/
It is also impossible to delete that user under site administration since getting that user data fails with the above error...
To return site to 'normal operation' one has to go to table usr and manually edit the new user email to an unique value
Cheers.
Edit : I did not tested it yet, but I do hope that this behaviour does not occur also in importing users from a CSV file ;-) |
When importing a LEAP2 zip into a 1.5 Mahara site (latest 1.5.0dev from git) and if the new user email is already known, importation proceeds normally but the mahara site then starts to fail in various places (search friends, see groups members) ...
Errors reported in httpd error_log are :
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] [WAR] a9 (lib/errors.php:749) 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://xxxxxxxxxxxxx/m
ahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] Call stack (most recent first):, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * log_message("get_record_sql found more than one row. If you mea...", 8, true, true)
at /var/www/html/mahara.git/htdocs/lib/errors.php:109, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * log_warn("get_record_sql found more than one row. If you mea...") at /var/www/html/
mahara.git/htdocs/lib/errors.php:749, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * SQLException->__construct("get_record_sql found more than one row. If you mea...")
at /var/www/html/mahara.git/htdocs/lib/dml.php:339, referer: http:///mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * get_record_sql("SELECT * FROM "usr" WHERE "email" = ? ", array(size 1)) at /var/www/html/mahara.git/htdocs/lib/dml.php:302, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * get_record("usr", "email", "pp@patrickpollet.net") at /var/www/html/mahara.git/htdo
cs/local/insa/remote_avatar.php:17, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * local_remote_avatar("pp@patrickpollet.net", array(size 2), "http://xxxxxxxxxxxx/mahara/theme/raw/stat...") at /var/www/html/mahara.git/htdocs/lib/user.php:2246, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * remote_avatar("pp@patrickpollet.net", array(size 2), "http://xxxxxxxxxxxx/
mahara/theme/raw/stat...") at /var/www/html/mahara.git/htdocs/lib/user.php:2227, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * profile_icon_url(object(stdClass), 40, 40) at /var/www/html/mahara.git/htdocs/lib/d
woo/mahara/plugins/function.profile_icon_url.php:13, referer: http://xxxxxxxxxxxx/mahara/
[Thu Jan 26 10:22:19 2012] [error] [client 134.214.152.108] * Dwoo_Plugin_profile_icon_url(object(Dwoo_Mahara), object(stdClass), 40, 40) at /wor
k/maharadata/dwoo/compile/insalyon/var/www/html/mahara.git/htdocs/theme/raw/templates/user/user.tpl.d17.php:92, referer: http://xxxxxxxxxxxx/mahara/
It is also impossible to delete that user under site administration since getting that user data fails with the above error...
To return site to 'normal operation' one has to go to table usr and manually edit the new user email to an unique value
Cheers.
Edit : I did not tested it yet, but I do hope that this behaviour does not occur also in importing users from a CSV file ;-) |
|
2012-01-27 03:52:50 |
François Marier |
tags |
email import leap2 unicity |
email import leap2a |
|
2012-01-27 03:53:00 |
François Marier |
mahara: status |
New |
Triaged |
|
2012-01-27 03:53:04 |
François Marier |
mahara: importance |
Undecided |
Medium |
|
2012-01-27 03:53:06 |
François Marier |
mahara: milestone |
|
1.5.0 |
|
2012-02-17 01:04:23 |
Richard Mansfield |
mahara: milestone |
1.5.0 |
|
|
2012-02-17 01:04:28 |
Richard Mansfield |
mahara: status |
Triaged |
Confirmed |
|
2012-08-13 01:37:16 |
Hugh Davenport |
mahara: milestone |
|
1.6.0 |
|
2012-09-07 03:13:25 |
Son Nguyen |
mahara: assignee |
|
Son Nguyen (ngson2000) |
|
2012-09-07 03:46:27 |
Kristina Hoeppner |
mahara: milestone |
1.6.0 |
|
|
2013-01-18 00:24:19 |
Son Nguyen |
mahara: assignee |
Son Nguyen (ngson2000) |
|
|