MysQL Index

  • Hi,


    I'm debugging an issue on a Perch site using a list/view model. Somehow list items are being duplicated in the DB.

    The perch3_content_index table has ended up with no Indexes the standard 5 col structure is present.


    1. indexID is missing AUTO_INCREMENT.
    2. No Primary, idx_fk , idx_key, idx_key_val and idx_keys

    This site still works but editing throws a mysql error about the missing indexes.


    I'd rather try and reconstruct indexes - wondering what is the best way to go about it.


    Here's the list page code. Is the first statement spawing the duplicates?


    Thanks in advance for any help