[fixed] orderby error

More
9 years 9 months ago - 9 years 9 months ago #23799 by onimaro
I get this error when try to access component geocommunity

0 Unknown column 'a.show_groups' in 'where clause' SQL=SELECT COUNT(*) FROM `n5fn4_geommunity3js_maps` AS a LEFT JOIN n5fn4_users AS uc ON uc.id=a.checked_out LEFT JOIN n5fn4_users AS created_by ON created_by.id = a.created_by WHERE (a.state IN (0, 1)) AND a.show_groups = '0' Unknown column 'a.show_groups' in 'where clause' SQL=SELECT a.*,uc.name AS editor,created_by.name AS created_by FROM `n5fn4_geommunity3js_maps` AS a LEFT JOIN n5fn4_users AS uc ON uc.id=a.checked_out LEFT JOIN n5fn4_users AS created_by ON created_by.id = a.created_by WHERE (a.state IN (0, 1)) AND a.show_groups = '0' ORDER BY a.id asc LIMIT 0, 20 Unknown column 'a.show_groups' in 'where clause' SQL=SELECT COUNT(*) FROM `n5fn4_geommunity3js_maps` AS a LEFT JOIN n5fn4_users AS uc ON uc.id=a.checked_out LEFT JOIN n5fn4_users AS created_by ON created_by.id = a.created_by WHERE (a.state IN (0, 1)) AND a.show_groups = '0'
Last edit: 9 years 9 months ago by nordmograph.

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

More
9 years 9 months ago #23807 by nordmograph
Hello

I see, p'robably because you where trying to filter by groups and Jomsocial does not have groups location.
I removed the option from the Jomscicla version and repacked.
You can redownload the latest version.

Thank you for reporting.
Let me know if it fixes it for for you.

- Need help? Post the URL of the related page (eventualy as confidential info), it will help solve your issue faster.
- An error, notice or warning? report the exact message including the line number
- If you get a white page , enable error reporting and / or check your server error logs.

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

More
9 years 9 months ago #23811 by onimaro
Thank now working all good

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

Time to create page: 0.319 seconds
Powered by Kunena Forum
Disclaimer: Nordmograph is not affiliated with or endorsed by The Joomla! Project™. Any products and services provided through this site are not supported or warrantied by The Joomla! Project or Open Source Matters, Inc. Use of the Joomla!® name, symbol, logo and related trademarks is permitted under a limited license granted by Open Source Matters, Inc.