I got the following error on one occasion. I wasn't able to reproduce it again. It just happened on one instance, I thought I should report it nevertheless.

I am on:

MySQL database 5.0.67
PHP 5.2.6

Apache/2.2.9 (Unix) PHP/4.4.9 mod_ssl/2.2.9 OpenSSL/0.9.8c mod_fastcgi/2.4.6 Phusion_Passenger/2.0.3 DAV/2 SVN/1.4.2

user warning: Duplicate entry '50-0-99.228.41.125' for key 1 query: INSERT INTO drupal_poll_votes (nid, chorder, hostname) VALUES (50, 0, '99.228.41.125') in /home/...../modules/poll/poll.module on line 611.

Just voted on a poll, the page refreshed with the following error.

Comments

HS’s picture

HS CreditAttribution: HS commented
Title: Duplicate entry error for a INSERT query in {poll_votes} » user warning: Duplicate entry
Version: 6.9 » 6.8
Priority: Critical » Normal

OK now I'm seeing this in my logs

Duplicate entry '318-0-121.217.251.252' for key 1 query: INSERT INTO drupal_poll_votes (nid, chorder, hostname) VALUES (318, 1, '121.217.251.252') in /home/is.../../modules/poll/poll.module on line 604.
HS’s picture

HS CreditAttribution: HS commented
Issue summary: View changes

Removed domain name.

apaderno’s picture

apaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
CreditAttribution: apaderno commented
Title: user warning: Duplicate entry » Duplicate entry error for a INSERT query in {poll_votes}
HS’s picture

HS CreditAttribution: HS commented
Priority: Normal » Critical

Still facing this issue. The module may not be able to handle votes from different User Id's emanating from the the same IP address? Been a month and no response to this issue.

antlib’s picture

antlib CreditAttribution: antlib commented
Version: 6.8 » 6.9

I'm having this issue too:
Duplicate entry '23-1-' for key 1 query: INSERT INTO poll_votes (nid, chorder, uid) VALUES (23, 3, 1)

For some reason the poll registered 2 votes when testing despite only voting once. I did not hit refresh or press the submit button twice.

Anyone else having this problem?

dpearcefl’s picture

dpearcefl CreditAttribution: dpearcefl commented
Status: Active » Postponed (maintainer needs more info)

Is this still an active issue for you?

dpearcefl’s picture

dpearcefl CreditAttribution: dpearcefl commented
Status: Postponed (maintainer needs more info) » Active

Status: Active » Closed (outdated)

Automatically closed because Drupal 6 is no longer supported. If the issue verifiably applies to later versions, please reopen with details and update the version.