Database error when selecting a category in image library view
-
Hi – when selecting a category i get the following error message:
error: [Not unique table/alias: ‘goe_term_relationships’]
SELECT SQL_CALC_FOUND_ROWS goe_posts.ID FROM goe_posts LEFT JOIN goe_term_relationships ON (goe_posts.ID = goe_term_relationships.object_id) LEFT JOIN goe_postmeta AS sq1 ON ( goe_posts.ID = sq1.post_id AND sq1.meta_key = ‘_wp_attached_file’ ) LEFT JOIN goe_postmeta ON ( goe_posts.ID = goe_postmeta.post_id AND goe_postmeta.meta_key = ‘w3tc_imageservice_file’ ) LEFT JOIN goe_posts AS p2 ON (goe_posts.post_parent = p2.ID) LEFT JOIN ( goe_term_relationships INNER JOIN goe_term_taxonomy ON goe_term_taxonomy.term_taxonomy_id = goe_term_relationships.term_taxonomy_id INNER JOIN goe_terms ON goe_terms.term_id = goe_term_taxonomy.term_id ) ON goe_posts.ID = goe_term_relationships.object_id WHERE 1=1 AND goe_posts.ID NOT IN (3103) AND ( goe_term_relationships.term_taxonomy_id IN (460) ) AND ( goe_postmeta.post_id IS NULL ) AND goe_posts.post_type = ‘attachment’ AND (((goe_posts.post_status = ‘inherit’ OR goe_posts.post_status = ‘private’) OR (goe_posts.post_status = ‘inherit’ AND (p2.post_status = ‘inherit’ OR p2.post_status = ‘private’)))) OR ( goe_term_taxonomy.taxonomy IN( ‘img-categories’ ) AND goe_terms.name LIKE ‘%%’ ) GROUP BY goe_posts.ID ORDER BY goe_posts.post_date DESC LIMIT 0, 20I use custom prefix for database tables. Is this the cause? regards theo
- The topic ‘Database error when selecting a category in image library view’ is closed to new replies.