Moodle

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.8.4
• Fix Version/s: None
• Component/s: Backup
• Labels:

  None
• Environment:

  Solaris + Oracle

When we restore a course we get some errors during the user creation:

ORA-12899: value too large for column "USU1"."MLUSER"."CITY" (actual: 21, maximum: 20)
INSERT INTO mluser ( ID, AUTH, CONFIRMED, POLICYAGREED, DELETED, MNETHOSTID, USERNAME, PASSWORD, IDNUMBER, FIRSTNAME, LASTNAME, EMAIL, EMAILSTOP, ICQ, SKYPE, YAHOO, AIM, MSN, PHONE1, PHONE2, INSTITUTION, DEPARTMENT, ADDRESS, CITY, COUNTRY, LANG, THEME, TIMEZONE, FIRSTACCESS, LASTACCESS, LASTLOGIN, CURRENTLOGIN, LASTIP, SECRET, PICTURE, URL, DESCRIPTION, MAILFORMAT, MAILDIGEST, MAILDISPLAY, HTMLEDITOR, AJAX, AUTOSUBSCRIBE, TRACKFORUMS, TIMEMODIFIED ) VALUES ( 781, 'ldap', 1, 0, 0, 1, 'agarc347', 'dasdfasdfsdfdsfddddc7cb29fc8', ' ', 'Toni', 'Garcia', 'agarc347@xtec.cat', 0, ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', 'L''''Hospitalet de Llob', 'ES', 'ca_utf8', ' ', '99', 0, 1201888301, 1201541064, 1201884880, '87.219.57.73', ' ', 1, ' ', 'Professor Cicles Formatius', 1, 0, 2, 1, 1, 1, 0, 1192727249 )

• line 1425 of lib/dmllib.php: call to debugging()
• line 1636 of backup/restorelib.php: call to insert_record()
• line 5948 of backup/restorelib.php: call to restore_create_users()
• line 47 of backup/restore_execute.html: call to restore_execute()
• line 162 of backup/restore.php: call to include_once()

We also send you the content of the CITY element in moodle.xml backup file:

<CITY>L'Hospitalet de Llob</CITY>

If you need more information to solve this problem we'll be pleased to help yourselves.

• Assignee:

  moodle.com

  Reporter:

  Sara Arjona

  Participants:

  moodle.com, Sara Arjona

• Created:

  05/Feb/08 9:09 PM

  Updated:

  08/Nov/11 1:18 PM