[SOLVED] Cant install new 2.0

bigk wrote: I've traced the pagination issue to a custom plugin created (by a freelancer) to show number of articles per person. Whenever this plugin is enabled , pagination goes away. Challenge now is to find which aspect of that plugin creates the conflict.

If you can help debug, I'll donate the plugin to the community

I would throw that plugin away it is not a clean solution as it appears to be a copy paste of one of the core xml files of CB (no wonder you are having issues).

I would just use the CB Query field to execute a simple query to count and show the number of articles you want.

Also you should check-out the CB Articles plugin (part of CB 2.0+) as it can be used to show article links for each profile.

Very very helpful. Thanks.

Next challenge is to get the right sql query.

If you just want to count the number of Joomla articles the user has then the below would work.

Count Users Articles:
Count Users Published Articles:
Count Users Unpublished Articles:
Note these are all copy-paste ready for CB Query Field and its Query fieldtype usage.

PERFECTO! Works great.

Can this field be made sortable in members list?

As it's a calculated field, no. However, you can use Advanced mode in the sorting of your userlist. Edit your userlist within CB > List Management then click Sorting then select "Advanced" and supply it the below query (whichever you're wanting).

Sort By Total Articles:
Sort By Total Published Articles:
Sort By Total Unpublished Articles:

ZIGACKLY!!!

I simply added DESC at the end, and I'm good to go.

You guys ROCK!!! and this tool is much more powerful than I thought. All it needs is packaging and marketing.