Loading...
 
Skip to main content

Custom Share Module 0.1dev

Features / Usability

Features / Usability

Forum List Topic List

Forums » Features / Usability » Column 'parentId' in where clause is ambiguous - Statistics
 
Thread actions
Print this page
  • Print all pages

    • Column 'parentId' in where clause is ambiguous - Statistics

    Posted by Bob 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

    Reads: 7044

    Posted by Bob posts: 32 Germany

    Hi Jonny,

    thanks - now it works!