WWD Posted January 7, 2018 Share Posted January 7, 2018 1 hour ago, Wells said: no, just the one i copy pasted i don't understand what do you mean by i need to get it checked.. Did you empty the sessions database table? You don't need to delete it, just empty it. Link to comment Share on other sites More sharing options...
Wells Posted January 7, 2018 Author Share Posted January 7, 2018 (edited) 7 hours ago, WhatWentDown said: Did you empty the sessions database table? You don't need to delete it, just empty it. Tried emptying it right now, same result. Same database error. Edited January 8, 2018 by Wells Link to comment Share on other sites More sharing options...
Wells Posted January 9, 2018 Author Share Posted January 9, 2018 Can someone help me please ? Link to comment Share on other sites More sharing options...
WWD Posted January 10, 2018 Share Posted January 10, 2018 On 1/9/2018 at 3:13 AM, Wells said: Can someone help me please ? Can you send a screenshot of the error so we're on the same page? Link to comment Share on other sites More sharing options...
Wells Posted January 11, 2018 Author Share Posted January 11, 2018 10 hours ago, WhatWentDown said: Can you send a screenshot of the error so we're on the same page? https://imgur.com/a/4S2N9 The error is only when i try to log in the admincp, the rest of the forum works. Link to comment Share on other sites More sharing options...
Cookie Monster Posted January 11, 2018 Share Posted January 11, 2018 Can you find out what time your server is set up to? Sorry was this a shared host or your own VPS / localhost? Has it been working before or is this a new board ? Liked what i posted remember to feed me a cookie ->Or you can add a cookie to my Link to comment Share on other sites More sharing options...
Wells Posted January 11, 2018 Author Share Posted January 11, 2018 (edited) 55 minutes ago, Cookie Monster said: Can you find out what time your server is set up to? Sorry was this a shared host or your own VPS / localhost? Has it been working before or is this a new board ? Europe/Bucharest Thu Jan 11 11:04:10 EET 2018 No, it's not my own VPS/localhost. IPB was working perfectly 3 months ago with the same webhost provider. But i don't understand why IPS works, shouldn't both of them not work ? Edited January 11, 2018 by Wells Link to comment Share on other sites More sharing options...
Cookie Monster Posted January 11, 2018 Share Posted January 11, 2018 1 hour ago, Wells said: Europe/Bucharest Thu Jan 11 11:04:10 EET 2018 No, it's not my own VPS/localhost. IPB was working perfectly 3 months ago with the same webhost provider. But i don't understand why IPS works, shouldn't both of them not work ? Register a new user, set its usergroup to admin in the SQL then try login with that will Liked what i posted remember to feed me a cookie ->Or you can add a cookie to my Link to comment Share on other sites More sharing options...
Wells Posted January 11, 2018 Author Share Posted January 11, 2018 (edited) 5 hours ago, Cookie Monster said: Register a new user, set its usergroup to admin in the SQL then try login with that will Tried right now, same error.. Edited January 11, 2018 by Wells Link to comment Share on other sites More sharing options...
agisthos Posted June 27, 2018 Share Posted June 27, 2018 Hi Wells, did you find a solution to this problem? I have come across the same with one of my 3.4x boards. Link to comment Share on other sites More sharing options...
kamil445 Posted October 30, 2018 Share Posted October 30, 2018 (edited) 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 ? Edited October 30, 2018 by kamil445 1 Link to comment Share on other sites More sharing options...
Polit Posted November 3, 2018 Share Posted November 3, 2018 On 10/30/2018 at 10:12 AM, kamil445 said: 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 ? 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! 2 2 Link to comment Share on other sites More sharing options...
rouslan Posted November 14, 2018 Share Posted November 14, 2018 Ah Link to comment Share on other sites More sharing options...
rettycbs Posted February 8, 2019 Share Posted February 8, 2019 On 1/7/2018 at 6:30 AM, Jeffrey said: I've looked into the "admin/sources/base/ipsController.php" file on line 306 and the software is trying to execute and read your class permissions. I assume this is to read and validate your permissions as an admin when logging into the admin control panel. Try to upgrade your files from the existing forum software using this download: Go into your host's phpmyadmin, go into the admin_core table, and look for an issue related to your permissions. If you still have access to the admin control panel and allowed to access the membergroups section, try to make a new admin group, set all the permissions your admin account has, and set your account to this new membergroup. If you already have other admin member groups on your forum already and can't access the admin control panel, you can change your membergroup via the core_members table. Edit the existing tables for your account and change the member_group_id to the same id as another admin membergroup. Its not working the download file Link to comment Share on other sites More sharing options...
gbob1 Posted August 1, 2020 Share Posted August 1, 2020 On 11/3/2018 at 3:43 AM, Polit said: 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! This worked for me, no need to download further files Link to comment Share on other sites More sharing options...
Recommended Posts