Error Number : 1062

[masterme]

I have done nothing that I know of that had triggered this error, did not do any work on my board big time.

This is the error I get: (the many 'xxx' I added personaly because it leads to my Live account)

Database error in vBulletin 3.6.4:

Invalid SQL:

INSERT INTO referrers
(url, count)
VALUES
(xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.aspx%3FAux%3D4%252c0%252c633066489248000000%26Fol derID%3D00000000-0000-0000-0000-000000000001%26InboxSortAscending%3DFalse%26InboxSortBy%3DDate%26ReadMessageId%3D541b91e9-c631-4f67-8645-09014d7f88d4%26n%3D1526920826', 1);

MySQL Error : Duplicate entryxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx2FReadMessageLight.aspx%3FAux%3D4%252c0%252c63306648924 8000000%26FolderID%3D00000000-0000-0000-0000-000000000001%26InboxSortAs...' for key 1
Error Number : 1062
Date : Friday, February 9th 2007 @ 09:19:29 PM
Script : http://www.myforum.nl/forum/showthread.php?p=634
Referrer : Removed, this was my msn Live account
IP Address : 83.117.143.233
Username : cindy
Classname : vb_database

So again, the many 'xxx' I have added because it leads to my msn Live account, as well as the referrer.

I am getting this message now a few times randomly, not even from users only, even unregistered guests show next to Username.
I really do not know what triggers this, since the board is active and I receive this now and than.

Also I find it very strange that my Live account shows up as referrer and as error.
Anybody any idea what this is?

[Floris]

Try this:

Back up your database 100% to your hard disk drive.

Then:

- Admin Control Panel > Maintenance > Optimize & Repair Database

* Run optimize on your database tables.
* Run repair on your database tables

and finally

* Run "Fix unique KEY indexes" once

Check if the forum works again.