Upgrade 1.3-beta -> 1.3.2: Quiz Errors with Postgres

Upgrade 1.3-beta -> 1.3.2: Quiz Errors with Postgres

by Martín Langhoff -
Number of replies: 1
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

Average of ratings: -