Piwik will not load anymore


#1

Recently I’ve been unable to access the Piwik installation on my server. I don’t know exactly when the problem started unfortunately. But this is the error page I get:

Error: Unable to start session. Please check that the web server has enough permission to write to these files/directories:
For example, on a GNU/Linux server if your Apache httpd user is www-data, you can try to execute:
chown -R www-data:www-data /home/c2it/public_html/analytics/tmp/sessions
chmod -R 0755 /home/c2it/public_html/analytics/tmp/sessions

If you still experience issues after trying these changes, we recommend that you enable database session storage.

Debug: the original error was
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'c2it_st

Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘c2it_stats.piwik_session’ doesn’t exist’ in /home/c2it/public_html/analytics/libs/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /home/c2it/public_html/analytics/libs/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /home/c2it/public_html/analytics/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #2 /home/c2it/public_html/analytics/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #3 /home/c2it/public_html/analytics/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘INSERT INTO piw…’, Array) #4 /home/c2it/public_html/analytics/core/Db/Adapter/Pdo/Mysql.php(233): Zend_Db_Adapter_Pdo_Abstract->query(‘INSERT INTO piw…’, Array) #5 /home/c2it/public_html/analytics/core/Session/SaveHandler/DbTable.php(108): Piwik\Db\Adapter\Pdo\Mysql->query(‘INSERT INTO piw…’, Array) #6 [internal function]: Piwik\Session\SaveHandler\Db in /home/c2it/public_html/analytics/libs/Zend/Db/Statement/Pdo.php on line 234

The permissions for the session directory are definately set correctly and I’ve always had database session storage enabled.
Any ideas why this started happening and what I can do to fix it?

Thanks,
CJ


(Matthieu Aubry) #2

Hi there

is the table piwik_session still there in your Piwik DB?


#3

I’m sure it was, but I’ve since had to reinstall the whole thing. I didn’t have much choice.