Over the last few months certain site functions are reporting errors or just stopped working. For instance private messages will not load, posting comments to blogs stopped working, posting blogs throws a error code. My host fast comet is giving me this advice . I am using oxwall 1.8.4 build 10800. Any suggestions on how i can fix this . I am not very computer literate forgive me in advance if your advice flies over my head. first is the error I am seeing on the network . Second is what the host is telling me .
SQLSTATE[42000]: Syntax error or
access violation: 1064 You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'DESC, `m` DESC' at line 4
File:
/home/satanici/public_html/social/ow_core/database.php
Line:
723
Trace:
#0 /home/satanici/public_html/social/ow_core/database.php(723): PDOStatement->execute()
#1 /home/satanici/public_html/social/ow_core/database.php(414): OW_Database->execute('\r\n\t\t\tSELECT YEA...', Array)
#2 /home/satanici/public_html/social/ow_plugins/blogs/bol/dao/post_dao.php(319): OW_Database->queryForList('\r\n\t\t\tSELECT YEA...', Array)
#3 /home/satanici/public_html/social/ow_plugins/blogs/bol/service/post_service.php(162): PostDao->findUserArchiveData(6726)
#4 /home/satanici/public_html/social/ow_plugins/blogs/controllers/view.php(261): PostService->findUserArchiveData(6726)
#5 [internal function]: BLOGS_CTRL_View->index(Array)
#6 /home/satanici/public_html/social/ow_core/request_handler.php(250): ReflectionMethod->invokeArgs(Object(BLOGS_CTRL_View), Array)
#7 /home/satanici/public_html/social/ow_core/request_handler.php(226): OW_RequestHandler->processControllerAction(Object(ReflectionMethod), Object(BLOGS_CTRL_View))
#8 /home/satanici/public_html/social/ow_core/application.php(346): OW_RequestHandler->dispatch()
#9 /home/satanici/public_html/social/index.php(76): OW_Application->handleRequest()
#10 {main}
Type:
------------------------------------
Host message ------------------------------------------------------------------------------------------------------------------------------------------
Note that the errors generated is the following:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an
error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'DESC, `m` DESC'
at line 4
This is a syntax error which indicates your database syntax is
incompatible with MYSQL 8. Note that this issue appears to have been
present even before downgrading as the previous server on which you
resided was with the exact same MySQL Version and configuration.
I would recommend contacting a certified MySQL expert who'd be able to
review the error and the database syntax and apply the necessary
changes. And if any changes are required on our end, simply update us
via this ticket with the specifics and we will gladly assist you
accordingly.
-------------------------------------------------------
Please note that MySQL 8 is actually server-wide software, and thus,
performing this change will impact all of our users on the named server.
Thus, reverting the MySQL version would not be doable.
You should consider upgrading your software, so that's MySQL 8
compatible, otherwise, you can consider purchasing a VPS/DS solution,
where we can rebuild the server for you to CentOS 7 and install MySQL
5.7 for you. You can review our VPS or Dedicated CPU Servers at the
links below:
> https://www.fastcomet.com/cloud-vps-hosting – Cloud VPS
> https://www.fastcomet.com/dedicated-server-hosting – Dedicated CPU Servers
PDOException
