Help - Search - Members - Calendar
Full Version: Can't Make New Entry
Movable Type Community Forum > Using Movable Type > Additional Features
jeepish
Here's an interesting one, I made one entry to my blog this morning, then a couple hours later I tried to make another one. It previews just fine, but when I try to save it I get this error:

CODE
Saving entry failed: Duplicate entry '648' for key 1


With the only option to close or go back.

I assume that somehow it thinks there's an entry #648, but in rebuilding the indexes and listing/editing the entries, it only goes up to the one successful post from a couple of hours ago.

Any tips on how to fix this?
jeepish
More info:

Looking at the db in phpMyAdmin, there is no row 648. It stops at 647. I find no other instance for why MT thinks that there's already an entry for 648.

This is MT v 2.64. I did *nothing* between the last successful post and the current state where I cannot make a new entry.
imabug
this usually indicates a problem with one or more of the MySQL tables. Select all the tables with phpMyAdmin and run a CHECK operation on them. If you get anything other than OK or Table OK, run a REPAIR operation on those tables. And then while you're at it, run an OPTIMIZE operation on all the tables after you're done.
jeepish
Yes, that did it - on Check it reported errors in both Comments and Entries. Repair did the trick nicely.

Thanks much!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2010 Invision Power Services, Inc.