Backend CBLastViewtab problem

chanteur94
OFFLINE
Posts: 302
Thanks: 13
Karma: 1

9 years 6 months ago - 9 years 6 months ago #263025 by chanteur94

Backend CBLastViewtab problem was created by chanteur94

Hi

With CBLastviewtab 3.0.3 (Joomla 3.4.1 cb 2.0.7)

Errors when sorting by users or visitors :

Erreur

Erreur de chargement de la base de données. Vérifiez et réparez votre base de données dans Composants / Community Builder / Outils.
SQL Error (visible to super-admins only): Unknown column 'b.user' in 'order clause' SQL=SELECT b.`username` AS `user`, c.`username` AS `viewer`, a.`lastip`, a.`lastview`, a.`viewscount` FROM `xxxx_comprofiler_views` AS a LEFT JOIN `xxxx_users` AS b ON b.`id` = a.`profile_id` LEFT JOIN `xxxx_users` AS c ON c.`id` = a.`viewer_id` ORDER BY b.`user` LIMIT 0, 20

When sorting by IP Adress :
Sorting seems to be made on the first digit of the IP Adress than the next digit...
Exemple : 110.xx.xx.xx comes before 25.xx.xx.xx who comes before 260.xx.xx.xx

Sorting by views and visits seems ok.

Thank you.

Last edit: 9 years 6 months ago by chanteur94.

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

krileon
ONLINE
Posts: 48478
Thanks: 8282
Karma: 1443

9 years 6 months ago #263047 by krileon

Replied by krileon on topic Backend CBLastViewtab problem

It's an API issue in our XML that we've already fixed for CB 2.0.8. I think the fix is already in our nightly build, which you can download below.

www.joomlapolis.com/downloads/doc_details/640-community-builder-nightly-build

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

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

Moderators: beat, nant, krileon