Hello,
after updating for 1.7 to 1.81 I get the following error message when I try to log on as superuser (no other users available):
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘name’ in ‘field list’
Backtrace:
#0 [xxx]/httpdocs/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 [xxx]/httpdocs/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 [xxx]/httpdocs/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT iddashbo…’, Array)
#3 [xxx]/httpdocs/core/Db/Adapter/Pdo/Mysql.php(220): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT iddashbo…’, Array)
#4 [xxx]/httpdocs/libs/Zend/Db/Adapter/Abstract.php(736): Piwik_Db_Adapter_Pdo_Mysql->query(‘SELECT iddashbo…’, Array)
#5 [xxx]/httpdocs/core/PluginsFunctions/Sql.php(80): Zend_Db_Adapter_Abstract->fetchAll(‘SELECT iddashbo…’, Array)
#6 [xxx]/httpdocs/core/PluginsFunctions/Sql.php(262): Piwik_Sql::fetchAll(‘SELECT iddashbo…’, Array)
#7 [xxx]/httpdocs/plugins/Dashboard/Dashboard.php(42): Piwik_FetchAll(‘SELECT iddashbo…’, Array)
#8 [xxx]/httpdocs/plugins/Dashboard/Dashboard.php(77): Piwik_Dashboard::getAllDashboards(‘Torsten’)
#9 [internal function]: Piwik_Dashboard->addMenus(Object(Piwik_Event_Notification))
#10 [xxx]/httpdocs/libs/Event/Dispatcher.php(284): call_user_func_array(Array, Array)
#11 [xxx]/httpdocs/core/PluginsManager.php(633): Event_Dispatcher->postNotification(Object(Piwik_Event_Notification), false, false)
#12 [xxx]/httpdocs/core/Menu/Main.php(65): Piwik_PostEvent(‘Menu.add’)
#13 [xxx]/httpdocs/core/Menu/Main.php(90): Piwik_Menu_Main->get()
#14 [xxx]/httpdocs/plugins/CoreHome/Controller.php(58): Piwik_GetMenu()
#15 [xxx]/httpdocs/plugins/CoreHome/Controller.php(92): Piwik_CoreHome_Controller->getDefaultIndexView()
#16 [internal function]: Piwik_CoreHome_Controller->index()
#17 [xxx]/httpdocs/core/FrontController.php(138): call_user_func_array(Array, Array)
#18 [xxx]/httpdocs/index.php(53): Piwik_FrontController->dispatch()
#19 {main}
[xxx]= Path to my installation
The database user has lock rights.
I’ve no idea what to do. Any help??
Best regards
Torsten