SQL problems with long usernames
"Vincent Weiss" <[email protected]> Thu, 29 Jan 2009 02:55:33 -0600
| Newsgroups | gmane.comp.cms.jahia.devel |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --===============0090029132== Content-class: urn:content-classes:message Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C981EE.D09D191A" This is a multi-part message in MIME format. ------_=_NextPart_001_01C981EE.D09D191A Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Goodmorning, =20 As we are using e- field in the table Jahia_locks_non_excl turned out to be too small. We fixed that problem, but amailadresses as usernames, we ran into a problem, that not all fields are prepared for such long usernames.=20 For example the owner_locksre there any other fields that might become too small, for such long usernames?=20 =20 So we can patch the database, before more problems arise. =20 Thanks in advance, =20 Vincent Weiss TopForce, The Netherlands =20 =20 ------_=_NextPart_001_01C981EE.D09D191A Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> <META content=3D"MSHTML 6.00.6000.20973" name=3DGENERATOR></HEAD> <BODY> <DIV><FONT face=3DVerdana size=3D2><SPAN=20 class=3D843514808-29012009>Goodmorning,</SPAN></FONT></DIV> <DIV><FONT face=3DVerdana size=3D2><SPAN=20 class=3D843514808-29012009></SPAN></FONT> </DIV> <DIV><FONT face=3DVerdana><FONT size=3D2><SPAN = class=3D843514808-29012009>As we are=20 using e-</SPAN></FONT><FONT size=3D2><SPAN class=3D843514808-29012009> = field in the=20 table Jahia_locks_non_excl turned out to be too=20 small.</SPAN></FONT></FONT></DIV> <DIV><FONT size=3D2><SPAN class=3D843514808-29012009><FONT = face=3DVerdana>We fixed=20 that problem, but amailadresses as usernames, we ran into a = problem, that=20 not all fields are prepared for such long usernames. </FONT> <DIV><FONT face=3DVerdana><FONT size=3D2><SPAN = class=3D843514808-29012009>For example=20 the owner_locks</SPAN></FONT>re there any other fields that might become = too=20 small, for such long usernames? </FONT></SPAN></FONT></DIV></DIV> <DIV><FONT face=3DVerdana size=3D2><SPAN=20 class=3D843514808-29012009></SPAN></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2><SPAN class=3D843514808-29012009>So = we=20 can patch the database, before more problems = arise.</SPAN></FONT></DIV> <DIV><FONT face=3DVerdana><SPAN class=3D843514808-29012009><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: = Arial"></SPAN></SPAN></FONT> </DIV> <DIV><FONT face=3DVerdana><SPAN class=3D843514808-29012009><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks in=20 advance,</SPAN></SPAN></FONT></DIV> <DIV><FONT face=3DVerdana><SPAN class=3D843514808-29012009><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: = Arial"></SPAN></SPAN></FONT> </DIV> <DIV><FONT><SPAN class=3D843514808-29012009><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></SPAN></FONT><FONT = face=3DVerdana><SPAN class=3D843514808-29012009><?xml:namespace prefix = =3D st1 ns =3D=20 "urn:schemas-microsoft-com:office:smarttags" /><st1:PersonName=20 ProductID=3D"Peter Mayringer" w:st=3D"on"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial"><SPAN=20 class=3D843514808-29012009>Vincent=20 Weiss</SPAN></SPAN></st1:PersonName></SPAN></FONT></DIV> <DIV><FONT><SPAN class=3D843514808-29012009><st1:PersonName=20 ProductID=3D"Peter Mayringer" w:st=3D"on"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial"><SPAN=20 class=3D843514808-29012009></SPAN></SPAN></st1:PersonName><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial"><FONT = face=3DVerdana>TopForce, The=20 Netherlands<?xml:namespace prefix =3D o ns =3D=20 "urn:schemas-microsoft-com:office:office"=20 /><o:p></o:p></FONT></SPAN></DIV></SPAN></FONT> <DIV><FONT face=3DVerdana size=3D2><SPAN=20 class=3D843514808-29012009></SPAN></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2><SPAN=20 class=3D843514808-29012009></SPAN></FONT> </DIV></BODY></HTML> ------_=_NextPart_001_01C981EE.D09D191A-- --===============0090029132== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ dev_list mailing list [email protected] http://lists.jahia.org/cgi-bin/mailman/listinfo/dev_list --===============0090029132==--