Mailing List Archive


Back to the month index Back to the list index
Siegfried Stepke (siegi@ns.adis.at)
Wed, 4 Sep 1996 15:34:11 +0200 (MET DST) 

From: Siegfried Stepke <siegi@ns.adis.at>
Message-Id: <199609041334.PAA15842@ns.adis.at>
Subject: [mSQL] INSERT ignored
Date: Wed, 4 Sep 1996 15:34:11 +0200 (MET DST)

Hi again,

The data I inserted 3 hours ago appeared now!!!

Any hints?

> mSQL > select keyid,dat,zeit,bearbeiter from change_status\g
>
> Query OK.
>
> 1 rows matched.
>
> +----------+----------+----------+----------------------+
> | keyid | dat | zeit | bearbeiter |
> +----------+----------+----------+----------------------+
> | 9515BC2D | 960904 | 104854 | WWW-Register |
> +----------+----------+----------+----------------------+
>
> mSQL > insert into change_status (keyid,dat) values ('9515BC2D',12)\g
>
> Query OK.
>
> mSQL > select keyid,dat,zeit,bearbeiter from change_status\g
>
> Query OK.
>
> 1 rows matched.
>
> +----------+----------+----------+----------------------+
> | keyid | dat | zeit | bearbeiter |
> +----------+----------+----------+----------------------+
> | 9515BC2D | 960904 | 104854 | WWW-Register |
> +----------+----------+----------+----------------------+
>
>
> I know, that I don't have a primary key. The problem is, I know it works:
> It worked yesterday but suddenly the error occured. Today I tried to
> simulate this with a new database, and I got the error from the beginning.
>
> Of course I don't know, what might have changed since yesterday, I would
> have checked it otherwise.
>
> Normally I use msqlPerl, but to evaluate the error I used the msql-Monitor.
>
> Here some Infos about my system:
> > uname -a
> Linux li04 1.3.52 #1 Thu Feb 8 13:32:04 MET 1996 i586
>
> > msqladmin version
>
> Version Details :-
>
> msqladmin version 1.0.16
> mSQL connection Localhost via UNIX socket
> mSQL server version 1.0.16
> mSQL protocol version 6
> mSQL TCP socket 1112
> mSQL UNIX socket /dev/msql
> mSQL root user root
> Host Architecture Linux-1.3.52-i586
>
> I applied the disappearing table-Patch from the FAQ.
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!