[NickCat]

Originally Posted by TMM-TT

Can you see if it has a primary key?
If you think it hasn't, try the command I gave before -
ALTER TABLE proxycache ADD PRIMARY KEY(`ip`);

Hopefully, that'll help..If not, you can try to reinstall the product or use...
OPTIMIZE TABLE proxycache
alt.
REPAIR TABLE proxycache

...instead

I am trying to install this on 3.6.0 and I'm getting the same database errors this user was.

Invalid SQL:
INSERT INTO proxycache (ip, listed, dateline) VALUES ('75.11.10.116', 0, 1160700950);

MySQL Error  : Duplicate entry '75.11.10.116' for key 1
Error Number : 1062
Date         : Thursday, October 12th 2006 @ 08:55:54 PM
Script       : http://forums.nasioc.com/forums/forumdisplay.php?f=112
Referrer     : http://forums.nasioc.com/forums/forumdisplay.php?f=23
IP Address   : 75.11.10.116
Username     : Unregistered
Classname    : vb_database

And the IPs do already have records, so it's trying to insert a ip that's already been inserted. Shouldn't the code check to see if it's been inserted before trying to insert it again or run an update?

I have the primary key setup properly for ip.

I have repaired, optimized the proxycache table, but still no luck getting away from this error.