HELP!!! Error 1064 when users try to access my site - Joomla! Forum - community, help and support
hi all,
i having trouble site (shukorf.co.uk). when users load website, presented error. (i using version 3.2)
1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near 'order content.created desc' @ line 28 sql=select content.id iid, content.access access, categories.title catname, users.email author_email, content.created_by_alias author_alias, content_rating.rating_sum rating_sum, content_rating.rating_count rating_count, case when char_length(content.alias) concat_ws(":", content.id, content.alias) else content.id end id, case when char_length(categories.alias) concat_ws(":", categories.id, categories.alias) else categories.id end cid xg6zxarh4_jos_content content left join xg6zxarh4_jos_categories categories on categories.id = content.catid left join xg6zxarh4_jos_users users on users.id = content.created_by left join xg6zxarh4_jos_content_rating content_rating on content_rating.content_id = content.id order content.created desc
you may not able visit page because of:
an out-of-date bookmark/favourite
a search engine has out-of-date listing site
a mistyped address
you have no access page
the requested resource not found.
an error has occurred while processing request.
please try 1 of following pages:
home page
if difficulties persist, please contact system administrator of site , report error below..
you have error in sql syntax; check manual corresponds mysql server version right syntax use near 'order content.created desc' @ line 28 sql=select content.id iid, content.access access, categories.title catname, users.email author_email, content.created_by_alias author_alias, content_rating.rating_sum rating_sum, content_rating.rating_count rating_count, case when char_length(content.alias) concat_ws(":", content.id, content.alias) else content.id end id, case when char_length(categories.alias) concat_ws(":", categories.id, categories.alias) else categories.id end cid xg6zxarh4_jos_content content left join xg6zxarh4_jos_categories categories on categories.id = content.catid left join xg6zxarh4_jos_users users on users.id = content.created_by left join xg6zxarh4_jos_content_rating content_rating on content_rating.content_id = content.id order content.created desc
what mean , how fix it? (i can still access joomla administration interface)
i having trouble site (shukorf.co.uk). when users load website, presented error. (i using version 3.2)
1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near 'order content.created desc' @ line 28 sql=select content.id iid, content.access access, categories.title catname, users.email author_email, content.created_by_alias author_alias, content_rating.rating_sum rating_sum, content_rating.rating_count rating_count, case when char_length(content.alias) concat_ws(":", content.id, content.alias) else content.id end id, case when char_length(categories.alias) concat_ws(":", categories.id, categories.alias) else categories.id end cid xg6zxarh4_jos_content content left join xg6zxarh4_jos_categories categories on categories.id = content.catid left join xg6zxarh4_jos_users users on users.id = content.created_by left join xg6zxarh4_jos_content_rating content_rating on content_rating.content_id = content.id order content.created desc
you may not able visit page because of:
an out-of-date bookmark/favourite
a search engine has out-of-date listing site
a mistyped address
you have no access page
the requested resource not found.
an error has occurred while processing request.
please try 1 of following pages:
home page
if difficulties persist, please contact system administrator of site , report error below..
you have error in sql syntax; check manual corresponds mysql server version right syntax use near 'order content.created desc' @ line 28 sql=select content.id iid, content.access access, categories.title catname, users.email author_email, content.created_by_alias author_alias, content_rating.rating_sum rating_sum, content_rating.rating_count rating_count, case when char_length(content.alias) concat_ws(":", content.id, content.alias) else content.id end id, case when char_length(categories.alias) concat_ws(":", categories.id, categories.alias) else categories.id end cid xg6zxarh4_jos_content content left join xg6zxarh4_jos_categories categories on categories.id = content.catid left join xg6zxarh4_jos_users users on users.id = content.created_by left join xg6zxarh4_jos_content_rating content_rating on content_rating.content_id = content.id order content.created desc
what mean , how fix it? (i can still access joomla administration interface)
the technical problem there no conditions specified in clause. @ modules published home menu item , system plugins. 1 of them might produce faulty sql. unpublish/disable it.
Comments
Post a Comment