Mailing List Archive


Back to the month index Back to the list index
Siegfried Stepke (siegi@ad.or.at)
Wed, 4 Sep 1996 11:50:09 +0200 (MET DST) 

From: Siegfried Stepke <siegi@ad.or.at>
Message-Id: <199609040950.LAA03642@li04.adis.at>
Subject: [mSQL] INSERT ignored
Date: Wed, 4 Sep 1996 11:50:09 +0200 (MET DST)

Hi,

I got a very strange problem when inserting to a table:
I don't get an error, but the insert fails...

Thanks for any help!

relshow neukey change_status

Database = neukey

Table = change_status

 +-----------------+----------+--------+----------+-----+
 | Field | Type | Length | Not Null | Key |
 +-----------------+----------+--------+----------+-----+
 | keyid | char | 8 | N | N |
 | dat | int | 4 | N | N |
 | zeit | int | 4 | N | N |
 | bearbeiter | char | 20 | N | N |
 | rechner | char | 30 | N | N |
 | old_state | char | 2 | N | N |
 | new_state | char | 2 | N | N |
 | kommentar | char | 256 | N | N |
 +-----------------+----------+--------+----------+-----+

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!