I have a problem with a database. Well, there are lots of problems with this database but I am struggling to make it function at the moment without errors.
The problem is that when the tables were designed, the developer did not make the right fields Primary or unique. This means that on a particular table, with members of an organisation, a field contains many duplicate values. This in turn leads to problems because some of the PHP relies on this field to update information.
The table in question appears not to have a primary key at all, it does specify unique for a different field (which should have been designated the Primary Key at the design stage, but which wasn’t)
There are many things wrong with this database, enum fields etc, but I am trying to resolve this critical problem at the moment.
The table is in a real mess with duplicates of on field causing problems. Is there any way I can do the following easily.
That sounds like quite a situation! I’m not sure how much we’ll be able to do, but we can certainly take a look for you. This is not really something we can do in this format, though, and I would recommend that you contact our support team with a ticket. You can enter this from Backstage, under Support, and our team will be more than happy to take a look and offer some advice.