Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-2972

Can't dump settings

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.0.3
    • Fix Version/s: 2.1
    • Labels:
      None
    • Environment:
      Scientific Linux 5.6 & RHEL 5.6, arch: x64_64, php (5.3.6 backport by rpms.famillecollet.com), postgresql84 (8.4.7)
    • Database:
      PostgreSQL
    • Affected Branches:
      MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_21_STABLE

      Description

      It says there is a syntax error. It possibly be due to PostgreSQL as DBMS, since a collegue from another school has sent me their dump which was done with Moodle 2.0.2 with MySQL. We have OS with german locale settings.

      (Transcript: ERROR: Invalid Input syntax for the number "2011033003.03")
      Debug info: FEHLER: ungültige Eingabesyntax für ganze Zahl: »2011033003.03«
      INSERT INTO mdl_admin_preset (userid,name,comments,site,author,moodleversion,moodlerelease,timecreated) VALUES($1,$2,$3,$4,$5,$6,$7,$8) RETURNING id
      [array (
      'userid' => '2',
      'name' => 'myExport',
      'comments' => '<p>NoCommentsHere</p>',
      'site' => 'https://devmoodle.koeniz-lerbermatt.ch',
      'author' => 'IT Services',
      'moodleversion' => '2011033003.03',
      'moodlerelease' => '2.0.3+ (Build: 20110525)',
      'timecreated' => 1306933186,
      )]
      Stack trace:

      • line 394 of /lib/dml/moodle_database.php: dml_write_exception thrown
      • line 232 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
      • line 781 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
      • line 833 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->insert_record_raw()
      • line 73 of /blocks/admin_presets/lib/admin_presets_export.class.php: call to pgsql_native_moodle_database->insert_record()
      • line 54 of /blocks/admin_presets/index.php: call to admin_presets_export->execute()

        Attachments

          Activity

            People

            Assignee:
            dmonllao David Monllaó
            Reporter:
            matsimon Mat Simon
            Participants:
            Component watchers:
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              1/Jul/11