Nothing works after update

emil · January 13, 2014, 11:06am

i’m using a own installation on a shared hoster.

updated from 2.0.2 to 2.0.3 today and nothing works anymore.
no error messages (see attached screenshot).

is there any known problem or any idea why?

howdytom · January 13, 2014, 11:10am

Please enable display_errors = true; on your server.

matthieu · January 13, 2014, 11:16am

any error in the server error log ?

emil · January 13, 2014, 1:23pm

i’m on a shared hoster, i don’t have access to the server itself.

Please enable display_errors = true; on your server.

Where can i do this? in a php-file?

howdytom · January 13, 2014, 3:23pm

Take a look at your hosting control panel.

Another option is to add the following snippet to your .htacess file
php_flag display_errors on

emil · January 13, 2014, 8:15pm

okay, i created a .htaccess with the content:

no effect :-/ page does not show errors or anything else…

rnidd · January 13, 2014, 10:16pm

Hello, i’m in the same situation. I have not changed any user or password and I saw the first error in cronjob email:


Error in the last Piwik archive.php run: 
2 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: http://stats.xxx.com/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=day&date=last28&format=php&token_auth=7661c9b33edfd6ee62e683318fe60db4&trigger=archivephp. Response was '<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Referrers[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Referrers[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>VERBOSE VisitsSummary[2014-01-13 22:00:02] [ab1ce] day archive, idSite = 1 (temporary archive), segment '', report = 'VisitsSummary', UTC datetime [2014-01-12 23:00:00 -> 2014-01-13 22:59:59]</pre>
a:28:{s:10:"2013-12-17";d:2;s:10:"2013-12-18";d:2;s:10:"2013-12-19";d:3;s:10:"2013-12-20";d:6;s:10:"2013-12-21";d:6;s:10:"2013-12-22";d:9;s:10:"2013-12-23";d:12;s:10:"2013-12-24";d:6;s:10:"2013-12-25";d:8;s:10:"2013-12-26";d:4;s:10:"2013-12-27";d:8;s:10:"2013-12-28";d:7;s:10:"2013-12-29";d:5;s:10:"2013-12-30";d:11;s:10:"2013-12-31";d:2;s:10:"2014-01-01";d:6;s:10:"2014-01-02";d:12;s:10:"2014-01-03";d:22;s:10:"2014-01-04";d:17;s:10:"2014-01-05";d:5;s:10:"2014-01-06";d:9;s:10:"2014-01-07";d:13;s:10:"2014-01-08";d:10;s:10:"2014-01-09";d:11;s:10:"2014-01-10";d:12;s:10:"2014-01-11";d:11;s:10:"2014-01-12";d:9;s:10:"2014-01-13";d:5;}'


 Here is the full errors output:

---------------------------
INIT
Querying Piwik API at: http://stats.xxx.com/index.php
Running Piwik 2.0.3 as Super User: admin
---------------------------
NOTES
- If you execute this script at least once per hour (or more often) in a crontab, you may disable 'Browser trigger archiving' in Piwik UI > Settings > General Settings. 
  See the doc at: http://piwik.org/docs/setup-auto-archiving/
- Reports for today will be processed at most every 10 seconds. You can change this value in Piwik UI > Settings > General Settings.
- Reports for the current week/month/year will be refreshed at most every 3600 seconds.
- Archiving was last executed without error 1 hours 59 min ago
- Will process 2 websites with new visits since 1 hours 59 min , IDs: 1, 2
---------------------------
START
ERROR: Got invalid response from API request: http://stats.xxx.com/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=day&date=last28&format=php&token_auth=7661c9b33edfd6ee62e683318fe60db4&trigger=archivephp. Response was '<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Referrers[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Referrers[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>VERBOSE VisitsSummary[2014-01-13 22:00:02] [ab1ce] day archive, idSite = 1 (temporary archive), segment '', report = 'VisitsSummary', UTC datetime [2014-01-12 23:00:00 -> 2014-01-13 22:59:59]</pre>
a:28:{s:10:"2013-12-17";d:2;s:10:"2013-12-18";d:2;s:10:"2013-12-19";d:3;s:10:"2013-12-20";d:6;s:10:"2013-12-21";d:6;s:10:"2013-12-22";d:9;s:10:"2013-12-23";d:12;s:10:"2013-12-24";d:6;s:10:"2013-12-25";d:8;s:10:"2013-12-26";d:4;s:10:"2013-12-27";d:8;s:10:"2013-12-28";d:7;s:10:"2013-12-29";d:5;s:10:"2013-12-30";d:11;s:10:"2013-12-31";d:2;s:10:"2014-01-01";d:6;s:10:"2014-01-02";d:12;s:10:"2014-01-03";d:22;s:10:"2014-01-04";d:17;s:10:"2014-01-05";d:5;s:10:"2014-01-06";d:9;s:10:"2014-01-07";d:13;s:10:"2014-01-08";d:10;s:10:"2014-01-09";d:11;s:10:"2014-01-10";d:12;s:10:"2014-01-11";d:11;s:10:"2014-01-12";d:9;s:10:"2014-01-13";d:5;}'
WARNING: Empty or invalid response '' for website id 1, Time elapsed: 0.663s, skipping
ERROR: Got invalid response from API request: http://stats.xxx.com/index.php?module=API&method=VisitsSummary.getVisits&idSite=2&period=day&date=last25&format=php&token_auth=7661c9b33edfd6ee62e683318fe60db4&trigger=archivephp. Response was '<pre>INFO Referrers[2014-01-13 22:00:02] [68b42] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Referrers[2014-01-13 22:00:02] [68b42] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>VERBOSE VisitsSummary[2014-01-13 22:00:02] [68b42] day archive, idSite = 2 (temporary archive), segment '', report = 'VisitsSummary', UTC datetime [2014-01-12 23:00:00 -> 2014-01-13 22:59:59]</pre>
a:25:{s:10:"2013-12-20";i:0;s:10:"2013-12-21";d:2;s:10:"2013-12-22";d:2;s:10:"2013-12-23";d:2;s:10:"2013-12-24";i:0;s:10:"2013-12-25";i:0;s:10:"2013-12-26";d:1;s:10:"2013-12-27";d:1;s:10:"2013-12-28";d:1;s:10:"2013-12-29";d:1;s:10:"2013-12-30";d:1;s:10:"2013-12-31";i:0;s:10:"2014-01-01";d:2;s:10:"2014-01-02";d:4;s:10:"2014-01-03";d:2;s:10:"2014-01-04";d:2;s:10:"2014-01-05";i:0;s:10:"2014-01-06";i:0;s:10:"2014-01-07";d:3;s:10:"2014-01-08";d:2;s:10:"2014-01-09";d:3;s:10:"2014-01-10";d:3;s:10:"2014-01-11";d:2;s:10:"2014-01-12";d:3;s:10:"2014-01-13";d:2;}'
WARNING: Empty or invalid response '' for website id 2, Time elapsed: 0.418s, skipping
Starting Piwik reports archiving...
Done archiving!
---------------------------
SUMMARY
Total daily visits archived: 0
Archived today's reports for 0 websites
Archived week/month/year for 0 websites
Skipped 2 websites: no new visit since the last script execution
Skipped 0 websites day archiving: existing daily reports are less than 10 seconds old
Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
Total API requests: 0
done: 0/2 0%, 0 v, 0 wtoday, 0 wperiods, 0 req, 1083 ms, 2 errors. eg. 'Got invalid response from API request: http://stats.xxx.com/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=day&date=last28&format=php&token_auth=7661c9b33edfd6ee62e683318fe60db4&trigger=archivephp. Response was '<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Referrers[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Referrers[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>VERBOSE VisitsSummary[2014-01-13 22:00:02] [ab1ce] day archive, idSite = 1 (temporary archive), segment '', report = 'VisitsSummary', UTC datetime [2014-01-12 23:00:00 -> 2014-01-13 22:59:59]</pre>
a:28:{s:10:"2013-12-17";d:2;s:10:"2013-12-18";d:2;s:10:"2013-12-19";d:3;s:10:"2013-12-20";d:6;s:10:"2013-12-21";d:6;s:10:"2013-12-22";d:9;s:10:"2013-12-23";d:12;s:10:"2013-12-24";d:6;s:10:"2013-12-25";d:8;s:10:"2013-12-26";d:4;s:10:"2013-12-27";d:8;s:10:"2013-12-28";d:7;s:10:"2013-12-29";d:5;s:10:"2013-12-30";d:11;s:10:"2013-12-31";d:2;s:10:"2014-01-01";d:6;s:10:"2014-01-02";d:12;s:10:"2014-01-03";d:22;s:10:"2014-01-04";d:17;s:10:"2014-01-05";d:5;s:10:"2014-01-06";d:9;s:10:"2014-01-07";d:13;s:10:"2014-01-08";d:10;s:10:"2014-01-09";d:11;s:10:"2014-01-10";d:12;s:10:"2014-01-11";d:11;s:10:"2014-01-12";d:9;s:10:"2014-01-13";d:5;}''
Time elapsed: 1.083s
---------------------------
SCHEDULED TASKS
Starting Scheduled tasks... 
 No task to run
done
---------------------------
---------------------------
SUMMARY OF ERRORS
Error: Got invalid response from API request: http://stats.xxx.com/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=day&date=last28&format=php&token_auth=7661c9b33edfd6ee62e683318fe60db4&trigger=archivephp. Response was '<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Referrers[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Referrers[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>VERBOSE VisitsSummary[2014-01-13 22:00:02] [ab1ce] day archive, idSite = 1 (temporary archive), segment '', report = 'VisitsSummary', UTC datetime [2014-01-12 23:00:00 -> 2014-01-13 22:59:59]</pre>
a:28:{s:10:"2013-12-17";d:2;s:10:"2013-12-18";d:2;s:10:"2013-12-19";d:3;s:10:"2013-12-20";d:6;s:10:"2013-12-21";d:6;s:10:"2013-12-22";d:9;s:10:"2013-12-23";d:12;s:10:"2013-12-24";d:6;s:10:"2013-12-25";d:8;s:10:"2013-12-26";d:4;s:10:"2013-12-27";d:8;s:10:"2013-12-28";d:7;s:10:"2013-12-29";d:5;s:10:"2013-12-30";d:11;s:10:"2013-12-31";d:2;s:10:"2014-01-01";d:6;s:10:"2014-01-02";d:12;s:10:"2014-01-03";d:22;s:10:"2014-01-04";d:17;s:10:"2014-01-05";d:5;s:10:"2014-01-06";d:9;s:10:"2014-01-07";d:13;s:10:"2014-01-08";d:10;s:10:"2014-01-09";d:11;s:10:"2014-01-10";d:12;s:10:"2014-01-11";d:11;s:10:"2014-01-12";d:9;s:10:"2014-01-13";d:5;}'
Error: Got invalid response from API request: http://stats.xxx.com/index.php?module=API&method=VisitsSummary.getVisits&idSite=2&period=day&date=last25&format=php&token_auth=7661c9b33edfd6ee62e683318fe60db4&trigger=archivephp. Response was '<pre>INFO Referrers[2014-01-13 22:00:02] [68b42] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Referrers[2014-01-13 22:00:02] [68b42] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>VERBOSE VisitsSummary[2014-01-13 22:00:02] [68b42] day archive, idSite = 2 (temporary archive), segment '', report = 'VisitsSummary', UTC datetime [2014-01-12 23:00:00 -> 2014-01-13 22:59:59]</pre>
a:25:{s:10:"2013-12-20";i:0;s:10:"2013-12-21";d:2;s:10:"2013-12-22";d:2;s:10:"2013-12-23";d:2;s:10:"2013-12-24";i:0;s:10:"2013-12-25";i:0;s:10:"2013-12-26";d:1;s:10:"2013-12-27";d:1;s:10:"2013-12-28";d:1;s:10:"2013-12-29";d:1;s:10:"2013-12-30";d:1;s:10:"2013-12-31";i:0;s:10:"2014-01-01";d:2;s:10:"2014-01-02";d:4;s:10:"2014-01-03";d:2;s:10:"2014-01-04";d:2;s:10:"2014-01-05";i:0;s:10:"2014-01-06";i:0;s:10:"2014-01-07";d:3;s:10:"2014-01-08";d:2;s:10:"2014-01-09";d:3;s:10:"2014-01-10";d:3;s:10:"2014-01-11";d:2;s:10:"2014-01-12";d:3;s:10:"2014-01-13";d:2;}'
2 total errors during this script execution, please investigate and try and fix these errors
ERROR: 2 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: http://stats.xxx.com/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=day&date=last28&format=php&token_auth=7661c9b33edfd6ee62e683318fe60db4&trigger=archivephp. Response was '<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Actions[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Referrers[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>INFO Referrers[2014-01-13 22:00:02] [ab1ce] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]</pre>
<pre>VERBOSE VisitsSummary[2014-01-13 22:00:02] [ab1ce] day archive, idSite = 1 (temporary archive), segment '', report = 'VisitsSummary', UTC datetime [2014-01-12 23:00:00 -> 2014-01-13 22:59:59]</pre>
a:28:{s:10:"2013-12-17";d:2;s:10:"2013-12-18";d:2;s:10:"2013-12-19";d:3;s:10:"2013-12-20";d:6;s:10:"2013-12-21";d:6;s:10:"2013-12-22";d:9;s:10:"2013-12-23";d:12;s:10:"2013-12-24";d:6;s:10:"2013-12-25";d:8;s:10:"2013-12-26";d:4;s:10:"2013-12-27";d:8;s:10:"2013-12-28";d:7;s:10:"2013-12-29";d:5;s:10:"2013-12-30";d:11;s:10:"2013-12-31";d:2;s:10:"2014-01-01";d:6;s:10:"2014-01-02";d:12;s:10:"2014-01-03";d:22;s:10:"2014-01-04";d:17;s:10:"2014-01-05";d:5;s:10:"2014-01-06";d:9;s:10:"2014-01-07";d:13;s:10:"2014-01-08";d:10;s:10:"2014-01-09";d:11;s:10:"2014-01-10";d:12;s:10:"2014-01-11";d:11;s:10:"2014-01-12";d:9;s:10:"2014-01-13";d:5;}'

If I click on the url I get this error:


INFO Actions[2014-01-13 21:56:08] [c322c] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]
INFO Actions[2014-01-13 21:56:08] [c322c] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]
INFO Actions[2014-01-13 21:56:08] [c322c] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]
INFO Actions[2014-01-13 21:56:08] [c322c] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]
INFO Referrers[2014-01-13 21:56:08] [c322c] LOAD DATA INFILE failed... Error was: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]
INFO Referrers[2014-01-13 21:56:08] [c322c] LOAD DATA INFILE failed or not supported, falling back to normal INSERTs... Error was:   Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'piwik'@'localhost' (using password: YES)[28000]
VERBOSE VisitsSummary[2014-01-13 21:56:08] [c322c] day archive, idSite = 1 (temporary archive), segment '', report = 'VisitsSummary', UTC datetime [2014-01-12 23:00:00 -> 2014-01-13 22:59:59]

