{"summary":{"analyzed":true,"build_worthy":false,"build_worthy_family_key":"search-visibility","build_worthy_family_name":"search visibility operations","build_worthy_reason":"This row is supporting evidence for the linked opportunity family; use the family card, not this row, for the build decision.","build_worthy_scope":"opportunity_family","comments_returned":30,"commercial_card_missing_count":0,"commercial_card_status":"complete","commercial_context_status":"linked_opportunity","commercial_context_status_label":"Evidence linked to opportunity","evidence_context_status":"linked_opportunity","evidence_context_status_label":"Evidence linked to opportunity","evidence_role":"supports_opportunity_family","evidence_role_label":"Evidence supporting opportunity family","evidence_role_reason":"This row is supporting evidence for the linked opportunity family; use the family card, not this row, for the build decision.","intelligence_role":"supporting_evidence","intelligence_role_label":"Supporting evidence","is_build_worthy":false,"opportunity_context_status":"linked_opportunity","opportunity_context_status_label":"Evidence linked to opportunity","opportunity_decision_status":"supporting_evidence","opportunity_decision_status_label":"Supporting evidence","opportunity_relevance":1.0,"plugin_name":"WP Fast Total Search – The Power of Indexed Search","promotion_reason":"This row is supporting evidence linked to a commercial opportunity family, not the build-worthy opportunity itself.","promotion_status":"linked_opportunity","promotion_status_label":"Evidence linked to opportunity","recommendation_role":"evidence_input","recommendation_role_label":"Evidence input","reply_count":30,"row_is_build_worthy":false,"row_is_opportunity":false,"row_role":"supporting_evidence","row_role_label":"Supporting evidence","sentiment":"complaint","severity":"high","slug":"fulltext-search","source":"support","source_link_count":2,"url":"https://wordpress.org/support/topic/wordpress-database-error-duplicate-entry-20/","worth_validating":false,"source_count":0,"source_evidence_summary":{"total":13,"source_evidence_rows":4,"source_link_rows":4,"source_count_only_rows":0,"missing_source_evidence_rows":9,"source_evidence_not_applicable_rows":0,"source_link_coverage_percent":30.8,"evidence_required_rows":0,"evidence_required_rows_missing_source_links":0,"build_worthy_rows_missing_source_links":0,"decision_rows_missing_source_links":0,"missing_source_examples":[]},"commercial_readiness":{"total":13,"validation_ready":0,"core_validation_ready_rows":0,"family_wide_validation_ready_rows":0,"core_only_validation_ready_rows":0,"validation_scope_status":"not_ready","validation_scope_label":"Not ready","validation_scope_warning":"","validation_scope_counts":[{"scope":"not_validation_ready","label":"Not validation-ready","count":13}],"blocker_count":24,"caution_count":0,"status_counts":[{"status":"needs_external_proof","label":"Needs outside proof","count":12},{"status":"needs_family_proof","label":"Needs family proof","count":1}],"blocker_counts":[{"label":"Outside proof needed: not validated","count":12},{"label":"Commercial gate not complete: proof blocked","count":12}],"caution_counts":[],"ready_for_buyer_validation":0,"needs_external_proof":12,"needs_family_proof":1,"needs_report":0,"needs_thesis_detail":0,"needs_thesis_sharpening":0,"research_first":0,"research_only":0,"hold":0,"unclassified":0,"core_wedge_validation_ready_rows":0,"full_family_validation_ready_rows":0,"scope_limited_validation_rows":0,"full_family_claim_ready_rows":0,"validation_claim_scope_policy":"Core-only validation rows are worth buyer testing, but they must not be presented as full-family commercial opportunities until family_wide_validation_ready is true."},"commercial_readiness_summary":{"status":"needs_family_proof","label":"Needs family proof","validation_ready":false,"family_key":"search-visibility","family_name":"search visibility operations","decision_bucket":"proof_blocked","decision_bucket_label":"Proof Blocked","proof_status":"validated_core","proof_status_label":"Validated core","commercial_gate_status":"complete","commercial_gate_label":"Gate complete","commercial_gate_passed":7,"commercial_gate_total":7,"commercial_card_status":"complete","commercial_card_complete":true,"commercial_card_missing_count":0,"blockers":[],"blocker_count":0,"cautions":[],"caution_count":0,"next_action":"Finish the missing outside proof, then test buyer urgency with SEO consultants managing WordPress sites: monitor better search drift, schema/indexing failures, and client-readable search-impact fixes.","dossier_url":"/opportunities/families/search-visibility/dossier","dossier_api_url":"/api/opportunities/families/search-visibility/dossier"},"readiness_summary":{"status":"needs_family_proof","label":"Needs family proof","validation_ready":false,"family_key":"search-visibility","family_name":"search visibility operations","decision_bucket":"proof_blocked","decision_bucket_label":"Proof Blocked","proof_status":"validated_core","proof_status_label":"Validated core","commercial_gate_status":"complete","commercial_gate_label":"Gate complete","commercial_gate_passed":7,"commercial_gate_total":7,"commercial_card_status":"complete","commercial_card_complete":true,"commercial_card_missing_count":0,"blockers":[],"blocker_count":0,"cautions":[],"caution_count":0,"next_action":"Finish the missing outside proof, then test buyer urgency with SEO consultants managing WordPress sites: monitor better search drift, schema/indexing failures, and client-readable search-impact fixes.","dossier_url":"/opportunities/families/search-visibility/dossier","dossier_api_url":"/api/opportunities/families/search-visibility/dossier"},"cache_source":"durable_stale","cache_age_seconds":81896,"payload_mode":"compact","full_payload_url":"/api/evidence/source?full=true&compact_schema=evidence-source-v2&url=https%3A//wordpress.org/support/topic/wordpress-database-error-duplicate-entry-20/&comment_limit=80&text_limit=12000","row_key":"rows","source_row_key":"rows","rows_shown":1,"comments_shown":3,"evidence_summary":{"total":1,"source_evidence_rows":0,"source_link_rows":1,"source_count_only_rows":0,"missing_source_evidence_rows":0,"source_evidence_not_applicable_rows":0,"source_link_coverage_percent":100.0,"evidence_required_rows":0,"evidence_required_rows_missing_source_links":0,"build_worthy_rows_missing_source_links":0,"decision_rows_missing_source_links":0,"missing_source_examples":[]}},"rows":[{"section":"source","row_type":"source","url":"https://wordpress.org/support/topic/wordpress-database-error-duplicate-entry-20/","slug":"fulltext-search","plugin_name":"WP Fast Total Search – The Power of Indexed Search","source":"support","sentiment":"complaint","severity":"high","opportunity_relevance":1.0,"reply_count":30,"comments_returned":30,"analyzed":true,"source_link_count":2,"title":"WordPress database error Duplicate entry","author":"Rafael Fischmann","published_at":"2024-07-04T15:56:00+00:00","resolved":false,"collected_at":"2026-07-07T05:57:26+00:00","intent":"feature_request","affected_feature":"form","summary":"WordPress database error Duplicate entry: users show security, bugs, compatibility pain that may indicate a product gap.","evidence_quote":"WordPress database error Duplicate entry Hi, I was looking at my PHP error.log file and noticed quite a few entries like these: [04-Jul-2024 12:34:47 UTC] WordPress database error Duplicate entry '1022765-wp_posts' for key 'tid_tsrc_unique' for query insert into wpftsi_index...","confidence":0.68,"analyzed_at":"2026-07-07T05:57:33+00:00","market_key":"better search","market_name":"Better Search","market_url":"/markets/better%20search","opportunity_url":"/opportunities/better%20search","family_key":"search-visibility","family_name":"search visibility operations","opportunity_family_key":"search-visibility","opportunity_family_name":"search visibility operations","buyer":"site owners, SEO consultants, and agencies","what_to_build":"Better Search visibility assurance for protecting search visibility and structured data quality","urgent_problem":"SEO and schema issues can quietly damage search performance until reports expose the loss.","problem":"SEO and schema issues can quietly damage search performance until reports expose the loss.","competitor_gap":"Gap to test: can buyers monitor better search drift, schema/indexing failures, and client-readable search-impact fixes before schema, indexing, and search-visibility risk. weak-incumbent evidence gives 14 teardown signal(s). paid-market language appears around analytics....","proof_support":"Proof base: outside proof that buyers already pay around the workflow, paid-adjacent plugin or pricing signals, repeated WordPress pain, and weak incumbent coverage around protecting search visibility and structured data quality.","needs_validation":"finish the missing outside proof, then test buyer urgency with SEO consultants managing WordPress sites: monitor better search drift, schema/indexing failures, and client-readable search-impact fixes.","what_still_needs_validation":"finish the missing outside proof, then test buyer urgency with SEO consultants managing WordPress sites: monitor better search drift, schema/indexing failures, and client-readable search-impact fixes.","commercial_attractiveness":"Commercial pull comes from SEO consultants managing WordPress sites: SEO and schema issues can quietly damage search performance until reports expose the loss. The first paid wedge is to monitor better search drift, schema/indexing failures, and client-readable search-impact...","first_validation_wedge":"monitor better search drift, schema/indexing failures, and client-readable search-impact fixes","mvp_wedge":"monitor better search drift, schema/indexing failures, and client-readable search-impact fixes","decision_bucket":"proof_blocked","decision_bucket_label":"Proof Blocked","row_role":"supporting_evidence","recommendation_role":"evidence_input","evidence_role":"supports_opportunity_family","promotion_status":"linked_opportunity","promotion_status_label":"Evidence linked to opportunity","promotion_reason":"This row is supporting evidence linked to a commercial opportunity family, not the build-worthy opportunity itself.","is_build_worthy":false,"worth_validating":false,"build_worthy_scope":"opportunity_family","build_worthy_family_key":"search-visibility","opportunity_decision_status":"supporting_evidence","body_summary":"Hi, I was looking at my PHP error.log file and noticed quite a few entries like these: [04-Jul-2024 12:34:47 UTC] WordPress database error Duplicate entry '1022765-wp_posts' for key 'tid_tsrc_unique' for query...","issue_labels":["security","bugs","compatibility","performance"],"source_links":[{"source_url":"https://wordpress.org/support/topic/wordpress-database-error-duplicate-entry-20/","url":"https://wordpress.org/support/topic/wordpress-database-error-duplicate-entry-20/","original_url":"https://wordpress.org/support/topic/wordpress-database-error-duplicate-entry-20/","source_page_url":"/evidence/source?url=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fwordpress-database-error-duplicate-entry-20%2F","source_api_url":"/api/evidence/source?url=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fwordpress-database-error-duplicate-entry-20%2F"}]}],"plugin":{"active_installs":1000,"api_url":"/api/plugins/fulltext-search","downloaded":70892,"name":"WP Fast Total Search – The Power of Indexed Search","rating":88.0,"slug":"fulltext-search","tags":["better search","extended search","fulltext search","relevant search","search pdf"],"url":"/plugin/fulltext-search"},"conversation":{"url":"https://wordpress.org/support/topic/wordpress-database-error-duplicate-entry-20/","slug":"fulltext-search","source":"support","title":"WordPress database error Duplicate entry","author":"Rafael Fischmann","published_at":"2024-07-04T15:56:00+00:00","resolved":false,"reply_count":30,"collected_at":"2026-07-07T05:57:26+00:00","body_summary":"Hi, I was looking at my PHP error.log file and noticed quite a few entries like these: [04-Jul-2024 12:34:47 UTC] WordPress database error Duplicate entry '1022765-wp_posts' for key 'tid_tsrc_unique' for query insert into wpftsi_index ( tid , tsrc , tdt , build_time ,..."},"analysis":{"affected_feature":"form","analyzed_at":"2026-07-07T05:57:33+00:00","complaint_types":["security","bugs","compatibility","performance","missing_feature","support","migration","setup"],"confidence":0.68,"conversation_url":"https://wordpress.org/support/topic/wordpress-database-error-duplicate-entry-20/","evidence_quote":"WordPress database error Duplicate entry Hi, I was looking at my PHP error.log file and noticed quite a few entries like these: [04-Jul-2024 12:34:47 UTC] WordPress database error Duplicate entry '1022765-wp_posts' for key 'tid_tsrc_unique' for query insert into wpftsi_index ( tid , tsrc , tdt , build_time , update_dt , force_rebuild , locked_dt ) values (\"1","intent":"feature_request","issue_labels":["security","bugs","compatibility","performance"],"model":"heuristic-v1","opportunity_relevance":1.0,"praise_types":["easy","support","performance","value","quality"],"sentiment":"complaint","severity":"high","slug":"fulltext-search","source":"support","summary":"WordPress database error Duplicate entry: users show security, bugs, compatibility pain that may indicate a product gap."},"comments":[{"position":1,"author":"Rafael Fischmann","published_at":"2024-07-28T10:55:00+00:00","body_summary":"Hi @epsiloncool , so I’ve updated to 1.71.238 today and now am seeing lots of these in my PHP error log: [28-Jul-2024 09:30:57 UTC] WordPress database error Table 'wordpress.wpftsi_doctree' doesn't exist for query..."},{"position":2,"author":"Rafael Fischmann","published_at":"2024-07-28T11:22:00+00:00","body_summary":"…and I’ve just noticed it’s not returning any searches anymore. I’ll try reverting back to the previous version."},{"position":3,"author":"Epsiloncool","published_at":"2024-07-28T12:41:00+00:00","body_summary":"Hi @rfischmann Thank you very much for the fast report! It’s actually the strange problem and we didn’t detect it on the testing stage…. 🙁 Could you please make a simple test for me? Please deactivate 1.71.238 and..."}],"source_links":[{"source_url":"https://wordpress.org/support/topic/wordpress-database-error-duplicate-entry-20/","url":"https://wordpress.org/support/topic/wordpress-database-error-duplicate-entry-20/","original_url":"https://wordpress.org/support/topic/wordpress-database-error-duplicate-entry-20/","source_page_url":"/evidence/source?url=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fwordpress-database-error-duplicate-entry-20%2F","source_api_url":"/api/evidence/source?url=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fwordpress-database-error-duplicate-entry-20%2F"},{"source_url":"https://wordpress.org/plugins/fulltext-search/","url":"https://wordpress.org/plugins/fulltext-search/","original_url":"https://wordpress.org/plugins/fulltext-search/","source_page_url":"/plugin/fulltext-search","source_api_url":"/api/plugins/fulltext-search"}],"source_link_count":2,"market_key":"better search","market_name":"Better Search","market_url":"/markets/better%20search","opportunity_url":"/opportunities/better%20search","opportunity_card":{"key":"search-visibility","name":"search visibility operations","family_key":"search-visibility","family_name":"search visibility operations","family_label":"search visibility operations","display_name":"Better Search visibility assurance","opportunity_name":"Better Search visibility assurance","opportunity_label":"Better Search visibility assurance","decision_bucket":"proof_blocked","commercial_readiness_status":"needs_family_proof","commercial_readiness_label":"Needs family proof","validation_ready":false,"is_build_worthy":false,"row_role":"opportunity_family","recommendation_role":"commercial_opportunity_candidate","buyer":"site owners, SEO consultants, and agencies","who_buys":"site owners, SEO consultants, and agencies","primary_buyer_segment":"SEO consultants managing WordPress sites","urgent_problem":"SEO and schema issues can quietly damage search performance until reports expose the loss.","problem":"SEO and schema issues can quietly damage search performance until reports expose the loss.","pain":"SEO and schema issues can quietly damage search performance until reports expose the loss.","what_to_build":"Better Search visibility assurance for protecting search visibility and structured data quality","first_validation_wedge":"monitor better search drift, schema/indexing failures, and client-readable search-impact fixes","mvp_wedge":"monitor better search drift, schema/indexing failures, and client-readable search-impact fixes","wedge":"monitor better search drift, schema/indexing failures, and client-readable search-impact fixes","source_count":8,"source_link_count":8,"next_action":"Finish the missing outside proof, then test buyer urgency with SEO consultants managing WordPress sites: monitor better search drift, schema/indexing failures, and client-readable search-impact fixes.","family_dossier_url":"/opportunities/families/search-visibility/dossier","opportunity_family_dossier_url":"/opportunities/families/search-visibility/dossier","family_dossier_api_url":"/api/opportunities/families/search-visibility/dossier","opportunity_family_dossier_api_url":"/api/opportunities/families/search-visibility/dossier","urls":{"dossier":"/opportunities/families/search-visibility/dossier","family":"/opportunities?family=search-visibility"},"api_urls":{"dossier":"/api/opportunities/families/search-visibility/dossier","family":"/api/opportunities/families?family=search-visibility"},"family_url":"/opportunities?family=search-visibility","opportunity_family_url":"/opportunities?family=search-visibility","opportunity_family_api_url":"/api/opportunities/families?family=search-visibility","commercial_gate_status":"complete","commercial_gate_label":"Gate complete","commercial_card_status":"complete","commercial_card_missing_count":0},"commercial_card_summary":{"status":"complete","status_label":"complete","missing_count":0,"passed":9,"required":9,"summary":{}},"commercial_card_checklist":[{"key":"what_to_build","label":"What to build","passed":true,"status":"pass","detail":"Better Search visibility assurance for protecting search visibility and structured data quality"},{"key":"specific_buyer","label":"Specific buyer","passed":true,"status":"pass","detail":"site owners, SEO consultants, and agencies"},{"key":"urgent_problem","label":"Urgent problem","passed":true,"status":"pass","detail":"SEO and schema issues can quietly damage search performance until reports expose the loss."},{"key":"competitor_gap","label":"Competitor gap","passed":true,"status":"pass","detail":"Gap to test: can buyers monitor better search drift, schema/indexing failures, and client-readable search-impact fixes before schema, indexing, and search-visibility risk. weak-incumbent evidence gives 14 teardown signal"}],"family_key":"search-visibility","family_name":"search visibility operations","opportunity_family_key":"search-visibility","opportunity_family_name":"search visibility operations","buyer":"site owners, SEO consultants, and agencies","what_to_build":"Better Search visibility assurance for protecting search visibility and structured data quality","urgent_problem":"SEO and schema issues can quietly damage search performance until reports expose the loss.","problem":"SEO and schema issues can quietly damage search performance until reports expose the loss.","competitor_gap":"Gap to test: can buyers monitor better search drift, schema/indexing failures, and client-readable search-impact fixes before schema, indexing, and search-visibility risk. weak-incumbent evidence gives 14 teardown signal(s). paid-market language appears around analytics. Entry wedge: monitor better search drift, schema/indexing failures, and client-readable search-impact fixes.","proof_support":"Proof base: outside proof that buyers already pay around the workflow, paid-adjacent plugin or pricing signals, repeated WordPress pain, and weak incumbent coverage around protecting search visibility and structured data quality.","needs_validation":"finish the missing outside proof, then test buyer urgency with SEO consultants managing WordPress sites: monitor better search drift, schema/indexing failures, and client-readable search-impact fixes.","what_still_needs_validation":"finish the missing outside proof, then test buyer urgency with SEO consultants managing WordPress sites: monitor better search drift, schema/indexing failures, and client-readable search-impact fixes.","commercial_attractiveness":"Commercial pull comes from SEO consultants managing WordPress sites: SEO and schema issues can quietly damage search performance until reports expose the loss. The first paid wedge is to monitor better search drift, schema/indexing failures, and client-readable search-impact fixes. Revenue can come from scheduled audits, Search Console integrations, schema validation, alerts, and client-ready reports.","first_validation_wedge":"monitor better search drift, schema/indexing failures, and client-readable search-impact fixes","mvp_wedge":"monitor better search drift, schema/indexing failures, and client-readable search-impact fixes","decision_bucket":"proof_blocked","decision_bucket_label":"Proof Blocked","api_urls":{"evidence":"/api/evidence?slug=fulltext-search","market":"/markets/better%20search","opportunity":"/opportunities/better%20search","plugin":"/api/plugins/fulltext-search","source":"/api/evidence/source?url=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fwordpress-database-error-duplicate-entry-20%2F","wordpress":"https://wordpress.org/support/topic/wordpress-database-error-duplicate-entry-20/","family":"/api/opportunities/families?family=search-visibility","dossier":"/api/opportunities/families/search-visibility/dossier"},"commercial_readiness":{"total":13,"validation_ready":0,"core_validation_ready_rows":0,"family_wide_validation_ready_rows":0,"core_only_validation_ready_rows":0,"validation_scope_status":"not_ready","validation_scope_label":"Not ready","validation_scope_warning":"","validation_scope_counts":[{"scope":"not_validation_ready","label":"Not validation-ready","count":13}],"blocker_count":24,"caution_count":0,"status_counts":[{"status":"needs_external_proof","label":"Needs outside proof","count":12},{"status":"needs_family_proof","label":"Needs family proof","count":1}],"blocker_counts":[{"label":"Outside proof needed: not validated","count":12},{"label":"Commercial gate not complete: proof blocked","count":12}],"caution_counts":[],"ready_for_buyer_validation":0,"needs_external_proof":12,"needs_family_proof":1,"needs_report":0,"needs_thesis_detail":0,"needs_thesis_sharpening":0,"research_first":0,"research_only":0,"hold":0,"unclassified":0,"core_wedge_validation_ready_rows":0,"full_family_validation_ready_rows":0,"scope_limited_validation_rows":0,"full_family_claim_ready_rows":0,"validation_claim_scope_policy":"Core-only validation rows are worth buyer testing, but they must not be presented as full-family commercial opportunities until family_wide_validation_ready is true."},"readiness_summary":{"total":13,"validation_ready":0,"core_validation_ready_rows":0,"family_wide_validation_ready_rows":0,"core_only_validation_ready_rows":0,"validation_scope_status":"not_ready","validation_scope_label":"Not ready","validation_scope_warning":"","validation_scope_counts":[{"scope":"not_validation_ready","label":"Not validation-ready","count":13}],"blocker_count":24,"caution_count":0,"status_counts":[{"status":"needs_external_proof","label":"Needs outside proof","count":12},{"status":"needs_family_proof","label":"Needs family proof","count":1}],"blocker_counts":[{"label":"Outside proof needed: not validated","count":12},{"label":"Commercial gate not complete: proof blocked","count":12}],"caution_counts":[],"ready_for_buyer_validation":0,"needs_external_proof":12,"needs_family_proof":1,"needs_report":0,"needs_thesis_detail":0,"needs_thesis_sharpening":0,"research_first":0,"research_only":0,"hold":0,"unclassified":0,"core_wedge_validation_ready_rows":0,"full_family_validation_ready_rows":0,"scope_limited_validation_rows":0,"full_family_claim_ready_rows":0,"validation_claim_scope_policy":"Core-only validation rows are worth buyer testing, but they must not be presented as full-family commercial opportunities until family_wide_validation_ready is true."},"evidence_summary":{"total":1,"source_evidence_rows":0,"source_link_rows":1,"source_count_only_rows":0,"missing_source_evidence_rows":0,"source_evidence_not_applicable_rows":0,"source_link_coverage_percent":100.0,"evidence_required_rows":0,"evidence_required_rows_missing_source_links":0,"build_worthy_rows_missing_source_links":0,"decision_rows_missing_source_links":0,"missing_source_examples":[]},"cache":{"source":"durable_stale","generated_at":"2026-08-05T06:48:14+00:00","age_seconds":81896},"row_role":"supporting_evidence","recommendation_role":"evidence_input","evidence_role":"supports_opportunity_family","promotion_status":"linked_opportunity","promotion_status_label":"Evidence linked to opportunity","promotion_reason":"This row is supporting evidence linked to a commercial opportunity family, not the build-worthy opportunity itself.","is_build_worthy":false,"worth_validating":false,"build_worthy_scope":"opportunity_family","build_worthy_family_key":"search-visibility","opportunity_decision_status":"supporting_evidence"}