Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error in Piwik (tracker): Error query: SQLSTATE[HY000]: General error: 1366 Incorrect string value: #11136

Closed
tehseenkn opened this issue Jan 3, 2017 · 9 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. worksforme The issue cannot be reproduced and things work as intended.

Comments

@tehseenkn
Copy link

tehseenkn commented Jan 3, 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
action_name=&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(?),?,?)

@tehseenkn tehseenkn changed the title Error in Piwik (tracker): Error query: SQLSTATE[HY000]: Error in Piwik (tracker): Error query: SQLSTATE[HY000]: General error: 1366 Incorrect string value: Jan 3, 2017
@mattab
Copy link
Member

mattab commented Jan 3, 2017

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
Copy link
Author

tehseenkn commented Jan 5, 2017

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

@mattab
Copy link
Member

mattab commented Feb 20, 2017

Upgrade ASAP to Piwik 3!!

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

@mattab mattab closed this as completed Feb 20, 2017
@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label Feb 20, 2017
@tehseenkn
Copy link
Author

tehseenkn commented Apr 12, 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
Copy link
Member

mattab commented Jun 21, 2017

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

@mattab mattab reopened this Jun 21, 2017
@mattab mattab added Bug For errors / faults / flaws / inconsistencies etc. Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users. and removed answered For when a question was asked and we referred to forum or answered it. labels Jun 21, 2017
@MERamadan
Copy link

MERamadan commented May 1, 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: #888888">Backtrace:<br /><pre>#0 D:\matomo-latest\matomo\core\Tracker\Model.php(182): Piwik\Tracker\Db\Pdo\Mysql->query('INSERT INTO ec_...', Array)
#1 D:\matomo-latest\matomo\core\Tracker\Model.php(163): Piwik\Tracker\Model->insertNewAction('10.50.158.200:4...', 1, 0)
#2 D:\matomo-latest\matomo\core\Tracker\TableLogAction.php(101): Piwik\Tracker\Model->createNewIdAction('10.50.158.200:4...', 1, 0)
#3 D:\matomo-latest\matomo\core\Tracker\TableLogAction.php(49): Piwik\Tracker\TableLogAction::insertNewIdsAction(Array, Array)
#4 D:\matomo-latest\matomo\core\Tracker\Action.php(345): Piwik\Tracker\TableLogAction::loadIdsAction(Array)
#5 D:\matomo-latest\matomo\plugins\Actions\Tracker\ActionsRequestProcessor.php(70): Piwik\Tracker\Action->loadIdsFromLogActionTable()
#6 D:\matomo-latest\matomo\core\Tracker\Visit.php(152): Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor->afterRequestProcessed(Object(Piwik\Tracker\Visit\VisitProperties), Object(Piwik\Tracker\Request))
#7 D:\matomo-latest\matomo\core\Tracker.php(138): Piwik\Tracker\Visit->handle()
#8 D:\matomo-latest\matomo\core\Tracker\Handler.php(49): Piwik\Tracker->trackRequest(Object(Piwik\Tracker\Request))
#9 D:\matomo-latest\matomo\core\Tracker.php(120): Piwik\Tracker\Handler->process(Object(Piwik\Tracker), Object(Piwik\Tracker\RequestSet))
#10 D:\matomo-latest\matomo\core\Tracker.php(97): Piwik\Tracker->track(Object(Piwik\Tracker\Handler), Object(Piwik\Tracker\RequestSet))
#11 D:\matomo-latest\matomo\piwik.php(76): Piwik\Tracker->main(Object(Piwik\Tracker\Handler), Object(Piwik\Tracker\RequestSet))
#12 {main}</pre></span>    </div>

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

</div>

@tsteur
Copy link
Member

tsteur commented May 1, 2019

I reckon this refs #9785 ?

@sgiehl
Copy link
Member

sgiehl commented Oct 9, 2023

We have meanwhile introduced support for UTF8mb4, which should have fixed issues like this one.

@sgiehl sgiehl closed this as not planned Won't fix, can't repro, duplicate, stale Oct 9, 2023
@sgiehl sgiehl added worksforme The issue cannot be reproduced and things work as intended. and removed Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users. labels Oct 9, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc. worksforme The issue cannot be reproduced and things work as intended.
Projects
None yet
Development

No branches or pull requests

5 participants