[buro9]

Originally Posted by buro9

Hehe, I'm very sure that I didn't delete indexes

Might look back to see what version installed it.

I have 3 installations, 2 of which are upgrades and were installed over the last few days. They have the index. It was the fresh install version that I've been running on for 3 months that didn't have the index, and that's been hacked... I'm already suspecting that some naughty hack writer has done some nasty deed with my database.

Thankfully I keep all hacks that install well documented, so I'll go through tomorrow and piece together quite why I didn't have this essential index in place.

Found it:

https://vborg.vbsupport.ru/showthread.php?t=63733

And in their code:
[sql]
ALTER TABLE `customprofilepic` DROP PRIMARY KEY;
ALTER TABLE `customprofilepic` ADD picture_id int(10) unsigned NOT NULL default '0' AUTO_INCREMENT PRIMARY KEY AFTER userid;
[/sql]

Their ought to be punishments for hackers that do things like this!