Please try updating to latest 2.15. That should at least fix the issue that some data is not lost. See #8765 / #7766

i forgot to mention but i just update to 2.14.3

i update to 2.15. from here: https://github.com/piwik/piwik

and the problem wasnt solved :(

Wasn't solved for new entries, aswell? Already broken entries won't get fixed later...

yes, new entries also shows as "xx_$$XX_X" (signs)...

Could you check in your browsers dev tools which request params are send to the piwik tracking?
Would be good to know, which characters can't be printed there...

what parametere do you look for?

i sent the data over the url, for example: "http://localhost/Home?q=בוהן"

will save in the db as "xxxx_".

Ok. We'll need to test that. Maybe it's related to #8790

i put every letter separately to check what are the problematic letters:

is there any progress?

i want to try debuggin the problem, what function get the request? (or how should i start?)

thanks a lot!

Hi @galr52 maybe try to enable debugging on the tracker: http://developer.piwik.org/api-reference/tracking-api#debugging-the-tracker

Maybe you find some interesting information?

after i debug it i found that the problem start at piwik/plugins/Actions/Actions/ActionSiteSearch.php row 231 - $parsedUrl = @parse_url($originalUrl);

the request is ok until it parse it and then some unicode characters get messy.

any idea?

i solved the problem by adding this function to the ActionSiteSearch.php:

function safe_urlencode($txt){
  $result = preg_replace_callback("/[^-\._~:\/\?#\\[\\]@!\$&'\(\)\*\+,;=]+/",
    function ($match) {
      return rawurlencode($match[0]);
    }, $txt);
  return ($result);
}

and call this function before parsing the url

@galr52 can you paste here the exact URL that was $originalUrl ? we wil try to reproduce the issue and add an automated test for this to make sure it does not break in the future

http://localhost:20891/Home/Index?q=שום+דבר+לא+יעצור+אותי
or
http://localhost:20891/Home/Index?q=חלת+בצל

any url with the "not exists" character will end up as "xx_xxxx_Xx_".

when i use the function above all works perfect in any languege i tested.

i had the same problem in the Action>Pages so i added a call to the function in the init function

in piwik/core/Tracker.php

    private function init()
    {
        $this->handleFatalErrors();
        // Call to safe_urlencode
        $_GET['url'] = this->safe_urlencode($_GET['url']);

        if ($this->isDebugModeEnabled()) {
            ErrorHandler::registerErrorHandler();
            ExceptionHandler::setUp();
            Common::printDebug("Debug enabled - Input parameters: ");
            Common::printDebug(var_export($_GET, true));
        }
    }

I cannot reproduce this issue in Piwik 2.15.0 - can someone else reproduce this?

It works for me to track http://localhost:20891/Home/Index?q=שום+דבר+לא+יעצור+אותי - both appear well in Page URLs (when I replace q= with hello=) and in Site Search reports.

:( ok thanks for your help

Hi,

We have upgraded to Piwik 3.0.2 and PHP 7.0.16 and getting following error:

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 => '/products/Счетчики Ð_лектроÑ_нергии/?cid=91701', 1 => '/products/Счетчики Ð_лектроÑ_нергии/?cid=91701', 2 => 1, 3 => 0, )

Other characters are been shown fine in dashboard but this error is appearing in PHP error log ?