Your software
My Mautic version is: 4.4.7
My PHP version is: 7.4.30
My Database type and version is: 10.3.38-MariaDB-0ubuntu0.20.04.1
Your problem
My problem is: New contacts are not importing from CSV file.
These errors are showing in the log:
[2023-03-17 01:03:36] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘INSERT INTO leads (is_published, date_added, created_by, created_by_user, date_modified, modified_by, modified_by_user, checked_out, checked_out_by, checked_out_by_user, points, last_active, internal, social_cache, date_identified, preferred_profile_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner_id, stage_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2023-03-17 01:03:36”, null, null, null, null, null, null, null, null, 0, null, “a:0:{}”, “a:0:{}”, null, “gravatar”, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]: SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine” at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO leads (is_published, date_added, created_by, created_by_user, date_modified, modified_by, modified_by_user, checked_out, checked_out_by, checked_out_by_user, points, last_active, internal, social_cache, date_identified, preferred_profile_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner_id, stage_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, "2023-03-17 01:03:36", null, null, null, null, null, null, null, null, 0, null, "a:0:{}", "a:0:{}", null, "gravatar", null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]:\n\nSQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: HY000): SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”} {“hostname”:“Avori”,“pid”:889}
Steps I have tried to fix the problem: Don’t know what to try.