Mahara

Cron job stopped working

Asked by Shen

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 "<email address hidden>" 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 "<email address hidden>" 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 "<email address hidden>" 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 "<email address hidden>" 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 "<email address hidden>" 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 "<email address hidden>" 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?

Question information

Language:
English Edit question
Status:
Answered
For:
Mahara Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:

This question was originally filed as bug #615625.

Revision history for this message
Shen (shzhang) said : 		#1

The name of the cron job is begin_autimport, which was developed for grouping purposes

Revision history for this message
Shen (shzhang) said : 		#2

Just wondering where I should go from here to get this resolved.

Revision history for this message
Richard Mansfield (richard-mansfield) said : 		#3

Hi Shen,

That was a custom script developed by Catalyst IT, so one option is to contact Catalyst directly to diagnose and fix it. You could also contact any of the partner organisations listed on the Partners page at mahara.org, or any other PHP developer.

Richard.

Can you help with this problem?

Provide an answer of your own, or ask Shen for more information if necessary.

To post a message you must log in.