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

users unable to edit personal profile

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 2.9.2
    • Fix Version/s: None
    • Component/s: User management
    • Labels:
      None
    • Affected Branches:
      MOODLE_29_STABLE

      Description

      Our setup- Windows 2008R2 Standard, IIS, php5.4, MSSQL 2008r2.

      one change- php.ini upload_tmp_directory as well as session.save_path changed. IUSR and IIS_IUSRS has full access to new temp directory.

      ever since, users are unable to make changes to their profile (upload photo, add info, remove info), Error Writing to Database. However, moodle admins are still able to make changes. Tried resetting iis, tried rebooting the server, no effect. any ideas?

      php error when full debugging is on:
      [23-Nov-2015 14:13:39 America/Chicago] PHP Notice: Array to string conversion in C:\inetpub\wwwroot\Moodle\moodle\lib\dml\sqlsrv_native_moodle_database.php on line 778
      [23-Nov-2015 14:13:39 America/Chicago] Default exception handler: Error writing to database Debug: SQLState: 22001<br>
      Error Code: 8152<br>
      Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated.<br>
      SQLState: 01000<br>
      Error Code: 3621<br>
      Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated.<br>

      UPDATE mdl_user SET firstname = N'moodle',lastname = N'test1',email = N'moodle.test1notreally@trnty.edu',maildisplay = '2',city = N'Here',country = N'Array',timezone = '99',imagealt = N'',firstnamephonetic = N'JOe',lastnamephonetic = N'',middlename = N'',alternatename = N'',url = N'',icq = N'',skype = N'',aim = N'',yahoo = N'',msn = N'',idnumber = N'moodletest1',institution = N'',department = N'',phone1 = N'',phone2 = N'',address = N'',timemodified = '1448309619',description = N'',descriptionformat = '1' WHERE id = '6203'
      [array (
      0 => 'moodle',
      1 => 'test1',
      2 => 'moodle.test1notreally@trnty.edu',
      3 => '2',
      4 => 'Here',
      5 =>
      array (
      0 => 'US',
      ),
      6 => '99',
      7 => '',
      8 => 'JOe',
      9 => '',
      10 => '',
      11 => '',
      12 => '',
      13 => '',
      14 => '',
      15 => '',
      16 => '',
      17 => '',
      18 => 'moodletest1',
      19 => '',
      20 => '',
      21 => '',
      22 => '',
      23 => '',
      24 => 1448309619,
      25 => '',
      26 => '1',
      27 => 6203,
      )]
      Error code: dmlwriteexception

      • line 446 of \lib\dml\moodle_database.php: dml_write_exception thrown
      • line 291 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()
      • line 398 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
      • line 1134 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
      • line 1166 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->update_record_raw()
      • line 173 of \user\lib.php: call to sqlsrv_native_moodle_database->update_record()
      • line 230 of \user\edit.php: call to user_update_user()

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              manema4 Matt Anema
              Participants:
              Component watchers:
              Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Sara Arjona (@sarjona)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: