Update. – viewing the tables in phpmyadmin shows the new groups in the participants_database_groups table, all with id=0 and order = 3. none of the new fields are showing in the participants_database_fields table. I could send a screenshot if that helps, but don’t think I can do that here
That sounds like the data in the groups table is corrupted…I mean it shouldn’t even be possible to have two entries with the same ID, since that is the primary column.
That would prevent the fields from getting updated probably.
I would suggest you try to repair the groups table. First take a backup of your database just in case. Make a note of the group “name” column values, then deleting the groups you created (Don’t delete the admin and internal groups). Open the Manage Database Fields page and recreate the groups you deleted from the database using the exact same name. You can edit the titles once the groups have been created.
You can email me at [email protected] if you want to send screenshots.
Thanks, It would appear that the indexes and auto_increments have been corrupted. I have managed to reinstate properly (I think) in the database_groups table, but am struggling in the database and database_fields tables.
Could you advise me which fields in these tables need to be indexed, and which are primary please.
Is there anywhere else I should be looking?
Here is a snapshot of the corrrect structure of the wp_participants_database_groups table:
Thanks very much – that seems to have done the trick. Could you please confirm the indexes I should have in the other two tables please
These are the index configurations.
wp_participants_database_fields:
wp_participants_database:
