Your software
My Mautic version is:v3.0.1
My PHP version is: 7.2.32
Your problem
My problem is:
Tried to test drive twitter integration and chose to follow @potus for lack of anything better. Multitude of log errors. No contacts created. See below.
These errors are showing in the log:
Can’t show the errors because this forum software does not allow more than 10 mentions in one post, and there are mentions in twitter error logs. . . so replaced mentions with the phrase “at”.
Here are the logs:
cuting Monitor Item 2
Creating new lead
An exception occurred while executing 'INSERT INTO xxxxxxxx_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, “2020-07-29 00:57:00”, null, " “, null, null, null, null, null, null, 0, “2020-07-29 00:56:56”, “a:0:{}”, “a:1:{s:7:“Twitter”;a:3:{s:7:“profile”;a:9:{s:13:“profileHandle”;s:15:“lobstahsinmaine”;s:4:“name”;s:53:”\ud83e\udd85 \ud83c\uddfa\ud83c\uddf8 \ud83d\udc38~Freedom Patriot~\ud83d\udc38 \ud83c\uddfa\ud83c\uddf8 \ud83e\udd85”;s:8:“location”;s:10:“Maine, USA”;s:11:“description”;s:58:“I support President Trump and America! #notabot #TRUMP2020”;s:3:“url”;s:0:"";s:9:“time_zone”;s:0:"";s:4:“lang”;s:0:"";s:5:“email”;s:0:"";s:12:“profileImage”;s:69:“https://pbs.twimg.com/profile_images/1258087138895163392/-Iz84TYd.jpg";}s:8:“activity”;a:3:{s:6:“tweets”;a:10:{i:0;a:4:{s:5:“tweet”;s:53:"RT atJonessense: Trump wore a mask and 2 days later…”;s:3:“url”;s:65:“https://twitter.com/812428408735039492/status/1288277098499649541";s:11:“coordinates”;N;s:9:“published”;s:30:"Wed Jul 29 00:56:09 +0000 2020”;}i:1;a:4:{s:5:“tweet”;s:35:“RT atDonaldJTrumpJr: It 100% should.”;s:3:“url”;s:65:“https://twitter.com/812428408735039492/status/1288276632852205568";s:11:“coordinates”;N;s:9:“published”;s:30:"Wed Jul 29 00:54:18 +0000 2020”;}i:2;a:4:{s:5:“tweet”;s:95:“RT atDilaraEsengil: oh i love love love love her!!! I love her accent too! God BLESS her! AMEN!”;s:3:“url”;s:65:“https://twitter.com/812428408735039492/status/1288276535393255431";s:11:“coordinates”;N;s:9:“published”;s:30:"Wed Jul 29 00:53:55 +0000 2020”;}i:3;a:4:{s:5:“tweet”;s:142:“RT atMalcolmOutLoud: Host Terry Beatley - STERILIZING CHILDREN, Transgender Pediatrics https://t.co/hYvD6zY6lt #Liberty https://t.co/jLSaLku\u2026";s:3:“url”;s:65:“https://twitter.com/812428408735039492/status/1288276295864979457”;s:11:“coordinates”;N;s:9:“published”;s:30:"Wed Jul 29 00:52:58 +0000 2020”;}i:4;a:4:{s:5:“tweet”;s:113:“RT atHeatherChilders: .atJim_Jordan\u2019s opening video of riots and violence- #BarrHearing \n https://t.co/wlxubNMca3";s:3:“url”;s:65:“https://twitter.com/812428408735039492/status/1288276246741360641”;s:11:“coordinates”;N;s:9:“published”;s:30:"Wed Jul 29 00:52:46 +0000 2020”;}i:5;a:4:{s:5:“tweet”;s:146:“RT atJennaEllisEsq: BREAKING: atGenFlynn\u2019s attorney Sidney Powell\u2019s Twitter has been suspended for her tweet on hydroxychloroquine that Presi\u2026”;s:3:“url”;s:65:“https://twitter.com/812428408735039492/status/1288276041790873600";s:11:“coordinates”;N;s:9:“published”;s:30:"Wed Jul 29 00:51:58 +0000 2020”;}i:6;a:4:{s:5:“tweet”;s:142:“RT atTheCollectiveQ: Office of the Press Secretary\nFOR IMMEDIATE RELEASE\nJuly 28, 2020\n\nPRESIDENT DONALD J. TRUMP IS COMMITTED TO ENDING AME\u2026”;s:3:“url”;s:65:“https://twitter.com/812428408735039492/status/1288276000657354752";s:11:“coordinates”;N;s:9:“published”;s:30:"Wed Jul 29 00:51:48 +0000 2020”;}i:7;a:4:{s:5:“tweet”;s:58:“RT atSantaFeChix: Great win for Upstate NY !!! GO KODAK !!!”;s:3:“url”;s:65:“https://twitter.com/812428408735039492/status/1288275916813225984";s:11:“coordinates”;N;s:9:“published”;s:30:"Wed Jul 29 00:51:28 +0000 2020”;}i:8;a:4:{s:5:“tweet”;s:179:“RT atGoldfish6801: atBreaking911 Yea baby!\n\nBring the pharmaceuticals back to the States. \n\n<span class=“emoji-outer emoji-sizer”><span class=“emoji-inner emoji1f60a”></span></span>”;s:3:“url”;s:65:“https://twitter.com/812428408735039492/status/1288275640123371528";s:11:“coordinates”;N;s:9:“published”;s:30:"Wed Jul 29 00:50:22 +0000 2020”;}i:9;a:4:{s:5:“tweet”;s:144:“RT atJujukitty3: atbalboa_ad atBreaking911 Not only Hydroxychloroquine. None of our meds or food should come from China. They can\u2019t be trusted\u2026”;s:3:“url”;s:65:“https://twitter.com/812428408735039492/status/1288275483302473728";s:11:“coordinates”;N;s:9:“published”;s:30:"Wed Jul 29 00:49:44 +0000 2020”;}}s:6:“photos”;a:1:{i:0;a:1:{s:3:“url”;s:47:“https://pbs.twimg.com/media/EeBiX0wXYAcxLfv.jpg";}}s:4:“tags”;a:2:{s:7:“Liberty”;a:2:{s:5:“count”;i:1;s:3:“url”;s:39:“https://twitter.com/search?q=%23Liberty”;}s:11:“BarrHearing”;a:2:{s:5:“count”;i:1;s:3:“url”;s:43:“https://twitter.com/search?q=%23BarrHearing”;}}}s:11:“lastRefresh”;s:19:"2020-07-29 00:56:59”;}}", “2020-07-29 00:57:00”, “Twitter”, null, “\ud83e\udd85 \ud83c\uddfa\ud83c\uddf8 \ud83d\udc38~Freedom Patriot~\ud83d\udc38 \ud83c\uddfa\ud83c\uddf8”, “\ud83e\udd85”, null, null, null, null, null, null, null, null, null, null, null, “Maine, USA”, null, null]:
SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xF0\x9F\xA6\x85 \xF0…’ for column ‘social_cache’ at row 1
Creating new lead
The EntityManager is closed.
Creating new lead
The EntityManager is closed.
Creating new lead
The EntityManager is closed.
Creating new lead
The EntityManager is closed.
Creating new lead
The EntityManager is closed.
Creating new lead
The EntityManager is closed.
Creating new lead
The EntityManager is closed.
Creating new lead
The EntityManager is closed.
Creating new lead
The EntityManager is closed.
Creating new lead
The EntityManager is closed.
Creating new lead
The EntityManager is closed.
Creating new lead
The EntityManager is closed.
Creating new lead
The EntityManager is closed.
Creating new lead
Steps I have tried to fix the problem:
