Leaderboard

THANK YOU for posting this! I was able to solve the issue thanks to your post. I'll post the fix here for anyone who stumbles upon this post in the future. Find the following file admin\applications\core\modules_admin\mycp\dashboard.php Change line 377 to $online = $this->DB->buildAndFetch( array( 'select' => 'count(*) as fixme', 'from' => 'sessions', 'where' => "running_time > {$time}" ) ); Change line 379 to $stats['active_users'] = $online['fixme']; Of course you don't have to use the word "fixme". You can use any word so long as you don't use "rows"!. Thanks!

For me this error occured when i update MariaDB from 10.1.36 to 10.2.18. So MariaDB 10.2 and newer have this issue. Downgrade to 10.1 resolving this issue. Edit: world rows in MariaDB 10.2 is reserved, so cant be used. It should be changed to 'rows' or anything, but how do that ?