Update 1.9 : Undefined index: sitesearch

Hello,

I’ve just updated in 1.9 et i have this error :

Thank you for all.
Thomas


Notice: Undefined index: sitesearch in /var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/core/Site.php on line 260

Backtrace -->

#0 Piwik_ErrorHandler(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/core/Site.php:260]
#1 Piwik_Site::getFor(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/core/Site.php:326]
#2 Piwik_Site::isSiteSearchEnabledFor(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/plugins/Actions/Actions.php:558]
#3 Piwik_Actions->isSiteSearchEnabled(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/plugins/Actions/Actions.php:546]
#4 Piwik_Actions->addMenus(…) called at [:]
#5 call_user_func_array(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/libs/Event/Dispatcher.php:284]
#6 Event_Dispatcher->postNotification(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/core/PluginsManager.php:668]
#7 Piwik_PostEvent(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/core/Menu/Main.php:65]
#8 Piwik_Menu_Main->get(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/core/Menu/Main.php:90]
#9 Piwik_GetMenu(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/plugins/CoreHome/Controller.php:58]
#10 Piwik_CoreHome_Controller->getDefaultIndexView(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/plugins/CoreHome/Controller.php:92]
#11 Piwik_CoreHome_Controller->index(…) called at [:]
#12 call_user_func_array(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/core/FrontController.php:138]
#13 Piwik_FrontController->dispatch(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/index.php:53]

HI Guys,

here the same:

There is an error. Please report the message (Piwik 1.9) and full backtrace in the Piwik forums (please do a Search first as it might have been reported already!).

Notice: Undefined index: sitesearch in /var/www/clients/client1/web1/web/report/core/Site.php on line 260

Backtrace -->

#0 Piwik_ErrorHandler(…) called at [/var/www/clients/client1/web1/web/report/core/Site.php:260]
#1 Piwik_Site::getFor(…) called at [/var/www/clients/client1/web1/web/report/core/Site.php:326]
#2 Piwik_Site::isSiteSearchEnabledFor(…) called at [/var/www/clients/client1/web1/web/report/plugins/Actions/Actions.php:558]
#3 Piwik_Actions->isSiteSearchEnabled(…) called at [/var/www/clients/client1/web1/web/report/plugins/Actions/Actions.php:402]
#4 Piwik_Actions->getReportMetadata(…) called at [:]
#5 call_user_func_array(…) called at [/var/www/clients/client1/web1/web/report/libs/Event/Dispatcher.php:284]
#6 Event_Dispatcher->postNotification(…) called at [/var/www/clients/client1/web1/web/report/core/PluginsManager.php:668]
#7 Piwik_PostEvent(…) called at [/var/www/clients/client1/web1/web/report/plugins/API/API.php:543]
#8 Piwik_API_API->getReportMetadata(…) called at [/var/www/clients/client1/web1/web/report/plugins/API/API.php:490]
#9 Piwik_API_API->getMetadata(…) called at [/var/www/clients/client1/web1/web/report/core/ViewDataTable.php:1206]
#10 Piwik_ViewDataTable->loadDocumentation(…) called at [/var/www/clients/client1/web1/web/report/core/ViewDataTable.php:1195]
#11 Piwik_ViewDataTable->getReportDocumentation(…) called at [/var/www/clients/client1/web1/web/report/core/ViewDataTable/GenerateGraphHTML.php:157]
#12 Piwik_ViewDataTable_GenerateGraphHTML->buildView(…) called at [/var/www/clients/client1/web1/web/report/core/ViewDataTable/GenerateGraphHTML.php:125]
#13 Piwik_ViewDataTable_GenerateGraphHTML->main(…) called at [/var/www/clients/client1/web1/web/report/core/Controller.php:152]
#14 Piwik_Controller->renderView(…) called at [/var/www/clients/client1/web1/web/report/plugins/DBStats/Controller.php:72]
#15 Piwik_DBStats_Controller->getDatabaseUsageSummary(…) called at [/var/www/clients/client1/web1/web/report/plugins/DBStats/Controller.php:33]
#16 Piwik_DBStats_Controller->index(…) called at [:]
#17 call_user_func_array(…) called at [/var/www/clients/client1/web1/web/report/core/FrontController.php:138]
#18 Piwik_FrontController->dispatch(…) called at [/var/www/clients/client1/web1/web/report/index.php:53]

I’m having the same problem. Have tried the manual update which didn’t work, the auto update… It seems that the database doesn’t get updated via the update script.
It doesn’t add the new fields in the database for SiteSearch and all the others that come with 1.9.

I’m now running 1.8.4 again.

I confirm the database doesn’t get updated via the update script.
How to return to 1.8.4? You have a zip file?

Well, the database isn’t updated and still on version 1.8.4. You have to delete all the 1.9 files and upload the 1.8.4 ones back into the same folder. Then you’ll run through the install process again, where you KEEP your database instead of deleting it. Fill every field with the exact same information as before the 1.9 update.

So when you’re done with this, you have a unchanged database with the 1.8.4 files again.

It should work, it did for me.

You can download older versions via this page : http://builds.piwik.org/

Thx you :slight_smile:
but I’ll wait for a patch if it’s possible…

[quote=mvandek]
Well, the database isn’t updated and still on version 1.8.4. You have to delete all the 1.9 files and upload the 1.8.4 ones back into the same folder. Then you’ll run through the install process again, where you KEEP your database instead of deleting it. Fill every field with the exact same information as before the 1.9 update.

So when you’re done with this, you have a unchanged database with the 1.8.4 files again.

It should work, it did for me.[/quote]

I try,thanks

If you see this error, it means the update script was not executed properly.

Run this SQL query to force piwik to re-run the update:


UPDATE piwik_option SET option_value='1.8.4' WHERE option_name='version_core'

Also, make sure the new files are uploaded correctly, you should have files in piwik/core/Updates/1.9-XXXXX.php ?

Matt, shouldn’t this be:


UPDATE piwik_option SET [b][u]option_value[/u][/b]='1.8.4' WHERE [b][u]option_name[/u][/b]='version_core'

re-ran the installation after update the version core on the db according with your advice.
Everything seems ok.

Thank you.

Cheers

[quote=matt]
If you see this error, it means the update script was not executed properly.

Run this SQL query to force piwik to re-run the update:


UPDATE piwik_option SET value='1.8.4' WHERE name='version_core'

Also, make sure the new files are uploaded correctly, you should have files in piwik/core/Updates/1.9-XXXXX.php ?[/quote]

I’ve changed all the rows in piwik_option manually, which contained 1.9 back into 1.8.4 and ran the update again. This time the database upgrade was performed and it runs like it’s supposed to be.

same here:

Notice: Undefined index: archiving_ranking_query_row_limit in /var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/plugins/Actions/Archiving.php on line 423

Backtrace -->

#0 Piwik_ErrorHandler(…) called at [/var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/plugins/Actions/Archiving.php:423]
#1 Piwik_Actions_Archiving::getRankingQueryLimit(…) called at [/var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/plugins/Actions/Archiving.php:93]
#2 Piwik_Actions_Archiving->archiveDay(…) called at [/var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/plugins/Actions/Actions.php:592]
#3 Piwik_Actions->archiveDay(…) called at [:]
#4 call_user_func_array(…) called at [/var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/libs/Event/Dispatcher.php:284]
#5 Event_Dispatcher->postNotification(…) called at [/var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/core/PluginsManager.php:668]
#6 Piwik_PostEvent(…) called at [/var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/core/ArchiveProcessing/Day.php:45]
#7 Piwik_ArchiveProcessing_Day->compute(…) called at [/var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/core/ArchiveProcessing.php:498]
#8 Piwik_ArchiveProcessing->launchArchiving(…) called at [/var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/core/Archive/Single.php:236]
#9 Piwik_Archive_Single->prepareArchive(…) called at [/var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/core/Archive/Array/IndexedBySite.php:192]
#10 Piwik_Archive_Array_IndexedBySite->getArchiveIdsAfterLaunching(…) called at [/var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/core/Archive/Array/IndexedBySite.php:131]
#11 Piwik_Archive_Array_IndexedBySite->loadValuesFromDB(…) called at [/var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/core/Archive/Array/IndexedBySite.php:108]
#12 Piwik_Archive_Array_IndexedBySite->getValues(…) called at [/var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/core/Archive/Array/IndexedBySite.php:73]
#13 Piwik_Archive_Array_IndexedBySite->getDataTableFromNumeric(…) called at [/var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/plugins/MultiSites/API.php:192]
#14 Piwik_MultiSites_API->buildDataTable(…) called at [/var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/plugins/MultiSites/API.php:112]
#15 Piwik_MultiSites_API->getAll(…) called at [/var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/plugins/MultiSites/Controller.php:65]
#16 Piwik_MultiSites_Controller->getSitesInfo(…) called at [/var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/plugins/MultiSites/Controller.php:36]
#17 Piwik_MultiSites_Controller->index(…) called at [:]
#18 call_user_func_array(…) called at [/var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/core/FrontController.php:138]
#19 Piwik_FrontController->dispatch(…) called at [/var/www/vhosts/click-business.de/subdomains/analytics/httpdocs/index.php:53]

I tried the query but the version was on 1.9 already
I used the prompt based update procedure. This was running fine.

Olabre , check that the new file piwik/config/global.ini.php has been updated correctly!

Thanks Matt, I use to keep the config dir, so the update of the file themes to work, thanks

Hi,

I have the same problem with 1.9.1.
I update the option_value in my database to 1.8.4 and I reload the page : /piwik/index.php?module=CoreUpdater&action=newVersionAvailable

But not issu.

Thank you.
Thomas

There is an error. Please report the message (Piwik 1.9.1) and full backtrace in the Piwik forums (please do a Search first as it might have been reported already!).

Notice: Undefined index: sitesearch in /var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/core/Site.php on line 260

Backtrace -->

#0 Piwik_ErrorHandler(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/core/Site.php:260]
#1 Piwik_Site::getFor(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/core/Site.php:326]
#2 Piwik_Site::isSiteSearchEnabledFor(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/plugins/Actions/Actions.php:558]
#3 Piwik_Actions->isSiteSearchEnabled(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/plugins/Actions/Actions.php:546]
#4 Piwik_Actions->addMenus(…) called at [:]
#5 call_user_func_array(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/libs/Event/Dispatcher.php:284]
#6 Event_Dispatcher->postNotification(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/core/PluginsManager.php:722]
#7 Piwik_PostEvent(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/core/Menu/Main.php:65]
#8 Piwik_Menu_Main->get(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/core/Menu/Main.php:90]
#9 Piwik_GetMenu(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/plugins/CoreHome/Controller.php:58]
#10 Piwik_CoreHome_Controller->getDefaultIndexView(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/plugins/CoreHome/Controller.php:92]
#11 Piwik_CoreHome_Controller->index(…) called at [:]
#12 call_user_func_array(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/core/FrontController.php:138]
#13 Piwik_FrontController->dispatch(…) called at [/var/www/vhosts/heberg.gratuit-domaine.eu/httpdocs/piwik/index.php:53]

can you please 1) Upgrade to latest beta : http://builds.piwik.org/piwik-1.9.2-b3.zip 2) if you still have problem post a screenshot showing problem? thanks!

Same problem for me, piwik does not seem to update my database at all.

Even with the “UPDATE piwik_option SET option_value” tweak…

Any idea ?

I’ve put my 1.8.4 files back in place and all seems fine again with the previous version.

so the UPDATE query but set the version to 1.8.4 if you update from there: it will add the fields.