SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field list'

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

It sounds like the upgrade didn’t execute properly for you?

run the sql:


ALTER TABLE `piwik_user_dashboard` ADD `name` VARCHAR( 100 ) NULL DEFAULT NULL AFTER  `iddashboard`;
ALTER TABLE `piwik_pdf` CHANGE `aggregate_reports_format` `display_format` TINYINT(1) NOT NULL

Thanks Matt,

the login now works BUT:
the whole dashboard is empty, the dropdown menu for choosing the website to investigate (start page, upper right) is not clickable anymore (tested with Chrome & Firefox). If click on “all websites” I get visits and actions but no website!!

see Troubleshooting - Analytics Platform - Matomo

Hi
my problem is

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘idsegment’ in ‘field list’

when i`m creating rapory

see solution in 301 Moved Permanently