Moin ich habe mir aus Testzwecken heute einen Moodle Server aufgesetzt.
Nun macht die Datenbank mir allerdings Probleme bei folgendem Szenario:
Ich versuche einen Nutzer anzulegen und es kommt folgende Debugmeldung:
Debug info: Column
'mailformat' cannot be null
INSERT INTO mdl_user
(username,auth,suspended,firstname,lastname,email,maildisplay,city,country,timezone,imagealt,firstnamephonetic,lastnamephonetic,middlename,alternatename,url,icq,skype,aim,yahoo,msn,idnumber,institution,department,phone1,phone2,address,timemodified,description,descriptionformat,mnethostid,confirmed,timecreated,password,calendartype,mailformat,maildigest,autosubscribe,trackforums,lang)
VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[array (
0 => 'rwr',
1 => 'manual',
2 => '0',
3 => 'hcshjdfh',
4 => 'uzdfshdajda',
5 => 'tetres@gregor.de',
6 => '0',
7 => '',
8 => 'DE',
9 => '99',
10 => '',
11 => '',
12 => '',
13 => '',
14 => '',
15 => '',
16 => '',
17 => '',
18 => '',
19 => '',
20 => '',
21 => '',
22 => '',
23 => '',
24 => '',
25 => '',
26 => '',
27 => 1436533097,
28 => '',
29 => '1',
30 => '1',
31 => 1,
32 => 1436533097,
33 => '$2y$10$AVpIrlIRIs2XhWhSMKl3ZuRVg5e/vGrpnADpsA2TVsIVFHG8x2EWu',
34 => 'gregorian',
35 => NULL,
36 => NULL,
37 => NULL,
38 => NULL,
39 => 'de',
)]
Error code: dmlwriteexception
Stack trace:
· line 446 of /lib/dml/moodle_database.php: dml_write_exception thrown
· line 1164 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
· line 1210 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
· line 99 of /user/lib.php: call to mysqli_native_moodle_database->insert_record()
· line 193 of /user/editadvanced.php: call to user_create_user()
Output buffer: <br /> <b>Notice</b>: Undefined property: stdClass::$defaultpreference_maildisplay in <b>/var/www/html/moodle/user/editlib.php</b> on line <b>318</b><br /> <br /> <b>Notice</b>: Undefined property: stdClass::$defaultpreference_mailformat in <b>/var/www/html/moodle/user/lib.php</b> on line <b>80</b><br /> <br /> <b>Notice</b>: Undefined property: stdClass::$defaultpreference_maildigest in <b>/var/www/html/moodle/user/lib.php</b> on line <b>83</b><br /> <br /> <b>Notice</b>: Undefined property: stdClass::$defaultpreference_autosubscribe in <b>/var/www/html/moodle/user/lib.php</b> on line <b>86</b><br /> <br /> <b>Notice</b>: Undefined property: stdClass::$defaultpreference_trackforums in <b>/var/www/html/moodle/user/lib.php</b> on line <b>89</b><br />
Debug info: Column
'mailformat' cannot be null
INSERT INTO mdl_user
(username,auth,suspended,firstname,lastname,email,maildisplay,city,country,timezone,imagealt,firstnamephonetic,lastnamephonetic,middlename,alternatename,url,icq,skype,aim,yahoo,msn,idnumber,institution,department,phone1,phone2,address,timemodified,description,descriptionformat,mnethostid,confirmed,timecreated,password,calendartype,mailformat,maildigest,autosubscribe,trackforums,lang)
VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[array (
0 => 'rwr',
1 => 'manual',
2 => '0',
3 => 'hcshjdfh',
4 => 'uzdfshdajda',
5 => 'tetres@gregor.de',
6 => '0',
7 => '',
8 => 'DE',
9 => '99',
10 => '',
11 => '',
12 => '',
13 => '',
14 => '',
15 => '',
16 => '',
17 => '',
18 => '',
19 => '',
20 => '',
21 => '',
22 => '',
23 => '',
24 => '',
25 => '',
26 => '',
27 => 1436533097,
28 => '',
29 => '1',
30 => '1',
31 => 1,
32 => 1436533097,
33 => '$2y$10$AVpIrlIRIs2XhWhSMKl3ZuRVg5e/vGrpnADpsA2TVsIVFHG8x2EWu',
34 => 'gregorian',
35 => NULL,
36 => NULL,
37 => NULL,
38 => NULL,
39 => 'de',
)]
Error code: dmlwriteexception
Stack trace:
· line 446 of /lib/dml/moodle_database.php: dml_write_exception thrown
· line 1164 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
· line 1210 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
· line 99 of /user/lib.php: call to mysqli_native_moodle_database->insert_record()
· line 193 of /user/editadvanced.php: call to user_create_user()
Output buffer: <br /> <b>Notice</b>: Undefined property: stdClass::$defaultpreference_maildisplay in <b>/var/www/html/moodle/user/editlib.php</b> on line <b>318</b><br /> <br /> <b>Notice</b>: Undefined property: stdClass::$defaultpreference_mailformat in <b>/var/www/html/moodle/user/lib.php</b> on line <b>80</b><br /> <br /> <b>Notice</b>: Undefined property: stdClass::$defaultpreference_maildigest in <b>/var/www/html/moodle/user/lib.php</b> on line <b>83</b><br /> <br /> <b>Notice</b>: Undefined property: stdClass::$defaultpreference_autosubscribe in <b>/var/www/html/moodle/user/lib.php</b> on line <b>86</b><br /> <br /> <b>Notice</b>: Undefined property: stdClass::$defaultpreference_trackforums in <b>/var/www/html/moodle/user/lib.php</b> on line <b>89</b><br />
vielleicht könnt ihr mir ja helfen
Ich danke schonmal