Hi
Ok I am using IPB 3.4.9 because i like it and it works great when it works anyway this is the error I get which is well known
"There appears to be an error with the database.
If you are seeing this page, it means there was a problem communicating with our database. Sometimes this error is temporary and will go away when you refresh the page. Sometimes the error will need to be fixed by an administrator before the site will become accessible again.
You can try to refresh the page by clicking here"
Any help to fix this would be appreciated.
I am also not very savvy with SQL so please explain simply if possible.
I have repaired the database 3 times with no issues but still the same problem I have also reinstall 3.4.9 several times as well as recreating new databases
all with the exact same issue I{PB 3.4.9 was downloaded from Webflake (today 9th Mar 2020) The below is the from the "sql_error_log_03_09_20.cgi" file
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 09 Mar 2020 05:04:44 +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 > 1583729384' at line 1
IP Address: 220.240.72.3 - /admin/index.php?adsess=23dc7c49b450093050c7be888900fd53&old_
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT count(*) as rows FROM sessions WHERE running_time > 1583729384
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/base/ipsController.php | [admin_core_mycp_dashboard].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
The below is from the "sql_error_latest.cgi" file.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 09 Mar 2020 05:04:44 +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 > 1583729384' at line 1
IP Address: 220.240.72.3 - /admin/index.php?adsess=23dc7c49b450093050c7be888900fd53&old_
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT count(*) as rows FROM sessions WHERE running_time > 1583729384
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/base/ipsController.php | [admin_core_mycp_dashboard].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'