Sorry for the bug.

Hi Chris,

I can edit the cars details now, but then it says:

A car with registration number E419mje is already registered by Paddy 1.

Even if I su to that user I get the same error

Cheers
Ade

Ah, sorry another bug.

It was checking for duplicate registrations when adding/editing cars, but BEFORE it stripped invalid characters from the registration numbers. This meant that some got through due to it not comparing like-for-like.

So the error message you saw was legitimate, because the bug let the duplicate into the system.

The following duplicate records exist...

+------+------------------+
| m_id | m_car_reg_number |
+------+------------------+
| 85 | LAA401Y |
| 167 | K19OLF |
| 201 | HRP168Y |
| 219 | khw190x |
| 220 | khw190x |
| 221 | khw190x |
| 249 | HRP168Y |
| 259 | Sij3853 |
| 260 | Sij3853 |
| 261 | Sij3853 |
| 262 | Sij3853 |
| 263 | Sij3853 |
| 282 | c32jro |
| 283 | c32jro |
| 292 | F608YRU |
| 296 | K19OLF |
| 337 | LAA401Y |
| 338 | LAA401Y |
| 366 | F608YRU |
| 376 | E419mje |
| 377 | E419mje |
| 380 | H861TAK |
| 381 | H861TAK |
+------+------------------+


I have fixed the bug. I have also made the error message you saw non-fatal in the cases of the problem already being in the system (however if you actively change a registration to something which is a duplicate, that would still be a fatal error).

Thanks Chris.

And thanks for listing the duplicates out !!

Cheers
Ade