Are you enjoying the extensions? Did you like the support? Help others decide.

Leave a review

file SELECT not working

More
10 years 2 weeks ago #3911 by biltong
SELECT not working was created by biltong
I have two problems with this extension preventing me from testing/configuring any further. Both are SELECT related. When I select a single Category to display (and display All Levels Sub-Categories), only two of the ~30 links are displayed.

When I select 'All Categories', an eror is displayed as follows:

Error: 1054 - Unknown column 'c.alias' in 'field list' SQL=SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug FROM `vbtj_weblinks` AS a WHERE a.access IN (1,1,5) AND a.state = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-12-01 18:43:26') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-12-01 18:43:26') AND a.language in ('en-GB','*') ORDER BY title asc

The site is:
Joomla 3.6
[url=http://]www.factbucks.org.uk/joomla3/weblinks-test[/url]

Please Log in or Create an account to join the conversation.

More
10 years 2 weeks ago #3912 by admin
Replied by admin on topic SELECT not working
Hello,

I have found what the problem is, can you send an email to [email protected] in order for me to send you the corrected version once I fixed the issue?

Thank you!

Olivier.

Please Log in or Create an account to join the conversation.

More
10 years 2 weeks ago #3913 by admin
Replied by admin on topic SELECT not working
Concerning:

When I select a single Category to display (and display All Levels Sub-Categories), only two of the ~30 links are displayed

I cannot reproduce the issue. It does work fine with my test samples. Did you limit the amount of links to show (max count) or,in the animation tab, the visible items?

Olivier.

Please Log in or Create an account to join the conversation.

More
10 years 2 weeks ago #3914 by biltong
Replied by biltong on topic SELECT not working

admin wrote: Concerning:

When I select a single Category to display (and display All Levels Sub-Categories), only two of the ~30 links are displayed

I cannot reproduce the issue. It does work fine with my test samples. Did you limit the amount of links to show (max count) or,in the animation tab, the visible items?


I'm not using Animation and Visible items parameter value is empty.

Animation settings:

Selection settings:

Configuration settings:

Advanced settings:

Please Log in or Create an account to join the conversation.

More
10 years 2 weeks ago - 10 years 2 weeks ago #3915 by admin
Replied by admin on topic SELECT not working
Your screenshots did not go through.
Could you send them to me? Thank you.
Sorry - no need to. They show in the email I received.

Olivier.
Last edit: 10 years 2 weeks ago by admin.

Please Log in or Create an account to join the conversation.

More
10 years 2 weeks ago #3916 by admin
Replied by admin on topic SELECT not working
I don't see anything abnormal from the screenshots.
Are your links all published? And their categories?

Olivier.

Please Log in or Create an account to join the conversation.