New question #120559 on Mahara:
https://answers.launchpad.net/mahara/+question/120559
The cron job has been running properly. But all of the sudden it stopped
working. The related message in the error_log under logs of the Apache server
is as follows:
--------------------------------------------------------
[Tue Aug 10 08:10:01 2010] [error] [client 156.62.52.126] [DBG] da
(lib/cron.php:70) ---------- cron running Tue, 10 Aug 2010 08:10:01 +1200
----------
[Tue Aug 10 08:10:01 2010] [error] [client 156.62.52.126] [DBG] da
(lib/cron.php:149) Running core cron begin_autimport
[Tue Aug 10 08:10:01 2010] [error] [client 156.62.52.126] [INF] da
(local/lib.php:194) Line 1 of the file specifies the e-mail address
"anne.g...@aut.ac.nz" that is already taken by another user
[Tue Aug 10 08:10:01 2010] [error] [client 156.62.52.126] [INF] da
(local/lib.php:194) Line 7 of the file specifies the e-mail address
"andrew.with...@aut.ac.nz" that is already taken by another user
[Tue Aug 10 08:10:02 2010] [error] [client 156.62.52.126] [INF] da
(local/lib.php:194) Line 27 of the file specifies the e-mail address
"peter.macla...@aut.ac.nz" that is already taken by another user
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] [WAR] da
(lib/errors.php:738) Failed to get a recordset: postgres7 error: [-1: ERROR:
invalid input syntax for integer: ""] in adodb_throw(SELECT * FROM
"usr_institution" WHERE usr = ? AND LOWER(institution) = ? LIMIT 1, Array)
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] [WAR] da
(lib/errors.php:738) Command was: SELECT * FROM "usr_institution" WHERE usr = ?
AND LOWER(institution) = ? and values was (,aut)
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] Call stack (most
recent first):
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] *
log_message("Failed to get a recordset: postgres7 error: [-1: E...", 8, true,
true) at /usr/local/apache22/htdocs/mahara/lib/errors.php:111
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] * log_warn("Failed
to get a recordset: postgres7 error: [-1: E...") at
/usr/local/apache22/htdocs/mahara/lib/errors.php:738
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] *
SQLException->__construct("Failed to get a recordset: postgres7 error: [-1:
E...") at /usr/local/apache22/htdocs/mahara/lib/dml.php:467
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] *
get_recordset_sql("SELECT * FROM "usr_institution" WHERE usr = ? AND ...",
array(size 2), 0, 1) at /usr/local/apache22/htdocs/mahara/lib/dml.php:211
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] *
record_exists_sql("SELECT * FROM "usr_institution" WHERE usr = ? AND ...",
array(size 2)) at /usr/local/apache22/htdocs/mahara/lib/dml.php:197
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] *
record_exists_select("usr_institution", "usr = ? AND LOWER(institution) = ?",
array(size 2)) at /usr/local/apache22/htdocs/mahara/local/lib.php:180
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] *
import_users(array(size 11), object(CsvFile), "aut", "3", "aut2009") at
/usr/local/apache22/htdocs/mahara/local/lib.php:98
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] * begin_autimport()
at /usr/local/apache22/htdocs/mahara/lib/cron.php:152
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126]
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] [WAR] da
(lib/dml.php:467) Failed to get a recordset: postgres7 error: [-1: ERROR:
invalid input syntax for integer: ""] in adodb_throw(SELECT * FROM
"usr_institution" WHERE usr = ? AND LOWER(institution) = ? LIMIT 1, Array)
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] [WAR] da
(lib/dml.php:467) Command was: SELECT * FROM "usr_institution" WHERE usr = ?
AND LOWER(institution) = ? and values was (,aut)
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] Call stack (most
recent first):
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] *
get_recordset_sql("SELECT * FROM "usr_institution" WHERE usr = ? AND ...",
array(size 2), 0, 1) at /usr/local/apache22/htdocs/mahara/lib/dml.php:211
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] *
record_exists_sql("SELECT * FROM "usr_institution" WHERE usr = ? AND ...",
array(size 2)) at /usr/local/apache22/htdocs/mahara/lib/dml.php:197
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] *
record_exists_select("usr_institution", "usr = ? AND LOWER(institution) = ?",
array(size 2)) at /usr/local/apache22/htdocs/mahara/local/lib.php:180
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] *
import_users(array(size 11), object(CsvFile), "aut", "3", "aut2009") at
/usr/local/apache22/htdocs/mahara/local/lib.php:98
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126] * begin_autimport()
at /usr/local/apache22/htdocs/mahara/lib/cron.php:152
[Tue Aug 10 08:10:04 2010] [error] [client 156.62.52.126]
[Tue Aug 10 08:11:01 2010] [error] [client 156.62.52.126] [DBG] 4a
(lib/cron.php:70) ---------- cron running Tue, 10 Aug 2010 08:11:01 +1200
----------
[Tue Aug 10 08:11:01 2010] [error] [client 156.62.52.126] [DBG] 4a
(lib/cron.php:149) Running core cron begin_autimport
[Tue Aug 10 08:11:01 2010] [error] [client 156.62.52.126] [INF] 4a
(local/lib.php:194) Line 1 of the file specifies the e-mail address
"anne.g...@aut.ac.nz" that is already taken by another user
[Tue Aug 10 08:11:01 2010] [error] [client 156.62.52.126] [INF] 4a
(local/lib.php:194) Line 7 of the file specifies the e-mail address
"andrew.with...@aut.ac.nz" that is already taken by another user
[Tue Aug 10 08:11:01 2010] [error] [client 156.62.52.126] [INF] 4a
(local/lib.php:194) Line 27 of the file specifies the e-mail address
"peter.macla...@aut.ac.nz" that is already taken by another user
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] [WAR] 4a
(lib/errors.php:738) Failed to get a recordset: postgres7 error: [-1: ERROR:
invalid input syntax for integer: ""] in adodb_throw(SELECT * FROM
"usr_institution" WHERE usr = ? AND LOWER(institution) = ? LIMIT 1, Array)
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] [WAR] 4a
(lib/errors.php:738) Command was: SELECT * FROM "usr_institution" WHERE usr = ?
AND LOWER(institution) = ? and values was (,aut)
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] Call stack (most
recent first):
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] *
log_message("Failed to get a recordset: postgres7 error: [-1: E...", 8, true,
true) at /usr/local/apache22/htdocs/mahara/lib/errors.php:111
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] * log_warn("Failed
to get a recordset: postgres7 error: [-1: E...") at
/usr/local/apache22/htdocs/mahara/lib/errors.php:738
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] *
SQLException->__construct("Failed to get a recordset: postgres7 error: [-1:
E...") at /usr/local/apache22/htdocs/mahara/lib/dml.php:467
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] *
get_recordset_sql("SELECT * FROM "usr_institution" WHERE usr = ? AND ...",
array(size 2), 0, 1) at /usr/local/apache22/htdocs/mahara/lib/dml.php:211
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] *
record_exists_sql("SELECT * FROM "usr_institution" WHERE usr = ? AND ...",
array(size 2)) at /usr/local/apache22/htdocs/mahara/lib/dml.php:197
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] *
record_exists_select("usr_institution", "usr = ? AND LOWER(institution) = ?",
array(size 2)) at /usr/local/apache22/htdocs/mahara/local/lib.php:180
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] *
import_users(array(size 11), object(CsvFile), "aut", "3", "aut2009") at
/usr/local/apache22/htdocs/mahara/local/lib.php:98
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] * begin_autimport()
at /usr/local/apache22/htdocs/mahara/lib/cron.php:152
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126]
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] [WAR] 4a
(lib/dml.php:467) Failed to get a recordset: postgres7 error: [-1: ERROR:
invalid input syntax for integer: ""] in adodb_throw(SELECT * FROM
"usr_institution" WHERE usr = ? AND LOWER(institution) = ? LIMIT 1, Array)
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] [WAR] 4a
(lib/dml.php:467) Command was: SELECT * FROM "usr_institution" WHERE usr = ?
AND LOWER(institution) = ? and values was (,aut)
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] Call stack (most
recent first):
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] *
get_recordset_sql("SELECT * FROM "usr_institution" WHERE usr = ? AND ...",
array(size 2), 0, 1) at /usr/local/apache22/htdocs/mahara/lib/dml.php:211
[Tue Aug 10 08:11:04 2010] [error] [client 156.62.52.126] *
record_exists_sql("SELECT * FROM "usr_institution" WHERE usr = ? AND ...",
array(size 2)) at /usr/local/apache22/htdocs/mahara/lib/dml.php:197
--------------------------------------------------------
The server settings are as follows:
OS: Red Hat Linux Server 5 32bit OS
PostgresPlus 8.4.1-2
Apache 2.2.14
PHP 5.2.9
Mahara 1.2.4
Any idea what is happening?
You received this question notification because you are a member of
Mahara Contributors, which is an answer contact for Mahara.
_______________________________________________
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
