By neobodhi on

I have had this installation for over 3 years with no errors until now. I have repaired the database and run cron jobs.

However I get this message when voting on content...

user warning: Duplicate entry '70603' for key 'PRIMARY' query: INSERT INTO votingapi_vote (vote_id, content_type, content_id, value, value_type, tag, uid, timestamp, hostname) VALUES (70603, 'node', 4156, 70, 'percent', 'vote', 1, 1312920525, 'myip') in /home/myname/public_html/mysite/includes/database.mysql.inc on line 172.

No new votes get saved. Anyone have any ideas on what to do? I would hate to remove the voting feature from the site and would love to fix this.

⋅ Categories: Drupal 5.x

Comments

neobodhi’s picture

neobodhi commented

Can anyone out there please help me with this? One of you experts must have an idea what is going on :)

neobodhi’s picture

neobodhi commented

anyone?

neobodhi’s picture

neobodhi commented

Is there any way to clear the db and start fresh? I really need the functionality but I have no problem resetting the votes.

zjoriz’s picture

zjoriz commented

I got a similar error. In fact, a whole page full of errors from all the installed themes (even those that aren't active). Had no idea why that was happening, and no idea why it happened seemingly random.

However, Drupal also showed the error discussed here, which has to do with free disk space for the MySQL database. One of the suggestions is to delete old automatic backups of the database, or have them cleared by the provider. Which is what I'm going to try tomorrow -- hopefully, it'll also clear the 'Duplicate entry' errors.