Ishis a bug? My table has one row, and my update says it has updated one row, but the data doesn't change. After the update, myisamchk reports the table as crashed.
Possibly related, we have occurrences of mysql saying it is unable to open clips.MYD, errno 145. clips.MYD still exists. mysql> select version() ; +--------------------+ | version() | +--------------------+ | 4.0.0-alpha-max-nt | +--------------------+ 1 row in set (0.00 sec) mysql> show columns from clips ; +-------------+---------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------+------+-----+---------------------+-------+ | ClipID | int(11) | | PRI | 0 | | | Created | datetime | | | 0000-00-00 00:00:00 | | | Modified | timestamp(14) | YES | | NULL | | | Server | int(11) | | | 0 | | | Deleted | datetime | YES | | NULL | | | Frames | int(11) | | | 0 | | | Title | tinytext | YES | MUL | NULL | | | Number | smallint(6) | YES | MUL | NULL | | | Category | tinytext | YES | MUL | NULL | | | Owner | tinytext | YES | MUL | NULL | | | JobID | int(11) | YES | MUL | NULL | | | Tape | tinytext | YES | MUL | NULL | | | Destination | int(11) | YES | | NULL | | | Expiry | datetime | YES | MUL | NULL | | | Description | tinytext | YES | | NULL | | | Register | int(11) | | | 0 | | | RegisterMOD | int(11) | | | 0 | | +-------------+---------------+------+-----+---------------------+-------+ 17 rows in set (0.00 sec) mysql> select clipId, owner from clips ; +--------+-------+ | clipId | owner | +--------+-------+ | 2 | NULL | +--------+-------+ 1 row in set (0.00 sec) mysql> update clips set owner = "him" where clipid = 2 ; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select clipId, owner from clips ; +--------+-------+ | clipId | owner | +--------+-------+ | 2 | NULL | +--------+-------+ 1 row in set (0.00 sec) mysql> ---------------------- After doing this, the table appears to be crashed: C:\mysql\data\alec>myisamchk clips Checking MyISAM file: clips Data records: 1 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check data record references index: 3 - check data record references index: 4 - check data record references index: 5 - check data record references index: 6 - check data record references index: 7 - check data record references index: 8 - check record links MyISAM-table 'clips' is usable but should be fixed C:\mysql\data\alec> <<-- This e-mail is intended for the named addressees only. Its contents may be privileged or confidential and should be treated as such. If you are not an intended recipient please notify the sender immediately; do not copy, distribute, or take any action based on this e-mail; and then delete it. In the pursuit of its legitimate business activities and its conformance with relevant legislation, Quantel Ltd. may access any e-mail (including attachments) it originates and receives, for potential scrutiny. Check out Quantel's new website, packed full of information, at : http://www.quantel.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
