Article not opening

[nikos65]

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 !

[webgift]

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.

[nikos65]

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 ! 

[nikos65]

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-

[webgift]

Please send me (FTP and Back-end) access through Private Message to
check this out.

[nikos65]

Hi , i have send you PM.
Thank you a lot !

[datahell]

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;

[datahell]

UPDATE! I updated the file, re-download it. It should work now.

[nikos65]

It works !!

Thank you so much Datahell !!