Loading...
 
Features / Usability

Features / Usability


Column 'parentId' in where clause is ambiguous - Statistics

posts: 32 Germany

Hi there,

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

Copy to clipboard
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: 32 Germany

Hi Jonny,

thanks - now it works!


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting