Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Duplicate
-
2.9.2
-
None
-
None
-
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
- duplicates
-
MDL-52260 Error editing profile when a profile field is locked
-
- Closed
-