Jump to content

Sort by Services on admin/clients.php


Recommended Posts

If you click the "services" header on the View/Search clients page to presumably sort by the number of services each client has, you will no longer be able to view your clients. The only way to resolve it is to clear your browser cookies.


I enabled SQL debugging and noticed this in the log files after this occurs:


SQL Error: Unknown column 'services' in 'order clause' - Full Query: SELECT * FROM tblclients ORDER BY services DESC LIMIT 0,50

Link to comment
Share on other sites


Please ensure you're running the latest release as the "Services" field is a dynamically generated field, and thus not sortable, so shouldn't even be showing as a link. However the way to resolve the list not showing is just to click to sort by another column.



Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated