Moodle
  1. Moodle
  2. MDL-3502

PostgreSQL: quiz_rqp_type need rename to quiz_rqp_types

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 1.5
    • Fix Version/s: None
    • Component/s: Quiz
    • Labels:
      None
    • Environment:
      FreeBSD
    • Rank:
      10884

      Description

      On fresh install 1.5+ on PostgreSQL 7.3 (FreeBSD 4.10, Apache 1.3 and PHP 4.3) i always get message

      'Failed to set sumgrades'

      if i can set up new quiz... In debug mode i get error:

      ERROR: relation mdl_quiz_rqp_types does not exist

      SELECT * FROM mdl_quiz_rqp_types

      I have tried rename table but message 'Failed to set sumgrades' is still here...

        Activity

        Hide
        Martin Dougiamas added a comment -

        From Juraj Chlebec (havran at mailbox.sk) Tuesday, 14 June 2005, 02:39 PM:

        On PostgreSQL 7.4.1, sorry...

        From Gustav Delius (gwd2 at york.ac.uk) Thursday, 16 June 2005, 05:36 AM:

        Penny, could you help us by fixing this problem in case it still exists? Thanks.

        From (penny at catalyst.net.nz) Thursday, 16 June 2005, 05:38 AM:

        sure I'll look into it.

        From (penny at catalyst.net.nz) Thursday, 16 June 2005, 06:29 AM:

        update – have reproduced problem – the table was getting created as type rather than types so I've fixed that (will commit shortly) – just renaming the table isn't enough as you need to also rename the indexes and sequences and then change the default value for the pk to get the value off the new sequence.

        Still getting the error trying to create a quiz though. Possibly some non-postgres friendly sql in the quiz module, working on it

        From (penny at catalyst.net.nz) Thursday, 16 June 2005, 06:50 AM:

        fixed in head & 1.5 stable.

        updating to latest 1.5 cvs version will fix the problem.

        Show
        Martin Dougiamas added a comment - From Juraj Chlebec (havran at mailbox.sk) Tuesday, 14 June 2005, 02:39 PM: On PostgreSQL 7.4.1, sorry... From Gustav Delius (gwd2 at york.ac.uk) Thursday, 16 June 2005, 05:36 AM: Penny, could you help us by fixing this problem in case it still exists? Thanks. From (penny at catalyst.net.nz) Thursday, 16 June 2005, 05:38 AM: sure I'll look into it. From (penny at catalyst.net.nz) Thursday, 16 June 2005, 06:29 AM: update – have reproduced problem – the table was getting created as type rather than types so I've fixed that (will commit shortly) – just renaming the table isn't enough as you need to also rename the indexes and sequences and then change the default value for the pk to get the value off the new sequence. Still getting the error trying to create a quiz though. Possibly some non-postgres friendly sql in the quiz module, working on it From (penny at catalyst.net.nz) Thursday, 16 June 2005, 06:50 AM: fixed in head & 1.5 stable. updating to latest 1.5 cvs version will fix the problem.

          People

          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: