Upgrade to 1.8.2 failed


#1

Hi,

Error message:


Mysqli prepare error: Unknown column 'name' in 'field list'

Go to Piwik
Login
Backtrace:

#0 /srv/http/piwik/libs/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT iddashbo...')
#1 /srv/http/piwik/libs/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Piwik_Db_Adapter_Mysqli), 'SELECT iddashbo...')
#2 /srv/http/piwik/libs/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SELECT iddashbo...')
#3 /srv/http/piwik/libs/Zend/Db/Adapter/Abstract.php(736): Zend_Db_Adapter_Abstract->query('SELECT iddashbo...', Array)
#4 /srv/http/piwik/core/PluginsFunctions/Sql.php(80): Zend_Db_Adapter_Abstract->fetchAll('SELECT iddashbo...', Array)
#5 /srv/http/piwik/core/PluginsFunctions/Sql.php(262): Piwik_Sql::fetchAll('SELECT iddashbo...', Array)
#6 /srv/http/piwik/plugins/Dashboard/Dashboard.php(42): Piwik_FetchAll('SELECT iddashbo...', Array)
#7 /srv/http/piwik/plugins/Dashboard/Dashboard.php(77): Piwik_Dashboard::getAllDashboards('regj')
#8 [internal function]: Piwik_Dashboard->addMenus(Object(Piwik_Event_Notification))
#9 /srv/http/piwik/libs/Event/Dispatcher.php(284): call_user_func_array(Array, Array)
#10 /srv/http/piwik/core/PluginsManager.php(633): Event_Dispatcher->postNotification(Object(Piwik_Event_Notification), false, false)
#11 /srv/http/piwik/core/Menu/Main.php(65): Piwik_PostEvent('Menu.add')
#12 /srv/http/piwik/core/Menu/Main.php(90): Piwik_Menu_Main->get()
#13 /srv/http/piwik/plugins/CoreHome/Controller.php(58): Piwik_GetMenu()
#14 /srv/http/piwik/plugins/CoreHome/Controller.php(92): Piwik_CoreHome_Controller->getDefaultIndexView()
#15 [internal function]: Piwik_CoreHome_Controller->index()
#16 /srv/http/piwik/core/FrontController.php(138): call_user_func_array(Array, Array)
#17 /srv/http/piwik/index.php(53): Piwik_FrontController->dispatch()
#18 {main}

Versions:


# mysql --version
mysql  Ver 14.14 Distrib 5.5.24, for Linux (x86_64) using readline 5.1
# php --version
PHP 5.4.3 (cli) (built: May 31 2012 10:40:02) 
Copyright (c) 1997-2012 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2012 Zend Technologies
# uname -a
Linux archlin 3.3.7-1-ARCH #1 SMP PREEMPT Tue May 22 00:26:26 CEST 2012 x86_64 GNU/Linux

Br,
Edgar


#2

Hy.

I add something similar when upgrade to 1.8
The root cause was the database upgrade failed from 1.7 to 1.8 because I did not grant enough privilege to the account.
I add to reproduce SQL upgrade by my own on mysql and everything was fine after.

I wrote something here: Piwik Update 1.8 — EjnTricks

Etienne Jouvin


#3

Thank you Etienne. My french is rather bad. Can you list all the mysql commands you executed to fix the issue?

Br,
Edgar


#4

Ouch, I nee to translate all my Wiki ? So much work for future…

All queries are in the article for each file studied under each section for updtaing file.

As a summary, here are executed queires:
ALTER TABLE piwik_pdf CHANGE aggregate_reports_format display_format TINYINT(1) NOT NULL;
ALTER TABLE piwik_user_dashboard ADD name VARCHAR( 100 ) NULL DEFAULT NULL AFTER iddashboard;
GRANT LOCK TABLES ON piwik.* TO ‘piwik’@‘localhost’;

But I still have problem. On browser extension, server time log, on iPad application also. I have to investigate and also upgrade to 1.8.2