DIscussion order (aC 1.1.5)

avatar grzegorz_d Pro Mar 30. 2009. 1:52 pm #1
Is there any way to display discussion posts from the latest to oldest instead oldest to latest? Clicking through pages in Discussions module to spot the last post is painful.
avatar Ilija Studen Staff Mar 30. 2009. 3:18 pm #2
There is a known error with discussion sorting that will be fixed in the next release. In the meantime, please execute this SQL query:

UPDATE acx_project_objects SET boolean_field_1 = '0' WHERE type = 'Discussion' AND boolean_field_1 IS NULL


Please note that this is not permanent fix. If you use discussions a lot, you should execute it for time to until the next upgrade.
Follow @activecollab and activeCollab on Facebook.
avatar grzegorz_d Pro Mar 30. 2009. 3:23 pm #3
Many thanks Ilija, where (or how) can I execute this SQL query? I am not the programmer...
avatar Ilija Studen Staff Mar 30. 2009. 3:37 pm #4
Than maybe it's better to avoid playing with the database directly and wait for the release that fixes the issue. Still, if you still wish to do this, you should use MySQL management tool (such is phpMyAdmin for example) and execute the query. These tools give you interface for doing most of the things, but they also let you run SQL commands directly.
Follow @activecollab and activeCollab on Facebook.

activeCollab

Demo

Tools

Community

Getting Started

Documentation

My activeCollab

If you are already an activeCollab user, you can visit your control panel to download installation and upgrade packages, request assistance, renew support etc.

My activeCollab

Try activeCollab free for 30 days, No credit card required!

Instant access to activeCollab, no installation needed.

.tryactivecollab.com

If you are already a user of activeCollab, you can log in here.