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