We have moved to Github. Please open tickets there.

Opened 5 years ago

Closed 5 years ago

Last modified 5 years ago

#53 closed Defect (fixed)

'Enabled' functionality needs to be added on annotations to fix query errors

Reported by: ben Owned by: marcus
Priority: critical Milestone:
Component: Core Version: 1.0
Severity: blocker Keywords:
Cc: brettp Difficulty:

Description

eg:

Unknown column 'a.enabled' in 'where clause' QUERY: SELECT count(ms.string) as sum from elggannotations a JOIN elggentities e on a.entity_guid = e.guid JOIN elggmetastrings ms on a.value_id=ms.id WHERE e.guid=4 and (a.access_id in (2,1) or (a.access_id = 0 and a.owner_guid = 2)) and a.enabled='yes'

Note it says 'a.enabled', not 'e.enabled'.

Change History (2)

comment:1 Changed 5 years ago by marcus

  • Resolution set to fixed
  • Status changed from new to closed

I do not believe that a.enabled is a bug here.

comment:2 Changed 5 years ago by marcus

(In [svn:986]) Fixes #54 - 'Enabled' functionality needs to be added to metadata, refs #53

Note: See TracTickets for help on using tickets.