MySQL suddenly quits

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
rainbow
Forum Newbie
Posts: 13
Joined: Thu Aug 22, 2002 6:03 am
Location: Finland

MySQL suddenly quits

Post 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. :evil:
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post 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?
rainbow
Forum Newbie
Posts: 13
Joined: Thu Aug 22, 2002 6:03 am
Location: Finland

Post 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 ?
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post 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.
rainbow
Forum Newbie
Posts: 13
Joined: Thu Aug 22, 2002 6:03 am
Location: Finland

Post 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. :(
rainbow
Forum Newbie
Posts: 13
Joined: Thu Aug 22, 2002 6:03 am
Location: Finland

Post by rainbow »

Anyway,I found the bug. :D 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
Post Reply