Problema admin panel

[Alecs Andru]

Salutare , am si eu erorile astea si nu pot accesa admin panelul, spune : 

There appears to be an error with the database.

 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Tue, 05 May 2020 11:54:21 +0000
 Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows FROM sessions WHERE running_time > 1588678761' at line 1
 IP Address: 86.120.171.46 - /forum/admin/index.php?adsess=760d8b50fffbc05cf6e27a4d08ddcab2
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT count(*) as rows FROM sessions WHERE running_time > 1588678761
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsController.php                                       | [admin_core_mycp_dashboard].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Tue, 05 May 2020 11:54:29 +0000
 Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows FROM sessions WHERE running_time > 1588678769' at line 1
 IP Address: 86.120.171.46 - /forum/admin/index.php?adsess=760d8b50fffbc05cf6e27a4d08ddcab2
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT count(*) as rows FROM sessions WHERE running_time > 1588678769
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsController.php                                       | [admin_core_mycp_dashboard].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Tue, 05 May 2020 11:55:38 +0000
 Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows FROM sessions WHERE running_time > 1588678838' at line 1
 IP Address: 86.120.171.46 - /forum/admin/index.php?adsess=760d8b50fffbc05cf6e27a4d08ddcab2
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT count(*) as rows FROM sessions WHERE running_time > 1588678838
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsController.php                                       | [admin_core_mycp_dashboard].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 

[Alecs Andru]

Just now, Alecs Andru said:

Salutare , am si eu erorile astea si nu pot accesa admin panelul, spune : 

There appears to be an error with the database.

 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Tue, 05 May 2020 11:54:21 +0000
 Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows FROM sessions WHERE running_time > 1588678761' at line 1
 IP Address: 86.120.171.46 - /forum/admin/index.php?adsess=760d8b50fffbc05cf6e27a4d08ddcab2
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT count(*) as rows FROM sessions WHERE running_time > 1588678761
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsController.php                                       | [admin_core_mycp_dashboard].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Tue, 05 May 2020 11:54:29 +0000
 Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows FROM sessions WHERE running_time > 1588678769' at line 1
 IP Address: 86.120.171.46 - /forum/admin/index.php?adsess=760d8b50fffbc05cf6e27a4d08ddcab2
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT count(*) as rows FROM sessions WHERE running_time > 1588678769
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsController.php                                       | [admin_core_mycp_dashboard].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Tue, 05 May 2020 11:55:38 +0000
 Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows FROM sessions WHERE running_time > 1588678838' at line 1
 IP Address: 86.120.171.46 - /forum/admin/index.php?adsess=760d8b50fffbc05cf6e27a4d08ddcab2
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT count(*) as rows FROM sessions WHERE running_time > 1588678838
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsController.php                                       | [admin_core_mycp_dashboard].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 

Rezolvat. Puteti inchide topicul !

[Alecs Andru]

Pentru cei ce au probleme si nu pot accesa admin panelul aveti rezolvarea aici :

Cauta si intra in urmatorul fisier : admin\applications\core\modules_admin\mycp\dashboard.php

Undeva la linia 377 copiaza codul asta :

$online	= $this->DB->buildAndFetch( array( 'select' => 'count(*) as fixme', 'from' => 'sessions', 'where' => "running_time > {$time}" ) );

Iar la undeva la linia 379 copiaza codul asta :

 

$stats['active_users']	= $online['fixme'];