oops - forgot to send back answer to this : problem
was in my own scripts - they were putting something
illegal (i still don't know what) into the tables that
caused the hang. using a clean table and just the
mysql client did not reproduce the errors so i must
have screwed up in the CGI big time. sorry for the noise.
chas
>I've just changed the schema of one of the columns in a
>table to BIGINT(14). Previously the 'passid' column was
>of type INT.
>
>mysql> explain members;
>+-----------+-----------------+------+-----+---------+-------+
>| Field | Type | Null | Key | Default | Extra |
>+-----------+-----------------+------+-----+---------+-------+
>| passid | bigint(14) | | PRI | 0 | |
>| password | char(16) | | | | |
>| lastlogin | timestamp(14) | YES | | NULL | |
>| language | enum('CN','EN') | | | | |
>+-----------+-----------------+------+-----+---------+-------+
>4 rows in set (0.00 sec)
>
>Now, my CGI script claims that it inputs a value using :
>INSERT INTO members (lastlogin, language, password, netpassid)
>VALUES (NULL, '', 'asdfasdf', 9999999999)
>
>but I know that it has not b/c I managed to query the table
>and found it had not been updated.
>
>now I find that I can't even query the table.
>"select * from members" causes the client to hang, then
>a popup appears and the server aborts.
>
>the server and client are both on the same NT workstation.
>
>I've paid for and am using the latest version (3.22)
>
>is this a known issue ? have i overlooked something ? all was
>fine when passid was of type "INT"
>
>chas
>
>
>
>
>
>
>
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread4098@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail mysql-unsubscribe@stripped instead.
>
>
>
