Hi there,
I am running Mautic 2.5.1.
When sending emails links are working on desktop PC and Mac, but opening the exact same email on a mobile phone or tablet and the links are not working and receive the error.
here is a copy of the link url from the email body.
http://dmpages.com/m/r/8f57dd6d4fce3baccdf81118b?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czoxNDoiY2FtcGFpZ24uZXZlbnQiO2k6MTtpOjY3O31zOjU6ImVtYWlsIjtpOjMzO3M6NDoic3RhdCI7czoxMzoiNTg5M2ExMWM1ZTcwOCI7czo0OiJsZWFkIjtpOjgyNzg0O3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjMzO319
on desktop/laptop perfect. O mobile device results in the following.
“Uh oh! I think I broke it. If I do it again, please report me to the system administrator!
500 Internal Server Error”
for what it’s worth here are a few lines form the system info error log (I have no idea what it all means and if its related to this issue or not)
[2017-02-03 10:39:37] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: “An exception occurred while executing ‘SELECT es.id as id, es.device as device, es.device_fingerprint FROM lead_devices es WHERE es.lead_id = 81880’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’” at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT es.id as id, es.device as device, es.device_fingerprint FROM lead_devices es WHERE es.lead_id = 81880’:nnSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []
[2017-02-03 10:39:40] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: “An exception occurred while executing ‘SELECT es.id as id, es.device as device, es.device_fingerprint FROM lead_devices es WHERE es.lead_id = 65280’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’” at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT es.id as id, es.device as device, es.device_fingerprint FROM lead_devices es WHERE es.lead_id = 65280’:nnSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []
[2017-02-03 05:40:40] mautic.ERROR: Deprecation: SymfonyComponentDependencyInjectionDefinition::setFactoryService(doctrine) is deprecated since version 2.6 and will be removed in 3.0. Use Definition::setFactory() instead. - in file /home3/raymondkent/public_html/dmpages.com/m/vendor/symfony/dependency-injection/Definition.php - at line 204 [] []
[2017-02-03 10:40:58] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: “An exception occurred while executing ‘SELECT es.id as id, es.device as device, es.device_fingerprint FROM lead_devices es WHERE es.lead_id = 83709’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’” at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT es.id as id, es.device as device, es.device_fingerprint FROM lead_devices es WHERE es.lead_id = 83709’:nnSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []
Any ideas how to fix?
Hi there,
I am running Mautic 2.5.1.
When sending emails links are working on desktop PC and Mac, but opening the exact same email on a mobile phone or tablet and the links are not working and receive the error.
here is a copy of the link url from the email body.
on desktop/laptop perfect. O mobile device results in the following.
“Uh oh! I think I broke it. If I do it again, please report me to the system administrator!
500 Internal Server Error”
for what it’s worth here are a few lines form the system info error log (I have no idea what it all means and if its related to this issue or not)
[2017-02-03 10:39:37] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: “An exception occurred while executing ‘SELECT es.id as id, es.device as device, es.device_fingerprint FROM lead_devices es WHERE es.lead_id = 81880’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’” at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT es.id as id, es.device as device, es.device_fingerprint FROM lead_devices es WHERE es.lead_id = 81880’:nnSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []
[2017-02-03 10:39:40] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: “An exception occurred while executing ‘SELECT es.id as id, es.device as device, es.device_fingerprint FROM lead_devices es WHERE es.lead_id = 65280’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’” at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT es.id as id, es.device as device, es.device_fingerprint FROM lead_devices es WHERE es.lead_id = 65280’:nnSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []
[2017-02-03 05:40:40] mautic.ERROR: Deprecation: SymfonyComponentDependencyInjectionDefinition::setFactoryService(doctrine) is deprecated since version 2.6 and will be removed in 3.0. Use Definition::setFactory() instead. - in file /home3/raymondkent/public_html/dmpages.com/m/vendor/symfony/dependency-injection/Definition.php - at line 204 [] []
[2017-02-03 10:40:58] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: “An exception occurred while executing ‘SELECT es.id as id, es.device as device, es.device_fingerprint FROM lead_devices es WHERE es.lead_id = 83709’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’” at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT es.id as id, es.device as device, es.device_fingerprint FROM lead_devices es WHERE es.lead_id = 83709’:nnSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home3/raymondkent/public_html/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []
Any ideas how to fix?
Huge thanks to @MxyzptlkFishStix
The update schema suggestion worked. If I could rate the value of your response it would be “5 stars out of 5”
I would not have known to do this.
I generally do the updates via the Mautic dashboard and ‘generally’ have no issues, other than sometimes having to manually delete the app/cache directory.
To apply the schema update that @MxyzptlkFishStix suggested I typed this in my web browser
[my-mautic-url- install-directory]/s/update/schema
After a little while I saw a confirmation message in my Mautic dashboard, saying the Schema was successfully updated.
To test, I then signed up to my blog to test the email welcome campaign that is sent out. The links NOW work on both mobile and desktop.
I then also tested a couple of previous emails that had link errors that my subscribers forwarded to me, and confirm that they all work now also.
This instruction on how to update the schema was from https://johnlinhart.com/blog/uh-oh-mautic-upgrade-was-not-successful
I hope this helps others who might have a similar anomaly.
Thanks again to @MxyzptlkFishStix and John Linhart for their input.