[MKDoc-users] error adding editor

Donald Blackstock donald.blackstock@casmir.net
Thu, 14 Mar 2002 14:56:18 -0000


This is a multi-part message in MIME format.

------=_NextPart_000_0000_01C1CB68.65E1AAD0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Good afternoon

I was confused before - it is ok now - except...

I just tried to add a new editor and it gave me the following error

$VAR1 = bless( {
                 'code' => 'RUNTIME_ERROR',
                 'info' => 'DBD::mysql::db do failed: Duplicate entry
\'gracchus armisu\' for key 2 at ../lib/sql/MySQL.pm line 258.
'
               }, 'lib::Exception' );

I have enclosed the su page which created the error - hope you can see it

Is it something to do with the fact that the name is quite long and in two
parts

Donald


------=_NextPart_000_0000_01C1CB68.65E1AAD0
Content-Type: text/html;
	name="Add an Editor.htm"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename="Add an Editor.htm"

<html xmlns:v=3D"urn:schemas-microsoft-com:vml"
xmlns:o=3D"urn:schemas-microsoft-com:office:office"
xmlns:w=3D"urn:schemas-microsoft-com:office:word"
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 9">
<meta name=3DOriginator content=3D"Microsoft Word 9">
<link rel=3DFile-List href=3D"./Add%20an%20Editor_files/filelist.xml">
<link rel=3DEdit-Time-Data =
href=3D"./Add%20an%20Editor_files/editdata.mso">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>Add an Editor </title>
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Author>Donald</o:Author>
  <o:Template>Normal</o:Template>
  <o:LastAuthor>Donald</o:LastAuthor>
  <o:Revision>1</o:Revision>
  <o:TotalTime>3</o:TotalTime>
  <o:Created>2002-03-14T14:49:00Z</o:Created>
  <o:LastSaved>2002-03-14T14:52:00Z</o:LastSaved>
  <o:Pages>1</o:Pages>
  <o:Company>casmir</o:Company>
  <o:Lines>1</o:Lines>
  <o:Paragraphs>1</o:Paragraphs>
  <o:Version>9.3821</o:Version>
 </o:DocumentProperties>
