Error when creating new dashboard #3328

Closed
anonymous-piwik-user opened this Issue Aug 16, 2012 · 2 comments

2 participants

@anonymous-piwik-user

Piwik version 1.8.3. Database version MySQL 5.x

For new users, who doesn't have any existent dashboards in a database table prefix_user_dashboard, attempt to create a new dashboard leads to an error.

Piwik_Dashboard_Controller::createNewDashboard method has sql query (183 line of the file) 'SELECT MAX(iddashboard)+1 FROM '.Piwik_Common::prefixTable('user_dashboard').' WHERE login = ?". Unfortunately this returns NULL value, when table doesn't have any records by this conditions. After that we are have a next query on line 194, which throws an error, when receives a null-value in $nextId variable.
Keywords: dashboard

@anonymous-piwik-user

Attachment: Patch to fix this issue
patch_#3328.txt

@mattab
Piwik Open Source Analytics member

(In [6801]) Fixes #3328 Thanks DnSL48 for report and patch!

This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment