Loading...
 
Features / Usability

Features / Usability


Column 'parentId' in where clause is ambiguous - Statistics

posts: 21 Germany

Hi there,

when I click "Statistics" it comes up this error:
Tiki version is: 21

System error.

The following error message was returned:

Column 'parentId' in where clause is ambiguous

The query was:
select count(*) from `tiki_comments`,`tiki_forums` where `object`=`forumId` and `objectType`=? and `parentId`=?

Values:

    forum
    0

The built query was likely:
select count(*) from `tiki_comments`,`tiki_forums` where `object`=`forumId` and `objectType`='forum' and `parentId`='0'


When I use this Select on a different TW installation, there is the same error. In this installation the built in Statisitcs are ok. (Comments and Forum is not active there).

Any idea?

Thanks


posts: 21 Germany

Hi Jonny,

thanks - now it works!