Your software
My Mautic version is: v2.16 and v4.4
My PHP version is: 7.2.24 (on the v2.16 instance) and 8.0.30 (on the v4.4 instance)
My Database type and version is: v4.4 is using 10.5.22-MariaDB. Not sure about the v2.16 one, but I’ll check.
My Server: The current version (2.16) runs on Centos Stream 8. The new one (v4.4) runs on Rocky 9.3.
Your problem
My problem is:
We’re stuck in the middle of an upgrade from v2.16 to v4.4. We set up a copy of our existing Mautic installation (v2.16) on a new server so we could upgrade it without disrupting business, and then hired someone to upgrade it to v4.4. He did that, and it looks like he did a good job, but we’re running into a couple of problems (and I can’t get a response from the guy we hired):
-
During the time it was being upgraded, we received new data on our current mautic instance. We’d like to copy the data from our existing mautic instance to the upgraded instance on the new server, but we’re running into errors when we do that. Does anyone know how we can move data from v2.16 to v4.4?
-
It doesn’t look like the cron jobs are running on the new one. Are they located in a different location on v4.4?
These errors are showing in the log:
[2024-10-29 09:52:31] mautic.ERROR: An exception occurred while executing ‘INSERT INTO live_page_hits (date_hit, date_left, country, region, city, isp, organization, code, referer, url, url_title, user_agent, remote_host, page_language, browser_languages, tracking_id, source, source_id, query, page_id, redirect_id, email_id, lead_id, ip_id, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“2024-10-29 09:52:31”, null, null, null, null, null, null, 404, null, null, null, null, null, null, “a:0:{}”, “axqqwyxwtaiw1qzes2vis8w”, null, null, “\x61\x3a\x33\x3a\x7b\x73\x3a\x35\x35\x3a\x22\xad\x64\x5f\x61\x6c\x6c\x6f\x77\x5f\x75\x72\x6c\x5f\x69\x6e\x63\x6c\x75\x64\x65\x3d\x31\x5f\xad\x64\x5f\x61\x75\x74\x6f\x5f\x70\x72\x65\x70\x65\x6e\x64\x5f\x66\x69\x6c\x65\x3d\x70\x68\x70\x3a\x2f\x2f\x69\x6e\x70\x75\x74\x22\x3b\x73\x3a\x30\x3a\x22\x22\x3b\x73\x3a\x31\x38\x32\x3a\x22\x3c\x3f\x70\x68\x70\x5f\x73\x68\x65\x6c\x6c\x5f\x65\x78\x65\x63\x28\x62\x61\x73\x65\x36\x34\x5f\x64\x65\x63\x6f\x64\x65\x28\x22\x57\x44\x30\x6b\x4b\x47\x4e\x31\x63\x6d\x77\x67\x61\x48\x52\x30\x63\x44\x6f\x76\x4c\x7a\x6b\x30\x4c\x6a\x45\x31\x4e\x69\x34\x78\x4e\x7a\x63\x75\x4d\x54\x41\x35\x4c\x33\x4e\x6f\x49\x48\x78\x38\x49\x48\x64\x6e\x5a\x58\x51\x67\x61\x48\x52\x30\x63\x44\x6f\x76\x4c\x7a\x6b\x30\x4c\x6a\x45\x31\x4e\x69\x34\x78\x4e\x7a\x63\x75\x4d\x54\x41\x35\x4c\x33\x4e\x6f\x49\x43\x31\x50\x4c\x53\x6b\x37\x49\x47\x56\x6a\x61\x47\x38\x67\x49\x69\x52\x59\x49\x69\x42\x38\x49\x48\x4e\x6f\x49\x43\x31\x7a\x49\x47\x4e\x32\x5a\x56\x38\x79\x4d\x44\x49\x30\x58\x7a\x51\x31\x4e\x7a\x63\x75\x63\x32\x56\x73\x5a\x6e\x4a\x6c\x63\x41\x22\x3b\x73\x3a\x34\x32\x3a\x22\x3d\x22\x29\x29\x3b\x20\x65\x63\x68\x6f\x28\x6d\x64\x35\x28\x22\x48\x65\x6c\x6c\x6f\x20\x43\x56\x45\x2d\x32\x30\x32\x34\x2d\x34\x35\x37\x37\x22\x29\x29\x3b\x20\x3f\x3e\x22\x3b\x73\x3a\x38\x3a\x22\x70\x61\x67\x65\x5f\x75\x72\x6c\x22\x3b\x73\x3a\x39\x37\x3a\x22\x68\x74\x74\x70\x73\x3a\x2f\x2f\x33\x34\x2e\x32\x31\x37\x2e\x34\x33\x2e\x31\x32\x32\x2f\x68\x65\x6c\x6c\x6f\x2e\x77\x6f\x72\x6c\x64\x3f\x25\x41\x44\x64\x2b\x61\x6c\x6c\x6f\x77\x5f\x75\x72\x6c\x5f\x69\x6e\x63\x6c\x75\x64\x65\x25\x33\x64\x31\x2b\x25\x41\x44\x64\x2b\x61\x75\x74\x6f\x5f\x70\x72\x65\x70\x65\x6e\x64\x5f\x66\x69\x6c\x65\x25\x33\x64\x70\x68\x70\x3a\x2f\x2f\x69\x6e\x70\x75\x74\x22\x3b\x7d”, null, null, null, null, 956500, “945418”]: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xADd_all…’ for column mauticdb
.live_page_hits
.query
at row 1 {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO live_page_hits (date_hit, date_left, country, region, city, isp, organization, code, referer, url, url_title, user_agent, remote_host, page_language, browser_languages, tracking_id, source, source_id, query, page_id, redirect_id, email_id, lead_id, ip_id, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params ["2024-10-29 09:52:31", null, null, null, null, null, null, 404, null, null, null, null, null, null, "a:0:{}", "axqqwyxwtaiw1qzes2vis8w", null, null, "\x61\x3a\x33\x3a\x7b\x73\x3a\x35\x35\x3a\x22\xad\x64\x5f\x61\x6c\x6c\x6f\x77\x5f\x75\x72\x6c\x5f\x69\x6e\x63\x6c\x75\x64\x65\x3d\x31\x5f\xad\x64\x5f\x61\x75\x74\x6f\x5f\x70\x72\x65\x70\x65\x6e\x64\x5f\x66\x69\x6c\x65\x3d\x70\x68\x70\x3a\x2f\x2f\x69\x6e\x70\x75\x74\x22\x3b\x73\x3a\x30\x3a\x22\x22\x3b\x73\x3a\x31\x38\x32\x3a\x22\x3c\x3f\x70\x68\x70\x5f\x73\x68\x65\x6c\x6c\x5f\x65\x78\x65\x63\x28\x62\x61\x73\x65\x36\x34\x5f\x64\x65\x63\x6f\x64\x65\x28\x22\x57\x44\x30\x6b\x4b\x47\x4e\x31\x63\x6d\x77\x67\x61\x48\x52\x30\x63\x44\x6f\x76\x4c\x7a\x6b\x30\x4c\x6a\x45\x31\x4e\x69\x34\x78\x4e\x7a\x63\x75\x4d\x54\x41\x35\x4c\x33\x4e\x6f\x49\x48\x78\x38\x49\x48\x64\x6e\x5a\x58\x51\x67\x61\x48\x52\x30\x63\x44\x6f\x76\x4c\x7a\x6b\x30\x4c\x6a\x45\x31\x4e\x69\x34\x78\x4e\x7a\x63\x75\x4d\x54\x41\x35\x4c\x33\x4e\x6f\x49\x43\x31\x50\x4c\x53\x6b\x37\x49\x47\x56\x6a\x61\x47\x38\x67\x49\x69\x52\x59\x49\x69\x42\x38\x49\x48\x4e\x6f\x49\x43\x31\x7a\x49\x47\x4e\x32\x5a\x56\x38\x79\x4d\x44\x49\x30\x58\x7a\x51\x31\x4e\x7a\x63\x75\x63\x32\x56\x73\x5a\x6e\x4a\x6c\x63\x41\x22\x3b\x73\x3a\x34\x32\x3a\x22\x3d\x22\x29\x29\x3b\x20\x65\x63\x68\x6f\x28\x6d\x64\x35\x28\x22\x48\x65\x6c\x6c\x6f\x20\x43\x56\x45\x2d\x32\x30\x32\x34\x2d\x34\x35\x37\x37\x22\x29\x29\x3b\x20\x3f\x3e\x22\x3b\x73\x3a\x38\x3a\x22\x70\x61\x67\x65\x5f\x75\x72\x6c\x22\x3b\x73\x3a\x39\x37\x3a\x22\x68\x74\x74\x70\x73\x3a\x2f\x2f\x33\x34\x2e\x32\x31\x37\x2e\x34\x33\x2e\x31\x32\x32\x2f\x68\x65\x6c\x6c\x6f\x2e\x77\x6f\x72\x6c\x64\x3f\x25\x41\x44\x64\x2b\x61\x6c\x6c\x6f\x77\x5f\x75\x72\x6c\x5f\x69\x6e\x63\x6c\x75\x64\x65\x25\x33\x64\x31\x2b\x25\x41\x44\x64\x2b\x61\x75\x74\x6f\x5f\x70\x72\x65\x70\x65\x6e\x64\x5f\x66\x69\x6c\x65\x25\x33\x64\x70\x68\x70\x3a\x2f\x2f\x69\x6e\x70\x75\x74\x22\x3b\x7d", null, null, null, null, 956500, "945418"]:\n\nSQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xADd_all…’ for column mauticdb
.live_page_hits
.query
at row 1 at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xADd_all…’ for column mauticdb
.live_page_hits
.query
at row 1 at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xADd_all…’ for column mauticdb
.live_page_hits
.query
at row 1 at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”} {“hostname”:“ip-10-0-0-83.us-west-2.compute.internal”,“pid”:523447}
[2024-10-29 09:52:31] mautic.CRITICAL: Uncaught PHP Exception Doctrine\ORM\Exception\EntityManagerClosed: “The EntityManager is closed.” at /var/www/html/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/Exception/EntityManagerClosed.php line 11 {“exception”:“[object] (Doctrine\ORM\Exception\EntityManagerClosed(code: 0): The EntityManager is closed. at /var/www/html/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/Exception/EntityManagerClosed.php:11)”} {“hostname”:“ip-10-0-0-83.us-west-2.compute.internal”,“pid”:523447}
[2024-10-29 14:39:09] mautic.ERROR: An exception occurred while executing ‘INSERT INTO live_page_hits (date_hit, date_left, country, region, city, isp, organization, code, referer, url, url_title, user_agent, remote_host, page_language, browser_languages, tracking_id, source, source_id, query, page_id, redirect_id, email_id, lead_id, ip_id, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“2024-10-29 14:39:09”, null, null, null, null, null, null, 404, null, null, null, null, null, null, “a:0:{}”, “0c71hu82j4hhplu33oyvg1q”, null, null, “\x61\x3a\x33\x3a\x7b\x73\x3a\x35\x35\x3a\x22\xad\x64\x5f\x61\x6c\x6c\x6f\x77\x5f\x75\x72\x6c\x5f\x69\x6e\x63\x6c\x75\x64\x65\x3d\x31\x5f\xad\x64\x5f\x61\x75\x74\x6f\x5f\x70\x72\x65\x70\x65\x6e\x64\x5f\x66\x69\x6c\x65\x3d\x70\x68\x70\x3a\x2f\x2f\x69\x6e\x70\x75\x74\x22\x3b\x73\x3a\x30\x3a\x22\x22\x3b\x73\x3a\x31\x38\x32\x3a\x22\x3c\x3f\x70\x68\x70\x5f\x73\x68\x65\x6c\x6c\x5f\x65\x78\x65\x63\x28\x62\x61\x73\x65\x36\x34\x5f\x64\x65\x63\x6f\x64\x65\x28\x22\x57\x44\x30\x6b\x4b\x47\x4e\x31\x63\x6d\x77\x67\x61\x48\x52\x30\x63\x44\x6f\x76\x4c\x7a\x6b\x30\x4c\x6a\x45\x31\x4e\x69\x34\x78\x4e\x7a\x63\x75\x4d\x54\x41\x35\x4c\x33\x4e\x6f\x49\x48\x78\x38\x49\x48\x64\x6e\x5a\x58\x51\x67\x61\x48\x52\x30\x63\x44\x6f\x76\x4c\x7a\x6b\x30\x4c\x6a\x45\x31\x4e\x69\x34\x78\x4e\x7a\x63\x75\x4d\x54\x41\x35\x4c\x33\x4e\x6f\x49\x43\x31\x50\x4c\x53\x6b\x37\x49\x47\x56\x6a\x61\x47\x38\x67\x49\x69\x52\x59\x49\x69\x42\x38\x49\x48\x4e\x6f\x49\x43\x31\x7a\x49\x47\x4e\x32\x5a\x56\x38\x79\x4d\x44\x49\x30\x58\x7a\x51\x31\x4e\x7a\x63\x75\x63\x32\x56\x73\x5a\x6e\x4a\x6c\x63\x41\x22\x3b\x73\x3a\x34\x32\x3a\x22\x3d\x22\x29\x29\x3b\x20\x65\x63\x68\x6f\x28\x6d\x64\x35\x28\x22\x48\x65\x6c\x6c\x6f\x20\x43\x56\x45\x2d\x32\x30\x32\x34\x2d\x34\x35\x37\x37\x22\x29\x29\x3b\x20\x3f\x3e\x22\x3b\x73\x3a\x38\x3a\x22\x70\x61\x67\x65\x5f\x75\x72\x6c\x22\x3b\x73\x3a\x39\x37\x3a\x22\x68\x74\x74\x70\x73\x3a\x2f\x2f\x33\x34\x2e\x32\x31\x37\x2e\x34\x33\x2e\x31\x32\x32\x2f\x68\x65\x6c\x6c\x6f\x2e\x77\x6f\x72\x6c\x64\x3f\x25\x41\x44\x64\x2b\x61\x6c\x6c\x6f\x77\x5f\x75\x72\x6c\x5f\x69\x6e\x63\x6c\x75\x64\x65\x25\x33\x64\x31\x2b\x25\x41\x44\x64\x2b\x61\x75\x74\x6f\x5f\x70\x72\x65\x70\x65\x6e\x64\x5f\x66\x69\x6c\x65\x25\x33\x64\x70\x68\x70\x3a\x2f\x2f\x69\x6e\x70\x75\x74\x22\x3b\x7d”, null, null, null, null, 956503, “945461”]: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xADd_all…’ for column mauticdb
.live_page_hits
.query
at row 1 {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO live_page_hits (date_hit, date_left, country, region, city, isp, organization, code, referer, url, url_title, user_agent, remote_host, page_language, browser_languages, tracking_id, source, source_id, query, page_id, redirect_id, email_id, lead_id, ip_id, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params ["2024-10-29 14:39:09", null, null, null, null, null, null, 404, null, null, null, null, null, null, "a:0:{}", "0c71hu82j4hhplu33oyvg1q", null, null, "\x61\x3a\x33\x3a\x7b\x73\x3a\x35\x35\x3a\x22\xad\x64\x5f\x61\x6c\x6c\x6f\x77\x5f\x75\x72\x6c\x5f\x69\x6e\x63\x6c\x75\x64\x65\x3d\x31\x5f\xad\x64\x5f\x61\x75\x74\x6f\x5f\x70\x72\x65\x70\x65\x6e\x64\x5f\x66\x69\x6c\x65\x3d\x70\x68\x70\x3a\x2f\x2f\x69\x6e\x70\x75\x74\x22\x3b\x73\x3a\x30\x3a\x22\x22\x3b\x73\x3a\x31\x38\x32\x3a\x22\x3c\x3f\x70\x68\x70\x5f\x73\x68\x65\x6c\x6c\x5f\x65\x78\x65\x63\x28\x62\x61\x73\x65\x36\x34\x5f\x64\x65\x63\x6f\x64\x65\x28\x22\x57\x44\x30\x6b\x4b\x47\x4e\x31\x63\x6d\x77\x67\x61\x48\x52\x30\x63\x44\x6f\x76\x4c\x7a\x6b\x30\x4c\x6a\x45\x31\x4e\x69\x34\x78\x4e\x7a\x63\x75\x4d\x54\x41\x35\x4c\x33\x4e\x6f\x49\x48\x78\x38\x49\x48\x64\x6e\x5a\x58\x51\x67\x61\x48\x52\x30\x63\x44\x6f\x76\x4c\x7a\x6b\x30\x4c\x6a\x45\x31\x4e\x69\x34\x78\x4e\x7a\x63\x75\x4d\x54\x41\x35\x4c\x33\x4e\x6f\x49\x43\x31\x50\x4c\x53\x6b\x37\x49\x47\x56\x6a\x61\x47\x38\x67\x49\x69\x52\x59\x49\x69\x42\x38\x49\x48\x4e\x6f\x49\x43\x31\x7a\x49\x47\x4e\x32\x5a\x56\x38\x79\x4d\x44\x49\x30\x58\x7a\x51\x31\x4e\x7a\x63\x75\x63\x32\x56\x73\x5a\x6e\x4a\x6c\x63\x41\x22\x3b\x73\x3a\x34\x32\x3a\x22\x3d\x22\x29\x29\x3b\x20\x65\x63\x68\x6f\x28\x6d\x64\x35\x28\x22\x48\x65\x6c\x6c\x6f\x20\x43\x56\x45\x2d\x32\x30\x32\x34\x2d\x34\x35\x37\x37\x22\x29\x29\x3b\x20\x3f\x3e\x22\x3b\x73\x3a\x38\x3a\x22\x70\x61\x67\x65\x5f\x75\x72\x6c\x22\x3b\x73\x3a\x39\x37\x3a\x22\x68\x74\x74\x70\x73\x3a\x2f\x2f\x33\x34\x2e\x32\x31\x37\x2e\x34\x33\x2e\x31\x32\x32\x2f\x68\x65\x6c\x6c\x6f\x2e\x77\x6f\x72\x6c\x64\x3f\x25\x41\x44\x64\x2b\x61\x6c\x6c\x6f\x77\x5f\x75\x72\x6c\x5f\x69\x6e\x63\x6c\x75\x64\x65\x25\x33\x64\x31\x2b\x25\x41\x44\x64\x2b\x61\x75\x74\x6f\x5f\x70\x72\x65\x70\x65\x6e\x64\x5f\x66\x69\x6c\x65\x25\x33\x64\x70\x68\x70\x3a\x2f\x2f\x69\x6e\x70\x75\x74\x22\x3b\x7d", null, null, null, null, 956503, "945461"]:\n\nSQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xADd_all…’ for column mauticdb
.live_page_hits
.query
at row 1 at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xADd_all…’ for column mauticdb
.live_page_hits
.query
at row 1 at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xADd_all…’ for column mauticdb
.live_page_hits
.query
at row 1 at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”} {“hostname”:“ip-10-0-0-83.us-west-2.compute.internal”,“pid”:520023}
[2024-10-29 14:39:09] mautic.CRITICAL: Uncaught PHP Exception Doctrine\ORM\Exception\EntityManagerClosed: “The EntityManager is closed.” at /var/www/html/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/Exception/EntityManagerClosed.php line 11 {“exception”:“[object] (Doctrine\ORM\Exception\EntityManagerClosed(code: 0): The EntityManager is closed. at /var/www/html/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/Exception/EntityManagerClosed.php:11)”} {“hostname”:“ip-10-0-0-83.us-west-2.compute.internal”,“pid”:520023}
[2024-10-29 16:50:28] mautic.WARNING: PHP Warning - Undefined array key “path” - in file /var/www/html/mautic/app/bundles/CoreBundle/Controller/ExceptionController.php - at line 111 {“hostname”:“ip-10-0-0-83.us-west-2.compute.internal”,“pid”:522076}
[2024-10-29 16:50:28] mautic.WARNING: PHP Warning - Undefined array key “path” - in file /var/www/html/mautic/app/bundles/CoreBundle/Controller/ExceptionController.php - at line 111 {“hostname”:“ip-10-0-0-83.us-west-2.compute.internal”,“pid”:520023}
[2024-10-29 16:50:28] mautic.WARNING: PHP Warning - Undefined array key “path” - in file /var/www/html/mautic/app/bundles/CoreBundle/Controller/ExceptionController.php - at line 111 {“hostname”:“ip-10-0-0-83.us-west-2.compute.internal”,“pid”:520019}
[2024-10-29 16:50:28] mautic.WARNING: PHP Warning - Undefined array key “path” - in file /var/www/html/mautic/app/bundles/CoreBundle/Controller/ExceptionController.php - at line 111 {“hostname”:“ip-10-0-0-83.us-west-2.compute.internal”,“pid”:526167}
Steps I have tried to fix the problem: We’ve tried copying certain database tables from the old instance to the new one. The data doesn’t appear and we get the errors I posted above.