Error: SQLSTATE[42S22]

Support & Bugs
21

Ok… Try this patch:

Index: plugins/Dashboard/Controller.php
===================================================================
--- plugins/Dashboard/Controller.php    (revision 1329)
+++ plugins/Dashboard/Controller.php    (working copy)
@@ -50,6 +50,9 @@
      */
     protected function saveLayoutForUser( $login, $idDashboard, $layout)
     {
+        // layout was JSON.stringified
+        $layout = str_replace("\\\"", "\"", $layout);
+
         $paramsBind = array($login, $idDashboard, $layout, $layout);
         Piwik_Query('INSERT INTO '.Piwik::prefixTable('user_dashboard') .
                     ' (login, iddashboard, layout)
22

[quote=vipsoft @ Jul 26 2009, 02:03 PM]This script returns phpinfo. I’m interested in knowing what version of PHP you are running and on what platform (Windows, Linux, …)? Whether your build has the native json_encode/json_decode, or uses the emulated functions? And anything else that might explain the difference.

<?php phpinfo();

FF3.5 and IE8 have their own JSON.stringify implementations, so maybe that’s the source of conflict. Try replacing libs/javascript/json2.js with the updated version from: http://www.json.org/json2.js[/quote]
this is the phpinfo from my server. i hope thats what you need.
http://phpinfo.bplaced.net/

the new jsons2.js didn´t help.

23

[quote=vipsoft @ Jul 26 2009, 02:40 PM]Ok… Try this patch:

Index: plugins/Dashboard/Controller.php
===================================================================
--- plugins/Dashboard/Controller.php	(revision 1329)
+++ plugins/Dashboard/Controller.php	(working copy)
@@ -50,6 +50,9 @@
....[/quote]

nope.
problem not solved style_emoticons/<#EMO_DIR#>/sad.gif
24

http://www.theo.bplaced.net/phpinfo.php

sorry, i think this my “own” phpinfo…

25

Please try again using the following steps:

Logout from Piwik.
Apply the patch.
Remove files in tmp/templates_c/*
Truncate the user_dashboard table.
Login to Piwik
Make changes to your dashboard.
Logout from Piwik.
Login to Piwik.

26

did every stepp…three times.
i´m sorry…but it is not working style_emoticons/<#EMO_DIR#>/sad.gif

27

Did the error message in the browser change?

28

no. everything the same.

i never got an error message - see screenshot in post #5

29

Sorry, I’m a bit confused. Where did the error message in post #9 come from?

30

oh sorry. i thougt you mean an error in the UI.
in the browser-log the error is similar. i think the difference is just because of different widgets.

NEW:
Fehler: illegal character
Quelldatei: http://www.theo.bplaced.net/piwik/index.php?module=CoreHome&action=index&idSite=1&period=day&date=today#module=Dashboard&action=embeddedIndex&idSite=1&period=day&date=today
Zeile: 0, Spalte: 27
Quelltext:
piwik.dashboardLayout = [[{\"uniqueId\":\"widgetVisitsSummarygetEvolutionGraph\",\"parameters\":{\"module\":\"VisitsSummary\",\"action\":\"getEvolutionGraph\",\"columns\":[\"nb_visits\"]}},{\"uniqueId\":\"widgetVisitorInterestgetNumberOfVisitsPerVisitDura

OLD:
Fehler: illegal character
Quelldatei: http://www.theo.bplaced.net/piwik/index.php?module=CoreHome&action=index&idSite=1&period=day&date=today#module=Dashboard&action=embeddedIndex&idSite=1&period=day&date=today
Zeile: 0, Spalte: 27
Quelltext:
piwik.dashboardLayout = [[{\"uniqueId\":\"widgetVisitsSummarygetEvolutionGraph\",\"parameters\":{\"module\":\"VisitsSummary\",\"action\":\"getEvolutionGraph\",\"columns\":[\"nb_visits\"]}},{\"uniqueId\":\"widgetActionsgetActions\",\"parameters\":{\"module
31

ooooh!
i think i found the problem…but not solved.
must be something with bplaced.net - my webspace-host.
at least i found one person who has exactly the same problem.

i will wait for an admins answer from them…i´ll report.

32

I think I err’d in that patch. I moved the str_replace() to getDashboardView().

Index: Controller.php
===================================================================
--- Controller.php    (revision 1329)
+++ Controller.php    (working copy)
@@ -20,6 +20,10 @@
         $view = new Piwik_View($template);
         $this->setGeneralVariablesView($view);
         $layout = html_entity_decode($this->getLayout());
+
+        // layout was JSON.stringified
+        $layout = str_replace("\\\"", "\"", $layout);
+
         if(!empty($layout)
             && strstr($layout, '[[') == false) {
             $layout = "'$layout'";
33

[quote=vipsoft @ Jul 27 2009, 12:43 AM]I think I err’d in that patch. I moved the str_replace() to getDashboardView().

Index: Controller.php
===================================================================
--- Controller.php    (revision 1329)
+++ Controller.php    (working copy)
@@ -20,6 +20,10 @@
         $view = new Piwik_View($template);
         $this->setGeneralVariablesView($view);
         $layout = html_entity_decode($this->getLayout());
+
+        // layout was JSON.stringified
+        $layout = str_replace("\\\"", "\"", $layout);
+
         if(!empty($layout)
             && strstr($layout, '[[') == false) {
             $layout = "'$layout'";

[/quote]
YES!!!
THATS IT!

thanks a lot!
juhuuuuuu