[mdk-re] Webmin 0.92 - Fwd: Re: Question (bug?)

[admin]

----------  Forwarded Message  ----------
Subject: Re: Question (bug?)
Date: Fri, 01 Mar 2002 11:58:57 +1100
From: Jamie Cameron <jcameron на webmin.com>
To: admin <admin на profitm.ru>


admin wrote:
> On Thursday 28 February 2002 01:49, you wrote:
> > admin wrote:
> > > Hi.
> > > i'am a user Webmin 0.92.
> > >
> > > i have any trouble in the module MySql
> > > in my Table 2 field's
> > > 1.code double(10,8) primary key
> > > 2.data varchar(10)
> > >
> > > after editing  row and pressing save
> > > i have error near ''
> > > in MYSQL log i find this record
> > > ------------
> > > update BaseCode set kod='14108.00000000', cat='test' where
> > > ------------
> > > this is all. WHERE is empty!
> > >
> > > where and how i made any changes for normal working
> >
> > Does this table have any primary keys? That's what webmin
> > uses for the where clause.
> >
> >  - Jamie
>
> -----------------
> Yes, this table have primary key
>
> > > in my Table 2 field's
> > > 1.code double(10,8) primary key
> > > 2.data varchar(10)
>
> Field one - 'code' is primary key, but her type is double and delimiter is
> '.'
> if i executing SQL Query
> ----------
> update BaseCode set kod='14108.00000000', cat='test' where
> kod='14108.00000000'
> ----------
> All ok.
> Another table editing is ok too, but primary key in another table is
> Integer may be trouble in the parsing

Would it be possible for you to send me a backup dump of this table?
I would like to replicate this problem on my system, so I can fix it up ..

 - Jamie

-------------------------------------------------------