CMS Made Simple Forums

Posted: **Thu Apr 25, 2013 7:46 am**

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

Posted: **Fri Apr 26, 2013 8:13 pm**

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

Posted: **Sun Apr 28, 2013 5:09 am**

Dr.CSS wrote: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

Posted: **Tue Apr 30, 2013 11:09 am**

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.

CMS Made Simple Forums

CGUserDirectory (error in count query)

CGUserDirectory (error in count query)

Re: CGUserDirectory (error in count query)

Re: CGUserDirectory (error in count query)

Re: CGUserDirectory (error in count query)