Page 1 of 1
MySQL suddenly quits
Posted: Thu Aug 22, 2002 6:03 am
by rainbow
When I want to add the data to one table, after clicking on a submit button, MySQL shows the message "DBUG: Test signal" and then it says that "this program has performed an illegal operation..." and it closes the connection. I tried to add the data both with a php script and with PhpMyAdmin - everywhere is the same result.
What can I do about it ?
It's really annoying, since i can't continue my work further because of this problem.

Posted: Thu Aug 22, 2002 11:24 am
by volka
maybe you should run a
CHECK TABLE and/or
myisamchk. Do you have any chance to reinstall mysql and compile php against it?
Posted: Thu Aug 22, 2002 3:08 pm
by rainbow
Thanks for the advice, maybe i should really try to reinstall MySQL .
I also tried to use 'check table' . But when i typed "CHECK TABLE table_name EXTENDED;" it gave an error that there's something wrong in this query ? Is there ?
Posted: Thu Aug 22, 2002 3:20 pm
by volka
since I have strong convidence in you having changed table_name to the valid name of your table in the right database (

) I think the problem may be
Starting with MySQL Version 3.23.13, you can check MyISAM tables with the CHECK TABLE command.
Posted: Fri Aug 23, 2002 1:18 am
by rainbow
Starting with MySQL Version 3.23.13, you can check MyISAM tables with the CHECK TABLE command.
Yeah, you are right, the problem with "check table" is in the version.

Posted: Sat Aug 24, 2002 2:33 am
by rainbow
Anyway,I found the bug.

The problem was that the table didn't have a primary key specified for some reason. But again it's a bit weird that MySQL reacted to this problem in a such way. It could just give an error