Database error 0 while doing query Duplicate entry '189519' for key 'PRIMARY'

ℹ️ Support
#1

Hi there!

Since yesterday I got that error when sending a newsletter:

 Database error 0 while doing query  Duplicate entry '189519' for key 'PRIMARY'

Does anybody know how to fix it? Sending doesn’t work. :frowning:

arada

#2

What has changed? What version of phpList are you running? What version of PHP is on your server?

All clues to help us help you.

#3

Oh, sorry. The Version is 2.10.19, nothing has been changed, that error occurres since yesterday when sending a newsletter. There are still 53 mails so send in the queue. The rest has been sent.

PHP is 5.56.

#4

hi @arada, it sounds like your database needs to be repaired. One of the tables has a duplicate entry for a primary key, (a primary key should be unique).

You would need to go into your cpanel and repair the database. If you want technical help, send me an email… (nominal charge…, not free).