Elxis CMS Forum
Support => General => Topic started by: bully on June 14, 2019, 11:45:05
-
Hi ..,
today, I wanted to update a page, content only.
Whilst all appears on first look as normal, ................ /content/articles/edit.html?id=xx oly returns white pages. in fact on all pages and that on TWO sites. Neither a new page can be created but pages can be copied and deleted
Both sites where recently moved and restored via the the regular cPanel restore.
All other, as editing, adding categories ... appears working as normal
Anyone has any ideas, what did happen? yes, it's on TWO sites
bully
the error log:
File name: error.log
Last modified: June 14, 2019 16:13
[2019-06-14 09:13:24] ERROR in file /home/xxxxx/public_html/includes/libraries/elxis/database/statement.class.php line 41
Uncaught PDOException: SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'xxxxx_new.elx_content.created' which is not in SELECT list; this is incompatible with DISTINCT in /home/xxxxx/public_html/includes/libraries/elxis/database/statement.class.php:41
Stack trace:
#0 /home/xxxxx/public_html/includes/libraries/elxis/database/statement.class.php(41): PDOStatement->execute(NULL)
#1 /home/xxxxx/public_html/components/com_content/models/content.model.php(1721): elxisPDOStatement->execute()
#2 /home/xxxxx/public_html/components/com_content/controllers/aarticle.php(658): contentModel->fetchArticlesImages(100)
#3 /home/xxxxx/public_html/components/com_content/content.php(59): aarticleContentController->editarticle()
#4 /home/xxxxx/public_html/includes/libraries/elxis/document.class.php(1173): contentRouter->route()
#5 /home/xxxxx/public_html/includes/libraries/elxis/document.class.php(981): elxisDocument->renderComponent()
#6 /home/
mysql Ver 14.14 Distrib 5.7.26, for Linux (x86_64) using EditLine wrapper
PHP 7.2.19 (cli) (built: Jun 3 2019 21:02:20) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
with the ionCube PHP Loader (enabled) + Intrusion Protection from ioncube24.com (unconfigured) v10.3.2, Copyright (c) 2002-2018, by ionCube Ltd.
with Zend OPcache v7.2.19, Copyright (c) 1999-2018, by Zend Technologies
-
sorted:
add in /etc/my.cnf near the end: sql_mode='' or if any entries in sql_mode= , then erase them
-
Bravo @bully that you found the issue.
-
yes, if I ask something and sometimes, I can fix it later myself, I reply to myself with the solution. It might help others. Others might search around to help, but it's fixed. Waste of others time is well
Is a question of manner for me
bully