System error.

The following error message was returned:

Column 'average' in order clause is ambiguous

The query was:

SELECT COUNT(*) FROM (SELECT `a`.`threadId`, COALESCE(a.`archived`, 'n') as `archived`, COALESCE(max(b.`commentDate`), a.`commentDate`) as `lastPost`, COALESCE(a.`type`='s', false) as `sticky`, count(distinct b.`threadId`) as `replies` from `tiki_comments` a left join `tiki_comments` b on b.`parentId`=a.`threadId` where 1 = 1 AND a.`object`=? and (a.`archived` is null or a.`archived`=?) and a.`objectType` = 'forum' and a.`parentId` = ? group by a.`threadId`order by `sticky` desc, `average` asc, `threadId`) a

Values:

  1. 6
  2. n
  3. 0

The built query was likely:

SELECT COUNT(*) FROM (SELECT `a`.`threadId`, COALESCE(a.`archived`, 'n') as `archived`, COALESCE(max(b.`commentDate`), a.`commentDate`) as `lastPost`, COALESCE(a.`type`='s', false) as `sticky`, count(distinct b.`threadId`) as `replies` from `tiki_comments` a left join `tiki_comments` b on b.`parentId`=a.`threadId` where 1 = 1 AND a.`object`='6' and (a.`archived` is null or a.`archived`='n') and a.`objectType` = 'forum' and a.`parentId` = '0' group by a.`threadId`order by `sticky` desc, `average` asc, `threadId`) a

Things to check:

  1. Is your database up and running?

  2. Is your database corrupt? Please see how to repair your database

  3. Are your database credentials accurate? (username, database name, etc in db/local.php)

  4. Did you complete the Tiki Installer?

Please see the documentation for more information.