Column not found

Support & Bugs
1

Hello,

I’ve installed Piwik yesterday, but i’ve a problem when i’m log in it, i’ve this message :

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

Backtrace:

#0 (xxx)/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 (xxx)/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 (xxx)/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT iddashbo…’, Array)
#3 (xxx)/core/Db/Adapter/Pdo/Mysql.php(220): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT iddashbo…’, Array)
#4 (xxx)/libs/Zend/Db/Adapter/Abstract.php(736): Piwik_Db_Adapter_Pdo_Mysql->query(‘SELECT iddashbo…’, Array)
#5 (xxx)/core/PluginsFunctions/Sql.php(80): Zend_Db_Adapter_Abstract->fetchAll(‘SELECT iddashbo…’, Array)
#6 (xxx)/core/PluginsFunctions/Sql.php(461): Piwik_Sql::fetchAll(‘SELECT iddashbo…’, Array)
#7 (xxx)/plugins/Dashboard/Dashboard.php(42): Piwik_FetchAll(‘SELECT iddashbo…’, Array)
#8 (xxx)/plugins/Dashboard/Dashboard.php(78): Piwik_Dashboard::getAllDashboards(‘gouvernance’)
#9 [internal function]: Piwik_Dashboard->addMenus(Object(Piwik_Event_Notification))
#10 (xxx)/libs/Event/Dispatcher.php(284): call_user_func_array(Array, Array)
#11 (xxx)/core/PluginsManager.php(668): Event_Dispatcher->postNotification(Object(Piwik_Event_Notification), false, false)
#12 (xxx)/core/Menu/Main.php(65): Piwik_PostEvent(‘Menu.add’)
#13 (xxx)/core/Menu/Main.php(90): Piwik_Menu_Main->get()
#14 (xxx)/plugins/CoreHome/Controller.php(58): Piwik_GetMenu()
#15 (xxx)/plugins/CoreHome/Controller.php(92): Piwik_CoreHome_Controller->getDefaultIndexView()
#16 [internal function]: Piwik_CoreHome_Controller->index()
#17 (xxx)/core/FrontController.php(138): call_user_func_array(Array, Array)
#18 (xxx)/index.php(53): Piwik_FrontController->dispatch()
#19 {main}

I tried this solution i saw on this site :

SQL Command :

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

But it doesn’t works, i have pthis result :

Requête SQL:

ALTER TABLE piwik_user_dashboard ADD name VARCHAR( 100 ) NULL DEFAULT NULL AFTER iddashboard ;

MySQL a répondu: Documentation
#1046 - No database selected

I don’t know what to do

Please, help me !

Thanks you in advance :slight_smile:

2

Before running the SQL query, you have to execute

USE piwik;

(if you database name is piwik)

If you use phpmyadmin click on the database name first, then execute the query. does it work?

3

Ok,

I’ve this message error :

Requête SQL:

ALTER TABLE piwik_pdf CHANGE aggregate_reports_format display_format TINYINT( 1 ) NOT NULL

MySQL a répondu: Documentation
#1054 - Unknown column ‘aggregate_reports_format’ in ‘piwik_pdf’

But It’s works, it’s really slow ( i think it come from my server, i will follow to test it).

Thanks you for to had helped me :slight_smile: