Elxis CMS Forum

Support => General => Topic started by: nikos65 on August 25, 2018, 13:23:24

Title: Article not opening
Post by: nikos65 on August 25, 2018, 13:23:24: Hi All,
I m facing a problem regaring the article handling. I cann't open existing page or to create a new article everything leeds to a blank page and only at google chrome appears to the HTTP ERROR 500 message your server can't handle the request !

Any help will be appreciated !
Thank you !
Title: Re: Article not opening
Post by: webgift on August 27, 2018, 09:46:35: Please check the following. One of these will cause such an issue.
1. Check the error log file of your website. Blank pages means fatal error!
2. Check the .htaccess file. A rule may block access this page.
3. PHP time out. The script has exceeded the available time to run.
4. File and/or folder permissions.

Most probably the solution will come from one of the first two causes.
Title: Re: Article not opening
Post by: nikos65 on August 27, 2018, 17:42:59: Hi Stavros ,Thank you for your reply ,
As i can see there is no error at the error log and the .htaccess is the recommended from file modified due to the current site.
I assume that the problem comes from my provider and already posted a ticket and i'm waiting there reply.
As soon i have any news i will post it here.

Thank you so much ! :)
Title: Re: Article not opening
Post by: nikos65 on August 28, 2018, 19:40:03: Hi Stavros , i have check my error log and found this error message and this appears at all my sites !
This site is already updated with the latest elxis version v4.6 Phaethon !
Any idea how we can sort it out ?

Thank you in advance !!

[2018-08-28 16:24:13] ERROR in file /home/..../public_html/includes/libraries/elxis/database/statement.class.php line 41
Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column '......_.....elx_content.created' which is not in SELECT list; this is incompatible with DISTINCT' in /home/..../public_html/includes/libraries/elxis/database/statement.class.php:41
Stack trace:
#0 /home/...../public_html/includes/libraries/elxis/database/statement.class.php(41): PDOStatement->execute(NULL)
#1 /home/...../public_html/components/com_content/models/content.model.php(1721): elxisPDOStatement->execute()
#2 /home/....../public_html/components/com_content/controllers/aarticle.php(658): contentModel->fetchArticlesImages(100)
#3 /home/....../public_html/components/com_content/content.php(59): aarticleContentController->editarticle()
#4 /home/....../public_html/includes/libraries/elxis/document.class.php(1173): contentRouter->route()
#5 /home/......./public_html/includes/libraries/elxis/document.class.php(981): elxisDocument-
Title: Re: Article not opening
Post by: webgift on August 29, 2018, 08:50:06: Please send me (FTP and Back-end) access through Private Message to
check this out.
Title: Re: Article not opening
Post by: nikos65 on August 29, 2018, 18:08:41: Hi , i have send you PM.
Thank you a lot ! :)
Title: Re: Article not opening
Post by: datahell on September 01, 2018, 18:15:50: It is a Mysql 5.7.5+ issue, but does not happens always, it depends on the sql_mode setting. It can be solved by editing my.ini configuration file but this is not the desired solution. I upload content.model.php.txt file (for Elxis 4.6). Download it, rename it to content.model.php and upload it to your site at components/com_content/models/ folder overwriting existing file. Tell me the problem is solved. If not, send me a personal message with access details to your phpmyadmin to debug it and find another solution.

Alternatevely if you can go to phpmyadmin and execute the following sql query. Tell me the result.

SELECT @@GLOBAL.sql_mode;
Title: Re: Article not opening
Post by: datahell on September 02, 2018, 09:57:27: UPDATE! I updated the file, re-download it. It should work now.
Title: Re: Article not opening
Post by: nikos65 on September 02, 2018, 16:49:38: It works !!

Thank you so much Datahell !! :)