@tehseenkn opened this Issue on January 3rd 2017

Mysql 5.6.16-Log
piwik 2.11.2

Http Link:

http://localhost/pwk2112/piwik.php?action_name=&idsite=1&rec=1&r=713679&h=12&m=43&s=27&url=http%3A%2F%2Fcategory%2F%C3%90_%C3%90%C2%BA%C3%91_%C3%90%C2%B5%C3%91_%C3%91_%C3%91%C6%92%C3%90%C2%B0%C3%91%E2%82%AC%C3%91%E2%80%B9%2Fcid-90409%2F%26%26page_yxm%3D18&_id=231bc7088d3af7ec&_idts=1483421432&_idvc=2&_idn=0&_refts=0&_viewts=1483429407&send_image=0&pdf=1&qt=0&realp=0&wma=0&dir=0&fla=1&java=0&gears=0&ag=0&cookie=1&res=1600x900&gt_ms=1776
actionname=&idsite=1&rec=1&r=713679&h=12&m=43&s=27&url=http%3A%2F%2F%2Fcategory%2F%C3%90%C3%90%C2%BA%C3%91%C3%90%C2%B5%C3%91%C3%91_%C3%91%C6%92%C3%90%C2%B0%C3%91%E2%82%AC%C3%91%E2%80%B9%2Fcid-90409%2F%26%26page_yxm%3D18&_id=231bc7088d3af7ec&_idts=1483421432&_idvc=2&_idn=0&_refts=0&_viewts=1483429407&send_image=0&pdf=1&qt=0&realp=0&wma=0&dir=0&fla=1&java=0&gears=0&ag=0&cookie=1&res=1600x900&gt_ms=1776

when i visit this link on local machine the above error occur.

Error in Piwik (tracker): Error query: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xC3_\xC3\xC2...' for column 'name' at row 1 In query: INSERT INTO piwik_log_action (name, hash, type, url_prefix) VALUES (?,CRC32(?),?,?)

@mattab commented on January 3rd 2017 Member

Hi @tehseenkn
This seems to not trigger any error in Piwik 3. although the Page URL report doesn't maybe look correct:

russian

Could you please ugprade to Piwik 3 and report whether it works well or not?

@tehseenkn commented on January 5th 2017

Hi @mattab
Is there any solution for version Piwik 2.11.2 for the above issue ?

@mattab commented on February 20th 2017 Member

Upgrade ASAP to Piwik 3!!

There are many security issues in 2.11.2 so you are very unsafe

@tehseenkn commented on April 12th 2017

I have upgraded piwik 3.0.2 and php 7.0.16 x64 nts, but still same type of error is coming in php error file.
Now this error occurs
[12-Apr-2017 04:42:45 UTC] Error in Piwik (tracker): Error query: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xD0_\xD0\xBB\xD0\xB5...' for column 'name' at row 1 In query: INSERT INTO piwik_log_action (name, hash, type, url_prefix) VALUES (?,CRC32(?),?,?) Parameters: array ( 0 => 'Счетчики Ð_лектроÑ_нергии/?cid=91701', 1 => 'Счетчики Ð_лектроÑ_нергии/?cid=91701', 2 => 1, 3 => 0, )

@mattab commented on June 21st 2017 Member

@tehseenkn What is the full piwik.php string that you can reproduce this error?

@MERamadan commented on May 1st 2019
@MERamadan commented on May 1st 2019

Here the full Matomo error page

<div class="box">

    <div class="header">
        <h1>An error occurred</h1>
    </div>

    <div class="content"><p>Error query: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xD9_\xD8\xA7\xD8\xB5...' for column 'name' at row 1 In query: INSERT INTO ec_log_action (name, hash, type, url_prefix) VALUES (?,CRC32(?),?,?) Parameters: array (
  0 => '10.50.158.200:4040/ec_followup/1645ac8d-19f3-e811-813d-005056bb148b/FollowUp/FollowUp/ت�_اصيل المتابعة - 2018/6/014/08.html',
  1 => '10.50.158.200:4040/ec_followup/1645ac8d-19f3-e811-813d-005056bb148b/FollowUp/FollowUp/ت�_اصيل المتابعة - 2018/6/014/08.html',
  2 => 1,
  3 => 0,
)</p><span style="color: <a href='/888888'>#888888</a>">Backtrace:<br /><pre><a href='/0'>#0</a> D:\matomo-latest\matomo\core\Tracker\Model.php(182): Piwik\Tracker\Db\Pdo\Mysql->query('INSERT INTO ec_...', Array)
<a href='/1'>#1</a> D:\matomo-latest\matomo\core\Tracker\Model.php(163): Piwik\Tracker\Model->insertNewAction('10.50.158.200:4...', 1, 0)
<a href='/2'>#2</a> D:\matomo-latest\matomo\core\Tracker\TableLogAction.php(101): Piwik\Tracker\Model->createNewIdAction('10.50.158.200:4...', 1, 0)
<a href='/3'>#3</a> D:\matomo-latest\matomo\core\Tracker\TableLogAction.php(49): Piwik\Tracker\TableLogAction::insertNewIdsAction(Array, Array)
<a href='/4'>#4</a> D:\matomo-latest\matomo\core\Tracker\Action.php(345): Piwik\Tracker\TableLogAction::loadIdsAction(Array)
<a href='/5'>#5</a> D:\matomo-latest\matomo\plugins\Actions\Tracker\ActionsRequestProcessor.php(70): Piwik\Tracker\Action->loadIdsFromLogActionTable()
<a href='/6'>#6</a> D:\matomo-latest\matomo\core\Tracker\Visit.php(152): Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor->afterRequestProcessed(Object(Piwik\Tracker\Visit\VisitProperties), Object(Piwik\Tracker\Request))
<a href='/7'>#7</a> D:\matomo-latest\matomo\core\Tracker.php(138): Piwik\Tracker\Visit->handle()
<a href='/8'>#8</a> D:\matomo-latest\matomo\core\Tracker\Handler.php(49): Piwik\Tracker->trackRequest(Object(Piwik\Tracker\Request))
<a href='/9'>#9</a> D:\matomo-latest\matomo\core\Tracker.php(120): Piwik\Tracker\Handler->process(Object(Piwik\Tracker), Object(Piwik\Tracker\RequestSet))
<a href='/10'>#10</a> D:\matomo-latest\matomo\core\Tracker.php(97): Piwik\Tracker->track(Object(Piwik\Tracker\Handler), Object(Piwik\Tracker\RequestSet))
<a href='/11'>#11</a> D:\matomo-latest\matomo\piwik.php(76): Piwik\Tracker->main(Object(Piwik\Tracker\Handler), Object(Piwik\Tracker\RequestSet))
<a href='/12'>#12</a> {main}</pre></span>    </div>

    <div class="footer">
        <a href="index.php">&laquo; Back to Matomo</a>
    </div>

</div>
@tsteur commented on May 1st 2019 Member
Powered by GitHub Issue Mirror