Opened 4 years ago
Closed 3 years ago
#1307 closed Defect (invalid)
error creating sql in get_entities_from_annotations function
| Reported by: | mybadminton | Owned by: | |
|---|---|---|---|
| Priority: | normal | Milestone: | Elgg 1.7 |
| Component: | Core | Version: | 1.6 |
| Severity: | minor | Keywords: | |
| Cc: | brettp | Difficulty: |
Description
$query .= "from {$CONFIG->dbprefix}annotations a JOIN {$CONFIG->dbprefix}entities e on e.guid = a.entity_guid ";
if ($value != "")
$query .= " JOIN {$CONFIG->dbprefix}metastrings v on a.value_id=v.id";
if (($group_guid != 0) && ($entity_type=='object')) $query .= "JOIN {$CONFIG->dbprefix}objects_entity o on o.guid = e.guid"; $query .= " where";
need a space before "JOIN"
" JOIN {$CONFIG->dbprefix}objects_entity o on o.guid =..."
Change History (1)
comment:1 Changed 3 years ago by cash
- Resolution set to invalid
- Status changed from new to closed
Note: See
TracTickets for help on using
tickets.

get_entities_from_annotations() has been replaced by the new elgg_get* functions