Log in
Search

Database exception error

  • Public
Started by Marielle Lange 11 Apr 2011 12:00am () Replies (4)

Following this link:

/mod/threaded_forums/topicposts.php?topic=42263&group_guid=26613#annotation-6927

Returns this:

DatabaseException


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND a.entity_guid = r.guid_two AND e.type='object' AND e.subtype = 9 ORDER BY a.' at line 1
QUERY: SELECT distinct e.*, a.*, n.string AS name, v.string AS value FROM elgg_entity_relationships r JOIN elgg_entities e JOIN elgg_annotations a on e.guid = r.guid_one JOIN elgg_metastrings v ON a.value_id = v.id JOIN elgg_metastrings n ON a.name_id = n.id WHERE r.relationship='group_discussion_top_level_post' AND r.guid_one=42263 AND r.guid_two != AND a.entity_guid = r.guid_two AND e.type='object' AND e.subtype = 9 ORDER BY a.time_created ASC LIMIT 0,10

 

Replies

Join this group to contribute to discussions.

VLN Website Development

VLN Website Development

A place to discuss the ongoing development of the VLN.