Sorry for my bad English, I do my best for good understand:
The problem is knowing. With Update to Piwik-version 1.8.x we know the error messages :“SQLSTATE [42000], etc.”
The graphical representation of Piwik is just a huge collection of error messages.
I’m search often the German and English board for results - without success.
I phone with my provider. The staff have worked hard to help.
At the end, have pointed to the support staff on the following wiki:
Piwik Update 1.8 — EjnTricks (search “Bug widgets”)
Today I received a response from the provider. I can try everything once. At first it was all a handle into the toilet.
But with a good feeling I have renamed “config.ini.php” and so you can create a new database with a new prefix. Before, showed up here even error messages! But in this time don’t it!
I have changed the new file config.ini.php and write in the old database file.
Then I started Piwik and all data were visible again .
Then I looked at both config.ini.php. There is one crucial difference:
new data file
[database]
host = "[b]localhos[/b]t"
username = "meinUserName"
password = "meinPasswort"
dbname = "meineDatenbank"
tables_prefix = "piwik2_"
charset = "utf8"
old data file
[database]
host = "[b]127.0.0.1[/b]"
username = "MeinUsername"
password = "MeinPasswort"
dbname = "meineDatenbanl"
tables_prefix = "piwik_"
adapter = "PDO_MYSQL"
port = 3306
charset = "utf8"
I have changed the table prefix to piwik and started the Piwik V 1.8.2!
WOOOOOW(:D, all data are ready to see. What was the reason?
There is one critical difference ::o And in this moment I see many new track information, it works fine now!
[database]
host = “127.0.0.1” and “localhost” with two critical reactions:
IP adress 127.0.0.1 makes errors errors errors errors errors errors errors errors errors errors errors errors errors errors errors errors errors errors errors errors errors errors errors …
localhost works very fine with all my data from more than two years ago!
I have infformed my privider about this nad waiting for a reply.
Is this a bug in the program Piwik or a bug in the MySQL-server environment?