Then i change the option “Allow Piwik archiving to trigger when reports are viewed from the browser” to default option and get the same errors (see attach file)

Anyone can help me?

Thx a lot.

matthieu · January 14, 2014, 12:41am

It looks like logging is enabled. Delete the [log] category in your config/config.ini.php file ?

emil · January 14, 2014, 7:04am

I can’t see sth like “[Log]” in my config.ini.php-file…


; <?php exit; ?> DO NOT REMOVE THIS LINE
; file automatically generated or modified by Piwik; you can manually override the default values in global.ini.php by redefining them in this file.
[database]
host = "127.0.0.1"
username = "***"
password = ***
dbname = "***"
tables_prefix = "piwik_"
charset = "utf8"

[superuser]
login = "***"
password = "***"
email = "***"
salt = "***"

[General]
trusted_hosts[] = "piwik.niedermann-online.de"

[Plugins]
Plugins[] = "CorePluginsAdmin"
Plugins[] = "CoreAdminHome"
Plugins[] = "CoreHome"
Plugins[] = "Proxy"
Plugins[] = "API"
Plugins[] = "Widgetize"
Plugins[] = "Transitions"
Plugins[] = "LanguagesManager"
Plugins[] = "Actions"
Plugins[] = "Dashboard"
Plugins[] = "MultiSites"
Plugins[] = "UserSettings"
Plugins[] = "Goals"
Plugins[] = "SEO"
Plugins[] = "UserCountry"
Plugins[] = "VisitsSummary"
Plugins[] = "VisitFrequency"
Plugins[] = "VisitTime"
Plugins[] = "VisitorInterest"
Plugins[] = "ExampleAPI"
Plugins[] = "ExamplePlugin"
Plugins[] = "ExampleRssWidget"
Plugins[] = "Provider"
Plugins[] = "Feedback"
Plugins[] = "Login"
Plugins[] = "UsersManager"
Plugins[] = "SitesManager"
Plugins[] = "Installation"
Plugins[] = "CoreUpdater"
Plugins[] = "UserCountryMap"
Plugins[] = "Live"
Plugins[] = "CustomVariables"
Plugins[] = "PrivacyManager"
Plugins[] = "ImageGraph"
Plugins[] = "DoNotTrack"
Plugins[] = "DBStats"
Plugins[] = "Annotations"
Plugins[] = "MobileMessaging"
Plugins[] = "Overlay"
Plugins[] = "SegmentEditor"
Plugins[] = "Referrers"
Plugins[] = "ScheduledReports"
Plugins[] = "Events"
Plugins[] = "CoreVisualizations"
Plugins[] = "Zeitgeist"
Plugins[] = "SecurityInfo"
Plugins[] = "CoreConsole"
Plugins[] = "ExampleTheme"

