There are some problems with your database. Normally it is safe to try to fix these problems automatically however if your community is large, you may want to run the necessary queries manually. If so, the queries to run are:

ALTER TABLE `core_pfields_content` DROP INDEX `field_1`;

What is this - some tips?

2 minutes ago, bosss said:

There are some problems with your database. Normally it is safe to try to fix these problems automatically however if your community is large, you may want to run the necessary queries manually. If so, the queries to run are:

ALTER TABLE `core_pfields_content` DROP INDEX `field_1`;

What is this - some tips?

Did you get this at the Support section of your Admin Panel? What it says is to drop the index from the profile fields table. Although indexes play an essential role in optimizing query performance by speeding up the retrieval of data, they can also slow down data modification operations for commands such as INSERT, UPDATE and DELETE due to the overhead of maintaining them. In that case indexes are no longer required as they have becomes redundant.

That said, it would be best to make a backup of the aforementioned table, or better yet of the whole database, before you manipulate the database, especially deleting stuff from it. Hope it helps.

1 minute ago, Miss_B said:

Did you get this at the Support section of your Admin Panel? What it says is to drop the index from the profile fields table. Although indexes play an essential role in optimizing query performance by speeding up the retrieval of data, they can also slow down data modification operations for commands such as INSERT, UPDATE and DELETE due to the overhead of maintaining them. In that case indexes are no longer required as they have becomes redundant.

That said, it would be best to make a backup of the aforementioned table, or better yet of the whole database, before you manipulate the database, especially deleting stuff from it. Hope it helps.

Yes that was in mt Admin cp - support section!

what was wrong?

1 minute ago, bosss said:

what was wrong?

Hard to say from the outside. But if the software recommended it then I'm sure it had good reasons.

5 minutes ago, Miss_B said:

Hard to say from the outside. But if the software recommended it then I'm sure it had good reasons.

Latest i made field "Address"

41 minutes ago, Miss_B said:

But if the software recommended it then I'm sure it had good reasons.

Fixed - thanks

1 minute ago, bosss said:

Fixed - thanks

Glad to see that it has been fixed.