Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-29491

Unable to create local users, or edit user profile

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Not a bug
    • Icon: Minor Minor
    • None
    • 2.1.1
    • Administration
    • None
    • Ubuntu Oneiric beta, PostgreSQL 9.1, php 5.3.6
    • PostgreSQL
    • MOODLE_21_STABLE

      Fresh install of Moodle 2.1.1+ (downloaded 23.9.2011) on Ubuntu Oneiric (PHP 5.3.6, PostgreSQL 9.1).
      After installation, first and only action taken is to try to create local account.
      I am unable to update user profile page and user is not created.
      Error reported is "Error reading from the database" and debug info is:

      Debug info: ERROR: invalid input syntax for integer: ""
      SELECT * FROM mdl_files WHERE contextid = $1 AND component = $2 AND filearea = $3 AND itemid = $4 ORDER BY id DESC
      [array (
      0 => '13',
      1 => 'user',
      2 => 'draft',
      3 => '',
      )]
      Stack trace:

      • line 394 of /lib/dml/moodle_database.php: dml_read_exception thrown
      • line 232 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
      • line 678 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
      • line 1122 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
      • line 1071 of /lib/dml/moodle_database.php: call to moodle_database->get_records_select()
      • line 266 of /lib/filestorage/file_storage.php: call to moodle_database->get_records()
      • line 127 of /lib/form/filepicker.php: call to file_storage->get_area_files()
      • line 1593 of /lib/formslib.php: call to MoodleQuickForm_filepicker->exportValue()
      • line 498 of /lib/formslib.php: call to MoodleQuickForm->exportValues()
      • line 448 of /lib/formslib.php: call to moodleform->validate_defined_fields()
      • line 545 of /lib/formslib.php: call to moodleform->is_validated()
      • line 141 of /user/editadvanced.php: call to moodleform->get_data()

      I have found that the only way to create user is to upload a picture in the same step when creating user.
      If I create user using this workaround, I am later unable to edit user information. Said error appears every time I try to update user info UNLESS I upload some file as a picture in the same step.
      Attached are the files containg debug information, php settings for moodle directory and picture of error page-

        1. php_settings.txt
          0.4 kB
        2. filepickerpatch2.txt
          0.8 kB
        3. filepickerpatch.txt
          0.4 kB
        4. error.png
          error.png
          108 kB
        5. debug_info.txt
          1 kB

            rajeshtaneja Rajesh Taneja
            gpredrag Predrag Gavrilovic
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.