NULL values in DB table "leads" appear automatically

Product Support
1

Your software
My Mautic version is: v4.4.9
My PHP version is: 7.4.33
My Database type and version is: 10.5.19-MariaDB-0+deb11u2

Your problem
My problem is:
Hello everyone,
I freshly installed Mautic 4.49 on a Debian Linux 11 with Apache2 and MariaDB.
I observe the following problem that when creating new contacts, one or more contacts with NULL values are created again and again without my intervention. I only see this in the MySQL CLI, but not in the GUI itself.
I manually delete them again on the MySQL cli, but it’s ugly that this blows up the database ids.

Does anyone here have an idea for this phenomenon?

Thanks very much
Njuguna

MariaDB [mautic]> SELECT id, firstname, lastname FROM leads
+----+--------------+--------------+
| id | firstname    | lastname     |
+----+--------------+--------------+
| 50 | Harald       | tttttttttt     |
| 51 | NULL         | NULL         |
| 52 | Dino         | zzzzzzz     |
| 54 | Georg        | yyyyyyy      |
| 55 | NULL         | NULL         |
| 56 | NULL         | NULL         |
| 57 | NULL         | NULL         |
| 58 | NULL         | NULL         |
| 59 | NULL         | NULL         |
| 60 | NULL         | NULL         |
| 61 | NULL         | NULL         |
| 62 | NULL         | NULL         |
| 63 | NULL         | NULL         |
| 64 | Gunnar       | xxxxxx     |

These errors are showing in the log:

Steps I have tried to fix the problem:
As already said, I delete them manually on the MySQL cli.

2

Hi, check the contacts page, click on this icon:

image

The contacts generated as unknow visitors by your tracking script will be visible.
Check their actions by clicking on the chain icon in their event history. You can see what pages they visit.

Probably bots.

3

All right, thank you.
How do I convert these into effective leads now?

4

Hi,
This is a business question.
If they are real visitors and not bots, then you can reach out to them with focus items (check videos, and mautic docs about this) or offer lead magnets to make them fill out a form on your page. This would turn them from unknown to known contacts.
Joey

5

This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.