CGUserDirectory (error in count query)

[urheat]

Hi!

I just installed fresh 1.11.6, CGUserDirectory 1.3. and FrontEndUsers 1.21.14.

I added some users and tried to use CGUserDirectory tag: {CGUserDirectory action="directory"}

If I click a letter, I'll get an error message:

Code: Select all

DEBUG: error in count query
  QUERY = SELECT * from cms_module_templates WHERE module_name = 'CMSPrinting' and template_name = 'linktemplate' LIMIT 1
  Error =

If I try for example:
{CGUserDirectory prop="sijainti" uselike=1 propval="ds%"}

It works. Though if I change propval-attribute to something that there won't be any items, I'll get an error message:

Code: Select all

DEBUG: error in count query
  QUERY = SELECT count(U.id) FROM cms_module_feusers_users U LEFT JOIN cms_module_feusers_properties P ON U.id = P.userid AND P.title = 'sijainti' WHERE expires > '2013-04-25 10:42:35' AND P.data LIKE 'ds%%' LIMIT 1
  Error =

Thanks in advance

[Dr.CSS]

System info would be nice, most likely that module needs PHP 5.3 at least...

[urheat]

System info would be nice, most likely that module needs PHP 5.3 at least...

Thanks Dr.CSS!

I tried site in two different servers, but the error still remains.

PHP: 5.3.18
server_db_type: mysql (mysqli)
server_db_version: 5.5.28

Only notice in System Information is: Test Curl Version version 7.15.5, minimum recommended version is 7.19.7

[urheat]

This is a bug. I founded related bug report:
http://dev.cmsmadesimple.org/bug/view/8002

There was also solution that seemed to work also with my site. Hopefully this will be fixed in the next release of CGUserDirectory.