[PluginsInstalled]
PluginsInstalled[] = "Login"
PluginsInstalled[] = "CoreAdminHome"
PluginsInstalled[] = "UsersManager"
PluginsInstalled[] = "SitesManager"
PluginsInstalled[] = "Installation"
PluginsInstalled[] = "CorePluginsAdmin"
PluginsInstalled[] = "CoreHome"
PluginsInstalled[] = "Proxy"
PluginsInstalled[] = "API"
PluginsInstalled[] = "Widgetize"
PluginsInstalled[] = "LanguagesManager"
PluginsInstalled[] = "Actions"
PluginsInstalled[] = "Dashboard"
PluginsInstalled[] = "MultiSites"
PluginsInstalled[] = "UserSettings"
PluginsInstalled[] = "Goals"
PluginsInstalled[] = "SEO"
PluginsInstalled[] = "UserCountry"
PluginsInstalled[] = "VisitsSummary"
PluginsInstalled[] = "VisitFrequency"
PluginsInstalled[] = "VisitTime"
PluginsInstalled[] = "VisitorInterest"
PluginsInstalled[] = "ExampleAPI"
PluginsInstalled[] = "ExamplePlugin"
PluginsInstalled[] = "ExampleRssWidget"
PluginsInstalled[] = "Provider"
PluginsInstalled[] = "Feedback"
PluginsInstalled[] = "CoreUpdater"
PluginsInstalled[] = "UserCountryMap"
PluginsInstalled[] = "Live"
PluginsInstalled[] = "CustomVariables"
PluginsInstalled[] = "PrivacyManager"
PluginsInstalled[] = "ImageGraph"
PluginsInstalled[] = "DoNotTrack"
PluginsInstalled[] = "Transitions"
PluginsInstalled[] = "DBStats"
PluginsInstalled[] = "Annotations"
PluginsInstalled[] = "MobileMessaging"
PluginsInstalled[] = "Overlay"
PluginsInstalled[] = "SegmentEditor"
PluginsInstalled[] = "CoreVisualizations"
PluginsInstalled[] = "Zeitgeist"
PluginsInstalled[] = "Referrers"
PluginsInstalled[] = "ScheduledReports"
PluginsInstalled[] = "LeftMenu"
PluginsInstalled[] = "PleineLune"
PluginsInstalled[] = "Events"
PluginsInstalled[] = "CoreConsole"
PluginsInstalled[] = "Morpheus"
PluginsInstalled[] = "SecurityInfo"
PluginsInstalled[] = "ExampleTheme"

[Plugins_Tracker]
Plugins_Tracker[] = "Provider"
Plugins_Tracker[] = "Goals"
Plugins_Tracker[] = "DoNotTrack"
Plugins_Tracker[] = "UserCountry"
Plugins_Tracker[] = "UsersManager"
Plugins_Tracker[] = "SitesManager"

rnidd · January 14, 2014, 7:27am

Hello, I have commented those lines, and now i don’t have any errors.


;[log]
;log_level = "VERBOSE"

Thx matt.

@emil, it is possible that you have changed the owner of the files? have you any problems with another update?

emil · January 14, 2014, 7:40am

I never had problems with any updates, from 1.x over 2 beta to 2.0.2 - never had a problem.

i didn’t change any over the filesystem.

emil · January 14, 2014, 8:21pm

What would happen if i delete my piwik files and reinstall it?

Can i use my existing database if i keep the config-file?

matthieu · January 15, 2014, 6:29am

Yes simply keep the config/config.ini.php and copy it back

emil · January 17, 2014, 6:57am

This worked very well.

Now i have an idea what happend:

I had not much space on my hoster left. I think while upgrading piwik, the space went full and so only the “half” updated was downloaded. Can this be possible?