Hello,
Can anyone help me with this:
When I’m logged-in in mautic, then I can open any mautic landing page in the same browser. But if I logout and want to access landing page as a visitor, then get a 500 Internal Server error. This is the error log:
[2017-01-13 00:22:49] 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 = 40’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’” at /home/supporte/public_html/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 = 40’:nnSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home/supporte/public_html/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 /home/supporte/public_html/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 /home/supporte/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []
PHP Version 5.6.29
mautic v2.5.1
cPanel, shared server
Thanks
Hello,
Can anyone help me with this:
When I’m logged-in in mautic, then I can open any mautic landing page in the same browser. But if I logout and want to access landing page as a visitor, then get a 500 Internal Server error. This is the error log:
[2017-01-13 00:22:49] 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 = 40’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’” at /home/supporte/public_html/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 = 40’:nnSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘es.device_fingerprint’ in ‘field list’ at /home/supporte/public_html/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 /home/supporte/public_html/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 /home/supporte/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []
PHP Version 5.6.29
mautic v2.5.1
cPanel, shared server
Thanks
Thanks! It works
I have updated the schema still getting the error in mautic log. using version 2.9.0
I am using 2.9.1 and updated schema still getting the error in mautic log. Though error is different one but scenario is similar.
[2017-07-28 06:53:55] mautic.WARNING: PHP Warning - mysqli_stmt::execute(): Error reading result set’s header - in file /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php - at line 164 [] []
[2017-07-28 06:53:55] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionDriverException: "An exception occurred while executing ‘SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.type AS type_3, s0_.event_type AS event_type_4, s0_.event_order AS event_order_5, s0_.properties AS properties_6, s0_.trigger_date AS trigger_date_7, s0_.trigger_interval AS trigger_interval_8, s0_.trigger_interval_unit AS trigger_interval_unit_9, s0_.trigger_mode AS trigger_mode_10, s0_.decision_path AS decision_path_11, s0_.temp_id AS temp_id_12, s0_.channel AS channel_13, s0_.channel_id AS channel_id_14, s1_.is_published AS is_published_15, s1_.date_added AS date_added_16, s1_.created_by AS created_by_17, s1_.created_by_user AS created_by_user_18, s1_.date_modified AS date_modified_19, s1_.modified_by AS modified_by_20, s1_.modified_by_user AS modified_by_user_21, s1_.checked_out AS checked_out_22, s1_.checked_out_by AS checked_out_by_23, s1_.checked_out_by_user AS checked_out_by_user_24, s1_.id AS id_25, s1_.name AS name_26, s1_.description AS description_27, s1_.publish_up AS publish_up_28, s1_.publish_down AS publish_down_29, s1_.canvas_settings AS canvas_settings_30, s2_.id AS id_31, s2_.name AS name_32, s2_.description AS description_33, s2_.type AS type_34, s2_.event_type AS event_type_35, s2_.event_order AS event_order_36, s2_.properties AS properties_37, s2_.trigger_date AS trigger_date_38, s2_.trigger_interval AS trigger_interval_39, s2_.trigger_interval_unit AS trigger_interval_unit_40, s2_.trigger_mode AS trigger_mode_41, s2_.decision_path AS decision_path_42, s2_.temp_id AS temp_id_43, s2_.channel AS channel_44, s2_.channel_id AS channel_id_45, s3_.id AS id_46, s3_.name AS name_47, s3_.description AS description_48, s3_.type AS type_49, s3_.event_type AS event_type_50, s3_.event_order AS event_order_51, s3_.properties AS properties_52, s3_.trigger_date AS trigger_date_53, s3_.trigger_interval AS trigger_interval_54, s3_.trigger_interval_unit AS trigger_interval_unit_55, s3_.trigger_mode AS trigger_mode_56, s3_.decision_path AS decision_path_57, s3_.temp_id AS temp_id_58, s3_.channel AS channel_59, s3_.channel_id AS channel_id_60, s4_.is_published AS is_published_61, s4_.date_added AS date_added_62, s4_.created_by AS created_by_63, s4_.created_by_user AS created_by_user_64, s4_.date_modified AS date_modified_65, s4_.modified_by AS modified_by_66, s4_.modified_by_user AS modified_by_user_67, s4_.checked_out AS checked_out_68, s4_.checked_out_by AS checked_out_by_69, s4_.checked_out_by_user AS checked_out_by_user_70, s4_.id AS id_71, s4_.name AS name_72, s4_.description AS description_73, s4_.publish_up AS publish_up_74, s4_.publish_down AS publish_down_75, s4_.canvas_settings AS canvas_settings_76 FROM sdcampaign_events s0_ INNER JOIN sdcampaigns s1_ ON s0_.campaign_id = s1_.id LEFT JOIN sdcampaign_events s2_ ON s0_.id = s2_.parent_id LEFT JOIN sdcampaign_events s3_ ON s0_.parent_id = s3_.id LEFT JOIN sdcampaigns s4_ ON s2_.campaign_id = s4_.id WHERE s1_.is_published = ? AND (s1_.publish_down IS NULL OR s1_.publish_down >= ?) AND (s1_.publish_up IS NULL OR s1_.publish_up <= ?) AND s0_.type = ? AND s1_.id IN (?) AND (s0_.id NOT IN (SELECT s5_.id FROM sdcampaign_lead_event_log s6_ LEFT JOIN sdcampaign_events s5_ ON s6_.event_id = s5_.id LEFT JOIN sdleads s7_ ON s6_.lead_id = s7_.id WHERE s5_.id = s0_.id AND s7_.id = ?)) AND (s0_.decision_path <> ‘no’ OR s0_.decision_path IS NULL) ORDER BY s0_.event_order ASC, s2_.event_order ASC’ with params [1, “2017-07-28 06:53:55”, “2017-07-28 06:53:55”, “email.open”, 13, 22]:
Can anyone please help me?