Duplicate Tweets? about tweetnest HOT 5 CLOSED

Since a notable part of the upgrade process was to eliminate tweet duplicates by upgrading the SQL tweets table, making sure that the tweet id column is always unique, I am lead to believe this upgrade hasn't progressed as it should have. Please double check that there is a UNIQUE index on column tweetid in table tweets in the database. Thanks!

from tweetnest.

These are the currently listed indexes on the table. No unique index on the tweetid column. What should I do? Authorize.php found only 1 duplicate tweet while upgrading. I still have 12741 duplicate tweets left in the database.

from tweetnest.

The most easy option is definitely to start over and install from scratch, and get your tweets from a Twitter archive. You could remove every duplicate manually, but that would obviously be tedious.

from tweetnest.

I had that in my mind too but for some reason even that was failing[out of memory errors]. Anyways managed to get rid of the duplicates thanks to the trick mentioned here: http://www.devcha.com/2008/03/how-to-remove-duplicate-records-with.html

Thanks for the help.

from tweetnest.

Now that you have no duplicate tweets, run upgrade.php to make sure the tables are as they should be. :)

from tweetnest.