</xml><![endif]-->
<style>
<!--
 /* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{mso-style-parent:"";
	margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
pre
	{margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.0pt;
	font-family:"Courier New";
	mso-fareast-font-family:"Courier New";}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;
	mso-paper-source:0;}
div.Section1
	{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1"/>
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-US style=3D'tab-interval:.5in'>

<div class=3DSection1>

<table border=3D0 cellpadding=3D0 =
style=3D'mso-cellspacing:1.5pt;mso-padding-alt:
 3.0pt 3.0pt 3.0pt 3.0pt'>
 <tr>
  <td colspan=3D2 style=3D'padding:3.0pt 3.0pt 3.0pt 3.0pt'>
  <p class=3DMsoNormal align=3Dcenter =
style=3D'text-align:center;background:#CCCCCC'><b><span
  style=3D'color:black'>Add an Editor <o:p></o:p></span></b></p>
  </td>
 </tr>
 <tr>
  <td style=3D'padding:3.0pt 3.0pt 3.0pt 3.0pt'>
  <p class=3DMsoNormal><b><span style=3D'color:black'>Username:=20
 </label>
 <o:p></o:p></span></b></p>
 </td>
 <td style=3D'padding:3.0pt 3.0pt 3.0pt 3.0pt'>
 <p class=3DMsoNormal><span style=3D'color:black'><INPUT TYPE=3D"TEXT" =
SIZE=3D"40" NAME=3D"Login" VALUE=3D"gracchus armisurplus"
 id=3DLogin><o:p></o:p></span></p>
 </td>
</tr>
<tr>
 <td style=3D'padding:3.0pt 3.0pt 3.0pt 3.0pt'>
 <p class=3DMsoNormal><b><span style=3D'color:black'>
 <label for=3DPassword>
  Password:=20
 </label>
 <o:p></o:p></span></b></p>
 </td>
 <td style=3D'padding:3.0pt 3.0pt 3.0pt 3.0pt'>
 <p class=3DMsoNormal><span style=3D'color:black'><INPUT TYPE=3D"TEXT" =
SIZE=3D"40" NAME=3D"Password" VALUE=3D"armisurplus"
 id=3DPassword><o:p></o:p></span></p>
 </td>
</tr>
<tr>
 <td style=3D'padding:3.0pt 3.0pt 3.0pt 3.0pt'>
 <p class=3DMsoNormal><b><span style=3D'color:black'>
 <label for=3DEmail>
  Email Address:=20
 </label>
 <o:p></o:p></span></b></p>
 </td>
 <td style=3D'padding:3.0pt 3.0pt 3.0pt 3.0pt'>
 <p class=3DMsoNormal><span style=3D'color:black'><INPUT TYPE=3D"TEXT" =
SIZE=3D"40" NAME=3D"Email" VALUE=3D"donald.blackstock@casmir.net"
 id=3DEmail><o:p></o:p></span></p>
 </td>
</tr>
<tr>
 <td style=3D'padding:3.0pt 3.0pt 3.0pt 3.0pt'>
 <p class=3DMsoNormal><b><span style=3D'color:black'>
 <label for=3D"First_Name">
  First Name:=20
 </label>
 <o:p></o:p></span></b></p>
 </td>
 <td style=3D'padding:3.0pt 3.0pt 3.0pt 3.0pt'>
 <p class=3DMsoNormal><span style=3D'color:black'><INPUT TYPE=3D"TEXT" =
SIZE=3D"40" NAME=3D"First_Name" VALUE=3D"gracchus "
 id=3D"First_Name"><o:p></o:p></span></p>
 </td>
</tr>
<tr>
 <td style=3D'padding:3.0pt 3.0pt 3.0pt 3.0pt'>
 <p class=3DMsoNormal><b><span style=3D'color:black'>
 <label for=3D"Family_Name">
  Family Name:=20
 </label>
 <o:p></o:p></span></b></p>
 </td>
 <td style=3D'padding:3.0pt 3.0pt 3.0pt 3.0pt'>
 <p class=3DMsoNormal><span style=3D'color:black'><INPUT TYPE=3D"TEXT" =
SIZE=3D"40" NAME=3D"Family_Name" VALUE=3D"armisurplus"
 id=3D"Family_Name"><o:p></o:p></span></p>
 </td>
</tr>
<tr>
 <td style=3D'padding:3.0pt 3.0pt 3.0pt 3.0pt'>
 <p class=3DMsoNormal><b><span style=3D'color:black'>
 <label for=3DDisabled>
  Allow login:=20
 </label>
 <o:p></o:p></span></b></p>
 </td>
 <td style=3D'padding:3.0pt 3.0pt 3.0pt 3.0pt'>
 <p class=3DMsoNormal><span style=3D'color:black'><SELECT =
NAME=3D"Disabled"
 id=3DDisabled>
<OPTION VALUE=3D"1">No
<OPTION SELECTED VALUE=3D"0">Yes
</SELECT><o:p></o:p></span></p>
 </td>
</tr>
<tr>
 <td style=3D'padding:3.0pt 3.0pt 3.0pt 3.0pt'>
 <p class=3DMsoNormal><b><span style=3D'color:black'>
 <label for=3DDocID>
  Base document(s):=20
 </label>
 <br>
 </span></b><span style=3D'font-size:10.0pt;color:black'>(Use Ctrl to =
select
 multiple base documents)</span><b><span style=3D'color:black'> =
<o:p></o:p></span></b></p>
 </td>
 <td style=3D'padding:3.0pt 3.0pt 3.0pt 3.0pt'>
 <p class=3DMsoNormal><span style=3D'color:black'><SELECT MULTIPLE =
NAME=3D"DocID" SIZE=3D"20"
 id=3DDocID>
<OPTION VALUE=3D"1">/
<OPTION VALUE=3D"19">/centre-people/
<OPTION VALUE=3D"24">/centre-people/cacofonix/
<OPTION VALUE=3D"22">/centre-people/goscinny/
<OPTION SELECTED VALUE=3D"25">/centre-people/gracchus-armisurplus/
<OPTION VALUE=3D"23">/centre-people/uderzo/
<OPTION VALUE=3D"12">/contact-details/
<OPTION VALUE=3D"20">/how-can-i-help-the-booth-centre/
<OPTION VALUE=3D"18">/overview-of-work/
<OPTION VALUE=3D"3">/overview-of-work/activities/
<OPTION VALUE=3D"7">/overview-of-work/activities/conservation-work/
<OPTION VALUE=3D"17">/overview-of-work/activities/gardening/
<OPTION VALUE=3D"9">/overview-of-work/activities/photography/
<OPTION VALUE=3D"8">/overview-of-work/activities/pottery/
<OPTION VALUE=3D"5">/overview-of-work/advice/
<OPTION VALUE=3D"6">/overview-of-work/drop-in/
<OPTION VALUE=3D"27">/overview-of-work/what-does-the-booth-centre-do/
</SELECT><o:p></o:p></span></p>
 </td>
</tr>
<tr>
 <td style=3D'padding:3.0pt 3.0pt 3.0pt 3.0pt'>
 <p class=3DMsoNormal><span style=3D'color:black'><span =
style=3D'display:none;
 mso-hide:all'><INPUT TYPE=3D"hidden" NAME=3D"action" =
VALUE=3D"add_editor"></span><o:p></o:p></span></p>
 </td>
 <td style=3D'padding:3.0pt 3.0pt 3.0pt 3.0pt'>
 <p class=3DMsoNormal><span style=3D'color:black'><INPUT TYPE=3D"submit" =
ACTION=3D"http://su.boothcentre.org.uk" VALUE=3D"Create Editor" =
METHOD=3D"post"><o:p></o:p></span></p>
 </td>
</tr>
</table>

<pre><![if !supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></pre>

<p class=3DMsoNormal><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></p>

</div>

</body>

</html>

------=_NextPart_000_0000_01C1CB68.65E1AAD0--