Bug or not bug, this is here the question:S


#1

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?


#2

The answer my provider:


The IP address "127.0.0.1" is equal to "localhost", because you are absolutely
right. The permissions are the same for both hosts set up, so to
the database side, everything is in order.


Die IP-Adresse "127.0.0.1" entspricht "localhost", da haben Sie vollkommen
recht. Die Berechtigungen sind für beide Hosts gleich eingerichtet, sodass auf
der Datenbankseite alles in Ordnung ist.


(vipsoft) #3

Not exactly.

MySQL treats “localhost” to mean “connect using sockets, eg /var/run/mysql.sock” instead of TCP/IP.

In php 5.3, mysqlndb was added which follows the MySQL convention.

Most likely your provider changed/updated some configuration and/or binaries.