This was a vanilla production database (3 weeks old, no custom installs, and I had only ever installed one plug in and then uninstalled it)
The error I get from the server logs is:
Mysqli statement execute error : Duplicate entry '1-Search' for key 'language_id_title'
I've searched the information schema, and found
SELECT * FROM 'KEY_COLUMN_USAGE'
WHERE 'CONSTRAINT_NAME' = 'language_id_title'
Returned 2 columns on the same table:
table : Column
xf_phrase_map : language_id
xf_phrase_map : title
But this table is empty
I'm not sure whats going on here yet.. any ideas? It sounds like its trying to insert "1-Search" twice, I cant see why yet..
Some info from looking in the DB, possible reasons????
1. in the table xf_admin_template_phrase
I have 2 rows with the value "search"
id 834 and id 1076, could either of these be causing this?