eZ Community » Forums » General » Fatal error after Loging in
expandshrink

Fatal error after Loging in

Fatal error after Loging in

Thursday 06 November 2014 5:10:06 pm - 1 reply

Fatal error: The web server did not finish its requestContact website owner with current url and info on what you did, and owner will be able to debug the issue further (by enabling 'display_errors' in php.ini).

This is the error which i got when i try to connect to my website .

I have to clear caches in order to be able to connect to server.

In error.log i have these errors :

   [ Nov 06 2014 17:10:02 ] [192.168.0.253] eZMySQLiDB:Query error (1054): Unknown column 'ezcontentobject_name.content_version' in 'on clause'. Query: SELECT DISTINCT ezcontentobject_tree.node_id, ezkeyword.keyword, a0.sort_key_int                  FROM ezkeyword                       INNER JOIN ezkeyword_attribute_link ON (ezkeyword_attribute_link.keyword_id = ezkeyword.id)                       INNER JOIN ezcontentobject_attribute ON (ezcontentobject_attribute.id = ezkeyword_attribute_link.objectattribute_id)                       INNER JOIN ezcontentobject ON (ezcontentobject_attribute.version = ezcontentobject.current_version AND ezcontentobject_attribute.contentobject_id = ezcontentobject.id)                       INNER JOIN ezcontentobject_tree ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id)                       INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id)                        INNER JOIN ezcontentobject_attribute a0 ON (                                   a0.contentobject_id = ezcontentobject.id AND                                   a0.contentclassattribute_id = 216 AND                                   a0.version = ezcontentobject_name.content_version AND ( a0.language_id & ezcontentobject.language_mask > 0 AND     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 1 )   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 8 ) >> 2 )   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 2 ) << 1 )   <     ( a0.language_id & 1 )   + ( ( a0.language_id & 8 ) >> 2 )   + ( ( a0.language_id & 2 ) << 1 ) ) ) INNER JOIN ezcontentobject_name ON (ezcontentobject_name.contentobject_id = ezcontentobject.id)                                         WHERE                  ezkeyword.keyword LIKE 'Livre%'                  AND ezcontentobject_tree.is_invisible = 0                   AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.section_id in (3)) OR (ezcontentobject.contentclass_id in (28, 29, 30, 32, 33, 34, 42) AND ezcontentobject.section_id in (3)))                                                       AND ezcontentobject_tree.parent_node_id = '645'                  AND ezcontentclass.version = 0                  AND ezcontentobject.status = 1                  AND ezcontentobject_tree.main_node_id = ezcontentobject_tree.node_id                  ORDER BY a0.sort_key_int DESCLIMIT 0, 5[ Nov 06 2014 17:10:02 ] [192.168.0.253] eZTemplate @ extension/beezext_beebuzziness/design/beezdsg_beebuzziness/templates/parts/blog/extra_info.tpl:25[38]:Cannot retrieve attribute of a NULL[ Nov 06 2014 17:10:03 ] [192.168.0.253] index:Undefined module: undefined[ Nov 06 2014 17:10:03 ] [192.168.0.253] error/view.php:Error ocurred using URI: /undefined

Friday 07 November 2014 12:49:32 am

Hello pa,

We had the same problem with that very same query in that same template (on ezecosystem.org's blog templates usage).

The problem is, most likely like our own, that your database server can't keep up in terms of performance (we had a massive dedicated db server and it still had this problem)  and is having weird side affects such as we both reported to others.

Our solution was to comment out the template fetch causing the problem entirely since we really didn't need the feature and it was causing major website and database performance problems (the blog template code for these extra features, in this situation, just doesn't scale well, i hate to say it but it's true) .

Oh and to be clear it's the ezkeyword template operator usage that is triggering the problem query in question.

https://github.com/ezsystems/ezwebin/blob/master/packages/ezwebin_extension/ezextension/ezwebin/design/ezwebin/templates/parts/blog/extra_info.tpl#L15

These are just a few of the performance scaling problems with ezwebin site's which use the default templates without performance testing in production first.

I hope this helps!

Cheers,
Heath 

expandshrink

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu

Proudly Developed with from