"Fix Unique Indexes" Does Not work for 4.2.2 please help

[londoner]

Hello,

I am having trouble after dumping my database back, when trying to edit a template after clicking save I get a blank page and when I go back to open that template my edit is not done. The only thing I can think of is rebuilding the Unique indexes, but when I do that it asks me for the mysql_schema.php file to be available inside the install directory, when I try adding it I get an security alert asking me to remove the whole directory

I have tried re-dumping, repairing my tables, and disabling my memcache & xcache but no luck.

If anyone can tel me what I should do i would be really grateful.
I have lost my vbulletin.com login I never log in there I dont even remember If I have a forum account or not (Must do but i dont remember using it). I only have the Member area login detail for my 2 licenses but not the forum login. I thought of opening a ticket but thought i ask someone here if anyone faced a similar problem and if they can help with what they did to fix it.


thanks.

--------------- Added [DATE]1385876987[/DATE] at [TIME]1385876987[/TIME] ---------------

oops it was something wrong with the code I was adding, sorry all good now

--------------- Added [DATE]1385953105[/DATE] at [TIME]1385953105[/TIME] ---------------

Still the 2fix unique indexes does not work anyway so if someone needs to do it they won't be able to

[Lynne]

You could probably turn on debug mode and then Fix Unique Indexes.