[Obm] bug updating contacts
Yann Bruneau
ybruneau@igtech.fr
Mon, 22 Mar 2004 12:09:03 +0100
This is a multi-part message in MIME format.
------=_NextPart_000_001F_01C41006.77E12AF0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
=20
First of all, I want to tell you that you did a great job with OBM!
It seems that there is a bug in the new 8.0 version. When I try to
validate a modification on a contact entry a SQL error appears :
=20
Database error: Invalid SQL: update Contact set
contact_timeupdate=3D'2004-03-22 11:39:26', contact_userupdate=3D'1',
contact_datasource_id=3D'0', contact_company_id=3D'38', =
contact_kind_id=3D'1',
contact_marketingmanager_id=3D'0', contact_lastname=3D'coollast',
contact_firstname=3D'coolfirst', contact_address1=3D'', =
contact_address2=3D'',
contact_address3=3D'', contact_zipcode=3D'', contact_town=3D'',
contact_expresspostal=3D'', contact_country_id=3D'0',
contact_function_id=3D'2', contact_title=3D'', contact_phone=3D'09 8987
67656', contact_homephone=3D'', contact_mobilephone=3D'', =
contact_fax=3D'',
contact_email=3D'', contact_mailing_ok=3D'', contact_archive=3D'0',
contact_visibility=3D'0', contact_comment=3D'Here is a comment' where
contact_id=3D'24'
MySQL Error: 1054 (Unknown column 'contact_address3' in 'field list')
Session halted.
=20
It seems that the table Contact need another column =
(contact_address3)=85
I would like to quickly use OBM in our company, do you think it=92s
possible to correct this bug ??
=20
Many thanks,
=20
Regards,
=20
Yann Bruneau
________________________________________________________________________
__
Yann Bruneau
Ing=E9nieur s=E9curit=E9 http://www.igtech.fr <http://www.igtech.fr/> =20
E-mail: <mailto:ybruneau@igtech.fr> ybruneau@igtech.fr=20
iGtech
153, avenue Jean Lolive
93500 Pantin=20
T=E9l: 33 (0) 1 56 96 01 23
Fax: 33 (0) 1 56 96 01 33
=20
------=_NextPart_000_001F_01C41006.77E12AF0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html 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=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 10">
<meta name=3DOriginator content=3D"Microsoft Word 10">
<link rel=3DFile-List href=3D"cid:filelist.xml@01C41006.771B42E0">
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:HyphenationZone>21</w:HyphenationZone>
<w:EnvelopeVis/>
<w:DrawingGridHorizontalSpacing>6 pt</w:DrawingGridHorizontalSpacing>
<w:DrawingGridVerticalSpacing>8,15 pt</w:DrawingGridVerticalSpacing>
=
<w:DisplayHorizontalDrawingGridEvery>2</w:DisplayHorizontalDrawingGridEve=
ry>
=
<w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;
text-underline:single;}
em
{font-family:"Times New Roman";
mso-bidi-font-family:"Times New Roman";}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.StyleCourrierlectronique17
{mso-style-type:personal-compose;
mso-style-noshow:yes;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Arial;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:windowtext;}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes;}
span.GramE
{mso-style-name:"";
mso-gram-e:yes;}
@page Section1
{size:21.0cm 842.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */=20
table.MsoNormalTable
{mso-style-name:"Tableau Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";}
</style>
<![endif]-->
</head>
<body lang=3DFR link=3Dblue vlink=3Dpurple =
style=3D'tab-interval:35.4pt'>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Hi,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial;mso-ansi-language:EN-GB'>First of all, I want =
to tell you
that you did a great job with OBM!<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial;mso-ansi-language:EN-GB'>It seems that there is =
a bug
in the new 8.0 version. When I try to validate a modification on a =
contact
entry a SQL error <span class=3DGramE>appears =
:</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial;mso-ansi-language:EN-GB'><o:p> </o:p></span=
></font></p>
<p class=3DMsoNormal><b><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt;mso-ansi-language:EN-GB;font-weight:bold'>Datab=
ase
error:</span></font></b><span lang=3DEN-GB =
style=3D'mso-ansi-language:EN-GB'>
Invalid SQL: update Contact set <span =
class=3DSpellE>contact_timeupdate</span>=3D'2004-03-22
11:39:26', <span class=3DSpellE>contact_userupdate</span>=3D'1', <span
class=3DSpellE>contact_datasource_id</span>=3D'0', <span =
class=3DSpellE>contact_company_id</span>=3D'38',
<span class=3DSpellE>contact_kind_id</span>=3D'1', <span =
class=3DSpellE>contact_marketingmanager_id</span>=3D'0',
<span class=3DSpellE>contact_lastname</span>=3D'<span =
class=3DSpellE>coollast</span>',
<span class=3DSpellE>contact_firstname</span>=3D'<span =
class=3DSpellE>coolfirst</span>',
contact_address1=3D'', contact_address2=3D'', contact_address3=3D'', =
<span
class=3DSpellE>contact_zipcode</span>=3D'', <span =
class=3DSpellE>contact_town</span>=3D'',
<span class=3DSpellE>contact_expresspostal</span>=3D'', <span =
class=3DSpellE>contact_country_id</span>=3D'0',
<span class=3DSpellE>contact_function_id</span>=3D'2', <span =
class=3DSpellE>contact_title</span>=3D'',
<span class=3DSpellE>contact_phone</span>=3D'09 8987 67656', <span =
class=3DSpellE>contact_homephone</span>=3D'',
<span class=3DSpellE>contact_mobilephone</span>=3D'', <span =
class=3DSpellE>contact_fax</span>=3D'',
<span class=3DSpellE>contact_email</span>=3D'', <span =
class=3DSpellE>contact_mailing_ok</span>=3D'',
<span class=3DSpellE>contact_archive</span>=3D'0', <span =
class=3DSpellE>contact_visibility</span>=3D'0',
<span class=3DSpellE>contact_comment</span>=3D'Here is a comment' where =
<span
class=3DSpellE>contact_id</span>=3D'24'<br>
<span class=3DSpellE><b><span =
style=3D'font-weight:bold'>MySQL</span></b></span><b><span
style=3D'font-weight:bold'> Error</span></b>: 1054 (Unknown column
'contact_address3' in 'field list')<br>
Session halted.<o:p></o:p></span></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt;mso-ansi-language:EN-GB'><o:p> </o:p></spa=
n></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt;mso-ansi-language:EN-GB'>It seems that the =
table
Contact need another column =
(contact_address3)…<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt;mso-ansi-language:EN-GB'>I would like to =
quickly use
OBM in our company, do you think it’s possible to correct this =
<span
class=3DGramE>bug ??</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt;mso-ansi-language:EN-GB'><o:p> </o:p></spa=
n></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt;mso-ansi-language:EN-GB'>Many =
thanks,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt;mso-ansi-language:EN-GB'><o:p> </o:p></spa=
n></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt;mso-ansi-language:EN-GB'>Regards,<o:p></o:p></s=
pan></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt;mso-ansi-language:EN-GB'><o:p> </o:p></spa=
n></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt;mso-ansi-language:EN-GB'>Yann =
Bruneau<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt;mso-no-proof:yes'>________________________________________________=
__________________________</span></font><font
size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:10.0pt;font-family:Arial;
mso-ansi-language:EN-GB'><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:navy;mso-no-proof:yes'> Yann =
Bruneau<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:navy;mso-no-proof:yes'> Ing=E9nieur
s=E9curit=E9 </span></font><span style=3D'mso-no-proof:yes'><a
href=3D"http://www.igtech.fr/">http://www.igtech.fr</a><font =
color=3Dnavy><span
style=3D'color:navy'> <o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:navy;mso-no-proof:yes'> </span></fon=
t><font
color=3Dnavy><span lang=3DDE =
style=3D'color:navy;mso-ansi-language:DE;mso-no-proof:
yes'>E-mail: </span></font><span style=3D'mso-no-proof:yes'><a
href=3D"mailto:ybruneau@igtech.fr"><span lang=3DDE =
style=3D'mso-ansi-language:DE'>ybruneau@igtech.fr</span></a></span><font
color=3Dnavy><span =
style=3D'color:navy;mso-ansi-language:DE;mso-no-proof:yes'> <span
lang=3DDE><o:p></o:p></span></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New =
Roman"><span
lang=3DDE =
style=3D'font-size:12.0pt;color:navy;mso-ansi-language:DE;mso-no-proof:
yes'> </span></font><em><i><font size=3D2 color=3Dnavy =
face=3D"Times New Roman"><span
lang=3DDE =
style=3D'font-size:10.0pt;color:navy;mso-ansi-language:DE;mso-no-proof:
yes'>iGtech</span></font></i></em><font color=3Dnavy><span lang=3DDE
style=3D'color:navy;mso-ansi-language:DE;mso-no-proof:yes'><o:p></o:p></s=
pan></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DDE
style=3D'font-size:12.0pt;mso-ansi-language:DE;mso-no-proof:yes'> </=
span><font
color=3Dnavy><span style=3D'color:navy;mso-no-proof:yes'>153, avenue =
Jean Lolive<o:p></o:p></span></font></font></p>
<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:navy;mso-no-proof:yes'> 93500 =
Pantin <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:navy;mso-no-proof:yes'> T=E9l: 33 =
(0) 1 56 96
01 23<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:navy;mso-no-proof:yes'> Fax: 33 (0) =
1 56 96
01 33</span></font><span =
style=3D'mso-no-proof:yes'><o:p></o:p></span></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
------=_NextPart_000_001F_01C41006.77E12AF0--