>
>
> Hi!
>
> I have tested your case and it works just fine for me.
>
> What error message do you get ??
What i wrote was all i got - so there's just
> mysql> update t_webmaster set status=1 where type='Open';
> Query OK, 0 rows affected (0.01 sec)
No other messages at all - simply repeating the query _does_ show the
expected.
- no message in the error log (...would have mentioned this... ;-)
- no special thing in the normal log:
010318 20:41:44 7 Query alter table t_webmaster change lfdnr
lfdnr int(10) unsigned default 0 not null auto_increment
010318 20:41:48 7 Query update t_webmaster set status=1 where
type='Open'
010318 20:41:49 7 Query update t_webmaster set status=1 where
type='Open'
(only 2nd "update" did something)
...just did some more tests - perhaps this is relevant for this case:
If i re-create this test table with "mysql mydb <testcase.sql"
("testcase.sql" includes a "drop table t_webmaster"), and do a
myisamchk -vv /usr/local/var/ticketeer/t_webmaster.MYI
immediately afterwards, i get:
Checking MyISAM file: /usr/local/var/ticketeer/t_webmaster.MYI
Data records: 1 Deleted blocks: 0
myisamchk: warning: 1 clients is using or hasn't closed the table properly
- check file-size
- check key delete-chain
block_size 1024:
- check record delete-chain
No recordlinks
- 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 record links
MyISAM-table '/usr/local/var/ticketeer/t_webmaster.MYI' is usable but should
be fixed
If fix it with "myisamchk", this error disappears - but the original strange
effect remains the same...
regards, Jan
>
>
> Regards,
>
> Sinisa
>
> ____ __ _____ _____ ___ == MySQL AB
> /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
> /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
> /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
> ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
> /*/ \*\ Developers Team
>
---------------------------------------------------------------------
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
