-
Hi,
I installed JA Slideshow 3 to bookshop template, when i open any articles, it display 1054 error:
1054
Unknown column ‘u.name’ in ‘order clause’ SQL=SELECT a.id, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(‘:’, a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(‘:’, cc.id, cc.alias) ELSE cc.id END as catslug FROM xhf82_content AS a LEFT JOIN xhf82_categories AS cc ON cc.id = a.catid WHERE a.catid = 95 AND a.state = 1 AND a.access = 1 AND (a.state = 1 OR a.state = -1) AND (publish_up = ‘0000-00-00 00:00:00’ OR publish_up <= ‘2014-01-23 10:09:57’) AND (publish_down = ‘0000-00-00 00:00:00’ OR publish_down >= ‘2014-01-23 10:09:57’) ORDER BY a.created_by_alias, u.nameHelp me please.
<blockquote>1. Slideshow:
If i set up Slideshow “Source” to “From Articles”, click slideshow images then display 1054 error, but if i change the “Source” to “From Image Folder”, the link working good.
</blockquote>It’s the issue of Joomla SEF. In this case, I created a new item “Slideshow” in menu “Top” – The issue get fixed now.
<blockquote>
2. Sidebar menu:
All don’t working, display 1054 error.
</blockquote>Could you be more specific on this please?
Quick update:
<blockquote>2. Sidebar menu:
All don’t working, display 1054 error.</blockquote>I have checked your site and detected that the issue was due to database problem.
1. In articles of your site, there appear duplicated alias
in category “Investment” and “Home Page Articles”:
This is not possible – each article should not have overlapped alias.
When I tested with other category “Articles_fp” and created a new menu “article fp” in menu “Top” – the problem gets fixed.
In the case, please remove category “Home Page Articles” and all its articles, then re-create new category and articles. I thinks it should fix.
Viewing 6 posts - 1 through 6 (of 6 total)This topic contains 6 replies, has 2 voices, and was last updated by
canadatony 10 years, 11 months ago.
We moved to new unified forum. Please post all new support queries in our New Forum
1054 error: Unknown column ‘u.name’ in ‘order clause’ SQL=SELECT a.id
Forums Joomla Templates Club JA Bookshop 1054 error: Unknown column 'u.name' in 'order clause' SQL=SELECT a.id
Viewing 6 posts - 1 through 6 (of 6 total)
