From 1.3-beta
To 1.3.2
DB Postgres 7.4.2
OS Debian (Sarge - testing)
The upgrade covered 3 installs running off the same directory, with different configs/databases. The databases are barely used, as these are test instances.
One of the databases, possibly the most active, failed on some SELECTs related to the Quiz module. See:
(postgres7): SELECT cm.instance, cm.visible FROM op_course_modules cm, op_modules m WHERE cm.course = '' AND cm.module = m.id AND m.name = 'quiz' AND cm.instance = '' ERROR: invalid input syntax for integer: "" : ERROR: invalid input syntax for integer: ""
adodb_postgres7._execute(SELECT cm.instance, cm.visible
..., false) % line 781, file: adodb.inc.php
adodb_postgres7.execute(SELECT cm.instance, cm.visible
...) % line 568, file: datalib.php
get_records_sql(SELECT cm.instance, cm.visible
...) % line 2083, file: datalib.php
instance_is_visible(quiz, 2) % line 377, file: lib.php
quiz_refresh_events() % line 150, file: postgres7.php
and later ...
(postgres7): SELECT cm.instance, cm.visible FROM op_course_modules cm, op_modules m WHERE cm.course = '' AND cm.module = m.id AND m.name = 'quiz' AND cm.instance = '' ERROR: invalid input syntax for integer: "" : ERROR: invalid input syntax for integer: ""
adodb_postgres7._execute(SELECT cm.instance, cm.visible
..., false) % line 781, file: adodb.inc.php
adodb_postgres7.execute(SELECT cm.instance, cm.visible
...) % line 568, file: datalib.php
get_records_sql(SELECT cm.instance, cm.visible
...) % line 2083, file: datalib.php
instance_is_visible(quiz, 1) % line 377, file: lib.php
quiz_refresh_events() % line 150, file: postgres7.php
is this something to worry about? The SELECT statements seem to be comparing an integer with an empty string (!?).
regards,
martin
In reply to Martín Langhoff
Re: Upgrade 1.3-beta -> 1.3.2: Quiz Errors with Postgres
by Martín Langhoff -