I get this error when adding a reciprocal relationship:
WordPress database error: [Unknown column 'wp_posts.ID' in 'field list']
SELECT wpec_posts.* , mbr.from AS mbr_from, mbr.to AS mbr_to, mbr.ID AS mbr_id, CASE WHEN mbr.to = wp_posts.ID THEN mbr.order_from WHEN mbr.from = wp_posts.ID THEN mbr.order_to END AS <code>mbr_order</code> FROM wpec_posts INNER JOIN wpec_mb_relationships AS mbr ON (mbr.type = 'attendance_to_student_present' AND ((mbr.from = wpec_posts.ID AND mbr.to IN (794)) OR (mbr.to = wpec_posts.ID AND mbr.from IN (794)))) WHERE 1=1 AND wpec_posts.post_type IN ('post', 'page', 'attachment', 'attendance', 'location', 'property', 'agent') AND (wpec_posts.post_status = 'publish' OR wpec_posts.post_author = 1 AND wpec_posts.post_status = 'private') GROUP BY mbr_from, mbr_to, wpec_posts.ID ORDER BY <code>mbr_order</code> ASC, mbr_id DESC
As you can see the table prefix is 'wpec_' and not 'wp_', but it seems as though the wp_posts has been hardcoded into the plugin (line 78 in query.php)
.
