• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

coppermine install and mysql problem

M

modom

Guest
Hi,

I have installed coppermine from the application vault.

If I turn off "display notices" in the coppermine admin and try to post a comment I get this error:

Critical error


There was an error while processing a database query.


While executing query "INSERT INTO cpg132_comments (pid, msg_author, msg_body, msg_date, author_md5_id, author_id, msg_raw_ip, msg_hdr_ip) VALUES ('5', 'admin', 'test', NOW(), '', '1', '69.152.209.174', '69.152.209.174')" on 0

mySQL error: Duplicate entry '8388607' for key 1

File: /home/httpd/vhosts/inkaboutitllc.com/httpdocs/gallery/include/functions.inc.php - Line: 105

================================================

I have tried to repair the table but it says it is ok. Nobody can post any comments because of this error.

Does anyone know how to fix this?

Thanks!
 
Back
Top