MySQL Forums
Forum List  »  Newbie

Can't insert rows until table renamed?
Posted by: V@no .
Date: December 16, 2011 09:52PM

Hello.

Someone contacted me with an issue, when database doesn't accept any new rows. There is no error messages, it just mysql ignores INSERT command even when table is empty or deleted then recreated.
The strange thing is, when this same table renamed to different name, it accepts new rows. After adding few rows and then rename it to old name - same problem, no more new rows accepted...

Does anyone know what causing it and how to fix it?

Thanks.

DROP TABLE IF EXISTS `4images_wordlist`;
CREATE TABLE IF NOT EXISTS `4images_wordlist` (
`word_text` varchar(50) NOT NULL DEFAULT '',
`word_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`word_id`),
UNIQUE KEY `word_text` (`word_text`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

Options: ReplyQuote


Subject
Written By
Posted
Can't insert rows until table renamed?
December 16, 2011 09:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.