Mailing List Archive


Back to the month index Back to the list index
Dean Karres (karres@southwind.net)
Sat, 15 Nov 1997 10:49:10 -0600 (CST) 

From: Dean Karres <karres@southwind.net>
Message-Id: <199711151649.KAA01036@onyx.southwind.net>
Subject: corrupted "real" and "money" values in 2.0.3
Date: Sat, 15 Nov 1997 10:49:10 -0600 (CST)

Hi,

I am running 2.0.3 on a BSD/OS 2.1 pentium class box

Version Details :-

        msqladmin version 2.0.3
        mSQL server version 2.0.3
        mSQL protocol version 23
        mSQL connection Localhost via UNIX socket
        Target platform BSD_OS-2.1-i386

Configuration Details :-

        Default config file /var/database/msql_2.0.3/msql.conf
        TCP socket 1114
        UNIX socket /var/database/msql_2.0.3/msql2.sock
        mSQL user info
        Admin user root
        Install directory /var/database/msql_2.0.3
        PID file location /var/database/msql_2.0.3/msql2d.pid
        Memory Sync Timer 30
        Hostname Lookup True

I have the following table def:

  CREATE TABLE userhours (
    uid_user INT NOT NULL,
    name_user CHAR(8) NOT NULL,
    uid_groupleader INT,
    email_contact CHAR(100),
    date_created UINT NOT NULL,
    date_signed UINT NOT NULL,
    date_paid UINT NOT NULL,
    date_modified UINT NOT NULL,
    hours_month MONEY NOT NULL,
    hours_group MONEY NOT NULL,
    hours_subgroup MONEY NOT NULL
  ) \g

  CREATE UNIQUE INDEX uid_index ON userhours (
        uid_user
  ) \g

I specify an insert for this table as

  INSERT INTO userhours VALUES (7304,`test`,NULL,NULL,0,0,0,0,.00,.00,.00)\g

The table is created the index is created the insert works fine. I then
enter msql to query the "hour_*" fields and the first field specified
shows up as corrupted, a la:

  mSQL > select hours_month,hours_group,hours_subgroup from userhours\b

  Query OK. 1 row(s) modified or retrieved.

   +-------------+-------------+----------------+
   | hours_month | hours_group | hours_subgroup |
   +-------------+-------------+----------------+
   | .0 | .00 | .00 |
   +-------------+-------------+----------------+

if you notice the value line above appears to be one character shorter
than it should be. The value in the first column is displaied on my
screen as ".<some extended character>0".

if I reorder the select to

  mSQL > select hours_group,hours_subgroup,hours_month from userhours\g

  Query OK. 1 row(s) modified or retrieved.

   +-------------+----------------+-------------+
   | hours_group | hours_subgroup | hours_month |
   +-------------+----------------+-------------+
   | .0 | .00 | .00 |
   +-------------+----------------+-------------+

then I get the same printed result. So it appears that the problem is
that the first displayed "reaL" or "money" field is hosed on output (?).

If I do a dump of the above table I get the insert line:

  INSERT INTO userhours VALUES (7304,`test`,NULL,NULL,.,0,0,0,0,.00,.00)\g

note the ",.," after the second NULL.

After some additional checking today it looks like this problem does not
lie in the commandline interfaces to msql. Both "msql" and "msqldump"
are reporting exactly what they are receiving from the "msql2d" daemon.
I have not tracked anything down in the daemon code yet but I`m looking.

Dean...K... 

-- 
Dean Karres               | http://www2.southwind.net/~karres
     karres@southwind.net |
Southwind Internet Access | Programmer / Systems Administrator
Wichita, KS               | <Troll 2nd Class /w Clusters>
From beren@saers.com  Sat Nov 15 11:56:26 1997
Received: from myname.my.domain (ti02a02-0028.dialup.online.no [130.67.16.156])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id LAA11442
	for <msql-list@services.bunyip.com>; Sat, 15 Nov 1997 11:56:24 -0500 (EST)
Received: from localhost (Received: from localhost (beren@localhost)
	by myname.my.domain (8.8.7/8.8.5) with SMTP id SAA00679
	for <msql-list@services.bunyip.com>; Fri, 15 Nov 1996 18:00:36 +0100 (CET)
X-Authentication-Warning: myname.my.domain: beren owned process doing -bs
Date: Fri, 15 Nov 1996 18:00:36 +0100 (CET)
From: Niklas Saers <beren@saers.com>
X-Sender: X-Sender: beren@myname.my.domain
To: msql-list@services.bunyip.com
Subject: Uploading a file using w3-msql
In-Reply-To: <Pine.SOL.3.91.971114181513.14905A-100000@sun.tir.com>
Message-ID: <Pine.BSF.3.95q.961115175730.668B-100000@myname.my.domain>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Hi, I've got a little problem here: I'm trying to upload a file to the
system to be processed by msql. The form is:

<form action=/cgi-bin/w3-msql/msql-base/upload_processing.html 
method=post>

<input type=file name=myfile size=80%><br>
<input type=submit value="Add data">
</form>

But when I'm in upload_processing.html write

<!
echo("$myfile");
>

I get only the filename. Where does it store the datas which are being
uploaded? How should I extract them?