[Openaaq-discuss] Unclaimed works but not Unanswered

[smirowsk (S. Mirowski) <smi...@co...>]

Our unclaimed emails send to the coordinator, but not our unanswered emails,
via the crond.  The error message we get is via root mail:

 

DBD::mysql::st execute failed: You have an error in your SQL syntax.  Check
the manual that

+corresponds to your MySQL server version for the right syntax to use near
')    and

+c.affiliation_key = a.affiliation_key' at line 1 at
/opt/IBMIHS/cgi-bin/aaq/r/send_late_notice.pl

+line 129.

DBD::mysql::st fetchrow_array failed: fetch() without execute() at

+/opt/IBMIHS/cgi-bin/aaq/r/send_late_notice.pl line 131.

DBI::db=HASH(0x8280f08)->disconnect invalidates 1 active statement handle
(either destroy

+statement handles or call finish on them before disconnecting) at

+/opt/IBMIHS/cgi-bin/aaq/login.pl line 27.

 

The error with line 27 in the login.pl file happens no matter what the
program does with the database.

 

 

Stephen